BEGIN TRANSACTION;
---
--- Table: Basic
---
DROP TABLE Basic;
CREATE TABLE Basic (
id INTEGER PRIMARY KEY NOT NULL,
explicitnulldef varchar,
explicitemptystring varchar DEFAULT '',
-- Hello emptytagdef
- emptytagdef varchar DEFAULT ''
+ emptytagdef varchar DEFAULT '',
+ another_id int(10) DEFAULT '2',
+ timest timestamp
);
CREATE INDEX titleindex_Basic on Basic (title);
CREATE UNIQUE INDEX emailuniqueindex_Basic on Basic (email);
+DROP TABLE Another;
+CREATE TABLE Another (
+ id INTEGER PRIMARY KEY NOT NULL
+);
+
+
COMMIT;
SQL