DaksvadN

1DROP DATABASE IF EXISTS Warble;
2CREATE DATABASE Warble;
3USE Warble;
4CREATE TABLE Users (
5  UserID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
6  UserName VARCHAR(45) NOT NULL,
7  Password VARCHAR(40) NOT NULL,
8  Email VARCHAR(40) NOT NULL,
9  PRIMARY KEY (UserID)
10);
11CREATE TABLE Posts (
12  PostID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
13  Poster INTEGER UNSIGNED NOT NULL,
14  Text VARCHAR(140) NOT NULL,
15  PRIMARY KEY (PostID),
16  CONSTRAINT FKC1 
17    FOREIGN KEY FKuser (Poster)
18    REFERENCES Users (UserID)
19    ON DELETE CASCADE
20    ON UPDATE CASCADE
21);
22CREATE INDEX PIndex ON Posts (Poster);
23INSERT INTO Users VALUES (1,"Bernd","all4nada","bernd@me.com");
24INSERT INTO Users VALUES (2,"Gerald","brickthick","gerald@bostock.com");
25INSERT INTO Posts VALUES (null,1,"My first tweet!");
26INSERT INTO Posts VALUES (null,1,"Tweeting is fun!");
27INSERT INTO Posts VALUES (null,2,"My tweets are the best!");