#-----------------------------

#

# Links database

# Makes the tables

# Sat Dec 11 00:39:58 EST 1999

#-----------------------------



CREATE TABLE category(

		cat integer AUTO_INCREMENT NOT NULL,

		under integer NOT NULL,

		title varchar(40),

		info varchar(50),

		pathto varchar(250),

		ttlinks integer(10) DEFAULT 0,

		INDEX icat (cat)

);



CREATE TABLE links(

		cat integer,

		title varchar(40),

		message varchar(255),

		link varchar(100),

		mod date,

		hits integer(10) DEFAULT 0

		

);



CREATE TABLE wait(

		id char(20),

		olink varchar(100), 

		title varchar(40),

		message varchar(255),

		link varchar(100),

		cat integer,

		ip char(36)

);



CREATE TABLE waitcat(

		id char(20),

		title varchar(40),

		message varchar(150),

		cat integer,

		ip char(36)

);

