qt-chat-app

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs

U1766702480__alter_table_chat.sql (386B)

      1 PRAGMA foreign_keys = OFF;
      2 
      3 CREATE TABLE "__alter_table_chat" (
      4     'id' INTEGER PRIMARY KEY NOT NULL,
      5     'title' TEXT NOT NULL
      6 ) STRICT;
      7 
      8 INSERT INTO
      9     "__alter_table_chat" ("id")
     10 SELECT
     11     "id"
     12 FROM
     13     "chat";
     14 
     15 DROP TABLE "chat";
     16 
     17 PRAGMA legacy_alter_table = ON;
     18 
     19 ALTER TABLE
     20     "__alter_table_chat" RENAME TO "chat";
     21 
     22 PRAGMA legacy_alter_table = OFF;
     23 
     24 PRAGMA foreign_keys = ON;