File indexing completed on 2024-06-23 05:36:15
0001 CREATE TABLE [%1.tag] 0002 ( 0003 id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 0004 name VARCHAR(255) NOT NULL UNIQUE 0005 ); 0006 0007 CREATE INDEX [%1.index_tag_name] ON [%1.tag] (name); 0008 0009 CREATE TABLE [%1.recency_bool] 0010 ( 0011 tag_id INTEGER REFERENCES [%1.tag](id) PRIMARY KEY, 0012 value BOOL NOT NULL, 0013 time INTEGER NOT NULL 0014 ); 0015 0016 CREATE TABLE [%1.recency_int] 0017 ( 0018 tag_id INTEGER REFERENCES [%1.tag](id) PRIMARY KEY, 0019 value INTEGER NOT NULL, 0020 time INTEGER NOT NULL 0021 ); 0022 0023 CREATE TABLE [%1.recency_real] 0024 ( 0025 tag_id INTEGER REFERENCES [%1.tag](id) PRIMARY KEY, 0026 value double precision NOT NULL, 0027 time INTEGER NOT NULL 0028 ); 0029 0030 CREATE TABLE [%1.event_bool] 0031 ( 0032 id INTEGER PRIMARY KEY, 0033 tag_id INTEGER REFERENCES [%1.tag](id), 0034 value BOOL NOT NULL, 0035 time INTEGER NOT NULL 0036 ); 0037 0038 CREATE INDEX [%1.index_event_bool_time] ON [%1.event_bool] (time); 0039 0040 CREATE TABLE [%1.event_int] 0041 ( 0042 id INTEGER PRIMARY KEY, 0043 tag_id INTEGER REFERENCES [%1.tag](id), 0044 value INTEGER NOT NULL, 0045 time INTEGER NOT NULL 0046 ); 0047 0048 CREATE INDEX [%1.index_event_int_time] ON [%1.event_int] (time); 0049 0050 CREATE TABLE [%1.event_real] 0051 ( 0052 id INTEGER PRIMARY KEY, 0053 tag_id INTEGER REFERENCES [%1.tag](id), 0054 value double precision NOT NULL, 0055 time INTEGER NOT NULL 0056 ); 0057 0058 CREATE INDEX [%1.index_event_real_time] ON [%1.event_real] (time); 0059 0060 CREATE TABLE [%1.history_bool] 0061 ( 0062 id INTEGER PRIMARY KEY, 0063 tag_id INTEGER REFERENCES [%1.tag](id), 0064 open BOOL NOT NULL, 0065 close BOOL NOT NULL, 0066 min BOOL NOT NULL, 0067 max BOOL NOT NULL, 0068 open_time INTEGER NOT NULL, 0069 close_time INTEGER NOT NULL, 0070 count INTEGER NOT NULL 0071 ); 0072 0073 CREATE INDEX [%1.index_history_bool_close_time] ON [%1.history_bool] (close_time); 0074 0075 CREATE TABLE [%1.history_int] 0076 ( 0077 id INTEGER PRIMARY KEY, 0078 tag_id INTEGER REFERENCES [%1.tag](id), 0079 open INTEGER NOT NULL, 0080 close INTEGER NOT NULL, 0081 min INTEGER NOT NULL, 0082 max INTEGER NOT NULL, 0083 open_time INTEGER NOT NULL, 0084 close_time INTEGER NOT NULL, 0085 count INTEGER NOT NULL 0086 ); 0087 0088 CREATE INDEX [%1.index_history_int_close_time] ON [%1.history_int] (close_time); 0089 0090 CREATE TABLE [%1.history_real] 0091 ( 0092 id INTEGER PRIMARY KEY, 0093 tag_id INTEGER REFERENCES [%1.tag](id), 0094 open double precision NOT NULL, 0095 close double precision NOT NULL, 0096 min double precision NOT NULL, 0097 max double precision NOT NULL, 0098 open_time INTEGER NOT NULL, 0099 close_time INTEGER NOT NULL, 0100 count INTEGER NOT NULL 0101 ); 0102 0103 CREATE INDEX [%1.index_history_real_close_time] ON [%1.history_real] (close_time);