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; |