From 8500be3f1ba7bcab6b8523507e74a132df58d925 Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Thu, 18 Sep 2008 06:25:41 -0400 Subject: [PATCH] - Changed addslashes to mysql_real_escape_string in several files. - Updated Debian installation instructions. --- install/sql/ispconfig3.sql | 44 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 44 insertions(+), 0 deletions(-) diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index 40c2c75..67cad84 100644 --- a/install/sql/ispconfig3.sql +++ b/install/sql/ispconfig3.sql @@ -609,6 +609,50 @@ -- -------------------------------------------------------- -- +-- Tabellenstruktur f�r Tabelle `software_repo` +-- + +CREATE TABLE `software_repo` ( + `software_repo_id` bigint(20) NOT NULL auto_increment, + `sys_userid` int(11) NOT NULL default '0', + `sys_groupid` int(11) NOT NULL default '0', + `sys_perm_user` varchar(5) default NULL, + `sys_perm_group` varchar(5) default NULL, + `sys_perm_other` varchar(5) default NULL, + `repo_name` varchar(40) default NULL, + `repo_url` varchar(40) default NULL, + `repo_username` varchar(30) default NULL, + `repo_password` varchar(30) default NULL, + `active` varchar(255) NOT NULL default 'y', + PRIMARY KEY (`software_repo_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur f�r Tabelle `software_update` +-- + +CREATE TABLE `software_update` ( + `software_update_id` int(11) NOT NULL auto_increment, + `software_repo_id` int(11) NOT NULL, + `update_url` varchar(255) NOT NULL, + `update_md5` varchar(255) NOT NULL, + `install` char(1) NOT NULL, + `depenencies` varchar(255) NOT NULL, + `update_title` varchar(255) NOT NULL, + PRIMARY KEY (`software_update_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; + +-- +-- Daten f�r Tabelle `software_update` +-- + + +-- -------------------------------------------------------- + + +-- -- Tabellenstruktur f�r Tabelle `spamfilter_policy` -- -- Gitblit v1.9.1