--- trunk/webwork-modperl/doc/new-DB-sql	2003/05/23 21:36:35	903
+++ trunk/webwork-modperl/doc/new-DB-sql	2003/05/26 22:13:34	904
@@ -1,71 +1,76 @@
 CREATE DATABASE webwork;
+USE webwork;
 
 CREATE TABLE user (
-	id		VARCHAR(255) NOT NULL PRIMARY KEY,
-	first_name	TEXT,
-	last_name	TEXT,
-	email_address	TEXT,
-	student_id	TEXT,
-	status		TEXT,
-	section		TEXT,
-	recitation	TEXT,
-	comment		TEXT
+	id VARCHAR(255) NOT NULL PRIMARY KEY,
+	first_name TEXT,
+	last_name TEXT,
+	email_address TEXT,
+	student_id TEXT,
+	status TEXT,
+	section TEXT,
+	recitation TEXT,
+	comment TEXT
 );
 
 CREATE TABLE password (
-	user_id		VARCHAR(255) NOT NULL PRIMARY KEY,
-	password	TEXT
+	user_id VARCHAR(255) NOT NULL PRIMARY KEY,
+	password TEXT
 );
 
 CREATE TABLE permission (
-	user_id		VARCHAR(255) NOT NULL PRIMARY KEY,
-	permission	INT
+	user_id VARCHAR(255) NOT NULL PRIMARY KEY,
+	permission INT
 );
 
-CREATE TABLE key (
-	user_id		VARCHAR(255) NOT NULL PRIMARY KEY,
-	key		TEXT
-);
-
-CREATE TABLE set (
-	id		VARCHAR(255) NOT NULL PRIMARY KEY,
-	set_header	TEXT,
-	problem_header	TEXT,
-	open_date	DATETIME,
-	due_date	DATETIME,
-	answer_date	DATETIME
+CREATE TABLE key_not_a_keyword (
+	user_id VARCHAR(255) NOT NULL PRIMARY KEY,
+	key_not_a_keyword TEXT,
+	timestamp INT
+);
+
+CREATE TABLE set_not_a_keyword (
+	id VARCHAR(255) NOT NULL PRIMARY KEY,
+	set_header TEXT,
+	problem_header TEXT,
+	open_date INT,
+	due_date INT,
+	answer_date INT
 );
 
 CREATE TABLE set_user (
-	user_id		VARCHAR(255) NOT NULL,
-	set_id		VARCHAR(255) NOT NULL,
-	psvn		INT,
-	set_header	TEXT,
-	problem_header	TEXT,
-	open_date	DATETIME,
-	due_date	DATETIME,
-	answer_date	DATETIME
+	user_id VARCHAR(255) NOT NULL,
+	set_id VARCHAR(255) NOT NULL,
+	psvn INT,
+	set_header TEXT,
+	problem_header TEXT,
+	open_date INT,
+	due_date INT,
+	answer_date INT
 );
 
 CREATE TABLE problem (
-	id		VARCHAR(255) NOT NULL PRIMARY KEY,
-	set_id		VARCHAR(255) NOT NULL,
-	source_file	TEXT,
-	value		INT,
-	max_attempts	INT
+	id VARCHAR(255) NOT NULL PRIMARY KEY,
+	set_id VARCHAR(255) NOT NULL,
+	source_file TEXT,
+	value INT,
+	max_attempts INT
 );
 
 CREATE TABLE problem_user (
-	user_id		VARCHAR(255) NOT NULL,
-	set_id		VARCHAR(255) NOT NULL,
-	problem_id	VARCHAR(255) NOT NULL,
-	source_file	TEXT,
-	value		INT,
-	max_attempts	INT,
-	problem_seed	INT,
-	status		FLOAT,
-	attempted	INT,
-	last_answer	TEXT,
-	num_correct	INT,
-	num_incorrect	INT,
+	user_id VARCHAR(255) NOT NULL,
+	set_id VARCHAR(255) NOT NULL,
+	problem_id VARCHAR(255) NOT NULL,
+	source_file TEXT,
+	value INT,
+	max_attempts INT,
+	problem_seed INT,
+	status FLOAT,
+	attempted INT,
+	last_answer TEXT,
+	num_correct INT,
+	num_incorrect INT
 );
+
+GRANT select ON webwork.* TO webworkRead@localhost IDENTIFIED BY 'zaqwsxcderfv';
+GRANT select, insert, update, delete ON webwork.* TO webworkWrite@localhost IDENTIFIED BY 'qwerfdsazxcv';