doc/kolab_wap.sql

[Aleksander Machniak]

 doc/kolab_wap.sql |   12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

New commits:
commit 2537eb265ee5fba66c2877663c01dbf0209394c3
Author: Aleksander Machniak <alec at alec.pl>
Date:   Thu Jan 8 09:42:40 2015 +0100

    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).

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,