Location: PHPKode > projects > Exero CMS > upload/install/resource/install_create_tables.php
<?
/*========================================*\
| Exero CMS                                |
|==========================================|
|          http://ecms.getox.net           |
|https://sourceforge.net/projects/exerocms/|
|==========================================|
|     Exero CMS is released under the      |
|     GNU General Public License (GPL)     |
| opensource.org/licenses/gpl-license.php  |
\*========================================*/

$table['1'] = "admin_items";
$db_table['1'] = "CREATE TABLE `".TABLE_PREFIX."admin_items` (
				  `id` bigint(20) NOT NULL auto_increment,
				  `title` varchar(255) NOT NULL default '',
				  `file` varchar(255) NOT NULL default '',
				  UNIQUE KEY `id` (`id`)
				) TYPE=MyISAM;";
				
$table['2'] = "admin_modules";
$db_table['2'] = "CREATE TABLE `".TABLE_PREFIX."admin_modules` (
				  `ident` varchar(255) NOT NULL default '',
				  `title` varchar(255) NOT NULL default '',
				  `file` varchar(255) NOT NULL default ''
				) TYPE=MyISAM;";
				
$table['3'] = "admin_permissions";
$db_table['3'] = "CREATE TABLE `".TABLE_PREFIX."admin_permissions` (
				  `groupid` varchar(255) NOT NULL default '',
				  `globalsettings` varchar(255) NOT NULL default '',
				  `installmodules` varchar(255) NOT NULL default '',
				  `managemodules` varchar(255) NOT NULL default '',
				  `manageblocks` varchar(255) NOT NULL default '',
				  `managepages` varchar(255) NOT NULL default '',
				  `manageitems` varchar(255) NOT NULL default '',
				  `manageusers` varchar(255) NOT NULL default '',
				  `managegroups` varchar(255) NOT NULL default '',
				  `useadminmodules` varchar(255) NOT NULL default '',
				  `managethemes` varchar(255) NOT NULL default '',
				  `manageplugins` varchar(255) NOT NULL default ''
				) TYPE=MyISAM;";

$table['4'] = "admin_sessions";
$db_table['4'] = "CREATE TABLE `".TABLE_PREFIX."admin_sessions` (
				  `userid` varchar(255) NOT NULL default '',
				  `sessionid` varchar(255) NOT NULL default '',
				  `lastactive` varchar(255) NOT NULL default ''
				) TYPE=MyISAM;";

$table['5'] = "blocks";
$db_table['5'] = "CREATE TABLE `".TABLE_PREFIX."blocks` (
				  `id` bigint(20) NOT NULL auto_increment,
				  `ident` varchar(255) NOT NULL default '',
				  `title` varchar(255) NOT NULL default '',
				  `side` varchar(255) NOT NULL default '',
				  `active` varchar(255) NOT NULL default '',
				  `displayorder` varchar(255) NOT NULL default '',
				  `content` longtext NOT NULL,
				  `items` longtext NOT NULL,
				  `groupaccess` varchar(255) NOT NULL default '',
				  `status` varchar(255) NOT NULL default '',
				  UNIQUE KEY `id` (`id`)
				) TYPE=MyISAM;";

$table['6'] = "custompages";
$db_table['6'] = "CREATE TABLE `".TABLE_PREFIX."custompages` (
				  `ident` varchar(255) NOT NULL default '',
				  `title` varchar(255) NOT NULL default '',
				  `page` longtext NOT NULL
				) TYPE=MyISAM;";

$table['7'] = "globalmodules";
$db_table['7'] = "CREATE TABLE `".TABLE_PREFIX."globalmodules` (
				  `id` bigint(20) NOT NULL auto_increment,
				  `module` varchar(255) NOT NULL default '',
				  `file` varchar(255) NOT NULL default '',
				  UNIQUE KEY `id` (`id`)
				) TYPE=MyISAM;";

$table['8'] = "groups";
$db_table['8'] = "CREATE TABLE `".TABLE_PREFIX."groups` (
				  `gid` bigint(20) NOT NULL auto_increment,
				  `title` varchar(255) NOT NULL default '',
				  `usertitle` varchar(255) NOT NULL default '',
				  `admincp` varchar(255) NOT NULL default '0',
				  UNIQUE KEY `gid` (`gid`)
				) TYPE=MyISAM;";

$table['9'] = "installed_modules";
$db_table['9'] = "CREATE TABLE `".TABLE_PREFIX."installed_modules` (
				  `name` varchar(255) NOT NULL default '',
				  `version` varchar(255) NOT NULL default '',
				  `ident` varchar(255) NOT NULL default '',
				  `author` varchar(255) NOT NULL default '',
				  `file` varchar(255) NOT NULL default ''
				) TYPE=MyISAM;";

$table['10'] = "items";
$db_table['10'] = "CREATE TABLE `".TABLE_PREFIX."items` (
				  `id` bigint(20) NOT NULL auto_increment,
				  `title` varchar(255) NOT NULL default '',
				  `itemfile` varchar(255) NOT NULL default '',
				  `info` longtext NOT NULL,
				  `extra` longtext NOT NULL,
				  `groupaccess` varchar(255) NOT NULL default '',
				  UNIQUE KEY `id` (`id`)
				) TYPE=MyISAM;";

