kwotes/kwotes.sql

CREATE TABLE kwote (
	id			INTEGER AUTO_INCREMENT,
	submit_dt	DATETIME,
	content		TEXT,
	rating		INT,
	ip_address	VARCHAR(15),
	PRIMARY KEY(id)
);

CREATE TABLE kwote_backup (
	id			INTEGER AUTO_INCREMENT,
	submit_dt	DATETIME,
	content		TEXT,
	rating		INT,
	ip_address	VARCHAR(15),
	PRIMARY KEY(id)
);

CREATE TABLE vote (
	id			INT AUTO_INCREMENT,
	kwote_id	INT,
	vote		INT,
	ip_address	VARCHAR(15),
	vote_dt		DATETIME,
	PRIMARY KEY(id)
);

CREATE TABLE captchas (
	id			INT AUTO_INCREMENT,
	phrase		VARCHAR(255),
	PRIMARY KEY(id)
);