Changeset 5870871 in github for SQL/mysql5.initial.sql


Ignore:
Timestamp:
May 17, 2007 1:30:33 PM (6 years ago)
Author:
thomascube <thomas@…>
Branches:
master, HEAD, courier-fix, dev-browser-capabilities, pdo, release-0.6, release-0.7, release-0.8
Children:
41bece1
Parents:
a549a92
Message:

Changed sql scripts to allow non-ascii chars in user names (#1483959)

File:
1 edited

Legend:

Unmodified
Added
Removed

  • SQL/mysql5.initial.sql

    r9e5d051 r5870871  
    11-- RoundCube Webmail initial database structure 
    2 -- Version 0.1-beta2 
    3 --  
     2-- Version 0.1-rc1 
    43 
    54-- -------------------------------------------------------- 
    … …  
    3231 `preferences` text NOT NULL DEFAULT '', 
    3332 PRIMARY KEY(`user_id`) 
    34 ) TYPE=MYISAM CHARACTER SET ascii COLLATE ascii_general_ci; 
     33) TYPE=MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; 
    3534 
    3635 
    … …  
    5756 INDEX `uid`(`uid`), 
    5857 UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`), 
    59  CONSTRAINT `User_ID_FK_messages` FOREIGN KEY (`user_id`) 
     58 CONSTRAINT `user_id_fk_messages` FOREIGN KEY (`user_id`) 
    6059   REFERENCES `users`(`user_id`) 
    6160     ON DELETE CASCADE 
    … …  
    7675 INDEX `cache_key`(`cache_key`), 
    7776 INDEX `session_id`(`session_id`), 
    78  CONSTRAINT `User_ID_FK_cache` FOREIGN KEY (`user_id`) 
     77 CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) 
    7978   REFERENCES `users`(`user_id`) 
    8079     ON DELETE CASCADE 
    … …  
    9695 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', 
    9796 PRIMARY KEY(`contact_id`), 
    98  CONSTRAINT `User_ID_FK_contacts` FOREIGN KEY (`user_id`) 
     97 CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`) 
    9998   REFERENCES `users`(`user_id`) 
    10099     ON DELETE CASCADE 
    … …  
    118117 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', 
    119118 PRIMARY KEY(`identity_id`), 
    120  CONSTRAINT `User_ID_FK_identities` FOREIGN KEY (`user_id`) 
     119 CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) 
    121120   REFERENCES `users`(`user_id`) 
    122121     ON DELETE CASCADE 
Note: See TracChangeset for help on using the changeset viewer.