View file dotwidgeta/info/dotwidgeta.sql

File size: 882B
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)



);