"Fossies" - the Fresh Open Source Software Archive

Member "roundcubemail-1.4.2/SQL/mysql/2011011200.sql" (1 Jan 2020, 344 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.5.x
    2 
    3 ALTER TABLE `contacts` ADD `words` TEXT NULL AFTER `vcard`;
    4 ALTER TABLE `contacts` CHANGE `vcard` `vcard` LONGTEXT /*!40101 CHARACTER SET utf8 */ NULL DEFAULT NULL;
    5 ALTER TABLE `contactgroupmembers` ADD INDEX `contactgroupmembers_contact_index` (`contact_id`);
    6 
    7 TRUNCATE TABLE `messages`;
    8 TRUNCATE TABLE `cache`;