Changeset 41296 for trunk/dbconfig/changes.txt

Timestamp:

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

Author:

eugene

Message:

adding new tables for stackExternalStacks

File:

• trunk/dbconfig/changes.txt (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;