Subversion Repositories taios

Rev

Rev 10 | 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");