Changeset 1502 in ExiteCMS for trunk/includes/dbsetup_include.php

Timestamp:

07/02/08 08:50:05 (4 years ago)

Author:

hverton

Message:

updated the setup procedure with the latest database changes

File:

• trunk/includes/dbsetup_include.php (modified) (6 diffs)

trunk/includes/dbsetup_include.php

@@ -2 +2 @@
 //----------------------------------------------------------
 // ExiteCMS file : dbsetup_include.php
-// Date generated  : `01/07/2008 22:00`
-// Generated by : `WanWizard`
+// Date generated  : `02/07/2008 08:40`
 //----------------------------------------------------------
 
-define('CMS_VERSION', '7.20');
+define('CMS_VERSION', '7.10');
 define('CMS_REVISION', '1500');
 
@@ -228 +227 @@
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('locale', 'English')");
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('login_expire', '7200')");
-    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('login_extended_expire', '604800')");
+    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('login_extended_expire', '84600')");
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('longdate', '%m/%d/%Y %H:%M:%S')");
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('maintenance', '0')");
@@ -234 +233 @@
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('maintenance_message', '')");
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('max_users', '0')");
-    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('max_users_datestamp', '1193029685')");
+    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('max_users_datestamp', '0')");
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('navbar_range', '5')");
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('newsletter_email', 'noreply@example.com')");
@@ -265 +264 @@
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('session_name', 'ExiteCMSid')");
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('shortdate', '%m/%d/%Y')");
-    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('siteemail', 'webmaster@example.com')");
+    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('siteemail', 'website@example.com')");
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('siteintro', '<center>\r\n<b>This website is under construction at the moment!</b><br /><br />\r\nExiteCMS v7.2 ©2008 Exite BV.</center>')");
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('sitelinks_localisation', 'none')");
@@ -286 +285 @@
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('unread_threshold', '90')");
     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('validation_method', 'image')");
-    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('version', '7.20')");
+    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('version', '7.10')");
 }
 
@@ -850 +849 @@
 
 //
-// Code to create table `reporting`
-//
-$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."reporting");
-$result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."reporting (
+// Code to create table `reports`
+//
+$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."reports");
+$result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."reports (
   `report_id` smallint(5) unsigned NOT NULL auto_increment,
-  `report_ident` varchar(4) NOT NULL default '',
-  `report_title` varchar(50) NOT NULL default '',
-  `report_active` tinyint(1) NOT NULL default 0,
-  `report_groups` text NOT NULL,
-  `report_code` text NOT NULL,
+  `report_mod_id` smallint(5) unsigned NOT NULL default 0,
+  `report_name` varchar(100) NOT NULL default '',
+  `report_title` varchar(100) NOT NULL default '',
+  `report_version` varchar(10) NOT NULL default '0',
+  `report_active` tinyint(1) unsigned NOT NULL default 0,
+  `report_visibility` tinyint(3) NOT NULL default 0,
   PRIMARY KEY  (`report_id`)
 ) ENGINE=MyISAM;");
 if (!$result) {
     $fail = "1";
-    $failed[] = "reporting : ".mysql_error();
+    $failed[] = "reports : ".mysql_error();
+}
+
+//
+// Code to create table `searches`
+//
+$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."searches");
+$result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."searches (
+  `search_id` smallint(5) unsigned NOT NULL auto_increment,
+  `search_mod_id` smallint(5) unsigned NOT NULL default 0,
+  `search_name` varchar(100) NOT NULL default '',
+  `search_title` varchar(100) NOT NULL default '',
+  `search_version` varchar(10) NOT NULL default '0',
+  `search_visibility` tinyint(3) NOT NULL default 0,
+  PRIMARY KEY  (`search_id`)
+) ENGINE=MyISAM;");
+if (!$result) {
+    $fail = "1";
+    $failed[] = "searches : ".mysql_error();
 }