/[libdata]/trunk/my2pg/libsession.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/my2pg/libsession.pgsql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 73 - (show annotations)
Thu Mar 18 21:27:37 2004 UTC (20 years, 1 month ago) by dpavlin
File size: 1800 byte(s)
sync trunk to HEAD of pear-db (without changes specific to PEAR which will be dropped)

1 ------------------------------------------------------------------
2 -- My2Pg 1.28 translated dump
3 --
4 ------------------------------------------------------------------
5
6 BEGIN;
7
8 --
9 -- Sequences for table SESSION
10 --
11
12 CREATE SEQUENCE session_key_id_seq;
13
14 -- MySQL dump 9.10
15 --
16 -- Host: localhost Database: libsession
17 -- ------------------------------------------------------
18 -- Server version 4.0.18-log
19
20 --
21 -- Table structure for table `session`
22 --
23
24 CREATE TABLE session (
25 key_id INT8 DEFAULT nextval('session_key_id_seq'),
26 session_id varchar(64) DEFAULT NULL,
27 staff_account varchar(20) DEFAULT NULL,
28 user_ip varchar(15) DEFAULT NULL,
29 time_human TIMESTAMP DEFAULT NULL,
30 time_unix varchar(30) DEFAULT NULL,
31 time_expire varchar(30) DEFAULT NULL,
32 ucardLibrary varchar(15) DEFAULT NULL,
33 LC1 char(1) DEFAULT NULL,
34 LC2 char(1) DEFAULT NULL,
35 LCA char(1) DEFAULT NULL,
36 LCC char(1) DEFAULT NULL,
37 LCD char(1) DEFAULT NULL,
38 LCH char(1) DEFAULT NULL,
39 LCM char(1) DEFAULT NULL,
40 PRIMARY KEY (key_id)
41
42 );
43
44 --
45 -- Dumping data for table `session`
46 --
47
48 INSERT INTO session VALUES (33,'6195f47dcff14b8f242aa333cdb2703e','mglavica','193.198.214.120','2004-03-04 17:58:41','1078419521.93','1078426721.93',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
49 INSERT INTO session VALUES (35,'0f20c77d6afb02422603acb0329b5a41','dpavlin','193.198.214.118','2004-03-04 19:49:35','1078426175.71','1078433375.71',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
50 INSERT INTO session VALUES (34,'2fe2a9d4c06124698de449b12aeb6249','dpavlin','193.198.214.118','2004-03-04 19:16:48','1078424208.73','1078431408.73',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
51
52
53
54 --
55 -- Sequences for table SESSION
56 --
57
58 SELECT SETVAL('session_key_id_seq',(select case when max(key_id)>0 then max(key_id)+1 else 1 end from session));
59
60 COMMIT;

  ViewVC Help
Powered by ViewVC 1.1.26