1 PRAGMA foreign_keys = ON; BEGIN TRANSACTION;
3 CREATE TABLE PackageInfo(
4 UNIQUE_ID INTEGER PRIMARY KEY AUTOINCREMENT,
11 PRIVACY_ID TEXT not null,
12 IS_ENABLED INTEGER not null,
13 FOREIGN KEY(ID) REFERENCES PackageInfo(UNQUE_ID),
16 CREATE VIEW PrivacyView as SELECT
17 PackageInfo.UNIQUE_ID,
21 FROM PackageInfo, Privacy
22 WHERE PackageInfo.UNIQUE_ID = Privacy.ID;
25 CREATE TABLE DB_VERSION_0_1 (version INT); COMMIT;