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

Parent Directory Parent Directory | Revision Log Revision Log


Revision 48 - (show annotations)
Fri Mar 5 13:45:55 2004 UTC (20 years, 1 month ago) by dpavlin
File size: 1800 byte(s)
moved mysql_ -> xx_ cludges to my2pg dir

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