Changeset 20786

Timestamp:

Nov 17, 2008, 3:54:32 PM (17 years ago)

Author:

bills

Message:

add magicDSRun and magicDSFile

Location:

trunk/ippTools/share

Files:

• pxadmin_create_tables.sql (modified) (1 diff)
• pxadmin_drop_tables.sql (modified) (1 diff)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1059 +1059 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE magicDSRun (
+        magic_ds_id BIGINT AUTO_INCREMENT,
+        magic_id BIGINT,
+        state VARCHAR(64),
+        stage VARCHAR(64),
+        outroot VARCHAR(255),
+        recoveryroot VARCHAR(255),
+        re_place TINYINT,
+        remove TINYINT,
+        PRIMARY KEY(magic_ds_id),
+        KEY(magic_ds_id),
+        KEY(state),
+        FOREIGN KEY (magic_id)  REFERENCES  magicRun(magic_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE magicDSFile (
+    magic_ds_id BIGINT,
+    component VARCHAR(64),
+    backup_path_base VARCHAR(255),
+    recovery_path_base VARCHAR(255),
+    fault SMALLINT,
+    PRIMARY KEY(magic_ds_id, component),
+    KEY(fault),
+    FOREIGN KEY (magic_ds_id) REFERENCES magicDSRun(magic_ds_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 CREATE TABLE calDB (
         cal_id BIGINT AUTO_INCREMENT,

trunk/ippTools/share/pxadmin_drop_tables.sql

@@ -47 +47 @@
 DROP TABLE IF EXISTS magicMask;
 DROP TABLE IF EXISTS magicSkyfileMask;
+DROP TABLE IF EXISTS magicDSRun;
+DROP TABLE IF EXISTS magicDSFile;
 DROP TABLE IF EXISTS calDB;
 DROP TABLE IF EXISTS calRun;