|
= |
|
| CREATE TABLE MASTER ( |
+- |
|
| ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, |
|
|
| NAME TEXT NOT NULL, |
|
|
| VALUE TEXT NOT NULL) |
|
|
|
= |
|
| CREATE TABLE DETAIL ( |
|
CREATE TABLE DETAIL ( |
| ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, |
|
ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, |
| NAME TEXT NOT NULL, |
|
NAME TEXT NOT NULL, |
| VALUE TEXT NOT NULL, |
|
VALUE TEXT NOT NULL, |
| PARENT_ID INTEGER, |
|
PARENT_ID INTEGER, |
| CONSTRAINT FK_DETAIL_MASTER_PARENT_ID FOREIGN KEY (PARENT_ID) REFERENCES MASTER (ID)) |
|
CONSTRAINT FK_DETAIL_MASTER_PARENT_ID FOREIGN KEY (PARENT_ID) REFERENCES MASTER (ID)) |
| |
|
|
| |
-+ |
CREATE TABLE MASTER ( |
| |
|
ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, |
| |
|
NAME TEXT NOT NULL, |
| |
|
VALUE TEXT NOT NULL) |
|
= |
|
| INSERT INTO MASTER ( |
|
INSERT INTO MASTER ( |
| NAME, VALUE) |
|
NAME, VALUE) |
| VALUES ( |
|
VALUES ( |
| :p1, :p2) |
|
:p1, :p2) |
| p1 = "Shopping List" (ftString) |
|
p1 = "Shopping List" (ftString) |
| p2 = "Tescos" (ftString) |
|
p2 = "Tescos" (ftString) |
|
|
|
| SELECT last_insert_rowid() |
|
SELECT last_insert_rowid() |
|
|
|
| INSERT INTO DETAIL ( |
|
INSERT INTO DETAIL ( |
| NAME, VALUE) |
|
NAME, VALUE) |
| VALUES ( |
|
VALUES ( |
| :p1, :p2) |
|
:p1, :p2) |
| p1 = "Tatties" (ftString) |
|
p1 = "Tatties" (ftString) |
| p2 = "5 lbs" (ftString) |
|
p2 = "5 lbs" (ftString) |
|
|
|
| SELECT last_insert_rowid() |
|
SELECT last_insert_rowid() |
|
|
|
| INSERT INTO DETAIL ( |
|
INSERT INTO DETAIL ( |
| NAME, VALUE) |
|
NAME, VALUE) |
| VALUES ( |
|
VALUES ( |
| :p1, :p2) |
|
:p1, :p2) |
| p1 = "Mince" (ftString) |
|
p1 = "Mince" (ftString) |
| p2 = "250 kilos" (ftString) |
|
p2 = "250 kilos" (ftString) |
|
|
|
| SELECT last_insert_rowid() |
|
SELECT last_insert_rowid() |
|
|
|
| INSERT INTO DETAIL ( |
|
INSERT INTO DETAIL ( |
| NAME, VALUE) |
|
NAME, VALUE) |
| VALUES ( |
|
VALUES ( |
| :p1, :p2) |
|
:p1, :p2) |
| p1 = "Baked Beans" (ftString) |
|
p1 = "Baked Beans" (ftString) |
| p2 = "6 pack" (ftString) |
|
p2 = "6 pack" (ftString) |
|
|
|
| SELECT last_insert_rowid() |
|
SELECT last_insert_rowid() |
|
|
|
| UPDATE DETAIL SET |
|
UPDATE DETAIL SET |
| PARENT_ID = :p1 |
|
PARENT_ID = :p1 |
| WHERE ID = :p_1 |
|
WHERE ID = :p_1 |
| p1 = "1" (ftInteger) |
|
p1 = "1" (ftInteger) |
| p_1 = "1" (ftInteger) |
|
p_1 = "1" (ftInteger) |
|
|
|
| UPDATE DETAIL SET |
|
UPDATE DETAIL SET |
| PARENT_ID = :p1 |
|
PARENT_ID = :p1 |
| WHERE ID = :p_1 |
|
WHERE ID = :p_1 |
| p1 = "1" (ftInteger) |
|
p1 = "1" (ftInteger) |
| p_1 = "2" (ftInteger) |
|
p_1 = "2" (ftInteger) |
|
|
|
| UPDATE DETAIL SET |
|
UPDATE DETAIL SET |
| PARENT_ID = :p1 |
|
PARENT_ID = :p1 |
| WHERE ID = :p_1 |
|
WHERE ID = :p_1 |
| p1 = "1" (ftInteger) |
|
p1 = "1" (ftInteger) |
| p_1 = "3" (ftInteger) |
|
p_1 = "3" (ftInteger) |
|
|
|
| SELECT A.ID AS A_ID, A.NAME AS A_NAME, A.VALUE AS A_VALUE |
|
SELECT A.ID AS A_ID, A.NAME AS A_NAME, A.VALUE AS A_VALUE |
| FROM MASTER A |
|
FROM MASTER A |
| |
-+ |
WHERE A.ID = :p_0 |
| |
|
p_0 = "1" (ftInteger) |
| |
= |
|
| |
-+ |
SELECT A.ID AS A_ID, A.NAME AS A_NAME, A.VALUE AS A_VALUE |
| |
|
FROM MASTER A |
| |
= |
|
| |
-+ |
SELECT A.ID AS A_ID, A.NAME AS A_NAME, A.VALUE AS A_VALUE |
| |
|
FROM MASTER A |
| |
|
WHERE A.ID = :p_0 |
| |
|
p_0 = "1" (ftInteger) |
| |
= |
|
| |
-+ |
SELECT A.ID AS A_ID, A.NAME AS A_NAME, A.VALUE AS A_VALUE, A.PARENT_ID AS A_PARENT_ID |
| |
|
FROM DETAIL A |
| |
|
WHERE A.PARENT_ID = :p_0 |
| |
|
p_0 = "1" (ftInteger) |
| |
= |
|
| |
-+ |
SELECT A.ID AS A_ID, A.NAME AS A_NAME, A.VALUE AS A_VALUE |
| |
|
FROM MASTER A |
| |
|
WHERE A.ID = :p_0 |
| |
|
p_0 = "1" (ftInteger) |
| |
= |
|
| |
-+ |
SELECT A.ID AS A_ID, A.NAME AS A_NAME, A.VALUE AS A_VALUE, A.PARENT_ID AS A_PARENT_ID |
| |
|
FROM DETAIL A |
| |
|
WHERE A.PARENT_ID = :p_0 |
| |
|
p_0 = "1" (ftInteger) |
|
= |
|
| DELETE FROM DETAIL |
|
DELETE FROM DETAIL |
| WHERE ID = :p_0 |
|
WHERE ID = :p_0 |
| p_0 = "3" (ftInteger) |
|
p_0 = "3" (ftInteger) |
|
|
|
| DELETE FROM DETAIL |
|
DELETE FROM DETAIL |
| WHERE ID = :p_0 |
|
WHERE ID = :p_0 |
| p_0 = "2" (ftInteger) |
|
p_0 = "2" (ftInteger) |
|
|
|
| DELETE FROM DETAIL |
|
DELETE FROM DETAIL |
| WHERE ID = :p_0 |
|
WHERE ID = :p_0 |
| p_0 = "1" (ftInteger) |
|
p_0 = "1" (ftInteger) |
|
|
|
| DELETE FROM MASTER |
|
DELETE FROM MASTER |
| WHERE ID = :p_0 |
|
WHERE ID = :p_0 |
| p_0 = "1" (ftInteger) |
|
p_0 = "1" (ftInteger) |
|
|
|
| SELECT A.ID AS A_ID, A.NAME AS A_NAME, A.VALUE AS A_VALUE |
+- |
|
| FROM MASTER A |
|
|