Posted on: 12/19/04 06:12pm
By: Anonymous (Mark)
Posted on: 12/19/04 11:47pm
By: mthomas
CREATE TABLE gl_staticpage ( sp_id varchar(40) NOT NULL default '', sp_uid mediumint(8) NOT NULL default '1', sp_title varchar(128) NOT NULL default '', sp_content text NOT NULL, sp_hits mediumint(8) unsigned NOT NULL default '0', sp_date datetime NOT NULL default '0000-00-00 00:00:00', sp_format varchar(20) NOT NULL default '', sp_onmenu tinyint(1) unsigned NOT NULL default '0', sp_label varchar(64) default NULL, group_id mediumint(8) unsigned NOT NULL default '1', owner_id mediumint(8) unsigned NOT NULL default '1', perm_owner tinyint(1) unsigned NOT NULL default '3', perm_group tinyint(1) unsigned NOT NULL default '2', perm_members tinyint(1) unsigned NOT NULL default '2', perm_anon tinyint(1) unsigned NOT NULL default '2', sp_centerblock tinyint(1) unsigned NOT NULL default '0', sp_tid varchar(20) NOT NULL default 'none', sp_where tinyint(1) unsigned NOT NULL default '1', sp_php tinyint(1) unsigned NOT NULL default '0', sp_nf tinyint(1) unsigned default '0', sp_inblock tinyint(1) unsigned default '1', PRIMARY KEY (sp_id), KEY staticpage_sp_uid (sp_uid), KEY staticpage_sp_date (sp_date), KEY staticpage_sp_onmenu (sp_onmenu), KEY staticpage_sp_centerblock (sp_centerblock), KEY staticpage_sp_tid (sp_tid), KEY staticpage_sp_where (sp_where) ) TYPE=MyISAM