- Timestamp:
- Jun 7, 2010, 12:00:46 PM (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/czw_branch/20100519/ippTools/share/pxadmin_create_tables.sql
r28164 r28245 983 983 CREATE TABLE warpSummary ( 984 984 warp_id BIGINT, 985 tangent_planeVARCHAR(64) NOT NULL,985 projection_cell VARCHAR(64) NOT NULL, 986 986 path_base VARCHAR(255) NOT NULL, 987 987 PRIMARY KEY(warp_id), 988 KEY( tangent_plane),988 KEY(projection_cell), 989 989 FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id) 990 990 ) ENGINE=innodb DEFAULT CHARSET=latin1; … … 1062 1062 CREATE TABLE stackSummary ( 1063 1063 stack_id BIGINT, 1064 tangent_planeVARCHAR(64) NOT NULL,1064 projection_cell VARCHAR(64) NOT NULL, 1065 1065 path_base VARCHAR(255) NOT NULL, 1066 1066 PRIMARY KEY(stack_id), 1067 KEY( tangent_plane),1067 KEY(projection_cell), 1068 1068 FOREIGN KEY(stack_id) REFERENCES stackRun(stack_id) 1069 1069 ) ENGINE=innodb DEFAULT CHARSET=latin1; … … 1072 1072 sass_id BIGINT AUTO_INCREMENT, 1073 1073 data_group VARCHAR(64) NOT NULL, 1074 tangent_planeVARCHAR(64) NOT NULL,1074 projection_cell VARCHAR(64) NOT NULL, 1075 1075 tess_id VARCHAR(64) NOT NULL, 1076 1076 filter VARCHAR(64) NOT NULL, 1077 1077 PRIMARY KEY(sass_id), 1078 1078 KEY(data_group), 1079 KEY( tangent_plane),1079 KEY(projection_cell), 1080 1080 KEY(tess_id) 1081 1081 ) ENGINE=innodb DEFAULT CHARSET=latin1; … … 1187 1187 CREATE TABLE diffSummary ( 1188 1188 diff_id BIGINT, 1189 tangent_planeVARCHAR(64) NOT NULL,1189 projection_cell VARCHAR(64) NOT NULL, 1190 1190 path_base VARCHAR(255) NOT NULL, 1191 1191 PRIMARY KEY(diff_id), 1192 KEY( tangent_plane),1192 KEY(projection_cell), 1193 1193 FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id) 1194 1194 ) ENGINE=innodb DEFAULT CHARSET=latin1;
Note:
See TracChangeset
for help on using the changeset viewer.
