Subversion Repositories taios

DROP DATABASE Tim32;
CREATE DATABASE Tim32;

USE Tim32;

CREATE TABLE Users
(
    ID INT NOT NULL AUTO_INCREMENT,
    AccessID INT,
    Username TEXT,
    Password TEXT,
    EmailAddress TEXT,
    Name TEXT,
    ChallengeID INT,
    PRIMARY KEY(ID)
);

CREATE TABLE BlogPosts
(
    ID INT NOT NULL AUTO_INCREMENT,
    AuthorID INT,
    Title TEXT,
    Content TEXT,
    DatePosted DATETIME,
    Category TEXT,
    PRIMARY KEY(ID)
);

INSERT INTO Users VALUES (1, 0, "admin", SHA1("password"), "admins@tim32.org", "Tim32 Admin", 0);
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");