1 |
dpavlin |
34 |
------------------------------------------------------------------ |
2 |
|
|
-- My2Pg 1.28 translated dump |
3 |
|
|
-- |
4 |
|
|
------------------------------------------------------------------ |
5 |
|
|
|
6 |
|
|
BEGIN; |
7 |
|
|
|
8 |
|
|
create schema libstats ; |
9 |
|
|
|
10 |
|
|
|
11 |
|
|
|
12 |
|
|
-- |
13 |
|
|
-- Sequences for table ELEMENTSTATS |
14 |
|
|
-- |
15 |
|
|
|
16 |
|
|
CREATE SEQUENCE libstats.elementstats_elementstats_id; |
17 |
|
|
|
18 |
|
|
-- MySQL dump 9.10 |
19 |
|
|
-- |
20 |
|
|
-- Host: localhost Database: libstats |
21 |
|
|
-- ------------------------------------------------------ |
22 |
|
|
-- Server version 4.0.18-log |
23 |
|
|
|
24 |
|
|
-- |
25 |
|
|
-- Table structure for table `elementstats` |
26 |
|
|
-- |
27 |
|
|
|
28 |
|
|
CREATE TABLE libstats.elementstats ( |
29 |
|
|
elementstats_id INT4 DEFAULT nextval('libstats.elementstats_elementstats_id'), |
30 |
dpavlin |
38 |
page_id INT4 references page(page_id), |
31 |
|
|
element_id INT4 references element(element_id), |
32 |
|
|
resource_id INT4 references resource(resource_id), |
33 |
|
|
location_id INT4 references location(location_id), |
34 |
|
|
service_id INT4 references service(service_id), |
35 |
|
|
staff_id INT4 references staff(staff_id), |
36 |
|
|
subject_id INT4 references subject(subject_id), |
37 |
dpavlin |
34 |
visit_date TIMESTAMP DEFAULT NULL, |
38 |
|
|
user_ip varchar(15) DEFAULT NULL, |
39 |
|
|
PRIMARY KEY (elementstats_id) |
40 |
|
|
|
41 |
|
|
); |
42 |
|
|
|
43 |
|
|
-- |
44 |
|
|
-- Dumping data for table `elementstats` |
45 |
|
|
-- |
46 |
|
|
|
47 |
|
|
INSERT INTO libstats.elementstats VALUES (1,17,50,NULL,NULL,NULL,NULL,NULL,'2004-03-03 20:58:54','193.198.214.120'); |
48 |
|
|
INSERT INTO libstats.elementstats VALUES (2,4,52,20,NULL,NULL,NULL,NULL,'2004-03-04 00:37:28','217.14.219.101'); |
49 |
|
|
INSERT INTO libstats.elementstats VALUES (3,19,74,NULL,NULL,NULL,NULL,NULL,'2004-03-04 16:31:25','193.198.214.120'); |
50 |
|
|
|
51 |
|
|
-- |
52 |
|
|
-- Table structure for table `pagestats` |
53 |
|
|
-- |
54 |
|
|
|
55 |
|
|
|
56 |
|
|
|
57 |
|
|
-- |
58 |
|
|
-- Sequences for table PAGESTATS |
59 |
|
|
-- |
60 |
|
|
|
61 |
|
|
CREATE SEQUENCE libstats.pagestats_pagestats_id_seq; |
62 |
|
|
|
63 |
|
|
CREATE TABLE libstats.pagestats ( |
64 |
|
|
pagestats_id INT4 DEFAULT nextval('libstats.pagestats_pagestats_id_seq'), |
65 |
dpavlin |
38 |
page_id INT4 references page(page_id), |
66 |
dpavlin |
34 |
visit_date TIMESTAMP DEFAULT NULL, |
67 |
|
|
user_ip varchar(15) DEFAULT NULL, |
68 |
|
|
PRIMARY KEY (pagestats_id) |
69 |
|
|
|
70 |
|
|
); |
71 |
|
|
|
72 |
|
|
-- |
73 |
|
|
-- Dumping data for table `libstats.pagestats` |
74 |
|
|
-- |
75 |
|
|
|
76 |
|
|
INSERT INTO libstats.pagestats VALUES (1,15,'2004-02-17 00:14:18','217.14.219.101'); |
77 |
|
|
INSERT INTO libstats.pagestats VALUES (2,15,'2004-02-17 00:14:35','217.14.219.101'); |
78 |
|
|
INSERT INTO libstats.pagestats VALUES (3,15,'2004-02-20 16:04:16','193.198.214.38'); |
79 |
|
|
INSERT INTO libstats.pagestats VALUES (4,15,'2004-02-20 16:04:50','193.198.214.38'); |
80 |
|
|
INSERT INTO libstats.pagestats VALUES (5,15,'2004-02-27 15:00:09','161.53.129.106'); |
81 |
|
|
INSERT INTO libstats.pagestats VALUES (6,15,'2004-03-02 16:11:25','161.53.116.81'); |
82 |
|
|
INSERT INTO libstats.pagestats VALUES (7,4,'2004-03-02 16:11:29','161.53.116.81'); |
83 |
|
|
INSERT INTO libstats.pagestats VALUES (8,4,'2004-03-02 16:12:19','161.53.116.81'); |
84 |
|
|
INSERT INTO libstats.pagestats VALUES (9,4,'2004-03-02 16:12:31','161.53.116.81'); |
85 |
|
|
INSERT INTO libstats.pagestats VALUES (10,17,'2004-03-03 20:58:46','193.198.214.120'); |
86 |
|
|
INSERT INTO libstats.pagestats VALUES (11,17,'2004-03-03 20:59:43','193.198.214.120'); |
87 |
|
|
INSERT INTO libstats.pagestats VALUES (12,17,'2004-03-03 20:59:46','193.198.214.120'); |
88 |
|
|
INSERT INTO libstats.pagestats VALUES (13,17,'2004-03-03 20:59:47','193.198.214.120'); |
89 |
|
|
INSERT INTO libstats.pagestats VALUES (14,17,'2004-03-03 20:59:48','193.198.214.120'); |
90 |
|
|
INSERT INTO libstats.pagestats VALUES (15,17,'2004-03-03 20:59:50','193.198.214.120'); |
91 |
|
|
INSERT INTO libstats.pagestats VALUES (16,17,'2004-03-03 21:00:15','193.198.214.120'); |
92 |
|
|
INSERT INTO libstats.pagestats VALUES (17,17,'2004-03-03 21:00:19','193.198.214.120'); |
93 |
|
|
INSERT INTO libstats.pagestats VALUES (18,17,'2004-03-03 21:00:58','193.198.214.120'); |
94 |
|
|
INSERT INTO libstats.pagestats VALUES (19,17,'2004-03-03 21:02:05','193.198.214.120'); |
95 |
|
|
INSERT INTO libstats.pagestats VALUES (20,4,'2004-03-04 00:34:08','217.14.219.101'); |
96 |
|
|
INSERT INTO libstats.pagestats VALUES (21,4,'2004-03-04 00:34:18','217.14.219.101'); |
97 |
|
|
INSERT INTO libstats.pagestats VALUES (22,4,'2004-03-04 00:37:13','217.14.219.101'); |
98 |
|
|
INSERT INTO libstats.pagestats VALUES (23,4,'2004-03-04 00:37:56','217.14.219.101'); |
99 |
|
|
INSERT INTO libstats.pagestats VALUES (24,4,'2004-03-04 00:40:01','217.14.219.101'); |
100 |
|
|
INSERT INTO libstats.pagestats VALUES (25,4,'2004-03-04 00:41:21','217.14.219.101'); |
101 |
|
|
INSERT INTO libstats.pagestats VALUES (26,4,'2004-03-04 00:42:41','217.14.219.101'); |
102 |
|
|
INSERT INTO libstats.pagestats VALUES (27,4,'2004-03-04 00:45:01','217.14.219.101'); |
103 |
|
|
INSERT INTO libstats.pagestats VALUES (28,19,'2004-03-04 13:45:52','193.198.214.118'); |
104 |
|
|
INSERT INTO libstats.pagestats VALUES (29,19,'2004-03-04 13:46:15','193.198.214.118'); |
105 |
|
|
INSERT INTO libstats.pagestats VALUES (30,19,'2004-03-04 13:46:17','193.198.214.118'); |
106 |
|
|
INSERT INTO libstats.pagestats VALUES (31,19,'2004-03-04 13:46:19','193.198.214.118'); |
107 |
|
|
INSERT INTO libstats.pagestats VALUES (32,19,'2004-03-04 13:46:39','193.198.214.118'); |
108 |
|
|
INSERT INTO libstats.pagestats VALUES (33,19,'2004-03-04 13:51:13','193.198.214.118'); |
109 |
|
|
INSERT INTO libstats.pagestats VALUES (34,19,'2004-03-04 13:51:33','193.198.214.118'); |
110 |
|
|
INSERT INTO libstats.pagestats VALUES (35,19,'2004-03-04 13:51:49','193.198.214.118'); |
111 |
|
|
INSERT INTO libstats.pagestats VALUES (36,19,'2004-03-04 13:52:45','193.198.214.118'); |
112 |
|
|
INSERT INTO libstats.pagestats VALUES (37,19,'2004-03-04 13:54:50','193.198.214.118'); |
113 |
|
|
INSERT INTO libstats.pagestats VALUES (38,19,'2004-03-04 16:30:43','193.198.214.120'); |
114 |
|
|
INSERT INTO libstats.pagestats VALUES (39,19,'2004-03-04 16:31:13','193.198.214.120'); |
115 |
|
|
INSERT INTO libstats.pagestats VALUES (40,19,'2004-03-04 16:45:54','193.198.214.120'); |
116 |
|
|
INSERT INTO libstats.pagestats VALUES (41,19,'2004-03-04 16:46:08','193.198.214.120'); |
117 |
|
|
INSERT INTO libstats.pagestats VALUES (42,17,'2004-03-04 17:10:50','193.198.214.120'); |
118 |
|
|
INSERT INTO libstats.pagestats VALUES (43,4,'2004-03-04 17:10:55','193.198.214.120'); |
119 |
|
|
INSERT INTO libstats.pagestats VALUES (44,18,'2004-03-04 17:11:05','193.198.214.120'); |
120 |
|
|
INSERT INTO libstats.pagestats VALUES (45,15,'2004-03-04 17:11:08','193.198.214.120'); |
121 |
|
|
|
122 |
|
|
-- |
123 |
|
|
-- Table structure for table `substats` |
124 |
|
|
-- |
125 |
|
|
|
126 |
|
|
|
127 |
|
|
|
128 |
|
|
-- |
129 |
|
|
-- Sequences for table SUBSTATS |
130 |
|
|
-- |
131 |
|
|
|
132 |
|
|
CREATE SEQUENCE libstats.substats_substats_id_seq; |
133 |
|
|
|
134 |
|
|
CREATE TABLE libstats.substats ( |
135 |
|
|
substats_id INT4 DEFAULT nextval('libstats.substats_substats_id_seq'), |
136 |
dpavlin |
38 |
subject_id INT4 references subject(subject_id), |
137 |
dpavlin |
34 |
visit_date TIMESTAMP DEFAULT NULL, |
138 |
|
|
user_ip varchar(15) DEFAULT NULL, |
139 |
|
|
PRIMARY KEY (substats_id) |
140 |
|
|
|
141 |
|
|
); |
142 |
|
|
|
143 |
|
|
-- |
144 |
|
|
-- Dumping data for table `substats` |
145 |
|
|
-- |
146 |
|
|
|
147 |
|
|
INSERT INTO libstats.substats VALUES (1,3,'2004-02-11 23:18:48','217.14.219.101'); |
148 |
|
|
INSERT INTO libstats.substats VALUES (2,2,'2004-02-11 23:34:01','217.14.219.101'); |
149 |
|
|
INSERT INTO libstats.substats VALUES (3,3,'2004-02-11 23:34:36','217.14.219.101'); |
150 |
|
|
INSERT INTO libstats.substats VALUES (4,2,'2004-02-11 23:37:07','217.14.219.101'); |
151 |
|
|
INSERT INTO libstats.substats VALUES (5,2,'2004-02-11 23:37:13','217.14.219.101'); |
152 |
|
|
INSERT INTO libstats.substats VALUES (6,2,'2004-02-11 23:37:19','217.14.219.101'); |
153 |
|
|
INSERT INTO libstats.substats VALUES (7,2,'2004-02-12 12:43:02','193.198.214.38'); |
154 |
|
|
INSERT INTO libstats.substats VALUES (8,2,'2004-02-13 16:34:08','193.198.214.38'); |
155 |
|
|
INSERT INTO libstats.substats VALUES (9,3,'2004-02-13 16:34:20','193.198.214.38'); |
156 |
|
|
INSERT INTO libstats.substats VALUES (10,2,'2004-02-13 16:43:12','161.53.52.8'); |
157 |
|
|
INSERT INTO libstats.substats VALUES (11,2,'2004-02-16 20:47:32','193.198.214.38'); |
158 |
|
|
INSERT INTO libstats.substats VALUES (12,2,'2004-02-16 20:51:21','193.198.214.38'); |
159 |
|
|
INSERT INTO libstats.substats VALUES (13,2,'2004-02-16 20:57:30','193.198.214.38'); |
160 |
|
|
INSERT INTO libstats.substats VALUES (14,3,'2004-02-16 20:57:41','193.198.214.38'); |
161 |
|
|
INSERT INTO libstats.substats VALUES (15,3,'2004-02-16 20:57:51','193.198.214.38'); |
162 |
|
|
INSERT INTO libstats.substats VALUES (16,3,'2004-02-16 20:59:10','193.198.214.38'); |
163 |
|
|
INSERT INTO libstats.substats VALUES (17,2,'2004-02-16 21:01:58','193.198.214.38'); |
164 |
|
|
INSERT INTO libstats.substats VALUES (18,6,'2004-02-17 00:43:35','217.14.219.101'); |
165 |
|
|
INSERT INTO libstats.substats VALUES (19,6,'2004-02-17 00:44:15','217.14.219.101'); |
166 |
|
|
INSERT INTO libstats.substats VALUES (20,6,'2004-02-17 00:56:09','217.14.219.101'); |
167 |
|
|
INSERT INTO libstats.substats VALUES (21,6,'2004-02-17 00:56:12','217.14.219.101'); |
168 |
|
|
INSERT INTO libstats.substats VALUES (22,6,'2004-02-17 00:56:15','217.14.219.101'); |
169 |
|
|
INSERT INTO libstats.substats VALUES (23,6,'2004-02-20 16:04:01','193.198.214.38'); |
170 |
|
|
INSERT INTO libstats.substats VALUES (24,6,'2004-02-27 21:18:50','217.14.219.101'); |
171 |
|
|
INSERT INTO libstats.substats VALUES (25,6,'2004-02-27 21:30:27','217.14.219.101'); |
172 |
|
|
INSERT INTO libstats.substats VALUES (26,6,'2004-02-27 21:34:28','217.14.219.101'); |
173 |
|
|
INSERT INTO libstats.substats VALUES (27,6,'2004-02-27 21:34:50','217.14.219.101'); |
174 |
|
|
INSERT INTO libstats.substats VALUES (28,6,'2004-02-27 21:34:55','217.14.219.101'); |
175 |
|
|
INSERT INTO libstats.substats VALUES (29,2,'2004-02-27 21:39:28','217.14.219.101'); |
176 |
|
|
INSERT INTO libstats.substats VALUES (30,2,'2004-03-01 09:28:50','161.53.130.128'); |
177 |
|
|
INSERT INTO libstats.substats VALUES (31,2,'2004-03-01 09:32:27','161.53.130.128'); |
178 |
|
|
INSERT INTO libstats.substats VALUES (32,7,'2004-03-02 16:03:11','161.53.116.81'); |
179 |
|
|
INSERT INTO libstats.substats VALUES (33,7,'2004-03-02 16:03:19','161.53.116.81'); |
180 |
|
|
INSERT INTO libstats.substats VALUES (34,7,'2004-03-02 16:04:36','161.53.116.81'); |
181 |
|
|
INSERT INTO libstats.substats VALUES (35,7,'2004-03-02 16:05:03','161.53.116.81'); |
182 |
|
|
INSERT INTO libstats.substats VALUES (36,6,'2004-03-02 16:05:28','161.53.116.81'); |
183 |
|
|
INSERT INTO libstats.substats VALUES (37,7,'2004-03-02 16:06:30','161.53.116.81'); |
184 |
|
|
INSERT INTO libstats.substats VALUES (38,6,'2004-03-02 16:07:01','161.53.116.81'); |
185 |
|
|
INSERT INTO libstats.substats VALUES (39,2,'2004-03-02 16:08:13','161.53.116.81'); |
186 |
|
|
INSERT INTO libstats.substats VALUES (40,7,'2004-03-02 16:09:48','161.53.116.81'); |
187 |
|
|
INSERT INTO libstats.substats VALUES (41,7,'2004-03-02 22:43:50','217.14.219.101'); |
188 |
|
|
INSERT INTO libstats.substats VALUES (42,7,'2004-03-02 22:46:10','217.14.219.101'); |
189 |
|
|
INSERT INTO libstats.substats VALUES (43,6,'2004-03-02 22:55:04','217.14.219.101'); |
190 |
|
|
INSERT INTO libstats.substats VALUES (44,6,'2004-03-02 22:55:55','217.14.219.101'); |
191 |
|
|
INSERT INTO libstats.substats VALUES (45,6,'2004-03-02 22:56:02','217.14.219.101'); |
192 |
|
|
INSERT INTO libstats.substats VALUES (46,6,'2004-03-02 22:56:05','217.14.219.101'); |
193 |
|
|
INSERT INTO libstats.substats VALUES (47,6,'2004-03-02 22:56:07','217.14.219.101'); |
194 |
|
|
INSERT INTO libstats.substats VALUES (48,6,'2004-03-02 23:07:47','217.14.219.101'); |
195 |
|
|
INSERT INTO libstats.substats VALUES (49,6,'2004-03-02 23:07:56','217.14.219.101'); |
196 |
|
|
INSERT INTO libstats.substats VALUES (50,6,'2004-03-02 23:08:03','217.14.219.101'); |
197 |
|
|
INSERT INTO libstats.substats VALUES (51,2,'2004-03-03 20:21:02','193.198.214.118'); |
198 |
|
|
INSERT INTO libstats.substats VALUES (52,2,'2004-03-03 20:21:20','193.198.214.118'); |
199 |
|
|
INSERT INTO libstats.substats VALUES (53,6,'2004-03-03 20:26:29','193.198.214.120'); |
200 |
|
|
INSERT INTO libstats.substats VALUES (54,6,'2004-03-04 00:36:43','217.14.219.101'); |
201 |
|
|
INSERT INTO libstats.substats VALUES (55,6,'2004-03-04 13:52:55','193.198.214.118'); |
202 |
|
|
INSERT INTO libstats.substats VALUES (56,6,'2004-03-04 13:53:06','193.198.214.118'); |
203 |
|
|
INSERT INTO libstats.substats VALUES (57,6,'2004-03-04 16:45:29','193.198.214.120'); |
204 |
|
|
INSERT INTO libstats.substats VALUES (58,6,'2004-03-04 18:01:17','193.198.214.120'); |
205 |
|
|
INSERT INTO libstats.substats VALUES (59,6,'2004-03-04 18:02:47','193.198.214.120'); |
206 |
|
|
|
207 |
|
|
|
208 |
|
|
|
209 |
|
|
-- |
210 |
|
|
-- Sequences for table SUBSTATS |
211 |
|
|
-- |
212 |
|
|
|
213 |
|
|
SELECT SETVAL('libstats.substats_substats_id_seq',(select case when max(substats_id)>0 then max(substats_id)+1 else 1 end from libstats.substats)); |
214 |
|
|
|
215 |
|
|
-- |
216 |
|
|
-- Sequences for table ELEMENTSTATS |
217 |
|
|
-- |
218 |
|
|
|
219 |
|
|
SELECT SETVAL('libstats.elementstats_elementstats_id',(select case when max(elementstats_id)>0 then max(elementstats_id)+1 else 1 end from libstats.elementstats)); |
220 |
|
|
|
221 |
|
|
-- |
222 |
|
|
-- Sequences for table PAGESTATS |
223 |
|
|
-- |
224 |
|
|
|
225 |
|
|
SELECT SETVAL('libstats.pagestats_pagestats_id_seq',(select case when max(pagestats_id)>0 then max(pagestats_id)+1 else 1 end from libstats.pagestats)); |
226 |
|
|
|
227 |
|
|
COMMIT; |