$table['11'] = "modules";
$db_table['11'] = "CREATE TABLE `".TABLE_PREFIX."modules` (
				  `id` bigint(20) NOT NULL auto_increment,
				  `ident` varchar(255) NOT NULL default '',
				  `title` varchar(255) NOT NULL default '',
				  `directory` varchar(255) NOT NULL default '',
				  `block` varchar(255) NOT NULL default '',
				  `active` varchar(255) NOT NULL default '',
				  `editable` varchar(255) NOT NULL default '',
				  `indexcapable` longtext NOT NULL,
				  `blockshidden` varchar(255) NOT NULL default '',
				  `blocksviewable` varchar(255) NOT NULL default '',
				  UNIQUE KEY `id` (`id`)
				) TYPE=MyISAM;";

$table['12'] = "modulesettings";
$db_table['12'] = "CREATE TABLE `".TABLE_PREFIX."modulesettings` (
				  `moduleident` varchar(255) NOT NULL default '',
				  `label` varchar(255) NOT NULL default '',
				  `setting` varchar(255) NOT NULL default '',
				  `value` longtext NOT NULL,
				  `type` varchar(255) NOT NULL default '',
				  `options` longtext NOT NULL,
				  `editable` varchar(255) NOT NULL default ''
				) TYPE=MyISAM;";

$table['13'] = "news";
$db_table['13'] = "CREATE TABLE `".TABLE_PREFIX."news` (
				  `id` bigint(20) NOT NULL auto_increment,
				  `title` varchar(255) NOT NULL default '',
				  `poster` varchar(255) NOT NULL default '',
				  `catid` varchar(255) NOT NULL default '',
				  `message` longtext NOT NULL,
				  `timestamp` varchar(255) NOT NULL default '',
				  `allowcomments` varchar(255) NOT NULL default '',
				  UNIQUE KEY `id` (`id`)
				) TYPE=MyISAM;";

$table['14'] = "news_cats";
$db_table['14'] = "CREATE TABLE `".TABLE_PREFIX."news_cats` (
				  `id` bigint(20) NOT NULL auto_increment,
				  `title` varchar(255) NOT NULL default '',
				  `picture` varchar(255) NOT NULL default '',
				  UNIQUE KEY `id` (`id`)
				) TYPE=MyISAM;";

$table['15'] = "news_comments";
$db_table['15'] = "CREATE TABLE `".TABLE_PREFIX."news_comments` (
				  `id` bigint(20) NOT NULL auto_increment,
				  `newsid` varchar(255) NOT NULL default '',
				  `posterid` varchar(255) NOT NULL default '',
				  `message` varchar(255) NOT NULL default '',
				  `timestamp` varchar(255) NOT NULL default '',
				  UNIQUE KEY `id` (`id`)
				) TYPE=MyISAM;";

$table['16'] = "permissions";
$db_table['16'] = "CREATE TABLE `".TABLE_PREFIX."permissions` (
				  `id` bigint(20) NOT NULL auto_increment,
				  `module` varchar(255) NOT NULL default '',
				  `section` varchar(255) NOT NULL default '',
				  `parent` varchar(255) NOT NULL default '',
				  `groupaccess` varchar(255) NOT NULL default '',
				  UNIQUE KEY `id` (`id`)
				) TYPE=MyISAM;";

$table['17'] = "plugin_data";
$db_table['17'] = "CREATE TABLE `".TABLE_PREFIX."plugin_data` (
				  `id` bigint(20) NOT NULL auto_increment,
				  `title` varchar(255) NOT NULL default '',
				  `hooklocation` varchar(255) NOT NULL default '',
				  `code` longtext NOT NULL,
				  `enabled` varchar(255) NOT NULL default '',
				  `pluginid` varchar(255) NOT NULL default '',
				  UNIQUE KEY `id` (`id`)
				) TYPE=MyISAM;";

$table['18'] = "plugins";
$db_table['18'] = "CREATE TABLE `".TABLE_PREFIX."plugins` (
				  `id` bigint(20) NOT NULL auto_increment,
				  `name` varchar(255) NOT NULL default '',
				  `uninstallcode` longtext NOT NULL,
				  UNIQUE KEY `id` (`id`)
				) TYPE=MyISAM;";

$table['19'] = "sessions";
$db_table['19'] = "CREATE TABLE `".TABLE_PREFIX."sessions` (
				  `sid` bigint(20) NOT NULL auto_increment,
				  `sessionid` varchar(255) NOT NULL default '',
				  `userid` varchar(255) NOT NULL default '',
				  `password` varchar(255) NOT NULL default '',
				  `remember` varchar(255) NOT NULL default '',
				  `lastvisit` varchar(255) NOT NULL default '',
				  UNIQUE KEY `sid` (`sid`)
				) TYPE=MyISAM;";

$table['20'] = "settings";
$db_table['20'] = "CREATE TABLE `".TABLE_PREFIX."settings` (
				  `setting` varchar(255) NOT NULL default '',
				  `value` longtext NOT NULL
				) TYPE=MyISAM;";

$table['21'] = "users";
$db_table['21'] = "CREATE TABLE `".TABLE_PREFIX."users` (
				  `uid` bigint(20) NOT NULL auto_increment,
				  `username` varchar(255) NOT NULL default '',
				  `password` varchar(255) NOT NULL default '',
				  `email` varchar(255) NOT NULL default '',
				  `groupid` varchar(255) NOT NULL default '',
				  `signature` varchar(255) NOT NULL default '',
				  `usertitle` varchar(255) NOT NULL default '',
				  `lastvisit` varchar(255) NOT NULL default '',
				  `lastactivity` varchar(255) NOT NULL default '',
				  `sessionid` varchar(255) NOT NULL default '',
				  `remember` varchar(255) NOT NULL default '',
				  `avatar` varchar(255) NOT NULL default '',
				  UNIQUE KEY `uid` (`uid`)
				) TYPE=MyISAM;";
?>
Return current item: Exero CMS