Web   ·   Wiki   ·   Activities   ·   Blog   ·   Lists   ·   Chat   ·   Meeting   ·   Bugs   ·   Git   ·   Translate   ·   Archive   ·   People   ·   Donate
summaryrefslogtreecommitdiffstats
path: root/databases/sql.log
blob: 7a8e599ee2e2a609675eb9d650f8dc72c012e8a5 (plain)
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
52
53
54
55
56
57
58
59
60
61
62
timestamp: 2010-07-08T16:17:34.182357
CREATE TABLE image(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    file CHAR(512),
    title CHAR(512),
    image_id CHAR(512),
    creator CHAR(512),
    description TEXT,
    views CHAR(512),
    newimage CHAR(512)
);
success!
timestamp: 2010-07-08T16:17:34.305771
CREATE TABLE comment(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    image_id REFERENCES image(id) ON DELETE CASCADE,
    author CHAR(512),
    body TEXT
);
success!
timestamp: 2010-07-08T16:17:34.388196
CREATE TABLE auth_user(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username CHAR(128) UNIQUE,
    email CHAR(128) UNIQUE,
    password CHAR(256),
    registration_key CHAR(128)
);
success!
timestamp: 2010-07-08T16:17:34.496921
CREATE TABLE auth_group(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    role CHAR(512),
    description TEXT
);
success!
timestamp: 2010-07-08T16:17:34.600049
CREATE TABLE auth_membership(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    user_id REFERENCES auth_user(id) ON DELETE CASCADE,
    group_id REFERENCES auth_group(id) ON DELETE CASCADE
);
success!
timestamp: 2010-07-08T16:17:34.678659
CREATE TABLE auth_permission(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    group_id REFERENCES auth_group(id) ON DELETE CASCADE,
    name CHAR(512),
    table_name CHAR(512),
    record_id INTEGER
);
success!
timestamp: 2010-07-08T16:17:34.767754
CREATE TABLE auth_event(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    time_stamp TIMESTAMP,
    client_ip CHAR(512),
    user_id REFERENCES auth_user(id) ON DELETE CASCADE,
    origin CHAR(512),
    description TEXT
);
success!