[dbsrgits/DBM-Deep.git] / etc / sqlite_tables.sql

DROP TABLE IF EXISTS datas;
DROP TABLE IF EXISTS refs;

CREATE TABLE refs (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
   ,ref_type STRING NOT NULL DEFAULT 'H'
   ,refcount INTEGER NOT NULL DEFAULT 1
   ,classname STRING
);

CREATE TABLE datas (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
   ,ref_id INTEGER NOT NULL
   ,data_type STRING DEFAULT 'S'
   ,`key` STRING NOT NULL
   ,value STRING
   ,FOREIGN KEY (ref_id) REFERENCES refs (id)
        ON DELETE CASCADE ON UPDATE CASCADE
   ,UNIQUE (ref_id, `key` )
);
Commit	Line	Data
bac1b5d5	1	DROP TABLE IF EXISTS datas;
	2	DROP TABLE IF EXISTS refs;
	3
	4	CREATE TABLE refs (
	5	id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
	6	,ref_type STRING NOT NULL DEFAULT 'H'
	7	,refcount INTEGER NOT NULL DEFAULT 1
	8	,classname STRING
	9	);
	10
	11	CREATE TABLE datas (
	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
	16	,value STRING
	17	,FOREIGN KEY (ref_id) REFERENCES refs (id)
	18	ON DELETE CASCADE ON UPDATE CASCADE
	19	,UNIQUE (ref_id, `key` )
	20	);