"Fossies" - the Fresh Open Source Software Archive

Member "roundcubemail-1.4.2/SQL/mysql/2008092100.sql" (1 Jan 2020, 515 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.2-beta (InnoDB required)
    2 
    3 ALTER TABLE `cache`
    4     DROP `session_id`;
    5 
    6 ALTER TABLE `session`
    7     ADD INDEX `changed_index` (`changed`);
    8 
    9 ALTER TABLE `cache`
   10     ADD INDEX `created_index` (`created`);
   11 
   12 ALTER TABLE `users`
   13     CHANGE `language` `language` varchar(5);
   14 
   15 ALTER TABLE `cache` ENGINE=InnoDB;
   16 ALTER TABLE `session` ENGINE=InnoDB;
   17 ALTER TABLE `messages` ENGINE=InnoDB;
   18 ALTER TABLE `users` ENGINE=InnoDB;
   19 ALTER TABLE `contacts` ENGINE=InnoDB;
   20 ALTER TABLE `identities` ENGINE=InnoDB;