1 DROP TABLE IF EXISTS datas;
2 DROP TABLE IF EXISTS refs;
5 id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
6 ,ref_type ENUM( 'H', 'A' ) NOT NULL DEFAULT 'H'
7 ,refcount BIGINT UNSIGNED NOT NULL DEFAULT 1
11 id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
12 ,ref_id BIGINT UNSIGNED NOT NULL
13 ,data_type ENUM( 'S', 'R' ) DEFAULT 'S'
17 ,FOREIGN KEY (ref_id) REFERENCES refs (id)
18 ON DELETE CASCADE ON UPDATE CASCADE
19 ,UNIQUE INDEX (ref_id, `key` (900) )