Rev 1 | Rev 13 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed
Rev | Author | Line No. | Line |
---|---|---|---|
1 | 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, |
||
14 | ChallengeID INT, |
||
15 | PRIMARY KEY(ID) |
||
16 | ); |
||
17 | |||
18 | CREATE TABLE BlogPosts |
||
19 | ( |
||
20 | ID INT NOT NULL AUTO_INCREMENT, |
||
21 | AuthorID INT, |
||
22 | Title TEXT, |
||
23 | Content TEXT, |
||
24 | DatePosted DATETIME, |
||
25 | Category TEXT, |
||
26 | PRIMARY KEY(ID) |
||
27 | ); |
||
28 | |||
7 | tom | 29 | CREATE TABLE BlogComments |
30 | ( |
||
31 | ID INT NOT NULL AUTO_INCREMENT, |
||
32 | AuthorID INT, |
||
33 | PostID INT, |
||
34 | Title TEXT, |
||
35 | Content TEXT, |
||
36 | DatePosted DATETIME, |
||
37 | Spam BOOLEAN, |
||
38 | PRIMARY KEY(ID) |
||
39 | ); |
||
40 | |||
41 | CREATE TABLE Projects |
||
42 | ( |
||
43 | ID INT NOT NULL AUTO_INCREMENT, |
||
44 | AuthorID INT, |
||
45 | Title TEXT, |
||
46 | Description TEXT, |
||
47 | LogoURL TEXT, |
||
48 | WebsiteURL TEXT, |
||
49 | LatestVersion TEXT, |
||
50 | PRIMARY KEY(ID) |
||
51 | ); |
||
52 | |||
53 | CREATE TABLE ForumCategories |
||
54 | ( |
||
55 | ID INT NOT NULL AUTO_INCREMENT, |
||
56 | ParentID INT, |
||
57 | Title TEXT, |
||
58 | Description TEXT, |
||
59 | PRIMARY KEY(ID) |
||
60 | ); |
||
61 | |||
62 | CREATE TABLE ForumTopics |
||
63 | ( |
||
64 | ID INT NOT NULL AUTO_INCREMENT, |
||
65 | AuthorID INT, |
||
66 | CategoryID INT, |
||
67 | Title TEXT, |
||
68 | DatePosted DATETIME, |
||
69 | PRIMARY KEY(ID) |
||
70 | ); |
||
71 | |||
72 | CREATE TABLE ForumPosts |
||
73 | ( |
||
74 | ID INT NOT NULL AUTO_INCREMENT, |
||
75 | AuthorID INT, |
||
76 | TopicID INT, |
||
77 | Title TEXT, |
||
78 | Content TEXT, |
||
79 | DatePosted DATETIME, |
||
80 | Spam BOOLEAN, |
||
81 | PRIMARY KEY(ID) |
||
82 | ); |
||
83 | |||
1 | tom | 84 | INSERT INTO Users VALUES (1, 0, "admin", SHA1("password"), "admins@tim32.org", "Tim32 Admin", 0); |
85 | INSERT INTO BlogPosts VALUES(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"); |