From db5aa62b7faa2685f29215d4d08e13d28fd481a1 Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Mon, 15 Dec 2008 04:22:20 -0500
Subject: [PATCH] - Added a global system settings storage in ini format. - Updated the user and database prefixes to use this storage.

---
 install/sql/ispconfig3.sql |   21 ++++++++++++++++++++-
 1 files changed, 20 insertions(+), 1 deletions(-)

diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index 35df222..cc5b893 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -598,7 +598,7 @@
   `db_server` tinyint(4) NOT NULL default '0',
   `vserver_server` tinyint(4) NOT NULL default '0',
   `config` text NOT NULL,
-  `updated` tinyint(4) NOT NULL default '0',
+  `updated` bigint(20) unsigned NOT NULL default '0',
   `active` tinyint(4) NOT NULL default '1',
   PRIMARY KEY  (`server_id`)
 ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
@@ -998,12 +998,31 @@
 -- --------------------------------------------------------
 
 -- 
+-- Tabellenstruktur f�r Tabelle `sys_ini`
+-- 
+
+CREATE TABLE `sys_ini` (
+  `sysini_id` int(11) NOT NULL auto_increment,
+  `config` longtext NOT NULL,
+  PRIMARY KEY  (`sysini_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=1 ;
+
+-- 
+-- Daten f�r Tabelle `sys_ini`
+-- 
+
+INSERT INTO `sys_ini` (`sysini_id`, `config`) VALUES (1, '');
+
+-- --------------------------------------------------------
+
+-- 
 -- Tabellenstruktur f�r Tabelle `sys_log`
 -- 
 
 CREATE TABLE `sys_log` (
   `syslog_id` int(10) unsigned NOT NULL auto_increment,
   `server_id` int(10) unsigned NOT NULL default '0',
+  `datalog_id` bigint(20) unsigned NOT NULL default '0',
   `loglevel` tinyint(4) NOT NULL default '0',
   `tstamp` int(10) unsigned NOT NULL,
   `message` text,

--
Gitblit v1.9.1