CREATE TABLE Muds (ID INTEGER PRIMARY KEY, Status INTEGER, IP_Address VARCHAR(15), MudPort INTEGER, lib_id INTEGER, baselib_id INTEGER, driver_id INTEGER, type_id INTEGER, AdminEmail VARCHAR(30), update_id INTEGER);

CREATE TABLE Intermud2 (mud_id INTEGER, Name VARCHAR(50), LastContact DATE, UDPPort INTEGER, inetd_id INTEGER, UpdateEmail VARCHAR(30));

CREATE TABLE Intermud3 (mud_id INTEGER, Name VARCHAR(50), LastContact DATE, OOBTcpPort INTEGER, OOBUdpPort INTEGER, OpenStatus VARCHAR(255));

CREATE TABLE MudUpdate (ID INTEGER, DateTime DATE, IPChange_id INTEGER);

CREATE TABLE Libraries (ID INTEGER PRIMARY KEY, Name VARCHAR(50), Version VARCHAR(10));

CREATE TABLE Drivers (ID INTEGER PRIMARY KEY, Name VARCHAR(50), Version VARCHAR(10));

CREATE TABLE Types (ID INTEGER PRIMARY KEY, Name VARCHAR(20));

CREATE TABLE Inetds (ID INTEGER PRIMARY KEY, Name VARCHAR(20), Version VARCHAR(10));

CREATE TABLE MudServicesI3 (mud_id INTEGER, service_id INTEGER, Value VARCHAR(20), PRIMARY KEY (mud_id, service_id));

CREATE TABLE MudServicesI2 (mud_id INTEGER, service_id INTEGER, Send VARCHAR(5), Receive VARCHAR(5), PRIMARY KEY (mud_id, service_id));

CREATE TABLE ServicesI3 (ID INTEGER PRIMARY KEY, Name VARCHAR(20), servicetype_id INTEGER);

CREATE TABLE ServiceTypesI3 (ID INTEGER PRIMARY KEY, Name VARCHAR(20));

CREATE TABLE ServicesI2 (ID INTEGER PRIMARY KEY, Name VARCHAR(20));

CREATE TABLE OtherData (mud_id INTEGER, Name VARCHAR(30), Value VARCHAR(255));

CREATE TABLE Channels (ID INTEGER PRIMARY KEY, Name VARCHAR(20), Type VARCHAR(20), Listen INTEGER);

CREATE TABLE MudChannels (mud_id INTEGER, channel_id INTEGER, PRIMARY KEY (mud_id, channel_id));

CREATE TABLE ParametersI3 (Name VARCHAR(255), Value VARCHAR(255));

CREATE TABLE ParametersI2 (Name VARCHAR(255), Value VARCHAR(255));

CREATE TABLE Users (ID INTEGER PRIMARY KEY, Name VARCHAR(12), Password
VARCHAR(20), Title VARCHAR(65), Desc VARCHAR(1024), Level VARCHAR(10),
Location VARCHAR(15), Away VARCHAR(30), Room INTEGER, Login INTEGER, Logout INTEGER);

CREATE TABLE Rooms (ID INTEGER PRIMARY KEY, Creator VARCHAR(12), Name VARCHAR(40), Description VARCHAR(1600));

CREATE TABLE RoomDetails (RoomId INTEGER, Name VARCHAR(40), Description VARCHAR(800), PRIMARY KEY (RoomId, Name));

CREATE TABLE UserParameters (user_id INTEGER, Name VARCHAR(20), Value VARCHAR(50));

CREATE TABLE IgnoredEvents (user_id INTEGER, Event VARCHAR(30));

CREATE TABLE IgnoredMuds (user_id INTEGER, Mud VARCHAR(50));

CREATE TABLE ColouredEvents (user_id INTEGER, Event VARCHAR(20), Colour VARCHAR(50), PRIMARY KEY (user_id, Event));

CREATE TABLE Aliases (user_id INTEGER, Name VARCHAR(20), Command VARCHAR(255), PRIMARY KEY (user_id, Name));

CREATE TABLE IPChanges (ID INTEGER PRIMARY KEY,From_id INTEGER, Date DATE, mud_id INTEGER, OldIP VARCHAR(15), NewIP VARCHAR(15), OldPort INTEGER, NewPort INTEGER);

CREATE TABLE Templates (Name VARCHAR(20), Value VARCHAR(255)); 

CREATE TABLE Mail (ID INTEGER PRIMARY KEY, user_id INTEGER, MailFrom VARCHAR(20), Subject VARCHAR(255), Date DATE, Text VARCHAR(5000));

INSERT INTO ServiceTypesI3 VALUES(1, "Yes/No");
INSERT INTO ServiceTypesI3 VALUES(2, "Number");
INSERT INTO ServiceTypesI3 VALUES(3, "String");

INSERT INTO ServicesI3 VALUES(1, "tell", 1);
INSERT INTO ServicesI3 VALUES(2, "emoteto", 1);
INSERT INTO ServicesI3 VALUES(3, "who", 1);
INSERT INTO ServicesI3 VALUES(4, "finger", 1);
INSERT INTO ServicesI3 VALUES(5, "locate", 1);
INSERT INTO ServicesI3 VALUES(6, "channel", 1);
INSERT INTO ServicesI3 VALUES(7, "news", 1);
INSERT INTO ServicesI3 VALUES(8, "file", 1);
INSERT INTO ServicesI3 VALUES(9, "mail", 1);
INSERT INTO ServicesI3 VALUES(10, "auth", 1);
INSERT INTO ServicesI3 VALUES(11, "ucache", 1);
INSERT INTO ServicesI3 VALUES(12, "smtp", 2);
INSERT INTO ServicesI3 VALUES(13, "ftp", 2);
INSERT INTO ServicesI3 VALUES(14, "nntp", 2);
INSERT INTO ServicesI3 VALUES(15, "http", 2);
INSERT INTO ServicesI3 VALUES(16, "rcp", 2);
INSERT INTO ServicesI3 VALUES(17, "amcp", 3);

INSERT INTO ServicesI2 VALUES(1, "mail");
INSERT INTO ServicesI2 VALUES(2, "finger");
INSERT INTO ServicesI2 VALUES(3, "who");
INSERT INTO ServicesI2 VALUES(4, "channel");
INSERT INTO ServicesI2 VALUES(5, "man");
INSERT INTO ServicesI2 VALUES(6, "locate");
INSERT INTO ServicesI2 VALUES(7, "tell");
INSERT INTO ServicesI2 VALUES(8, "gopher");
INSERT INTO ServicesI2 VALUES(9, "news");
INSERT INTO ServicesI2 VALUES(10, "htmlwho");
INSERT INTO ServicesI2 VALUES(11, "ftp");
INSERT INTO ServicesI2 VALUES(12, "newsgroup");
INSERT INTO ServicesI2 VALUES(13, "iboard");
INSERT INTO ServicesI2 VALUES(14, "uptime");