Port added to "Host" header
[public/netxms.git] / sql / metadata.in
CommitLineData
28f5b9a4
VK
1/*
2** Metadata
3**
4** ex: syntax=sql
5*/
6
7INSERT INTO metadata (var_name,var_value)
8 VALUES ('SchemaVersion',DB_FORMAT_VERSION);
9INSERT INTO metadata (var_name,var_value)
10 VALUES ('Syntax',DB_SYNTAX);
11INSERT INTO metadata (var_name,var_value)
12 VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) not null)');
13INSERT INTO metadata (var_name,var_value)
14 VALUES ('IDataIndexCreationCommand_0','CREATE INDEX idx_idata_%d_item_id ON idata_%d(item_id)');
15#if defined(DB_MYSQL)
16INSERT INTO metadata (var_name,var_value)
17 VALUES ('IDataIndexCreationCommand_1','CREATE INDEX idx_idata_%d_id_timestamp ON idata_%d(item_id,idata_timestamp)');
18#elif defined(DB_POSTGRESQL)
19INSERT INTO metadata (var_name,var_value)
20 VALUES ('IDataIndexCreationCommand_1','CREATE INDEX idx_idata_%d_timestamp_id ON idata_%d(idata_timestamp,item_id)');
21#elif defined(DB_MSSQL)
22INSERT INTO metadata (var_name,var_value)
23 VALUES ('IDataIndexCreationCommand_1','CREATE CLUSTERED INDEX idx_idata_%d_id_timestamp ON idata_%d(item_id,idata_timestamp)');
24#endif