CREATE TABLE `{$tablePrefix}categories` (
`categoryid` int(11) NOT NULL auto_increment,
`parentid` int(11) default '0',
`name` varchar(255) NOT NULL default '',
`description` longtext,
`metadesc` text,
`metakeywords` text,
`metatitle` varchar(255) NOT NULL default '',
`visits` int(11) default '0',
`sortorder` int(11) default '0',
`caticon` varchar(255) NOT NULL default '',
`catpass` varchar(255) NOT NULL default '',
`contentcount` int(11) NOT NULL default '0',
`sortcache` varchar(255) NOT NULL default '',
`generateurl` int(1) unsigned NOT NULL default '1',
`hidefrommenu` int(11) NOT NULL default '0',
`haslayout` int(1) NOT NULL default '0',
PRIMARY KEY  (`categoryid`),
KEY `{$tablePrefix}category_parentid` (`parentid`),
KEY `sortorder` (`sortorder`),
KEY `sortcache` (`sortcache`),
FULLTEXT KEY `description` (`description`),
FULLTEXT KEY `name` (`name`),
FULLTEXT KEY `name_3` (`name`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;


CREATE TABLE `{$tablePrefix}categoryassociations` (
`associationid` int(11) NOT NULL auto_increment,
`contentid` int(11) default '0',
`categoryid` int(11) default '0',
PRIMARY KEY  (`associationid`),
KEY `contentid` (`contentid`),
KEY `categoryid` (`categoryid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;



CREATE TABLE `{$tablePrefix}content` (
`contentid` int(11) NOT NULL auto_increment,
`typeid` int(11) default '0',
`title` varchar(255) NOT NULL,
`author` varchar(255) default NULL,
`content` longtext NOT NULL,
`startdate` datetime default NULL,
`visible` int(1) NOT NULL default '1',
`status` enum('approved','pending','disapproved','draft') default NULL,
`featured` int(1) NOT NULL default '0',
`metakeywords` text,
`metadesc` text,
`summary` text,
`views` int(11) default '0',
`expirydate` datetime default NULL,
`enableexpiry` int(1) default NULL,
`parentid` int(11) NOT NULL default '0',
`metatitle` varchar(255) default NULL,
`sortorder` FLOAT NOT NULL DEFAULT '0',
`pagesortorder` int(11) default '0',
`hidefrommenu` int(1) NOT NULL default '0',
`contentparentid` int(11) NOT NULL default '0',
`hierarchycache` varchar(255) default NULL,
`sortcache` varchar(255) default NULL,
`haslayout` int(1) NOT NULL default '0',
`metaauto` tinyint(1) NOT NULL default '0',
PRIMARY KEY  (`contentid`),
KEY `authorlist` (`author`),
KEY `startdate` (`startdate`),
KEY `expirydate` (`expirydate`),
KEY `sortorder` (`sortorder`),
KEY `contentparentid` (`contentparentid`),
FULLTEXT KEY `title_ft` (`title`),
FULLTEXT KEY `title_summary_ft` (`title`,`content`),
FULLTEXT KEY `content` (`content`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;


CREATE TABLE `{$tablePrefix}content_types` (
`typeid` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`name_singular` varchar(255) NOT NULL,
`defaulturl` varchar(255) NOT NULL,
`modulelist` text,
`cachetime` int(11) unsigned NOT NULL default '1',
`cacheunit` enum('hours','minutes','days','seconds') NOT NULL default 'days',
`searchable` tinyint(1) unsigned NOT NULL default '0',
`typeicon` varchar(255) default '',
`field_visible` int(1) unsigned NOT NULL,
`field_hidefrommenu` int(1) NOT NULL,
`field_startdate` int(1) NOT NULL,
`field_expiryoptions` int(1) NOT NULL,
`field_status` int(1) NOT NULL,
PRIMARY KEY  (`typeid`),
KEY `searchable` (`searchable`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `{$tablePrefix}content_vars` (
`varid` int(11) NOT NULL auto_increment,
`moduleid` int(11) NOT NULL,
`typeid` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`value` varchar(255) NOT NULL,
PRIMARY KEY  (`varid`),
KEY `typeid` (`typeid`),
KEY `moduleid` (`moduleid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;


CREATE TABLE `{$tablePrefix}content_views` (
`searchid` int(10) unsigned NOT NULL auto_increment,
`searchname` varchar(255) NOT NULL,
`values` longtext NOT NULL,
PRIMARY KEY  (`searchid`),
KEY `searchname` (`searchname`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;

CREATE TABLE `{$tablePrefix}groupassociations` (
`associd` int(11) NOT NULL auto_increment,
`groupid` int(11) NOT NULL,
`userid` int(11) NOT NULL,
PRIMARY KEY  (`associd`),
KEY `groupid` (`groupid`),
KEY `userid` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;


CREATE TABLE `{$tablePrefix}grouppermissions` (
`permid` int(11) NOT NULL auto_increment,
`groupid` int(11) NOT NULL,
`scopetype` char(16) character set latin1 NOT NULL,
`itemcsv` text character set latin1 NOT NULL,
`granularity` char(16) default NULL,
`catcsv` text character set latin1 NOT NULL,
`flag` enum('allow','deny') default NULL,
`scopename` char(32) NOT NULL,
`scopeitem` char(32) NOT NULL,
PRIMARY KEY  (`permid`),
KEY `groupid` (`groupid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;


CREATE TABLE `{$tablePrefix}groups` (
`groupid` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
PRIMARY KEY  (`groupid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;

CREATE TABLE `{$tablePrefix}list_filters` (
`filterid` int(11) NOT NULL auto_increment,
`listid` int(11) NOT NULL,
`filtertype` enum('where','orderby','limit') NOT NULL,
`fieldname` varchar(255) default NULL,
`value` varchar(255) default NULL,
`operator` varchar(255) default NULL,
PRIMARY KEY  (`filterid`),
KEY `menuid` (`listid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;


CREATE TABLE `{$tablePrefix}list_links` (
`itemid` int(11) NOT NULL auto_increment,
`listid` int(11) unsigned NOT NULL,
`url` varchar(255) NOT NULL,
`text` varchar(255) NOT NULL,
`target` enum('same','new') NOT NULL default 'same',
`sortorder` int(11) NOT NULL,
`parentid` int(11) unsigned NOT NULL default '0',
PRIMARY KEY  (`itemid`),
KEY `menuid` (`listid`),
KEY `sortorder` (`sortorder`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;

CREATE TABLE `{$tablePrefix}lists` (
`listid` int(11) NOT NULL auto_increment,
`type` enum('static','dynamic','rss') NOT NULL,
`title` varchar(255) NOT NULL,
`querycache` text,
`datatype` enum('none','categories','users','comments','content') NOT NULL default 'none',
`options` text,
`matchtype` enum('or','and','none') NOT NULL default 'none',
`rssurl` varchar(255) default NULL,
`blocktype` varchar(255) NOT NULL,
`cssclasses` varchar(255) NOT NULL,
`rssfeed` enum('yes','no') NOT NULL default 'no',
`homepage` enum('yes','no') NOT NULL default 'no',
`itemcount` int(11) unsigned NOT NULL,
`modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY  (`listid`),
KEY `blocktype` (`blocktype`),
KEY `homepage` (`homepage`),
KEY `rssfeed` (`rssfeed`),
KEY `itemcount` (`itemcount`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;

CREATE TABLE `{$tablePrefix}list_sortcache` (
 `listid` int(11) NOT NULL,
 `sortcache` varchar(255) NOT NULL,
 `contentid` int(11) NOT NULL,
 PRIMARY KEY  (`listid`,`contentid`),
 KEY `contentid` (`contentid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



CREATE TABLE `{$tablePrefix}modules` (
`moduleid` int(11) NOT NULL auto_increment,
`version` int(10) unsigned NOT NULL,
`codename` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
PRIMARY KEY  (`moduleid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;

CREATE TABLE `{$tablePrefix}modulevars` (
`modulecodename` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`value` longtext NOT NULL,
`varid` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY  USING BTREE (`varid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;

CREATE TABLE `{$tablePrefix}settings` (
`settingid` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`value` longtext,
PRIMARY KEY  (`settingid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;


CREATE TABLE `{$tablePrefix}template_data` (
`blockid` int(10) unsigned NOT NULL auto_increment,
`type` varchar(20) NOT NULL,
`name` varchar(255) NOT NULL,
`title` varchar(255) default NULL,
`content` text NOT NULL,
`newwindow` int(1) NOT NULL default '0',
`uri` varchar(255) default NULL,
PRIMARY KEY  (`blockid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;


CREATE TABLE `{$tablePrefix}template_settings` (
`settingid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`value` text NOT NULL,
`template` varchar(255) NOT NULL,
PRIMARY KEY  (`settingid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;

CREATE TABLE `{$tablePrefix}urls` (
`urlid` int(11) unsigned NOT NULL auto_increment,
`urlpath` varchar(255) NOT NULL,
`assoctype` enum('categories','content','comments','users','redirect','module') NOT NULL,
`associd` int(11) unsigned NOT NULL,
`modulename` varchar(50) default NULL,
`redirecttype` enum('categories','content','comments','users','module') default NULL,
PRIMARY KEY  (`urlid`),
UNIQUE KEY `urlpath` (`urlpath`),
KEY `assoctype` (`assoctype`,`associd`),
KEY `modulename` (`modulename`),
KEY `associd` (`associd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;


CREATE TABLE `{$tablePrefix}users` (
`userid` int(11) NOT NULL auto_increment,
`firstname` varchar(255) NOT NULL default '',
`lastname` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`username` varchar(100) NOT NULL default '',
`password` varchar(250) NOT NULL default '',
`biography` longtext,
`picture` varchar(250) NOT NULL default '',
`status` int(11) default '0',
PRIMARY KEY  (`userid`),
KEY `users_username` (`username`),
KEY `users_firstname` (`firstname`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;


CREATE TABLE `{$tablePrefix}views` (
`viewid` int(11) unsigned NOT NULL auto_increment,
`type` enum('user','content','contenttype','group','feedback','module') character set utf8 NOT NULL default 'content',
`name` varchar(255) character set utf8 NOT NULL,
`vars` text character set utf8 NOT NULL,
PRIMARY KEY  (`viewid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;

CREATE TABLE `{$tablePrefix}import` (
  `importid` int(10) unsigned NOT NULL auto_increment,
  `importer` varchar(50) NOT NULL,
  `data` longtext NOT NULL,
  `finished` int(1) NOT NULL default '0',
  PRIMARY KEY  (`importid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;

CREATE TABLE `{$tablePrefix}activity` (
  `activityid` int(10) unsigned NOT NULL auto_increment,
  `source` enum('core','content','module') default NULL,
  `scope` varchar(255) default NULL,
  `subjecttext` varchar(255) default NULL,
  `subjectid` varchar(255) default NULL,
  `usertext` varchar(255) default NULL,
  `userid` varchar(255) default NULL,
  `userip` char(15) default NULL,
  `activitydate` datetime default NULL,
  `action` varchar(255) default NULL,
  `colour` smallint(5) unsigned default NULL,
  PRIMARY KEY  (`activityid`),
  KEY `colour` (`colour`),
  KEY `activitydate` (`activitydate`,`activityid`),
  KEY `source_scope_colour` (`source`,`scope`,`colour`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `{$tablePrefix}settings` (`settingid`, `name`, `value`) VALUES (1, 'code_version', '{$CodeVersion}');
INSERT INTO `{$tablePrefix}settings` (`settingid`, `name`, `value`) VALUES (2, 'database_version', '{$DBVersion}');

INSERT INTO `{$tablePrefix}groups` (`groupid`, `name`) VALUES (1, 'Super Administrator');
INSERT INTO `{$tablePrefix}users` (`userid`, `firstname`, `lastname`, `email`, `username`, `password`, `biography`, `picture`, `status` ) VALUES (1, 'Website', 'Administrator', '{$adminEmail}', 'admin', md5('{$adminPass}'),'', '', 1);
INSERT INTO `{$tablePrefix}grouppermissions` VALUES (1, 1, 'core', '', 'all', '', 'allow', 'root', 'full');

INSERT INTO `{$tablePrefix}groupassociations` VALUES (1, 1, 1);