"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "install/sql/powerdns.sql" between
ISPConfig-3.2.3.tar.gz and ISPConfig-3.2.4.tar.gz

About: ISPConfig is an ISP management and Hosting Control Panel (for different Managed Services).

powerdns.sql  (ISPConfig-3.2.3):powerdns.sql  (ISPConfig-3.2.4)
skipping to change at line 23 skipping to change at line 23
CREATE TABLE IF NOT EXISTS `records` ( CREATE TABLE IF NOT EXISTS `records` (
`id` int(11) NOT NULL auto_increment, `id` int(11) NOT NULL auto_increment,
`domain_id` int(11) default NULL, `domain_id` int(11) default NULL,
`name` varchar(255) default NULL, `name` varchar(255) default NULL,
`type` varchar(6) default NULL, `type` varchar(6) default NULL,
`content` TEXT default NULL, `content` TEXT default NULL,
`ttl` int(11) default NULL, `ttl` int(11) default NULL,
`prio` int(11) default NULL, `prio` int(11) default NULL,
`change_date` int(11) default NULL, `change_date` int(11) default NULL,
`disabled` tinyint(1) default 0,
`auth` tinyint(1) default 1,
`ispconfig_id` int(11) NOT NULL, `ispconfig_id` int(11) NOT NULL,
PRIMARY KEY (`id`), PRIMARY KEY (`id`),
KEY `rec_name_index` (`name`), KEY `rec_name_index` (`name`),
KEY `nametype_index` (`name`,`type`), KEY `nametype_index` (`name`,`type`),
KEY `domain_id` (`domain_id`) KEY `domain_id` (`domain_id`)
) ENGINE=InnoDB; ) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `supermasters` ( CREATE TABLE IF NOT EXISTS `supermasters` (
`ip` varchar(25) NOT NULL, `ip` varchar(25) NOT NULL,
`nameserver` varchar(255) NOT NULL, `nameserver` varchar(255) NOT NULL,
`account` varchar(40) default NULL `account` varchar(40) default NULL
) ENGINE=InnoDB; ) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `domainmetadata` (
`id` int auto_increment,
`domain_id` int NOT NULL,
`kind` varchar(32),
`content` TEXT,
PRIMARY KEY (`id`)
) Engine=InnoDB;
-- add new columns if not existing
SET @dbname = DATABASE();
SELECT count(*) INTO @exist FROM `information_schema`.`columns` WHERE `table_sch
ema` = @dbname AND `column_name` = 'auth' AND `table_name` = 'records' LIMIT 1;
SET @query = IF(@exist <= 0, 'ALTER TABLE `records` ADD COLUMN `auth` tinyint(1)
default 1 AFTER `change_date`', 'SELECT \'Column Exists\' STATUS');
PREPARE stmt FROM @query;
EXECUTE stmt;
SELECT count(*) INTO @exist FROM `information_schema`.`columns` WHERE `table_sch
ema` = @dbname AND `column_name` = 'disabled' AND `table_name` = 'records' LIMIT
1;
SET @query = IF(@exist <= 0, 'ALTER TABLE `records` ADD COLUMN `disabled` tinyin
t(1) default 0 AFTER `change_date`', 'SELECT \'Column Exists\' STATUS');
PREPARE stmt FROM @query;
EXECUTE stmt;
 End of changes. 2 change blocks. 
0 lines changed or deleted 2 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)