Changeset 28304 for branches/czw_branch/20100519/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Jun 10, 2010, 6:28:51 PM (16 years ago)

Author:

watersc1

Message:

Skycell Summary and stack Association stuff should be finished. I'll merge and do final tests on monday.

Location:

branches/czw_branch/20100519

Files:

• . (modified) (1 prop)
• ippTools/share/pxadmin_create_tables.sql (modified) (3 diffs)

branches/czw_branch/20100519/ippTools/share/pxadmin_create_tables.sql

@@ -1060 +1060 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
-CREATE TABLE stackSummary (
-    stack_id     BIGINT,
-    projection_cell VARCHAR(64) NOT NULL,
-    path_base   VARCHAR(255) NOT NULL,
-    PRIMARY KEY(stack_id),
-    KEY(projection_cell),
-    FOREIGN KEY(stack_id) REFERENCES stackRun(stack_id)
-) ENGINE=innodb DEFAULT CHARSET=latin1;
-
 CREATE TABLE stackAssociation (
     sass_id      BIGINT AUTO_INCREMENT,
@@ -1087 +1078 @@
     FOREIGN KEY(sass_id) REFERENCES stackAssociation(sass_id),
     FOREIGN KEY(stack_id) REFERENCES stackRun(stack_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE stackSummary (
+    sass_id     BIGINT,
+    projection_cell VARCHAR(64) NOT NULL,
+    path_base   VARCHAR(255) NOT NULL,
+    PRIMARY KEY(sass_id),
+    KEY(projection_cell),
+    FOREIGN KEY(sass_id) REFERENCES stackAssociation(sass_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -1448 +1448 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE pstampWebRequest (
+        num BIGINT AUTO_INCREMENT,
+        PRIMARY KEY(num)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 CREATE TABLE distTarget (
     target_id   BIGINT AUTO_INCREMENT,