"Fossies" - the Fresh Open Source Software Archive

Member "roundcubemail-1.4.2/SQL/postgres/2008092100.sql" (1 Jan 2020, 472 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
    2 
    3 ALTER TABLE cache DROP session_id;
    4 
    5 CREATE INDEX session_changed_idx ON session (changed);
    6 CREATE INDEX cache_created_idx ON "cache" (created);
    7 
    8 ALTER TABLE users ALTER "language" DROP NOT NULL;
    9 ALTER TABLE users ALTER "language" DROP DEFAULT;
   10 
   11 ALTER TABLE identities ALTER del TYPE smallint;
   12 ALTER TABLE identities ALTER standard TYPE smallint;
   13 ALTER TABLE contacts ALTER del TYPE smallint;
   14 ALTER TABLE messages ALTER del TYPE smallint;