From 8065e06cb37b27d0736b74e0e8ab646499a630b7 Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Tue, 30 Sep 2008 14:27:48 -0400 Subject: [PATCH] - Added the interface part of the ispconfig pacage manager - updated the debian installation instructions --- install/sql/ispconfig3.sql | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 56 insertions(+), 4 deletions(-) diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index 67cad84..dcf65d9 100644 --- a/install/sql/ispconfig3.sql +++ b/install/sql/ispconfig3.sql @@ -609,6 +609,27 @@ -- -------------------------------------------------------- -- +-- Tabellenstruktur f�r Tabelle `software_package` +-- + +CREATE TABLE `software_package` ( + `package_id` int(11) NOT NULL auto_increment, + `software_repo_id` int(11) NOT NULL, + `package_name` varchar(100) NOT NULL, + `package_title` varchar(255) NOT NULL, + `package_description` text, + `package_version` varchar(255) default NULL, + PRIMARY KEY (`package_id`), + UNIQUE KEY `package_name` (`package_name`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Daten f�r Tabelle `software_package` +-- + +-- -------------------------------------------------------- + +-- -- Tabellenstruktur f�r Tabelle `software_repo` -- @@ -625,7 +646,13 @@ `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 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Daten f�r Tabelle `software_repo` +-- + +INSERT INTO `software_repo` (`software_repo_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `repo_name`, `repo_url`, `repo_username`, `repo_password`, `active`) VALUES (1, 1, 1, 'riud', 'riud', '', 'ISPConfig Addons', 'http://repo.ispconfig.org/addons/', '', '', 'n'); -- -------------------------------------------------------- @@ -636,18 +663,43 @@ CREATE TABLE `software_update` ( `software_update_id` int(11) NOT NULL auto_increment, `software_repo_id` int(11) NOT NULL, + `package_name` varchar(255) 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_dependencies` varchar(255) NOT NULL, `update_title` varchar(255) NOT NULL, + `v1` tinyint(4) NOT NULL default '0', + `v2` tinyint(4) NOT NULL default '0', + `v3` tinyint(4) NOT NULL default '0', + `v4` tinyint(4) NOT NULL default '0', + `type` enum('full','update') NOT NULL default 'full', PRIMARY KEY (`software_update_id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten f�r Tabelle `software_update` -- +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur f�r Tabelle `software_update_inst` +-- + +CREATE TABLE `software_update_inst` ( + `software_update_inst_id` int(10) unsigned NOT NULL auto_increment, + `software_update_id` int(11) NOT NULL default '0', + `package_name` varchar(255) NOT NULL, + `server_id` int(11) NOT NULL, + `status` enum('none','installing','installed','deleting') NOT NULL default 'none', + PRIMARY KEY (`software_update_inst_id`), + UNIQUE KEY `software_update_id` (`software_update_id`,`package_name`,`server_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Daten f�r Tabelle `software_update_inst` +-- + -- -------------------------------------------------------- -- Gitblit v1.9.1