/[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

Annotation of /trunk/pg/libstats.pgsql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 34 - (hide annotations)
Thu Mar 4 21:28:31 2004 UTC (20 years, 2 months ago) by dpavlin
File size: 11640 byte(s) 
PostgreSQL schema files and sample data
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     page_id INT4 DEFAULT NULL,
31     element_id INT4 DEFAULT NULL,
32     resource_id INT4 DEFAULT NULL,
33     location_id INT4 DEFAULT NULL,
34     service_id INT4 DEFAULT NULL,
35     staff_id INT4 DEFAULT NULL,
36     subject_id INT4 DEFAULT NULL,
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 DEFAULT NULL,
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 DEFAULT NULL,
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