-- phpMyAdmin SQL Dump
-- version 2.9.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 24, 2009 at 03:09 PM
-- Server version: 5.0.67
-- PHP Version: 5.2.6
--
-- Database: `jcore_client`
--
-- --------------------------------------------------------
--
-- Table structure for table `ads`
--
DROP TABLE IF EXISTS `ads`;
CREATE TABLE `ads` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Location` varchar(255) NOT NULL,
`Title` varchar(255) default NULL,
`URL` varchar(255) default NULL,
`AdCode` mediumtext,
`TimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`BlockID` smallint(5) unsigned NOT NULL default '0',
`StartDate` date default NULL,
`EndDate` date default NULL,
`ShowOn` varchar(15) default NULL,
`Deactivated` tinyint(1) NOT NULL default '0',
`Shown` int(10) unsigned NOT NULL default '0',
`Clicked` int(10) unsigned NOT NULL default '0',
`OrderID` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `ShowOn` (`ShowOn`),
KEY `OrderID` (`OrderID`),
KEY `BlockID` (`BlockID`,`StartDate`,`EndDate`,`Deactivated`)
) ENGINE=MyISAM;
--
-- Dumping data for table `ads`
--
-- --------------------------------------------------------
--
-- Table structure for table `bfprotection`
--
DROP TABLE IF EXISTS `bfprotection`;
CREATE TABLE `bfprotection` (
`Username` varchar(100) NOT NULL default '',
`IP` bigint(20) NOT NULL default '0',
`TimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
KEY `IP` (`IP`)
) ENGINE=MyISAM;
--
-- Dumping data for table `bfprotection`
--
-- --------------------------------------------------------
--
-- Table structure for table `bfprotectionbans`
--
DROP TABLE IF EXISTS `bfprotectionbans`;
CREATE TABLE `bfprotectionbans` (
`IP` bigint(20) NOT NULL default '0',
`EndTimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`Usernames` mediumtext NOT NULL,
KEY `IP` (`IP`)
) ENGINE=MyISAM;
--
-- Dumping data for table `bfprotectionbans`
--
-- --------------------------------------------------------
--
-- Table structure for table `blocks`
--
DROP TABLE IF EXISTS `blocks`;
CREATE TABLE `blocks` (
`ID` smallint(5) unsigned NOT NULL auto_increment,
`Title` varchar(255) NOT NULL,
`Content` mediumtext NOT NULL,
`BlockID` varchar(100) NOT NULL,
`Class` varchar(255) NOT NULL,
`Deactivated` tinyint(1) unsigned NOT NULL default '0',
`TypeID` tinyint(3) unsigned NOT NULL default '0',
`SubBlockOfID` smallint(5) unsigned NOT NULL default '0',
`MenuItemIDs` varchar(255) NOT NULL,
`MenuItemExcept` tinyint(1) unsigned NOT NULL default '0',
`LanguageIDs` varchar(255) NOT NULL,
`LanguageExcept` tinyint(1) unsigned NOT NULL default '0',
`ViewableBy` tinyint(1) unsigned NOT NULL default '0',
`Limit` tinyint(3) unsigned NOT NULL default '5',
`OrderID` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `SubBlockOfID` (`SubBlockOfID`),
KEY `TypeID` (`TypeID`),
KEY `Deactivated` (`Deactivated`,`OrderID`),
KEY `ViewableBy` (`ViewableBy`)
) ENGINE=MyISAM;
--
-- Dumping data for table `blocks`
--
INSERT INTO `blocks` (`ID`, `Title`, `Content`, `BlockID`, `Class`, `Deactivated`, `TypeID`, `SubBlockOfID`, `MenuItemIDs`, `MenuItemExcept`, `LanguageIDs`, `LanguageExcept`, `ViewableBy`, `Limit`, `OrderID`) VALUES
(1, 'Content', '', 'content', '', 0, 1, 2, '', 0, '', 0, 0, 0, 3),
(2, 'Website', '', 'website', '', 0, 0, 0, '', 0, '', 0, 0, 0, 1),
(3, 'Left Menu', '', 'left-menu', '', 0, 3, 2, '', 0, '', 0, 0, 0, 2),
(4, 'Header', '%PAGE_TITLE%', 'header', '', 0, 0, 2, '', 0, '', 0, 0, 0, 1),
(5, 'Footer', '{url}validXHTML{/url}\r\n{url}validCSS{/url}\r\nCopyright %NOW_YEAR% © %PAGE_TITLE%
\r\nPowered by jCore', 'footer', '', 0, 0, 2, '', 0, '', 0, 0, 0, 4);
-- --------------------------------------------------------
--
-- Table structure for table `dynamicformfields`
--
DROP TABLE IF EXISTS `dynamicformfields`;
CREATE TABLE `dynamicformfields` (
`ID` int(10) unsigned NOT NULL auto_increment,
`FormID` smallint(5) unsigned NOT NULL default '0',
`Title` varchar(255) NOT NULL,
`Name` varchar(255) NOT NULL,
`TypeID` tinyint(3) unsigned NOT NULL,
`ValueType` tinyint(3) unsigned NOT NULL default '1',
`Required` tinyint(1) unsigned NOT NULL default '0',
`Attributes` varchar(255) NOT NULL,
`Style` varchar(255) NOT NULL,
`OrderID` mediumint(9) NOT NULL default '0',
`Protected` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `FormID` (`FormID`,`OrderID`)
) ENGINE=MyISAM;
--
-- Dumping data for table `dynamicformfields`
--
-- --------------------------------------------------------
--
-- Table structure for table `dynamicformfieldvalues`
--
DROP TABLE IF EXISTS `dynamicformfieldvalues`;
CREATE TABLE `dynamicformfieldvalues` (
`ID` int(10) unsigned NOT NULL auto_increment,
`FieldID` int(10) unsigned NOT NULL,
`Value` mediumtext NOT NULL,
`ValueTitle` varchar(255) NOT NULL,
`Selected` tinyint(1) unsigned NOT NULL default '0',
`OrderID` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `FieldID` (`FieldID`,`Selected`),
KEY `OrderID` (`OrderID`)
) ENGINE=MyISAM;
--
-- Dumping data for table `dynamicformfieldvalues`
--
-- --------------------------------------------------------
--
-- Table structure for table `dynamicforms`
--
DROP TABLE IF EXISTS `dynamicforms`;
CREATE TABLE `dynamicforms` (
`ID` smallint(5) unsigned NOT NULL auto_increment,
`Title` varchar(255) NOT NULL,
`FormID` varchar(255) NOT NULL,
`Method` varchar(10) NOT NULL default 'POST',
`SendNotificationEmail` tinyint(1) unsigned NOT NULL default '0',
`SQLTable` varchar(100) NOT NULL,
`Protected` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM;
--
-- Dumping data for table `dynamicforms`
--
-- --------------------------------------------------------
--
-- Table structure for table `languages`
--
DROP TABLE IF EXISTS `languages`;
CREATE TABLE `languages` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`Title` varchar(100) NOT NULL,
`Path` varchar(255) NOT NULL,
`Locale` varchar(10) NOT NULL default 'en_US',
`Default` tinyint(1) unsigned NOT NULL default '0',
`Deactivated` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `Default` (`Default`),
KEY `Deactivated` (`Deactivated`)
) ENGINE=MyISAM;
--
-- Dumping data for table `languages`
--
-- --------------------------------------------------------
--
-- Table structure for table `menuitemmodules`
--
DROP TABLE IF EXISTS `menuitemmodules`;
CREATE TABLE `menuitemmodules` (
`MenuItemID` mediumint(8) unsigned NOT NULL default '0',
`ModuleID` tinyint(3) unsigned NOT NULL default '0',
KEY `MenuID` (`MenuItemID`)
) ENGINE=MyISAM;
--
-- Dumping data for table `menuitemmodules`
--
-- --------------------------------------------------------
--
-- Table structure for table `menuitems`
--
DROP TABLE IF EXISTS `menuitems`;
CREATE TABLE `menuitems` (
`ID` mediumint(8) unsigned NOT NULL auto_increment,
`Title` varchar(150) NOT NULL,
`Path` varchar(255) default NULL,
`Link` varchar(255) NOT NULL,
`Hidden` tinyint(1) unsigned NOT NULL default '0',
`Deactivated` tinyint(1) unsigned NOT NULL default '0',
`ViewableBy` tinyint(1) unsigned NOT NULL default '0',
`SubMenuOfID` mediumint(8) unsigned NOT NULL default '0',
`MenuID` tinyint(3) unsigned NOT NULL default '1',
`LanguageID` tinyint(3) unsigned NOT NULL default '0',
`Limit` tinyint(3) unsigned NOT NULL default '0',
`OrderID` mediumint(9) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `Deactivated` (`Deactivated`,`SubMenuOfID`,`OrderID`),
KEY `Hidden` (`Hidden`),
KEY `MenuID` (`MenuID`),
KEY `LanguageID` (`LanguageID`)
) ENGINE=MyISAM;
--
-- Dumping data for table `menuitems`
--
INSERT INTO `menuitems` (`ID`, `Title`, `Path`, `Link`, `Hidden`, `Deactivated`, `ViewableBy`, `SubMenuOfID`, `MenuID`, `LanguageID`, `Limit`, `OrderID`) VALUES
(1, 'Home', 'home', '', 0, 0, 0, 0, 1, 0, 0, 1),
(2, 'What next?', 'what-next', '', 0, 0, 0, 0, 1, 0, 0, 2);
-- --------------------------------------------------------
--
-- Table structure for table `menus`
--
DROP TABLE IF EXISTS `menus`;
CREATE TABLE `menus` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`Title` varchar(255) NOT NULL,
`Name` varchar(100) NOT NULL,
`BlockID` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `BlockID` (`BlockID`)
) ENGINE=MyISAM;
--
-- Dumping data for table `menus`
--
INSERT INTO `menus` (`ID`, `Title`, `Name`, `BlockID`) VALUES
(1, 'Main Menu', 'main-menu', 3);
-- --------------------------------------------------------
--
-- Table structure for table `modules`
--
DROP TABLE IF EXISTS `modules`;
CREATE TABLE `modules` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`Name` varchar(100) NOT NULL,
`Installed` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM;
--
-- Dumping data for table `modules`
--
-- --------------------------------------------------------
--
-- Table structure for table `postattachments`
--
DROP TABLE IF EXISTS `postattachments`;
CREATE TABLE `postattachments` (
`ID` int(10) unsigned NOT NULL auto_increment,
`OrderID` mediumint(9) NOT NULL default '0',
`Location` varchar(255) NOT NULL default '',
`Title` varchar(255) default NULL,
`TimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`HumanMimeType` varchar(255) NOT NULL,
`FileSize` int(10) unsigned NOT NULL default '0',
`PostID` int(10) unsigned NOT NULL default '1',
`Downloads` int(10) unsigned NOT NULL default '0',
KEY `ID` (`ID`),
KEY `OrderID` (`OrderID`),
KEY `PostID` (`PostID`),
KEY `TimeStamp` (`TimeStamp`)
) ENGINE=MyISAM;
--
-- Dumping data for table `postattachments`
--
-- --------------------------------------------------------
--
-- Table structure for table `postcomments`
--
DROP TABLE IF EXISTS `postcomments`;
CREATE TABLE `postcomments` (
`ID` int(10) unsigned NOT NULL auto_increment,
`PostID` int(10) unsigned NOT NULL default '0',
`UserName` varchar(100) NOT NULL,
`UserID` mediumint(8) unsigned NOT NULL default '0',
`Comment` text NOT NULL,
`TimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`IP` bigint(20) NOT NULL default '0',
`SubCommentOfID` int(10) unsigned NOT NULL default '0',
`Rating` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `TimeStamp` (`TimeStamp`),
KEY `PostID` (`PostID`,`UserName`),
KEY `UserID` (`UserID`)
) ENGINE=MyISAM;
--
-- Dumping data for table `postcomments`
--
-- --------------------------------------------------------
--
-- Table structure for table `postcommentsratings`
--
DROP TABLE IF EXISTS `postcommentsratings`;
CREATE TABLE `postcommentsratings` (
`CommentID` int(10) unsigned NOT NULL default '0',
`UserID` mediumint(8) unsigned NOT NULL default '0',
`IP` bigint(20) NOT NULL default '0',
`TimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`Rating` tinyint(1) NOT NULL default '0',
KEY `CommentID` (`CommentID`,`UserID`,`IP`,`TimeStamp`),
KEY `Rating` (`Rating`)
) ENGINE=MyISAM;
--
-- Dumping data for table `postcommentsratings`
--
-- --------------------------------------------------------
--
-- Table structure for table `postpictures`
--
DROP TABLE IF EXISTS `postpictures`;
CREATE TABLE `postpictures` (
`ID` int(10) unsigned NOT NULL auto_increment,
`OrderID` mediumint(9) NOT NULL default '0',
`Location` varchar(255) NOT NULL default '',
`Title` varchar(255) default NULL,
`TimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`URL` varchar(255) default NULL,
`PostID` int(10) unsigned NOT NULL default '1',
KEY `ID` (`ID`),
KEY `OrderID` (`OrderID`),
KEY `PostID` (`PostID`),
KEY `TimeStamp` (`TimeStamp`)
) ENGINE=MyISAM;
--
-- Dumping data for table `postpictures`
--
-- --------------------------------------------------------
--
-- Table structure for table `posts`
--
DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
`ID` int(10) unsigned NOT NULL auto_increment,
`MenuItemID` mediumint(8) unsigned NOT NULL,
`Title` varchar(255) NOT NULL,
`Path` varchar(255) default NULL,
`TimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`StartDate` date default NULL,
`EndDate` date default NULL,
`Content` mediumtext NOT NULL,
`Keywords` varchar(255) NOT NULL,
`Views` int(10) unsigned NOT NULL default '0',
`Comments` smallint(5) unsigned NOT NULL default '0',
`Pictures` smallint(5) unsigned NOT NULL default '0',
`Attachments` smallint(5) unsigned NOT NULL default '0',
`EnableComments` tinyint(1) unsigned NOT NULL default '0',
`EnableGuestComments` tinyint(1) unsigned NOT NULL default '0',
`Deactivated` tinyint(1) unsigned NOT NULL default '0',
`PartialContent` tinyint(1) unsigned NOT NULL default '0',
`OnMainPage` tinyint(1) unsigned NOT NULL default '0',
`BlockID` smallint(5) unsigned NOT NULL default '0',
`UserID` mediumint(8) unsigned NOT NULL default '0',
`OrderID` mediumint(9) NOT NULL,
PRIMARY KEY (`ID`),
KEY `MenuID` (`MenuItemID`,`Deactivated`,`OrderID`),
KEY `OnMainPage` (`OnMainPage`),
KEY `StartDate` (`StartDate`,`EndDate`),
KEY `Link` (`Path`),
KEY `BlockID` (`BlockID`),
KEY `UserID` (`UserID`)
) ENGINE=MyISAM;
--
-- Dumping data for table `posts`
--
INSERT INTO `posts` (`ID`, `MenuItemID`, `Title`, `Path`, `TimeStamp`, `StartDate`, `EndDate`, `Content`, `Keywords`, `Views`, `Comments`, `Pictures`, `Attachments`, `EnableComments`, `EnableGuestComments`, `Deactivated`, `PartialContent`, `OnMainPage`, `BlockID`, `UserID`, `OrderID`) VALUES
(1, 1, 'Welcome to jCore', 'welcome-to-jcore', '2009-07-24 09:52:03', NULL, NULL, '
Welcome to jCore, if you see this message it meens you have successfully set up jCore on your server and you can now start customizing this site.
\r\nTo access the admin area just click here:
\r\n%SITE_URL%admin
Your login information to the admin are:
\r\nUsername: admin
\r\nPassword: jcore
Have fun.
', '', 76, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1), (2, 2, 'What to do next', 'what-to-do-next', '2009-07-24 10:02:00', NULL, NULL, 'As on the first page noted, the first thing you should do is to change your admin password (and or username if you want to), then you can go to the Content Management area and start setting up your menu items like About, News, Contact and so on. You can add as many posts (content) as you wish under a menu item. To read more about the content management feature please see Features -> Content Management
\r\nThe second thing you should do when menus are set up is to look in the Site Layout & Functionality and start setting up your own Blocks (Layout Blocks). Layout blocks are the div tags that you will be able to customize from css and js. Each block can have unlimited subblocks and you can even limit them to show it only for a defined menu and/or language. To lear more about blocks please see Features -> Dynamic Web 2.0 Layout
\r\nOnce all your blocks are set up and you have the site''s design done from css/js you can start adding custom modules/content to your site, if you have any questions please see the Features section.
', '', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `ptprotectionbans` -- DROP TABLE IF EXISTS `ptprotectionbans`; CREATE TABLE `ptprotectionbans` ( `UserID` mediumint(8) NOT NULL default '0', `EndTimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `IPs` mediumtext NOT NULL, KEY `UserID` (`UserID`) ) ENGINE=MyISAM; -- -- Dumping data for table `ptprotectionbans` -- -- -------------------------------------------------------- -- -- Table structure for table `rssfeeds` -- DROP TABLE IF EXISTS `rssfeeds`; CREATE TABLE `rssfeeds` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `Title` varchar(255) NOT NULL, `FeedURL` varchar(255) NOT NULL, `Deactivated` tinyint(1) unsigned NOT NULL default '0', `OrderID` mediumint(9) NOT NULL default '0', PRIMARY KEY (`ID`), KEY `Deactivated` (`Deactivated`), KEY `OrderID` (`OrderID`) ) ENGINE=MyISAM; -- -- Dumping data for table `rssfeeds` -- -- -------------------------------------------------------- -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; CREATE TABLE `settings` ( `ID` varchar(100) NOT NULL, `Value` mediumtext NOT NULL, `TypeID` tinyint(1) unsigned NOT NULL default '1', `OrderID` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`ID`), KEY `OrderID` (`OrderID`) ) ENGINE=MyISAM; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`ID`, `Value`, `TypeID`, `OrderID`) VALUES ('Page_Title', 'jCore - the Webmaster''s Multisite CMS', 1, 1), ('Meta_Title', 'jCore - the Webmaster''s Multisite CMS', 1, 1), ('Picture_Thumbnail_Height', '0', 2, 2), ('Meta_Keywords', 'jcore, cms, content management system, php, mysql, lamp, web cms', 1, 1), ('Meta_Description', 'jCore is the web Content Management System build especially for webmasters to easily maintenance multiple websites', 1, 1), ('Webmaster_Email', 'support@jcore.net', 1, 1), ('Webmaster_BCC_Email', '', 1, 1), ('Picture_Thumbnail_Width', '150', 2, 2), ('Page_Settings', '', 0, 1), ('Picture_Settings', '', 0, 2), ('Brute_Force_Protection', '', 0, 3), ('Brute_Force_Maximum_Failure_Attempts', '5', 2, 3), ('Brute_Force_Protection_Time_Minutes', '60', 2, 3), ('Brute_Force_Maximum_Failure_Attempts_Before_TwoWeeks_Ban', '30', 2, 3), ('Brute_Force_Email_Notification', '1', 3, 3), ('Password_Trading_Protection', '', 0, 4), ('Password_Trading_Maximum_Simultaneous_Logins', '3', 2, 4), ('Password_Trading_Protection_Time_Minutes', '60', 2, 4), ('Password_Trading_Email_Notification', '1', 3, 4), ('Maintenance_Settings', '', 0, 5), ('Maintenance_Suspend_Website', '0', 3, 5), ('Maintenance_Suspend_Text', '\r\n\r\n\r\nUnfortunately the page you are looking for can''t be found on the server {url}server{/url}.\r\n
\r\n\r\nSuggestions:\r\n
\r\n