/[libdata]/trunk/pg/libstats.pgsql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /trunk/pg/libstats.pgsql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 38 - (show annotations)
Thu Mar 4 21:37:42 2004 UTC (20 years, 1 month ago) by dpavlin
File size: 11790 byte(s) 
added referential integrity
1 ------------------------------------------------------------------
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 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 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 page_id INT4 references page(page_id),
66 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 subject_id INT4 references subject(subject_id),
137 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;
  ViewVC Help
Powered by ViewVC 1.1.26