From c1a7b2cde02bb97221122c33e627c8329fbc660e Mon Sep 17 00:00:00 2001
From: cfoe <cfoe@ispconfig3>
Date: Wed, 08 Aug 2012 05:18:24 -0400
Subject: [PATCH] changed sql table for standard conform themes
---
install/sql/incremental/upd_0034.sql | 34 +++++++++++-----------------------
1 files changed, 11 insertions(+), 23 deletions(-)
diff --git a/install/sql/incremental/upd_0034.sql b/install/sql/incremental/upd_0034.sql
index a426d8e..fce86f7 100644
--- a/install/sql/incremental/upd_0034.sql
+++ b/install/sql/incremental/upd_0034.sql
@@ -54,7 +54,7 @@
-- --------------------------------------------------------
--
--- Tabellenstruktur für Tabelle `aps_settings`
+-- Table structure for table `aps_settings`
--
CREATE TABLE IF NOT EXISTS `aps_settings` (
@@ -68,28 +68,16 @@
-- --------------------------------------------------------
--
--- Tabellenstruktur für Tabelle `tpl_default`
+-- Table structure for table `sys_theme`
--
--- 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 ;
+CREATE TABLE IF NOT EXISTS `sys_theme` (
+ `var_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+ `tpl_name` varchar(32) NOT NULL,
+ `username` varchar(64) NOT NULL,
+ `logo_url` varchar(255) NOT NULL,
+ PRIMARY KEY (`var_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
-- --------------------------------------------------------
@@ -104,5 +92,5 @@
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');
\ No newline at end of file
+INSERT INTO `dbispconfig`.`sys_theme` (`var_id`, `tpl_name`, `username`, `logo_url`) VALUES (NULL, 'default', 'global', 'themes/default/images/header_logo.png');
+INSERT INTO `dbispconfig`.`sys_theme` (`var_id`, `tpl_name`, `username`, `logo_url`) VALUES (NULL, 'default-v2', 'global', 'themes/default-v2/images/header_logo.png');
\ No newline at end of file
--
Gitblit v1.9.1