1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
# MySQL dump 4.0
#
# Host: localhost Database: token
#--------------------------------------------------------
#
# Table structure for table 'accesses'
#
CREATE TABLE accesses (
username char(40) DEFAULT '' NOT NULL,
directory char(64) DEFAULT '' NOT NULL,
accessed timestamp(14) DEFAULT '',
KEY username (username),
KEY username_2 (username),
KEY directory (directory)
);
#
# Table structure for table 'tstmp'
#
CREATE TABLE tstmp (
dname char(3) DEFAULT '' NOT NULL,
now timestamp(14) DEFAULT ''
);
#
# Table structure for table 'userdetails'
#
CREATE TABLE userdetails (
username char(40) DEFAULT '' NOT NULL,
address1 char(20) DEFAULT '' NOT NULL,
address2 char(20) DEFAULT '' NOT NULL,
country char(20) DEFAULT '' NOT NULL,
state char(20) DEFAULT '' NOT NULL,
postcode char(10) DEFAULT '' NOT NULL,
firstname char(20) DEFAULT '' NOT NULL,
lastname char(20) DEFAULT '' NOT NULL
);
#
# Table structure for table 'users'
#
CREATE TABLE users (
username char(40) DEFAULT '' NOT NULL,
password char(24) DEFAULT '' NOT NULL,
email char(64) DEFAULT '' NOT NULL,
tokens int(6) DEFAULT '0' NOT NULL,
expiration timestamp(14) DEFAULT '',
filler timestamp(14) DEFAULT ''
);
|
