Merge CV, ver=5.1; ops/methods from HV, and interface from CV where possible

[goodguy/history.git] / cinelerra-5.1 / db / sch1.txt

diff --git a/cinelerra-5.1/db/sch1.txt b/cinelerra-5.1/db/sch1.txt
new file mode 100644 (file)
index 0000000..420791c
--- /dev/null
+++ b/cinelerra-5.1/db/sch1.txt
@@ -0,0 +1,29 @@
+
+CREATE TABLE  clip (
+  clip_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
+  name varchar(255) binary NOT NULL default '',
+  width int unsigned,
+  height int unsigned,
+  length int unsigned,
+  media_type int unsigned
+)  ;
+
+CREATE TABLE prefix (
+  clip_id int unsigned,
+  prefix_seq_no int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
+  time_offset real,
+  key_data media
+)  ;
+
+CREATE UNIQUE INDEX prefix_key_data ON prefix (key_data)  ;
+
+
+CREATE TABLE suffix (
+  clip_id int unsigned,
+  suffix_seq_no int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
+  time_offset real,
+  key_data media
+)  ;
+
+CREATE UNIQUE INDEX suffix_key_data ON suffix (key_data)  ;
+