DROP TABLE "Basic";
CREATE TABLE "Basic" (
- "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+ "id" INTEGER PRIMARY KEY NOT NULL,
"title" varchar(100) NOT NULL DEFAULT 'hello',
"description" text DEFAULT '',
"email" varchar(500),
DROP TABLE "Another";
CREATE TABLE "Another" (
- "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+ "id" INTEGER PRIMARY KEY NOT NULL,
"num" numeric(10,2)
);
'BEGIN TRANSACTION',
q<DROP TABLE "Basic">,
q<CREATE TABLE "Basic" (
- "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+ "id" INTEGER PRIMARY KEY NOT NULL,
"title" varchar(100) NOT NULL DEFAULT 'hello',
"description" text DEFAULT '',
"email" varchar(500),
q<CREATE UNIQUE INDEX "very_long_index_name_on_title_field_which_should_be_truncated_for_various_rdbms" ON "Basic" ("title")>,
q<DROP TABLE "Another">,
q<CREATE TABLE "Another" (
- "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+ "id" INTEGER PRIMARY KEY NOT NULL,
"num" numeric(10,2)
)>,
q<DROP VIEW IF EXISTS "email_list">,
'COMMIT',
], 'SQLite translate in list context matches');
+
+