From ab8baa23e8e78c792f0ff5cd754fc50fb218d4f6 Mon Sep 17 00:00:00 2001 From: Marius Burkard <m.burkard@pixcept.de> Date: Wed, 04 May 2016 09:28:08 -0400 Subject: [PATCH] - changed PRIMARY keys with null values to UNIQUE --- install/sql/incremental/upd_0074.sql | 7 +------ 1 files changed, 1 insertions(+), 6 deletions(-) diff --git a/install/sql/incremental/upd_0074.sql b/install/sql/incremental/upd_0074.sql index 9772ef6..05c33a3 100644 --- a/install/sql/incremental/upd_0074.sql +++ b/install/sql/incremental/upd_0074.sql @@ -49,7 +49,7 @@ CHANGE `sys_perm_group` `sys_perm_group` varchar(5) NOT NULL DEFAULT '', CHANGE `sys_perm_other` `sys_perm_other` varchar(5) NOT NULL DEFAULT '', CHANGE `zone` `zone` int(11) unsigned NOT NULL DEFAULT '0', - CHANGE `name` `name` varchar(64) NOT NULL DEFAULT '', + CHANGE `name` `name` varchar(255) NOT NULL DEFAULT '', CHANGE `data` `data` varchar(255) NOT NULL DEFAULT ''; ALTER TABLE `dns_slave` @@ -157,11 +157,6 @@ ALTER TABLE `shell_user` CHANGE `chroot` `chroot` varchar(255) NOT NULL DEFAULT '', CHANGE `ssh_rsa` `ssh_rsa` text; - -ALTER TABLE `software_package` - CHANGE `package_name` `package_name` varchar(64) NOT NULL DEFAULT '', - CHANGE `package_title` `package_title` varchar(64) NOT NULL DEFAULT '', - CHANGE `package_key` `package_key` varchar(255) NOT NULL DEFAULT ''; ALTER TABLE `software_update` CHANGE `software_repo_id` `software_repo_id` int(11) unsigned NOT NULL DEFAULT '0', -- Gitblit v1.9.1