CREATE TABLE IF NOT EXISTS `pcms2_contenthistory` (
`HistoryID` int(11) NOT NULL auto_increment,
`HistoryContentID` int(11) default NULL,
`HistoryUserID` int(11) default NULL,
`HistoryValue` text,
`HistoryGroup` varchar(100) default NULL,
`HistoryReference` varchar(100) default NULL,
`HistoryDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
`ContentPageName` varchar(100) default NULL,
`ContentPageSetParentID` int(11) default NULL,
`ContentPageSetOrder` int(11) default NULL,
`ParentID` int(11) default NULL,
PRIMARY KEY (`HistoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `pcms2_contents` (
`ContentID` int(11) NOT NULL auto_increment,
`ContentGroup` varchar(100) default NULL,
`ContentRefID` varchar(100) default NULL,
`ContentUserID` int(11) default NULL,
`ContentValue` text,
`ContentDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
`ContentPageName` varchar(100) default NULL,
`ContentPageSetParentID` int(11) default NULL,
`ContentPageSetOrder` int(11) default NULL,
`ParentID` int(11) default NULL,
PRIMARY KEY (`ContentID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `wa_settings` */
CREATE TABLE IF NOT EXISTS wa_settings (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE latin1_bin DEFAULT NULL,
`type` varchar(50) COLLATE latin1_bin DEFAULT NULL,
`options` text COLLATE latin1_bin,
`value` varchar(255) COLLATE latin1_bin DEFAULT NULL,
`grp` varchar(50) COLLATE latin1_bin DEFAULT NULL,
`subcategory` varchar(50) COLLATE latin1_bin DEFAULT NULL,
`cond` varchar(255) COLLATE latin1_bin DEFAULT NULL,
`description` varchar(255) COLLATE latin1_bin DEFAULT NULL,
`variable` varchar(50) COLLATE latin1_bin DEFAULT NULL,
`weight` float DEFAULT NULL,
`spry_args` text COLLATE latin1_bin,
`spry_error` text COLLATE latin1_bin,
`help_text` text COLLATE latin1_bin,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `settings` */
INSERT INTO `wa_settings` (`name`,`type`,`options`,`value`,`grp`,`subcategory`,`cond`,`description`,`variable`,`weight`,`spry_args`,`spry_error`,`help_text`)
VALUES ( 'Temp Placeholder', NULL, NULL, 'My Site', NULL, NULL, NULL, NULL,'Site_Name', NULL, NULL, NULL, NULL );
INSERT INTO `wa_settings` (`name`,`type`,`options`,`value`,`grp`,`subcategory`,`cond`,`description`,`variable`,`weight`,`spry_args`,`spry_error`,`help_text`)
SELECT 'Site Name', NULL, NULL, 'My Site', NULL, NULL, NULL, NULL,'Site_Name', NULL, NULL, NULL, NULL FROM wa_settings WHERE NOT EXISTS (SELECT name FROM wa_settings WHERE name='Site Name') LIMIT 1;
INSERT INTO `wa_settings` (`name`,`type`,`options`,`value`,`grp`,`subcategory`,`cond`,`description`,`variable`,`weight`,`spry_args`,`spry_error`,`help_text`)
SELECT 'Serial Number', NULL, NULL, '@@serial_number@@', NULL, NULL, NULL, NULL,'PCMS_Serial', NULL, NULL, NULL, NULL FROM wa_settings WHERE NOT EXISTS (SELECT name FROM wa_settings WHERE name='Serial Number') LIMIT 1;
INSERT INTO `wa_settings` (`name`,`type`,`options`,`value`,`grp`,`subcategory`,`cond`,`description`,`variable`,`weight`,`spry_args`,`spry_error`,`help_text`)
SELECT 'Image Upload Folder', NULL, NULL, 'files', NULL, NULL, NULL, NULL, 'images_folder', NULL, NULL, NULL, NULL FROM wa_settings WHERE NOT EXISTS (SELECT name FROM wa_settings WHERE name='Image Upload Folder') LIMIT 1;
INSERT INTO `wa_settings` (`name`,`type`,`options`,`value`,`grp`,`subcategory`,`cond`,`description`,`variable`,`weight`,`spry_args`,`spry_error`,`help_text`)
SELECT 'Disable Images Upload', NULL, NULL, 0, NULL, NULL, NULL, NULL, 'dis_images_upload', NULL, NULL, NULL, NULL FROM wa_settings WHERE NOT EXISTS (SELECT name FROM wa_settings WHERE name='Disable Images Upload') LIMIT 1;
DELETE FROM `wa_settings` WHERE name = 'Temp Placeholder';
/*Table structure for table `usergroups` */
CREATE TABLE IF NOT EXISTS `pcms2_usergroups` (
`UserGroupID` int(11) NOT NULL auto_increment,
`UserGroup` varchar(50) default NULL,
PRIMARY KEY (`UserGroupID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `usergroups` */
INSERT INTO `pcms2_usergroups` (`UserGroupID`,`UserGroup`) VALUES (0,'Temp Placeholder');
INSERT INTO `pcms2_usergroups` (`UserGroupID`,`UserGroup`)
SELECT 1,'Administrator' FROM pcms2_usergroups WHERE NOT EXISTS (SELECT UserGroupID FROM pcms2_usergroups WHERE UserGroupID=1) LIMIT 1;
DELETE FROM `pcms2_usergroups` WHERE `UserGroup`='Temp Placeholder';
/*Table structure for table `users` */
CREATE TABLE IF NOT EXISTS `pcms2_users` (
`UserID` int(11) NOT NULL auto_increment,
`UserEmail` varchar(500) default NULL,
`UserPassword` varchar(500) default NULL,
`UserFirstName` varchar(50) default NULL,
`UserLastName` varchar(50) default NULL,
`UserCity` varchar(90) default NULL,
`UserState` varchar(20) default NULL,
`UserZip` varchar(12) default NULL,
`UserEmailVerified` tinyint(1) default '0',
`UserRegistrationDate` timestamp NULL default CURRENT_TIMESTAMP,
`UserVerificationCode` varchar(20) default NULL,
`UserIP` varchar(50) default NULL,
`UserPhone` varchar(20) default NULL,
`UserFax` varchar(20) default NULL,
`UserCountry` varchar(20) default NULL,
`UserAddress` varchar(100) default NULL,
`UserAddress2` varchar(50) default NULL,
`UserGroupID` int(11) NOT NULL default '1',
PRIMARY KEY (`UserID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;