OLD | NEW |
(Empty) | |
| 1 BEGIN TRANSACTION; |
| 2 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY,value LONGVARCHAR)
; |
| 3 INSERT INTO "meta" VALUES('version','21'); |
| 4 INSERT INTO "meta" VALUES('last_compatible_version','16'); |
| 5 CREATE TABLE android_urls(id INTEGER PRIMARY KEY, raw_url LONGVARCHAR, created_t
ime INTEGER NOT NULL, last_visit_time INTEGER NOT NULL, url_id INTEGER NOT NULL,
favicon_id INTEGER DEFAULT NULL, bookmark INTEGER DEFAULT 0); |
| 6 INSERT INTO "android_urls" VALUES(1,'http://google.com/',1,1,1,1,0); |
| 7 INSERT INTO "android_urls" VALUES(4,'www.google.com/',1,1,3,1,1); |
| 8 COMMIT; |
| 9 |
| 10 |
OLD | NEW |