summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAleksander Machniak <alec@alec.pl>2015-01-08 08:42:40 (GMT)
committerAleksander Machniak <alec@alec.pl>2015-01-08 08:42:40 (GMT)
commit2537eb265ee5fba66c2877663c01dbf0209394c3 (patch)
tree69c5f08e0690bdeeb9244fe6761dd7d1660c63fb
parent133bbb64b1187b580a8173df13a2bd1b1bbdeb37 (diff)
downloadkolab-wap-2537eb265ee5fba66c2877663c01dbf0209394c3.tar.gz
Fix SQL error: "Specified key was too long; max key length is 767 bytes" (#4179)
After tables charset change the unique key length was too long. Changed 'name' column type to varchar(255).
-rw-r--r--doc/kolab_wap.sql12
1 files changed, 6 insertions, 6 deletions
diff --git a/doc/kolab_wap.sql b/doc/kolab_wap.sql
index 180911a..871c130 100644
--- a/doc/kolab_wap.sql
+++ b/doc/kolab_wap.sql
@@ -25,7 +25,7 @@ DROP TABLE IF EXISTS `group_types`;
CREATE TABLE `group_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` text NOT NULL,
- `name` varchar(256) NOT NULL,
+ `name` varchar(255) NOT NULL,
`description` text NOT NULL,
`attributes` longtext NOT NULL,
`is_default` tinyint(1) DEFAULT 0,
@@ -77,7 +77,7 @@ DROP TABLE IF EXISTS `ou_types`;
CREATE TABLE `ou_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` text NOT NULL,
- `name` varchar(256) NOT NULL,
+ `name` varchar(255) NOT NULL,
`description` text NOT NULL,
`attributes` longtext NOT NULL,
`is_default` tinyint(1) DEFAULT 0,
@@ -106,7 +106,7 @@ DROP TABLE IF EXISTS `resource_types`;
CREATE TABLE `resource_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` text NOT NULL,
- `name` varchar(256) NOT NULL,
+ `name` varchar(255) NOT NULL,
`description` text NOT NULL,
`attributes` longtext NOT NULL,
`is_default` tinyint(1) DEFAULT 0,
@@ -135,7 +135,7 @@ DROP TABLE IF EXISTS `role_types`;
CREATE TABLE `role_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` text NOT NULL,
- `name` varchar(256) NOT NULL,
+ `name` varchar(255) NOT NULL,
`description` text NOT NULL,
`attributes` longtext NOT NULL,
`is_default` tinyint(1) DEFAULT 0,
@@ -164,7 +164,7 @@ DROP TABLE IF EXISTS `sharedfolder_types`;
CREATE TABLE `sharedfolder_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` text NOT NULL,
- `name` varchar(256) NOT NULL,
+ `name` varchar(255) NOT NULL,
`description` text NOT NULL,
`attributes` longtext NOT NULL,
`is_default` tinyint(1) DEFAULT 0,
@@ -193,7 +193,7 @@ DROP TABLE IF EXISTS `user_types`;
CREATE TABLE `user_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` text NOT NULL,
- `name` varchar(256) NOT NULL,
+ `name` varchar(255) NOT NULL,
`description` text NOT NULL,
`attributes` longtext NOT NULL,
`used_for` varchar(16) DEFAULT NULL,