-- 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\n

To access the admin area just click here:
\r\n%SITE_URL%admin  

\r\n

Your login information to the admin are:
\r\nUsername: admin
\r\nPassword: jcore

\r\n
IMPORTANT: Please change your password as soon as possible in the admin (Member Management -> Users)
\r\n

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\n

The 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\n

Once 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), ('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\nSite Under Maintenance\r\n\r\n\r\n
\r\n
\r\nSite under maintenance: We are currently making enhancements and/or fixing issues. We appreciate your patience during this time, and encourage you to return here shortly.\r\n
\r\n
\r\n\r\n', 4, 5), ('Maintenance_Notification_Text', '', 4, 5), ('Page_TimeZone', 'Europe/London', 1, 1), ('Page_Charset', 'utf-8', 1, 1), ('Page_404_Error_Text', '
\r\n
\r\n

\r\nAddress Not Found\r\n{url}uri{/url}\r\n

\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
    \r\n
  • Check the spelling of the address you typed.
  • \r\n
  • Are you certain this page exists? The link may have expired.
  • \r\n
  • If you are still having problems, please visit the Main Page.
  • \r\n
\r\n
\r\nMain Page\r\n
\r\n
\r\n
\r\n
\r\n
', 4, 1); -- -------------------------------------------------------- -- -- Table structure for table `userlogins` -- DROP TABLE IF EXISTS `userlogins`; CREATE TABLE `userlogins` ( `SessionID` varchar(100) NOT NULL, `UserID` mediumint(8) unsigned NOT NULL default '0', `FromIP` bigint(20) NOT NULL default '0', `TimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `KeepIt` tinyint(4) NOT NULL default '0', KEY `UserID` (`UserID`), KEY `ID` (`SessionID`) ) ENGINE=MyISAM; -- -- Dumping data for table `userlogins` -- -- -------------------------------------------------------- -- -- Table structure for table `userpermissions` -- DROP TABLE IF EXISTS `userpermissions`; CREATE TABLE `userpermissions` ( `ID` int(10) unsigned NOT NULL auto_increment, `UserID` mediumint(8) unsigned NOT NULL default '0', `Path` varchar(255) NOT NULL, `PermissionTypeID` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`ID`), KEY `UserID` (`UserID`,`Path`) ) ENGINE=MyISAM; -- -- Dumping data for table `userpermissions` -- -- -------------------------------------------------------- -- -- Table structure for table `userrequests` -- DROP TABLE IF EXISTS `userrequests`; CREATE TABLE `userrequests` ( `UserID` mediumint(8) unsigned NOT NULL default '0', `TimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `RequestTypeID` tinyint(3) unsigned NOT NULL default '0', `RequestID` varchar(100) NOT NULL, `FromIP` bigint(20) NOT NULL default '0', KEY `UserID` (`UserID`,`TimeStamp`,`RequestID`), KEY `FromIP` (`FromIP`) ) ENGINE=MyISAM; -- -- Dumping data for table `userrequests` -- -- -------------------------------------------------------- -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `ID` mediumint(8) unsigned NOT NULL auto_increment, `UserName` varchar(100) NOT NULL, `Password` varchar(100) NOT NULL, `Email` varchar(100) NOT NULL, `Website` varchar(255) NOT NULL, `TimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `StayLoggedIn` tinyint(1) unsigned NOT NULL default '0', `LastVisitTimeStamp` timestamp NOT NULL default '0000-00-00 00:00:00', `Admin` tinyint(1) unsigned NOT NULL default '0', `IP` bigint(20) NOT NULL default '0', `Suspended` tinyint(1) unsigned NOT NULL default '0', `DisableNotificationEmails` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM; -- -- Dumping data for table `users` -- INSERT INTO `users` (`ID`, `UserName`, `Password`, `Email`, `Website`, `TimeStamp`, `StayLoggedIn`, `LastVisitTimeStamp`, `Admin`, `IP`, `Suspended`, `DisableNotificationEmails`) VALUES (1, 'admin', '30c6bb566785a74868c1e62f4a40c67fac8ffcb5640efcb', 'admin@jcore.net', 'http://jcore.net', '2009-07-23 14:33:13', 0, '2009-07-24 12:15:39', 1, 2130706433, 0, 0); -- -------------------------------------------------------- -- -- Modification / Changes for ver. 0.2 -- DROP TABLE IF EXISTS `massemails`; CREATE TABLE `massemails` ( `ID` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `UserID` MEDIUMINT UNSIGNED NOT NULL , `From` VARCHAR( 255 ) NOT NULL , `To` TEXT NOT NULL , `Subject` VARCHAR( 255 ) NOT NULL , `Message` MEDIUMTEXT NOT NULL , `TimeStamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `EmailsSentOut` MEDIUMINT UNSIGNED NOT NULL , INDEX ( `TimeStamp`, `UserID` ) ) ENGINE = MYISAM ; INSERT INTO `settings` ( `ID` , `Value` , `TypeID` , `OrderID` ) VALUES ( 'Functionality_Settings', '', '0', '6' ), ( 'Ajax_Paging', '0', '3', '6' ); ALTER TABLE `dynamicforms` CHANGE `Method` `Method` VARCHAR( 10 ) NOT NULL DEFAULT 'post'; ALTER TABLE `dynamicformfields` ADD `AdditionalText` VARCHAR( 255 ) NOT NULL AFTER `Required` ; -- -------------------------------------------------------- -- -- Modification / Changes for ver. 0.3 -- INSERT INTO `settings` ( `ID` , `Value` , `TypeID` , `OrderID` ) VALUES ( 'Email_Settings', '', '0', '7' ), ( 'Email_Use_SMTP', '0', '3', '7' ), ( 'Email_Use_SSL_SMTP', '0', '3', '7' ), ( 'Email_SMTP_Host', 'localhost', '1', '7' ), ( 'Email_SMTP_Port', '25', '1', '7' ), ( 'Email_SMTP_Username', '', '1', '7' ), ( 'Email_SMTP_Password', '', '1', '7' ); INSERT INTO `settings` ( `ID` , `Value` , `TypeID` , `OrderID` ) VALUES ( 'Blog_Ping_On_New_Posts', '0', '3', '6' ), ( 'Blog_Ping_Servers', 'http://rpc.pingomatic.com/', '1', '6' ); ALTER TABLE `posts` ADD `DisplayRelatedPosts` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `OnMainPage`; INSERT INTO `settings` ( `ID` , `Value` , `TypeID` , `OrderID` ) VALUES ( 'jQuery_Settings', '', '0', '8' ), ( 'jQuery_Load_Plugins', 'cookie, loading, delay, mailme, pngfix, qtip, rating, ajaxlinks, ajaxform, lightbox, ui, ui.datepicker, tabby, fctoggle, corner', '1', '8' ); ALTER TABLE `menuitemmodules` ADD `ModuleItemID` INT UNSIGNED NOT NULL DEFAULT '0'; -- -------------------------------------------------------- -- -- Modification / Changes for ver. 0.4 -- ALTER TABLE `blocks` ADD `Caching` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `ViewableBy` , ADD `CacheOnlyForGuests` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `Caching`, ADD `CacheRefreshTime` SMALLINT UNSIGNED NOT NULL DEFAULT '10' AFTER `CacheOnlyForGuests` , ADD `CacheContent` LONGTEXT NOT NULL AFTER `CacheRefreshTime` , ADD `CacheTimeStamp` TIMESTAMP NOT NULL AFTER `CacheContent`; ALTER TABLE `posts` ADD INDEX ( `TimeStamp` ); DROP TABLE IF EXISTS `noteattachments`; CREATE TABLE `noteattachments` ( `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', `NoteID` int(10) unsigned NOT NULL default '1', `Downloads` int(10) unsigned NOT NULL default '0', KEY `ID` (`ID`), KEY `OrderID` (`OrderID`), KEY `NoteID` (`NoteID`), KEY `TimeStamp` (`TimeStamp`) ) ENGINE=MyISAM; DROP TABLE IF EXISTS `notecomments`; CREATE TABLE `notecomments` ( `ID` int(10) unsigned NOT NULL auto_increment, `NoteID` 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 `NoteID` (`NoteID`,`UserName`), KEY `UserID` (`UserID`) ) ENGINE=MyISAM; DROP TABLE IF EXISTS `notecommentsratings`; CREATE TABLE `notecommentsratings` ( `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; DROP TABLE IF EXISTS `notes`; CREATE TABLE `notes` ( `ID` int(10) unsigned NOT NULL auto_increment, `Title` varchar(255) NOT NULL, `TimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `DueDate` date default NULL, `Content` mediumtext NOT NULL, `Comments` smallint(5) unsigned NOT NULL default '0', `Attachments` smallint(5) unsigned NOT NULL default '0', `StatusID` tinyint(1) unsigned NOT NULL default '1', `UserID` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`ID`), KEY `TimeStamp` (`TimeStamp`), KEY `StatusID` (`StatusID`), KEY `DueDate` (`DueDate`), KEY `UserID` (`UserID`) ) ENGINE=MyISAM; INSERT INTO `settings` ( `ID` , `Value` , `TypeID` , `OrderID` ) VALUES ( 'Picture_Watermark', '0', '3', '2' ), ( 'Picture_Watermark_Text', 'Copyright (c) 2009', '1', '2' ), ( 'Picture_Watermark_Text_Font', 'fonts/arial.ttf', '1', '2' ), ( 'Picture_Watermark_Logo', '', '1', '2' ), ( 'Picture_Watermark_Position', '100% 100%', '1', '2' ); INSERT INTO `settings` ( `ID` , `Value` , `TypeID` , `OrderID` ) VALUES ( 'Security_Image_Settings', '', '0', '9' ), ( 'Security_Image_Code_Length', '7', '1', '9' ), ( 'Security_Image_Font', 'fonts/arial.ttf', '1', '9' ), ( 'Security_Image_Font_Size', '15', '1', '9' ), ( 'Security_Image_Random_Lines', '7', '1', '9' ), ( 'Security_Image_Foreground_Color', '#000000', '1', '9' ), ( 'Security_Image_Background_Color', '#ffffc8', '1', '9' );