1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
|
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO homer_user;
CREATE TABLE IF NOT EXISTS alarm_config (
id SERIAL NOT NULL,
name varchar(200) NOT NULL DEFAULT '',
startdate timestamp NOT NULL,
stopdate timestamp NOT NULL,
type varchar(50) NOT NULL DEFAULT '',
value integer NOT NULL DEFAULT 0,
notify smallint NOT NULL DEFAULT '1',
email varchar(200) NOT NULL DEFAULT '',
createdate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
active smallint NOT NULL DEFAULT '1',
PRIMARY KEY (id)
);
CREATE UNIQUE INDEX alarm_config_type ON "alarm_config" (type);
CREATE TABLE IF NOT EXISTS alarm_data (
id BIGSERIAL NOT NULL,
create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
type varchar(50) NOT NULL DEFAULT '',
total integer NOT NULL DEFAULT 0,
source_ip varchar(150) NOT NULL DEFAULT '0.0.0.0',
description varchar(256) NOT NULL DEFAULT '',
status smallint NOT NULL DEFAULT '1',
PRIMARY KEY (id,create_date)
);
CREATE INDEX alarm_data_to_date ON "alarm_data" (create_date);
CREATE INDEX alarm_data_method ON "alarm_data" (type);
CREATE TABLE alarm_data_p2013082901() INHERITS (alarm_data);
ALTER TABLE alarm_data_p2013082901 ADD CONSTRAINT chk_alarm_data_p2013082901 CHECK (create_date < to_timestamp(1377734400));
CREATE TABLE IF NOT EXISTS alarm_data_mem (
id BIGSERIAL NOT NULL,
create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
type varchar(50) NOT NULL DEFAULT '',
total integer NOT NULL DEFAULT 0,
source_ip varchar(150) NOT NULL DEFAULT '0.0.0.0',
description varchar(256) NOT NULL DEFAULT '',
status smallint NOT NULL DEFAULT '1',
PRIMARY KEY (id)
);
CREATE UNIQUE INDEX alarm_data_mem_type ON "alarm_data_mem" (type,source_ip);
CREATE INDEX alarm_data_mem_to_date ON "alarm_data_mem" (create_date);
CREATE INDEX alarm_data_mem_method ON "alarm_data_mem" (type);
CREATE TABLE IF NOT EXISTS stats_data (
id BIGSERIAL NOT NULL,
from_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
to_date timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
type varchar(50) NOT NULL DEFAULT '',
total integer NOT NULL DEFAULT 0,
PRIMARY KEY (id,from_date)
);
CREATE UNIQUE INDEX stats_data_datemethod ON "stats_data" (from_date,to_date,type);
CREATE INDEX stats_data_from_date ON "stats_data" (from_date);
CREATE INDEX stats_data_to_date ON "stats_data" (to_date);
CREATE INDEX stats_data_method ON "stats_data" (type);
CREATE TABLE stats_data_p2013082901() INHERITS (stats_data);
ALTER TABLE stats_data_p2013082901 ADD CONSTRAINT chk_stats_data_p2013082901 CHECK (from_date < to_timestamp(1377734400));
CREATE TABLE IF NOT EXISTS stats_ip (
id BIGSERIAL NOT NULL,
from_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
to_date timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
method varchar(50) NOT NULL DEFAULT '',
source_ip varchar(255) NOT NULL DEFAULT '0.0.0.0',
total integer NOT NULL DEFAULT 0,
PRIMARY KEY (id,from_date)
);
CREATE UNIQUE INDEX stats_ip_datemethod ON "stats_ip" (from_date,to_date,method,source_ip);
CREATE INDEX stats_ip_from_date ON "stats_ip" (from_date);
CREATE INDEX stats_ip_to_date ON "stats_ip" (to_date);
CREATE INDEX stats_ip_method ON "stats_ip" (method);
CREATE TABLE stats_ip_p2013082901() INHERITS (stats_ip);
ALTER TABLE stats_ip_p2013082901 ADD CONSTRAINT chk_stats_ip_p2013082901 CHECK (from_date < to_timestamp(1377734400));
CREATE TABLE IF NOT EXISTS stats_ip_mem (
id BIGSERIAL NOT NULL,
create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
method varchar(50) NOT NULL DEFAULT '',
source_ip varchar(255) NOT NULL DEFAULT '0.0.0.0',
total integer NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
CREATE UNIQUE INDEX stats_ip_mem_datemethod ON "stats_ip_mem" (method,source_ip);
CREATE TABLE IF NOT EXISTS stats_geo_mem (
id BIGSERIAL NOT NULL,
create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
method varchar(50) NOT NULL DEFAULT '',
country varchar(255) NOT NULL DEFAULT 'UN',
lat float NOT NULL DEFAULT '0',
lon float NOT NULL DEFAULT '0',
total integer NOT NULL DEFAULT '0',
PRIMARY KEY (id)
);
CREATE UNIQUE INDEX stats_geo_mem_datemethod ON "stats_geo_mem" (method,country);
CREATE TABLE IF NOT EXISTS stats_geo (
id BIGSERIAL NOT NULL,
from_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
to_date timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
method varchar(50) NOT NULL DEFAULT '',
country varchar(255) NOT NULL DEFAULT 'UN',
lat float NOT NULL DEFAULT '0',
lon float NOT NULL DEFAULT '0',
total integer NOT NULL DEFAULT '0',
PRIMARY KEY (id,from_date)
);
CREATE UNIQUE INDEX stats_geo_datemethod ON "stats_geo" (from_date,to_date,method,country);
CREATE INDEX stats_geo_from_date ON "stats_geo" (from_date);
CREATE INDEX stats_geo_to_date ON "stats_geo" (to_date);
CREATE INDEX stats_geo_method ON "stats_geo" (method);
CREATE TABLE stats_geo_p2013082901() INHERITS (stats_geo);
ALTER TABLE stats_geo_p2013082901 ADD CONSTRAINT chk_stats_geo_p2013082901 CHECK (from_date < to_timestamp(1377734400));
CREATE TABLE IF NOT EXISTS stats_method (
id BIGSERIAL NOT NULL,
from_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
to_date timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
method varchar(50) NOT NULL DEFAULT '',
auth smallint NOT NULL DEFAULT '0',
cseq varchar(100) NOT NULL DEFAULT '',
totag smallint NOT NULL DEFAULT 0,
total integer NOT NULL DEFAULT 0,
PRIMARY KEY (id,from_date)
);
CREATE UNIQUE INDEX stats_method_datemethod ON "stats_method" (from_date,to_date,method,auth,totag,cseq);
CREATE INDEX stats_method_from_date ON "stats_method" (from_date);
CREATE INDEX stats_method_to_date ON "stats_method" (to_date);
CREATE INDEX stats_method_method ON "stats_method" (method);
CREATE INDEX stats_method_completed ON "stats_method" (cseq);
CREATE TABLE stats_method_p2013082901() INHERITS (stats_method);
ALTER TABLE stats_method_p2013082901 ADD CONSTRAINT chk_stats_method_p2013082901 CHECK (from_date < to_timestamp(1377734400));
CREATE TABLE IF NOT EXISTS stats_method_mem (
id BIGSERIAL NOT NULL,
create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
method varchar(50) NOT NULL DEFAULT '',
auth smallint NOT NULL DEFAULT '0',
cseq varchar(100) NOT NULL DEFAULT '',
totag smallint NOT NULL DEFAULT 0,
total integer NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
CREATE UNIQUE INDEX stats_method_mem_datemethod ON "stats_method_mem" (method,auth,totag,cseq);
CREATE INDEX stats_method_mem_from_date ON "stats_method_mem" (create_date);
CREATE INDEX stats_method_mem_method ON "stats_method_mem" (method);
CREATE INDEX stats_method_mem_completed ON "stats_method_mem" (cseq);
CREATE TABLE IF NOT EXISTS stats_useragent (
id BIGSERIAL NOT NULL,
from_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
to_date timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
useragent varchar(100) NOT NULL DEFAULT '',
method varchar(50) NOT NULL DEFAULT '',
total integer NOT NULL DEFAULT '0',
PRIMARY KEY (id,from_date)
);
CREATE UNIQUE INDEX stats_useragent_datemethod ON "stats_useragent" (from_date,to_date,method,useragent);
CREATE INDEX stats_useragent_from_date ON "stats_useragent" (from_date);
CREATE INDEX stats_useragent_to_date ON "stats_useragent" (to_date);
CREATE INDEX stats_useragent_useragent ON "stats_useragent" (useragent);
CREATE INDEX stats_useragent_method ON "stats_useragent" (method);
CREATE INDEX stats_useragent_total ON "stats_useragent" (total);
CREATE TABLE stats_useragent_p2013082901() INHERITS (stats_useragent);
ALTER TABLE stats_useragent_p2013082901 ADD CONSTRAINT chk_stats_useragent_p2013082901 CHECK (from_date < to_timestamp(1377734400));
CREATE TABLE IF NOT EXISTS stats_useragent_mem (
id BIGSERIAL NOT NULL,
create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
useragent varchar(100) NOT NULL DEFAULT '',
method varchar(50) NOT NULL DEFAULT '',
total integer NOT NULL DEFAULT '0',
PRIMARY KEY (id)
);
CREATE UNIQUE INDEX stats_useragent_mem_useragent ON "stats_useragent_mem" (useragent,method);
CREATE TABLE IF NOT EXISTS stats_generic (
id BIGSERIAL NOT NULL,
from_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
to_date timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
type varchar(50) NOT NULL DEFAULT '',
tag varchar(50) NOT NULL DEFAULT '',
total integer NOT NULL,
PRIMARY KEY (id,from_date)
);
CREATE UNIQUE INDEX stats_generic_datemethod ON "stats_generic" (from_date,to_date,type,tag);
CREATE INDEX stats_generic_from_date ON "stats_generic" (from_date);
CREATE INDEX stats_generic_to_date ON "stats_generic" (to_date);
CREATE INDEX stats_generic_tag ON "stats_generic" (tag);
CREATE TABLE stats_generic_p2013082901() INHERITS (stats_generic);
ALTER TABLE stats_generic_p2013082901 ADD CONSTRAINT chk_stats_generic_p2013082901 CHECK (from_date < to_timestamp(1377734400));
|
