1 DROP TABLE encdoe_track_info CASCADE;
2 DROP TABLE encode_tf_binding_tracks CASCADE;
3 DROP TABLE encode_tracks CASCADE;
4 DROP TABLE encode_track_info_keys CASCADE;
6 CREATE TABLE encode_tracks (
11 CREATE TABLE encode_track_info_keys (
12 id SERIAL PRIMARY KEY,
16 CREATE TABLE encode_track_info (
17 id SERIAL PRIMARY KEY,
18 track_id INT NOT NULL REFERENCES encode_tracks,
19 info_key_id INT NOT NULL REFERENCES encode_track_info_keys,
20 info_value TEXT NOT NULL
23 CREATE UNIQUE INDEX ON encode_track_info(track_id,info_key_id);
24 CREATE INDEX ON encode_track_info(info_key_id,info_value);
26 CREATE TABLE encode_tf_binding_tracks (
27 id SERIAL PRIMARY KEY,
28 track_id INT NOT NULL REFERENCES encode_tracks,
32 name TEXT NOT NULL DEFAULT '',
34 strand TEXT NOT NULL DEFAULT '.',