Subversion Repositories taios

Rev

Rev 507 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
169 tom 1
DROP DATABASE Tim32;
2
CREATE DATABASE Tim32;
3
 
4
USE Tim32;
5
 
6
CREATE TABLE Users
7
(
8
    ID INT NOT NULL AUTO_INCREMENT,
9
    AccessID INT,
10
    Username TEXT,
11
    Password TEXT,
12
    EmailAddress TEXT,
13
    Name TEXT,
500 freddie 14
    Salt TEXT,
507 freddie 15
    CSRFToken TEXT,
169 tom 16
    ChallengeID INT,
17
    PRIMARY KEY(ID)
18
);
19
 
20
CREATE TABLE BlogPosts
21
(
22
    ID INT NOT NULL AUTO_INCREMENT,
23
    ParentID INT,
24
    AuthorID INT,
25
    Title TEXT,
26
    Content TEXT,
27
    DatePosted DATETIME,
28
    Category TEXT,
29
    Spam BOOLEAN,
30
    PRIMARY KEY(ID)
31
);
32
 
33
CREATE TABLE Projects
34
(
35
    ID INT NOT NULL AUTO_INCREMENT,
36
    AuthorID INT,
37
    Title TEXT,
38
    Description TEXT,
39
    LogoURL TEXT,
191 tom 40
    DownloadURL TEXT,
169 tom 41
    WebsiteURL TEXT,
42
    LatestVersion TEXT,
192 tom 43
    LastUpdate DATETIME,
169 tom 44
    PRIMARY KEY(ID)
45
);
46
 
47
CREATE TABLE ForumCategories
48
(
49
    ID INT NOT NULL AUTO_INCREMENT,
50
    ParentID INT,
51
    Title TEXT,
52
    Description TEXT,
53
    PRIMARY KEY(ID)
54
);
55
 
245 tom 56
CREATE TABLE ForumPosts
169 tom 57
(
58
    ID INT NOT NULL AUTO_INCREMENT,
59
    AuthorID INT,
60
    CategoryID INT,
245 tom 61
    ParentID INT,
169 tom 62
    Title TEXT,
63
    Content TEXT,
64
    DatePosted DATETIME,
65
    Spam BOOLEAN,
66
    PRIMARY KEY(ID)
67
);
68
 
516 freddie 69
INSERT INTO Users VALUES (1, 0, "admin", SHA1("passwordrostok"), "admins@tim32.org", "Tim32 Admin", "rostok", "rostok", 0);
169 tom 70
INSERT INTO BlogPosts VALUES(1, -1, 1, "Welcome to Tim32!", "Welcome to the new Tim32 website! It has had a complete design re-think to make it simpler and easier to use!", NOW(), "Tim32", FALSE);
191 tom 71
INSERT INTO Projects VALUES (1, 1, "TAIOS", "TAIOS (The All In One System) is a PHP based system to make the Tim32 website very self contained and altogether.", "http://websvn.kde.org/*checkout*/trunk/kdesupport/oxygen-icons/64x64/categories/applications-internet.png", "", "http://tim32.org/~tom/taios/", "SVN", NOW());
245 tom 72
INSERT INTO ForumCategories VALUES (1, -1, "Tim32", "Talk about Tim32 in here");
73
INSERT INTO ForumCategories VALUES (2, 1, "TAIOS", "Talk about TAIOS in here");
74
INSERT INTO ForumPosts VALUES (1, 1, 2, -1, "TAIOS Almost Finished", "As I speak we are currently in the process of finilising TAIOS so it works perfectly! I'm pleased to accounce that TAIOS should be ready within the next week or so! :D", NOW(), FALSE);