Changeset 41296

Timestamp:

Feb 27, 2020, 12:40:09 PM (6 years ago)

Author:

eugene

Message:

adding new tables for stackExternalStacks

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• stack.md (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -2560 +2560 @@
 ALTER TABLE minidvodbRun ADD COLUMN note varchar(255) AFTER state;
 
+--
+
+CREATE TABLE stackExternalCamera (
+    ext_camera_id BIGINT AUTO_INCREMENT,
+    ext_camera    VARCHAR(64) NOT NULL,
+    KEY ext_camera_id (ext_camera_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE stackExternalStack (
+    stack_id      BIGINT,
+    ext_stack_id  BIGINT,
+    ext_camera_id BIGINT,
+    FOREIGN KEY (ext_camera_id)
+      REFERENCES stackExternalCamera(ext_camera_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;

trunk/dbconfig/stack.md

@@ -75 +75 @@
     stack_id       S64      0       # Primary Key fkey(stack_id) ref stackRun(stack_id)
 END
+
+stackExternalCamera METADATA
+    ext_camera_id  S64      0       # Primary Key AUTO_INCREMENT
+    ext_camera     STR     64
+END
+
+stackExternalStack METADATA
+    stack_id       S64      0       # Primary Key
+    ext_stack_id   S64      0
+    ext_camera_id  S64      0       # fkey(ext_camera_id) ref stackExternalCamera(ext_camera_id)
+END