-- -------------------------------------------------------- -- -- Table structure for table `aps_instances` -- CREATE TABLE IF NOT EXISTS `aps_instances` ( `id` int(4) NOT NULL AUTO_INCREMENT, `sys_userid` int(11) unsigned NOT NULL DEFAULT '0', `sys_groupid` int(11) unsigned 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, `server_id` int(11) NOT NULL DEFAULT '0', `customer_id` int(4) NOT NULL, `package_id` int(4) NOT NULL, `instance_status` int(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; -- -------------------------------------------------------- -- -- Table structure for table `aps_instances_settings` -- CREATE TABLE IF NOT EXISTS `aps_instances_settings` ( `id` int(4) NOT NULL AUTO_INCREMENT, `server_id` int(11) NOT NULL DEFAULT '0', `instance_id` int(4) NOT NULL, `name` varchar(255) NOT NULL, `value` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; -- -------------------------------------------------------- -- -- Table structure for table `aps_packages` -- CREATE TABLE IF NOT EXISTS `aps_packages` ( `id` int(4) NOT NULL AUTO_INCREMENT, `path` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `version` varchar(20) NOT NULL, `release` int(4) NOT NULL, `package_url` TEXT NOT NULL, `package_status` int(1) NOT NULL DEFAULT '2', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `aps_settings` -- CREATE TABLE IF NOT EXISTS `aps_settings` ( `id` int(4) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `value` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `tpl_default` -- -- CREATE TABLE IF NOT EXISTS `tpl_default` ( -- `var_id` int(11) unsigned NOT NULL AUTO_INCREMENT, -- `username` varchar(64) NOT NULL, -- `logo_url` varchar(255) NOT NULL, -- PRIMARY KEY (`var_id`) --) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `tpl_default-v2` -- --CREATE TABLE IF NOT EXISTS `tpl_default-v2` ( -- `var_id` int(11) unsigned NOT NULL AUTO_INCREMENT, -- `username` varchar(64) NOT NULL, -- `logo_url` varchar(255) NOT NULL, -- PRIMARY KEY (`var_id`) --) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; -- -------------------------------------------------------- -- -- Dumping data for table `aps_settings` -- INSERT INTO `aps_settings` (`id`, `name`, `value`) VALUES(1, 'ignore-php-extension', ''); INSERT INTO `aps_settings` (`id`, `name`, `value`) VALUES(2, 'ignore-php-configuration', ''); INSERT INTO `aps_settings` (`id`, `name`, `value`) VALUES(3, 'ignore-webserver-module', ''); ALTER TABLE `client` ADD `limit_aps` int(11) NOT NULL DEFAULT '0' AFTER `limit_webdav_user`; ALTER TABLE `client_template` ADD `limit_aps` int(11) NOT NULL DEFAULT '0' AFTER `limit_webdav_user`; -- INSERT INTO `tpl_default` (`var_id`, `username`, `logo_url`) VALUES('', 'global', 'themes/default/images/header_logo.png'); -- INSERT INTO `tpl_default-2` (`var_id`, `username`, `logo_url`) VALUES('', 'global', 'themes/default-v2/images/header_logo.png');