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 | 46 +++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 43 insertions(+), 3 deletions(-)
diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index 7020868..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 ;
@@ -911,7 +911,9 @@
`tstamp` bigint(20) NOT NULL default '0',
`user` varchar(255) NOT NULL default '',
`data` text NOT NULL,
- PRIMARY KEY (`datalog_id`)
+ `status` set('pending','ok','warning','error') NOT NULL default 'pending',
+ PRIMARY KEY (`datalog_id`),
+ KEY `server_id` (`server_id`,`status`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
@@ -992,6 +994,44 @@
--
INSERT INTO `sys_group` (`groupid`, `name`, `description`, `client_id`) VALUES (1, 'admin', 'Administrators group', 0);
+
+-- --------------------------------------------------------
+
+--
+-- 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,
+ PRIMARY KEY (`syslog_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=1 ;
+
+--
+-- Daten f�r Tabelle `sys_log`
+--
-- --------------------------------------------------------
@@ -1144,7 +1184,7 @@
`value` varchar(255) NOT NULL
) ENGINE=MyISAM;
-INSERT INTO sys_config VALUES ('1','db','db_version','3.0.0.8.$Revision$');
+INSERT INTO sys_config VALUES ('1','db','db_version','3.0.0.8 beta');
-- --------------------------------------------------------
--
Gitblit v1.9.1