/* $Id: schema.txt,v 1.18 2005/04/06 23:58:26 leeh Exp $ */

CREATE TABLE nicks (
	nickname TEXT,
	username TEXT,
	reg_time TIMESTAMP,
	last_time TIMESTAMP,
	flags INTEGER,
	PRIMARY KEY(nickname)
);

CREATE TABLE users (
	username TEXT,
	password TEXT,
	email TEXT,
	suspender TEXT,
	reg_time TIMESTAMP,
	last_time TIMESTAMP,
	flags INTEGER,
	PRIMARY KEY(username)
);

CREATE TABLE channels (
	chname TEXT,
	topic TEXT,
	url TEXT,
	createmodes TEXT,
	enforcemodes TEXT,
	tsinfo TIMESTAMP,
	reg_time TIMESTAMP,
	last_time TIMESTAMP,
	flags INTEGER,
	suspender TEXT,
	PRIMARY KEY(chname)
);

CREATE TABLE members (
	chname TEXT,
	username TEXT,
	lastmod TEXT,
	level INTEGER,
	flags INTEGER,
	suspend INTEGER,
	FOREIGN KEY(chname) REFERENCES channels (chname) MATCH FULL,
	FOREIGN KEY(username) REFERENCES users (username) MATCH FULL	
);

CREATE TABLE bans (
	chname TEXT,
	mask TEXT,
	reason TEXT,
	username TEXT,
	level INTEGER,
	hold TIMESTAMP,
	FOREIGN KEY(chname) REFERENCES channels (chname) MATCH FULL
);

CREATE TABLE operbot (
	chname TEXT,
	tsinfo TIMESTAMP,
	oper TEXT
);

CREATE TABLE operserv (
	chname TEXT,
	tsinfo TIMESTAMP,
	oper TEXT
);

CREATE TABLE jupes (
	servername TEXT,
	reason TEXT
);