Table: cohaontario
Create Table: CREATE TABLE `cohaontario` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `orderinpage` tinyint(3) unsigned NOT NULL default '0',
  `mainfolder` tinytext NOT NULL,
  `mainlevel` mediumint(8) unsigned NOT NULL default '0',
  `subfolder` tinytext NOT NULL,
  `level_name` tinytext NOT NULL,
  `level` smallint(5) unsigned NOT NULL default '0',
  `title` tinytext NOT NULL,
  `show_title` tinyint(1) NOT NULL default '1',
  `menutext` tinytext NOT NULL,
  `template` varchar(100) NOT NULL default '/u/c/cohaontario/scripts/websitemanager/templates/cohaontario_template.php',
  `path` tinytext NOT NULL,
  `content` mediumtext NOT NULL,
  `meta_title` tinytext NOT NULL,
  `meta_desc` text NOT NULL,
  `meta_key` text NOT NULL,
  `use_section_meta` tinyint(1) NOT NULL default '1',
  `use_site_meta` tinyint(1) NOT NULL default '1',
  `form_name` tinytext,
  `access_type` enum('all','members','limited access') NOT NULL default 'all',
  `owner` tinytext NOT NULL,
  `page_status` enum('Live and in Menu','Live but Hidden','Live - Hidden except SiteMap','Link to other page','Suspend','New','Delete this Page') NOT NULL default 'Live and in Menu',
  `gifname` tinytext NOT NULL,
  `gifwidth` varchar(3) NOT NULL default '',
  `gifheight` varchar(3) NOT NULL default '',
  `active` char(1) NOT NULL default '',
  `access` tinytext NOT NULL,
  `has_subpages` char(1) default 'F',
  `highlight` mediumtext,
  `footer_content` text NOT NULL,
  `footer_name` tinytext NOT NULL,
  `menu_colour` tinytext NOT NULL,
  `right_col` text NOT NULL,
  `profile` varchar(255) NOT NULL default '',
  `form_inc_id` int(10) unsigned NOT NULL,
  `left_col` text NOT NULL,
  `is_secure` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=597 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

mysql> show create table metatags \G
*************************** 1. row ***************************
       Table: metatags
Create Table: CREATE TABLE `metatags` (
  `mainlevel` mediumint(9) NOT NULL default '0',
  `mainfolder` tinytext,
  `meta_title` tinytext,
  `meta_desc` text,
  `meta_key` text,
  `client` tinytext NOT NULL,
  `meta_title_fr` tinytext,
  `meta_desc_fr` text,
  `meta_key_fr` text,
  UNIQUE KEY `meta_index` (`client`(8),`mainlevel`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
show create table loginname \G
*************************** 1. row ***************************
       Table: loginname
Create Table: CREATE TABLE `loginname` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `email` tinytext NOT NULL,
  `name` tinytext NOT NULL,
  `username` tinytext character set utf8 collate utf8_bin NOT NULL,
  `password` tinytext character set utf8 collate utf8_bin NOT NULL,
  `active` int(10) unsigned NOT NULL default '1',
  `access_level` varchar(45) NOT NULL default 'member',
  `accesstool` tinytext,
  `accesspage` tinytext,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
mysql> show create table variables \G
*************************** 1. row ***************************
       Table: variables
Create Table: CREATE TABLE `variables` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `code` mediumtext,
  `varname` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
mysql> show create table Web_session \G
*************************** 1. row ***************************
       Table: Web_session
Create Table: CREATE TABLE `Web_session` (
  `web_session_id` int(11) NOT NULL auto_increment,
  `id` int(11) NOT NULL,
  `login_date` datetime NOT NULL,
  `remember` int(11) NOT NULL,
  `session_id` varchar(45) NOT NULL,
  `expiry` int(11) NOT NULL,
  `last_access` datetime NOT NULL,
  `last_page` tinytext NOT NULL,
  `access_level` tinytext NOT NULL,
  `user` varchar(100) default NULL,
  PRIMARY KEY  (`web_session_id`)
) ENGINE=MyISAM AUTO_INCREMENT=561 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)