CREATE TABLE article_authors (
id int(11) NOT NULL auto_increment,
name varchar(100) NOT NULL,
email varchar(100) NOT NULL,
byline text NOT NULL,
pic_url varchar(100),
PRIMARY KEY (id)
);
CREATE TABLE article_cats (
id int(11) NOT NULL auto_increment,
name varchar(100) NOT NULL,
description text NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE article_lookup (
JID int(11) DEFAULT '0' NOT NULL,
CID int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (JID, CID)
);
CREATE TABLE articles (
id tinyint(4) NOT NULL auto_increment,
description text NOT NULL,
title varchar(200) NOT NULL,
content text NOT NULL,
aid int(11) DEFAULT '0' NOT NULL,
datecreated date DEFAULT '0000-00-00' NOT NULL,
PRIMARY KEY (id)
);