-- Roy McElmurry
-- This script generates tables inside your personal webster database.
-- Run the script with 'source dcdb.sql' within a mysql console

-- The following things are referenced throught the file such that it should be easy
-- for you to find/replace most of them where appropriate. You will also need to name the
-- columns of each table and fill the insert statements with appropriate data. You may add
-- additional tables if you wish, but you may not alter the structures of the 4 starting tables.
--		YOUR_UW_NET_ID, TABLE_1, TABLE_2, TABLE_3, TABLE_4

-- use your personal database
USE YOUR_UW_NET_ID;

-- get rid of the old tables if any
DROP TABLE TABLE_1;
DROP TABLE TABLE_2;
DROP TABLE TABLE_3;
DROP TABLE TABLE_4;

-- create the tables
CREATE TABLE TABLE_1 (
	COLUMN_ID INTEGER PRIMARY KEY,
	COLUMN_NAME VARCHAR(100),
	COLUMN_NAME VARCHAR(100),
	COLUMN_NAME VARCHAR(100),
	COLUMN_NAME VARCHAR(1),
	COLUMN_NAME VARCHAR(7)
);

CREATE TABLE TABLE_2 (
	COLUMN_ID INTEGER PRIMARY KEY,
	COLUMN_NAME VARCHAR(100)
);

CREATE TABLE TABLE_3 (
	TABLE_1_ID INTEGER REFERENCES supers,
	TABLE_2_ID INTEGER REFERENCES abilities
);

-- Signifies that TABLE_1_ID_1 has relationship 'COLUMN_NAME' with TABLE_1_ID_2
CREATE TABLE TABLE_4 (
	TABLE_1_ID_1 INTEGER REFERENCES supers,
	TABLE_1_ID_2 INTEGER REFERENCES supers,
	COLUMN_NAME VARCHAR(10)
);

-- Populate the TABLE_1 table
INSERT INTO TABLE_1 VALUES (...);
INSERT INTO TABLE_1 VALUES (...);
INSERT INTO TABLE_1 VALUES (...);
INSERT INTO TABLE_1 VALUES (...);
INSERT INTO TABLE_1 VALUES (...);
INSERT INTO TABLE_1 VALUES (...);
INSERT INTO TABLE_1 VALUES (...);
INSERT INTO TABLE_1 VALUES (...);
INSERT INTO TABLE_1 VALUES (...);
INSERT INTO TABLE_1 VALUES (...);

-- Populate the TABLE_2 table
INSERT INTO TABLE_2 VALUES (...);
INSERT INTO TABLE_2 VALUES (...);
INSERT INTO TABLE_2 VALUES (...);
INSERT INTO TABLE_2 VALUES (...);
INSERT INTO TABLE_2 VALUES (...);
INSERT INTO TABLE_2 VALUES (...);
INSERT INTO TABLE_2 VALUES (...);
INSERT INTO TABLE_2 VALUES (...);
INSERT INTO TABLE_2 VALUES (...);
INSERT INTO TABLE_2 VALUES (...);

-- Populate the TABLE_3 table
INSERT INTO TABLE_3 VALUES (...);
INSERT INTO TABLE_3 VALUES (...);
INSERT INTO TABLE_3 VALUES (...);
INSERT INTO TABLE_3 VALUES (...);
INSERT INTO TABLE_3 VALUES (...);
INSERT INTO TABLE_3 VALUES (...);
INSERT INTO TABLE_3 VALUES (...);
INSERT INTO TABLE_3 VALUES (...);
INSERT INTO TABLE_3 VALUES (...);
INSERT INTO TABLE_3 VALUES (...);


-- Populate the TABLE_4 table
INSERT INTO TABLE_4 VALUES (...);
INSERT INTO TABLE_4 VALUES (...);
INSERT INTO TABLE_4 VALUES (...);
INSERT INTO TABLE_4 VALUES (...);
INSERT INTO TABLE_4 VALUES (...);
INSERT INTO TABLE_4 VALUES (...);
INSERT INTO TABLE_4 VALUES (...);
INSERT INTO TABLE_4 VALUES (...);
INSERT INTO TABLE_4 VALUES (...);
INSERT INTO TABLE_4 VALUES (...);