"Fossies" - the Fresh Open Source Software Archive

Member "roundcubemail-1.4.2/SQL/mysql/2011121400.sql" (1 Jan 2020, 1017 Bytes) of package /linux/www/roundcubemail-1.4.2.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 -- Updates from version 0.7
    2 
    3 /*!40014 SET FOREIGN_KEY_CHECKS=0 */;
    4 
    5 ALTER TABLE `contacts` DROP FOREIGN KEY `user_id_fk_contacts`;
    6 ALTER TABLE `contacts` DROP INDEX `user_contacts_index`;
    7 ALTER TABLE `contacts` MODIFY `email` text NOT NULL;
    8 ALTER TABLE `contacts` ADD INDEX `user_contacts_index` (`user_id`,`del`);
    9 ALTER TABLE `contacts` ADD CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`)
   10    REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
   11 
   12 ALTER TABLE `cache` ALTER `user_id` DROP DEFAULT;
   13 ALTER TABLE `cache_index` ALTER `user_id` DROP DEFAULT;
   14 ALTER TABLE `cache_thread` ALTER `user_id` DROP DEFAULT;
   15 ALTER TABLE `cache_messages` ALTER `user_id` DROP DEFAULT;
   16 ALTER TABLE `contacts` ALTER `user_id` DROP DEFAULT;
   17 ALTER TABLE `contactgroups` ALTER `user_id` DROP DEFAULT;
   18 ALTER TABLE `contactgroupmembers` ALTER `contact_id` DROP DEFAULT;
   19 ALTER TABLE `identities` ALTER `user_id` DROP DEFAULT;
   20 ALTER TABLE `searches` ALTER `user_id` DROP DEFAULT;
   21 
   22 /*!40014 SET FOREIGN_KEY_CHECKS=1 */;