`id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', // article title `teaser` text NOT NULL, // the teaser `url` varchar(255) NOT NULL default '', // the title in all lower case with all characters except a-z0-9, spaces converted to dashes. MUST be unique `published` int(11) NOT NULL default '0', // a unix timestamp `text` text NOT NULL, // the article `author` varchar(255) NOT NULL, //author name `authorLoc` varchar(255) NOT NULL, // author location