1 DROP TABLE IF EXISTS datas;
2 DROP TABLE IF EXISTS refs;
5 id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
6 ,ref_type STRING NOT NULL DEFAULT 'H'
7 ,refcount INTEGER NOT NULL DEFAULT 1
12 id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
13 ,ref_id INTEGER NOT NULL
14 ,data_type STRING DEFAULT 'S'
15 ,`key` STRING NOT NULL
17 ,FOREIGN KEY (ref_id) REFERENCES refs (id)
18 ON DELETE CASCADE ON UPDATE CASCADE
19 ,UNIQUE (ref_id, `key` )