-
Notifications
You must be signed in to change notification settings - Fork 0
/
lastPlainText.sql
31 lines (23 loc) · 1.04 KB
/
lastPlainText.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "content" (
"field_id" INTEGER PRIMARY KEY AUTOINCREMENT,
"name" TEXT,
"value" TEXT
);
INSERT INTO content VALUES(1,'description','<p>Kate</p>');
INSERT INTO content VALUES(2,'description','<p>Ryan</p>');
INSERT INTO content VALUES(3,'description','<p>Stella</p>');
INSERT INTO content VALUES(4,'pet','<p>Dog</p>');
INSERT INTO content VALUES(5,'notpet','<p>Cat</p>');
INSERT INTO content VALUES(9,'description','<p>Stella</p>');
INSERT INTO content VALUES(15,'description','<p>Stella</p>');
INSERT INTO content VALUES(18,'description','<p>Stella</p>');
INSERT INTO content VALUES(19,'description','<p>Stella</p>');
INSERT INTO content VALUES(44,'description','<p>Stella</p>');
INSERT INTO content VALUES(91,'ryan','</h>react?</h>');
INSERT INTO content VALUES(555,'first cli generated pet','<p>Cat</p>');
INSERT INTO content VALUES(5556,'Steak','<p>Cat</p>');
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('content',5556);
COMMIT;