CREATE TABLE `miicc_content` (
  `id` int(11) NOT NULL auto_increment,
  `page` varchar(100) NOT NULL default '',
  `content` text NOT NULL,
  `left` text NOT NULL,
  `title` text NOT NULL,  
  `pagetitle` text NOT NULL,
  `keywords` text NOT NULL,
  `description` text NOT NULL,
  `parentid` int(11) NOT NULL default '0',
  `menu` int(1) NOT NULL default '0',
  `seq_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)



CREATE TABLE `miicc_mainsettings` (
  `adminuser` varchar(100) NOT NULL default '',
  `adminpass` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `subject` text NOT NULL,
  `message` text NOT NULL,
  `confirm` text NOT NULL,
  `title` text NOT NULL,
  `metakeywords` text NOT NULL,
  `metadescription` text NOT NULL
)


INSERT INTO `miicc_mainsettings` VALUES ('admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@miicc.com', 'Message from MIICC site', '', 'Thank you for you message we will be with you shortly', '', '', '');