Subversion Repositories taios

Rev

Rev 7 | Go to most recent revision | Details | 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 
 
29 
INSERT INTO Users VALUES (1, 0, "admin", SHA1("password"), "admins@tim32.org", "Tim32 Admin", 0);
30 
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");