-
Notifications
You must be signed in to change notification settings - Fork 0
/
base_dump.txt
12 lines (12 loc) · 1.02 KB
/
base_dump.txt
1
2
3
4
5
6
7
8
9
10
11
12
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "TAGINVENTORY_TABLE" ( "tagname" TEXT NOT NULL,"objectname" TEXT NOT NULL,"recordname" TEXT NOT NULL,"tagid" ULONGLONG ,"pfn" TEXT NOT NULL,"labelname" TEXT , PRIMARY KEY("tagid") );
CREATE TABLE coral_sqlite_fk(id TEXT NOT NULL, name TEXT, tablename TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS "TAGINVENTORY_IDS" ( "nextID" ULONGLONG );
INSERT INTO TAGINVENTORY_IDS VALUES(1);
CREATE TABLE IF NOT EXISTS "TAGTREE_TABLE_replacethis" ( "lft" ULONGLONG NOT NULL,"globaltill" ULONGLONG ,"rgt" ULONGLONG NOT NULL,"nodelabel" TEXT NOT NULL,"tagid" ULONGLONG ,"parentid" ULONGLONG NOT NULL,"nodeid" ULONGLONG ,"globalsince" ULONGLONG , PRIMARY KEY("nodeid"), UNIQUE ( "nodelabel" ) );
INSERT INTO TAGTREE_TABLE_replacethis VALUES(1,4294967295,4,'All',0,0,1,0);
INSERT INTO TAGTREE_TABLE_replacethis VALUES(2,0,3,'Calibration',0,1,2,0);
CREATE TABLE IF NOT EXISTS "TAGTREE_replacethis_IDS" ( "nextID" ULONGLONG );
INSERT INTO TAGTREE_replacethis_IDS VALUES(3);
COMMIT;