8
CREATE TABLE xoops_snippets (
snippetID tinyint(4) NOT NULL auto_increment,
catID tinyint(4) NOT NULL default '0',
title varchar(75) NOT NULL default '0',
body text NOT NULL,
summary text NOT NULL,
uid int(6) default '1',
submit int(1) NOT NULL default '0',
datesub int(11) NOT NULL default '1033141070',
counter int(8) unsigned NOT NULL default '0',
weight int(11) NOT NULL default '1',
groupid varchar(255) NOT NULL default '1 2 3',
rating double(6,4) NOT NULL default '0.0000',
votes int(11) unsigned NOT NULL default '0',
PRIMARY KEY (snippetID),
UNIQUE KEY snippetID (snippetID),
FULLTEXT KEY body (body)
) TYPE=MyISAM COMMENT='WF-Snippets by hsalazar, after Catzwolf';
do i need to make some fix with this table ?
