Location: PHPKode > projects > Pointter PHP CMS > pointtercms_package/pointtercms_package/pointtercms_tables.txt
CREATE TABLE `ACheck` (
  `AdminID` int(11) NOT NULL auto_increment,
  `EmailAddress` varchar(50) NOT NULL default '',
  `Password` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`AdminID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `Blog` (
  `BlogID` float NOT NULL auto_increment,
  `Url` varchar(100) NOT NULL default '0',
  `Content` text NOT NULL,
  `Email` varchar(100) NOT NULL default '',
  `Date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`BlogID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `Box` (
  `BoxID` float NOT NULL auto_increment,
  `Name` varchar(100) NOT NULL default '',
  `Position` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`BoxID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



CREATE TABLE `Category` (
  `CategoryID` float NOT NULL auto_increment,
  `Name` varchar(100) NOT NULL default '',
  `Code` tinyint(1) NOT NULL default '0',
  `Url` varchar(100) NOT NULL default '',
  `Subcode` float NOT NULL default '0',
  PRIMARY KEY  (`CategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



CREATE TABLE `Images` (
  `ImageID` float NOT NULL auto_increment,
  `Url` varchar(100) NOT NULL default '',
  `Imagefile` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`ImageID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



CREATE TABLE `Members` (
  `MemberID` float NOT NULL auto_increment,
  `FirstName` varchar(30) NOT NULL default '',
  `LastName` varchar(30) NOT NULL default '',
  `EmailAddress` varchar(100) NOT NULL default '',
  `Password` varchar(100) NOT NULL default '',
  `City` varchar(20) NOT NULL default '',
  `Country` varchar(20) NOT NULL default '',
  `IP` varchar(100) NOT NULL default '',
  `LogDate` varchar(10) NOT NULL default '',
  `News` tinyint(1) NOT NULL default '1',
  `Active` int(1) NOT NULL default '0',
  `ID` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`MemberID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



CREATE TABLE `Metatags` (
  `TagID` float NOT NULL auto_increment,
  `Url` varchar(100) NOT NULL default '',
  `Title` text NOT NULL,
  `Description` text NOT NULL,
  `Keywords` text NOT NULL,
  PRIMARY KEY  (`TagID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

INSERT INTO `Metatags` VALUES(1, 'accountsubmit.php', '', '', '');
INSERT INTO `Metatags` VALUES(2, 'confirmaccount.php', '', '', '');
INSERT INTO `Metatags` VALUES(3, 'createaccount.php', '', '', '');
INSERT INTO `Metatags` VALUES(4, 'forgotpassword.php', '', '', '');
INSERT INTO `Metatags` VALUES(5, 'index.php', '', '', '');
INSERT INTO `Metatags` VALUES(6, 'logout.php', '', '', '');
INSERT INTO `Metatags` VALUES(7, 'memberinfo.php', '', '', '');
INSERT INTO `Metatags` VALUES(8, 'passwordconfirm.php', '', '', '');
INSERT INTO `Metatags` VALUES(9, 'searchresult.php', '', '', '');



CREATE TABLE `Products` (
  `ProductID` float NOT NULL auto_increment,
  `Url` varchar(100) NOT NULL default '',
  `Category` varchar(100) NOT NULL default '',
  `ProductName` varchar(100) NOT NULL default '',
  `Image` varchar(200) NOT NULL default '',
  `Html` text NOT NULL,
  `Subcode` varchar(20) NOT NULL default '0',
  PRIMARY KEY  (`ProductID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



CREATE TABLE `Settings` (
  `SettingsID` int(1) NOT NULL default '1',
  `Boxonoff` int(1) NOT NULL default '1',
  `Boxposition` int(1) NOT NULL default '0',
  `Boxcount` int(1) NOT NULL default '1',
  `Boxname` varchar(20) NOT NULL default 'Category',
  `Todayposition` int(1) NOT NULL default '1',
  `Todayonoff` int(1) NOT NULL default '1',
  `Todayname` varchar(20) NOT NULL default 'Today',
  `Mostonoff` int(1) NOT NULL default '1',
  `Mostposition` int(1) NOT NULL default '0',
  `Mostname` varchar(20) NOT NULL default 'Most Viewed',
  `Newonoff` int(1) NOT NULL default '1',
  `Newposition` int(1) NOT NULL default '0',
  `Newname` varchar(20) NOT NULL default 'Newly Added',
  `Memberonoff` int(1) NOT NULL default '1',
  `Memberposition` int(1) NOT NULL default '1',
  `Membername` varchar(20) NOT NULL default 'Member Login',
  `Searchonoff` int(1) NOT NULL default '1',
  `Searchname` varchar(100) NOT NULL default 'Search',
  `EmailAddress` varchar(100) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `Settings` VALUES(1, 1, 0, 1, 'Category', 1, 1, 'Today Box', 1, 1, 'Most Viewed', 1, 1, 'Newly Added', 1, 1, 'Member Module', 1, 'Search A Product', '');



CREATE TABLE `Static` (
  `StaticID` float NOT NULL auto_increment,
  `Name` varchar(100) NOT NULL default '',
  `Url` varchar(100) NOT NULL default '',
  `Html` text NOT NULL,
  `Boxname` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`StaticID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

INSERT INTO `Static` VALUES(1, 'Account Submit', 'accountsubmit.php', '', 'System');
INSERT INTO `Static` VALUES(2, 'Confirm Account', 'confirmaccount.php', '', 'System');
INSERT INTO `Static` VALUES(3, 'Create Account', 'createaccount.php', '', 'System');
INSERT INTO `Static` VALUES(4, 'Forgot Password', 'forgotpassword.php', '', 'System');
INSERT INTO `Static` VALUES(5, 'Index', 'index.php', '', 'System');
INSERT INTO `Static` VALUES(6, 'Log Out', 'logout.php', '', 'System');
INSERT INTO `Static` VALUES(7, 'Member Info', 'memberinfo.php', '', 'System');
INSERT INTO `Static` VALUES(8, 'Password Confirm', 'passwordconfirm.php', '', 'System');
INSERT INTO `Static` VALUES(9, 'Search Result', 'searchresult.php', '', 'System');



CREATE TABLE `Views` (
  `ViewID` float NOT NULL auto_increment,
  `Url` varchar(100) NOT NULL default '',
  `Number` float NOT NULL default '0',
  `Name` varchar(100) NOT NULL default '',
  `Type` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`ViewID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

INSERT INTO `Views` VALUES(1, 'accountsubmit.php', 0, 'Account Submit', 'Page');
INSERT INTO `Views` VALUES(2, 'confirmaccount.php', 0, 'Confirm Account', 'Page');
INSERT INTO `Views` VALUES(3, 'createaccount.php', 0, 'Create Account', 'Page');
INSERT INTO `Views` VALUES(4, 'forgotpassword.php', 0, 'Forgot Password', 'Page');
INSERT INTO `Views` VALUES(5, 'index.php', 0, 'Index', 'Page');
INSERT INTO `Views` VALUES(6, 'logout.php', 0, 'Log Out', 'Page');
INSERT INTO `Views` VALUES(7, 'memberinfo.php', 0, 'Member Info', 'Page');
INSERT INTO `Views` VALUES(8, 'passwordconfirm.php', 0, 'Password Confirm', 'Page');
INSERT INTO `Views` VALUES(9, 'searchresult.php', 0, 'Search Result', 'Page');
Return current item: Pointter PHP CMS