-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.51a-community-log


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema c_aus_vic_moon01
--

CREATE DATABASE IF NOT EXISTS c_aus_vic_moon01;
USE c_aus_vic_moon01;

--
-- Definition of table `test_drop`
--

DROP TABLE IF EXISTS `test_drop`;
CREATE TABLE `test_drop` (
  `bay_index` mediumint(8) unsigned NOT NULL default '0',
  `test_string` varchar(12) NOT NULL,
  `test_number` mediumint(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `test_drop`
--

/*!40000 ALTER TABLE `test_drop` DISABLE KEYS */;
INSERT INTO `test_drop` (`bay_index`,`test_string`,`test_number`) VALUES 
 (0,'',0),
 (922,'CP1-001',25),
 (923,'CP1-003',25),
 (924,'CP1-005',25),
 (925,'CP1-007',25),
 (926,'CP1-009',25),
 (927,'CP1-011',25),
 (928,'CP1-013',25),
 (929,'CP1-015',25),
 (930,'CP1-017',25),
 (931,'CP1-019',25),
 (932,'CP1-021',25),
 (933,'CP1-023',25),
 (934,'CP1-025',25),
 (935,'CP1-027',25),
 (936,'CP1-029',25),
 (937,'CP1-031',25),
 (938,'CP1-033',25),
 (939,'CP1-035',25),
 (940,'CP1-037',25),
 (941,'CP1-039',25),
 (942,'CP1-041',25),
 (943,'CP1-043',25),
 (944,'CP1-045',25),
 (945,'CP1-047',25),
 (946,'CP1-049',25),
 (947,'CP1-051',25),
 (948,'CP1-002',25),
 (949,'CP1-004',25),
 (950,'CP1-006',25),
 (951,'CP1-008',25),
 (952,'CP1-010',25),
 (953,'CP1-012',25),
 (954,'CP1-014',25),
 (955,'CP1-016',25),
 (956,'CP1-018',25),
 (957,'CP1-020',25),
 (958,'CP1-022',25),
 (959,'CP1-024',25),
 (960,'CP1-026',25),
 (961,'CP1-028',25),
 (962,'CP1-030',25),
 (963,'CP1-032',25),
 (964,'CP1-034',25),
 (965,'CP1-036',25),
 (966,'CP1-038',25),
 (967,'CP1-040',25),
 (968,'HAL-001',24),
 (969,'HAL-003',24),
 (970,'HAL-005',24),
 (971,'HAL-007',24),
 (972,'HAL-009',24),
 (973,'HAL-011',24),
 (974,'HAL-013',24),
 (975,'HAL-015',24),
 (976,'HAL-017',24),
 (977,'HAL-019',24),
 (978,'HAL-021',24),
 (979,'HAL-023',24),
 (980,'HAL-025',24),
 (981,'HAL-027',24),
 (982,'HAL-029',24),
 (983,'HAL-031',24),
 (984,'HAL-033',24),
 (985,'HAL-035',24),
 (986,'HAL-037',24),
 (987,'HAL-039',24),
 (988,'HAL-041',24),
 (989,'HAL-043',24),
 (990,'HAL-045',24),
 (991,'HAL-047',24),
 (992,'HAL-049',24),
 (993,'HAL-051',24),
 (994,'HAL-053',24),
 (995,'HAL-055',24),
 (996,'HAL-057',24),
 (997,'HAL-059',24),
 (998,'HAL-061',24),
 (999,'HAL-063',24),
 (1000,'HAL-065',24),
 (1001,'HAL-067',24),
 (1002,'HAL-069',24),
 (1003,'HAL-071',24),
 (1004,'HAL-073',24),
 (1005,'HAL-075',24),
 (1006,'HAL-077',24),
 (1007,'HAL-079',24),
 (1008,'HAL-081',24),
 (1009,'HAL-083',24),
 (1010,'HAL-085',24),
 (1011,'HAL-087',24),
 (1012,'HAL-089',24),
 (1013,'HAL-091',24),
 (1014,'HAL-093',24),
 (1015,'HAL-095',24),
 (1016,'HAL-097',24),
 (1017,'HAL-099',24),
 (1018,'HAL-002',24),
 (1019,'HAL-004',24),
 (1020,'HAL-006',24),
 (1021,'HAL-008',24),
 (1022,'HAL-010',24),
 (1023,'HAL-012',24),
 (1024,'HAL-014',24),
 (1025,'HAL-016',24),
 (1026,'HAL-018',24),
 (1027,'HAL-020',24),
 (1028,'HAL-022',24),
 (1029,'HAL-024',24),
 (1030,'HAL-026',24),
 (1031,'HAL-028',24),
 (1032,'HAL-030',24),
 (1033,'HAL-032',24),
 (1034,'HAL-034',24),
 (1035,'HAL-036',24),
 (1036,'HAL-038',24),
 (1037,'HAL-040',24),
 (1038,'HAL-042',24),
 (1039,'HAL-044',24),
 (1040,'HAL-046',24),
 (1041,'HAL-048',24),
 (1042,'CP2-001',32),
 (1043,'CP2-003',32),
 (1044,'CP2-005',32),
 (1045,'CP2-007',32),
 (1046,'CP2-009',32),
 (1047,'CP2-011',32),
 (1048,'CP2-013',32),
 (1049,'CP2-015',32),
 (1050,'CP2-017',32),
 (1051,'CP2-019',32),
 (1052,'CP2-021',32),
 (1053,'CP2-023',32),
 (1054,'CP2-025',32),
 (1055,'CP2-027',32),
 (1056,'CP2-029',32),
 (1057,'CP2-031',32),
 (1058,'CP2-033',32),
 (1059,'CP2-035',32),
 (1060,'CP2-037',32),
 (1061,'CP2-039',32),
 (1062,'CP2-041',32),
 (1063,'CP2-043',32),
 (1064,'CP2-045',32),
 (1065,'CP2-047',32),
 (1066,'CP2-049',32),
 (1067,'CP2-051',32),
 (1068,'CP2-053',32),
 (1069,'CP2-055',32),
 (1070,'CP2-057',32),
 (1071,'CP2-059',32),
 (1072,'CP2-061',32),
 (1073,'CP2-063',32),
 (1074,'CP2-065',32),
 (1075,'CP2-067',32),
 (1076,'CP2-069',32),
 (1077,'CP2-071',32),
 (1078,'CP2-073',32),
 (1079,'CP2-075',32),
 (1080,'CP2-077',32),
 (1081,'CP2-079',32),
 (1082,'CP2-081',32),
 (1083,'CP2-083',32),
 (1084,'CP2-085',32),
 (1085,'CP2-087',32),
 (1086,'CP2-089',32),
 (1087,'CP2-091',32),
 (1088,'CP2-093',32),
 (1089,'CP2-095',32),
 (1090,'CP2-002',32),
 (1091,'CP2-004',32),
 (1092,'CP2-006',32),
 (1093,'CP2-008',32),
 (1094,'CP2-010',32),
 (1095,'CP2-012',32),
 (1096,'CP2-014',32),
 (1097,'CP2-016',32),
 (1098,'CP2-018',32),
 (1099,'CP2-020',32),
 (1100,'CP2-022',32),
 (1101,'CP2-024',32),
 (1102,'CP2-026',32),
 (1103,'CP2-028',32),
 (1104,'CP2-030',32),
 (1105,'CP2-032',32),
 (1106,'CP2-034',32),
 (1107,'CP2-040',32),
 (1108,'CP2-042',32),
 (1109,'CP2-044',32),
 (1110,'CP2-046',32),
 (1111,'CP2-048',32),
 (1112,'CP2-050',32),
 (1113,'CP2-052',32),
 (1114,'CP2-054',32),
 (1115,'CP2-056',32),
 (1116,'CP2-058',32),
 (1117,'CP2-060',32),
 (1118,'CP2-062',32),
 (1119,'CP2-064',32),
 (1120,'CP2-066',32),
 (1121,'CP2-068',32),
 (1122,'SHU-001',31),
 (1123,'SHU-003',31),
 (1124,'SHU-005',31),
 (1125,'SHU-007',31),
 (1126,'SHU-009',31),
 (1127,'SHU-011',31),
 (1128,'SHU-013',31),
 (1129,'SHU-015',31),
 (1130,'SHU-017',31),
 (1131,'SHU-019',31),
 (1132,'SHU-021',31),
 (1133,'SHU-023',31),
 (1134,'SHU-025',31),
 (1135,'SHU-027',31),
 (1136,'SHU-029',31),
 (1137,'SHU-031',31),
 (1138,'SHU-002',31),
 (1139,'SHU-004',31),
 (1140,'SHU-006',31),
 (1141,'SHU-008',31),
 (1142,'SHU-010',31),
 (1143,'SHU-012',31),
 (1144,'SHU-014',31),
 (1145,'SHU-016',31),
 (1146,'SHU-018',31),
 (1147,'SHU-020',31),
 (1148,'SHU-022',31),
 (1149,'SHU-024',31),
 (1150,'SHU-026',31),
 (1151,'SHU-028',31),
 (1152,'SHU-030',31),
 (1153,'SHU-032',31),
 (1154,'SHU-034',31),
 (1155,'SHU-036',31),
 (1156,'SHU-038',31),
 (1157,'SHU-040',31),
 (1158,'SHU-042',31),
 (1159,'PKL-011A',30),
 (1160,'PKL-058A',30),
 (1161,'PKL-001',30),
 (1162,'PKL-003',30),
 (1163,'PKL-005',30),
 (1164,'PKL-007',30),
 (1165,'PKL-009',30),
 (1166,'PKL-011',30),
 (1167,'PKL-013',30),
 (1168,'PKL-015',30),
 (1169,'PKL-017',30),
 (1170,'PKL-019',30),
 (1171,'PKL-021',30),
 (1172,'PKL-023',30),
 (1173,'PKL-025',30),
 (1174,'PKL-027',30),
 (1175,'PKL-029',30),
 (1176,'PKL-031',30),
 (1177,'PKL-033',30),
 (1178,'PKL-035',30),
 (1179,'PKL-037',30),
 (1180,'PKL-039',30),
 (1181,'PKL-041',30),
 (1182,'PKL-043',30),
 (1183,'PKL-045',30),
 (1184,'PKL-047',30),
 (1185,'PKL-049',30),
 (1186,'PKL-051',30),
 (1187,'PKL-053',30),
 (1188,'PKL-055',30),
 (1189,'PKL-057',30),
 (1190,'PKL-059',30),
 (1191,'PKL-061',30),
 (1192,'PKL-063',30),
 (1193,'PKL-065',30),
 (1194,'PKL-067',30),
 (1195,'PKL-069',30),
 (1196,'PKL-071',30),
 (1197,'PKL-073',30),
 (1198,'PKL-075',30),
 (1199,'PKL-077',30),
 (1200,'PKL-079',30),
 (1201,'PKL-081',30),
 (1202,'PKL-002',30),
 (1203,'PKL-004',30),
 (1204,'PKL-006',30),
 (1205,'PKL-008',30),
 (1206,'PKL-010',30),
 (1207,'PKL-012',30),
 (1208,'PKL-014',30),
 (1209,'PKL-016',30),
 (1210,'PKL-018',30),
 (1211,'PKL-020',30),
 (1212,'PKL-022',30),
 (1213,'PKL-024',30),
 (1214,'PKL-026',30),
 (1215,'PKL-028',30),
 (1216,'PKL-030',30),
 (1217,'PKL-032',30),
 (1218,'PKL-034',30),
 (1219,'PKL-036',30),
 (1220,'PKL-038',30),
 (1221,'PKL-040',30),
 (1222,'PKL-042',30),
 (1223,'PKL-044',30),
 (1224,'PKL-046',30),
 (1225,'PKL-048',30),
 (1226,'PKL-050',30),
 (1227,'PKL-052',30),
 (1228,'PKL-054',30),
 (1229,'PKL-056',30),
 (1230,'PKL-058',30),
 (1231,'PKL-060',30),
 (1232,'PKL-062',30),
 (1233,'PKL-064',30),
 (1234,'PKL-066',30),
 (1235,'PKL-068',30),
 (1236,'PKL-070',30),
 (1237,'PKL-072',30),
 (1238,'PKL-074',30),
 (1239,'PKL-076',30),
 (1240,'PKL-078',30),
 (1241,'PKL-080',30),
 (1242,'PKL-082',30),
 (1243,'PKL-084',30),
 (1244,'HLM-086',26),
 (1245,'HLM-088',26),
 (1246,'HLM-090',26),
 (1247,'HLM-092',26),
 (1248,'HLM-094',26),
 (1249,'HLM-096',26),
 (1250,'HLM-098',26),
 (1251,'HLM-100',26),
 (1252,'HLM-102',26),
 (1253,'HLM-104',26),
 (1254,'HLM-106',26),
 (1255,'HLM-108',26),
 (1256,'HLM-110',26),
 (1257,'HLM-112',26),
 (1258,'HLM-114',26),
 (1259,'PRT-001',29),
 (1260,'PRT-003',29),
 (1261,'PRT-002',29),
 (1262,'PRT-004',29),
 (1263,'PRT-006',29),
 (1264,'PRT-008',29),
 (1265,'PRT-010',29),
 (1266,'PRT-012',29),
 (1267,'PRT-014',29),
 (1268,'ALX-001',28),
 (1269,'ALX-003',28),
 (1270,'ALX-005',28),
 (1271,'ALX-007',28),
 (1272,'ALX-009',28),
 (1273,'ALX-011',28),
 (1274,'ALX-013',28),
 (1275,'ALX-015',28),
 (1276,'ALX-017',28),
 (1277,'ALX-019',28),
 (1278,'ALX-021',28),
 (1279,'ALX-023',28),
 (1280,'ALX-025',28),
 (1281,'ALX-027',28),
 (1282,'ALX-029',28),
 (1283,'ALX-031',28),
 (1284,'ALX-033',28),
 (1285,'ALX-035',28),
 (1286,'ALX-037',28),
 (1287,'ALX-039',28),
 (1288,'ALX-041',28),
 (1289,'ALX-043',28),
 (1290,'ALX-045',28),
 (1291,'ALX-047',28),
 (1292,'ALX-049',28),
 (1293,'ALX-051',28),
 (1294,'ALX-053',28),
 (1295,'ALX-055',28),
 (1296,'ALX-057',28),
 (1297,'ALX-059',28),
 (1298,'ALX-061',28),
 (1299,'ALX-063',28),
 (1300,'ALX-065',28),
 (1301,'ALX-067',28),
 (1302,'ALX-069',28),
 (1303,'ALX-071',28),
 (1304,'ALX-073',28),
 (1305,'ALX-075',28),
 (1306,'ALX-077',28),
 (1307,'ALX-079',28),
 (1308,'ALX-081',28),
 (1309,'ALX-083',28),
 (1310,'ALX-085',28),
 (1311,'ALX-087',28),
 (1312,'ALX-089',28),
 (1313,'ALX-091',28),
 (1314,'ALX-093',28),
 (1315,'ALX-095',28),
 (1316,'ALX-097',28),
 (1317,'ALX-099',28),
 (1318,'ALX-101',28),
 (1319,'ALX-103',28),
 (1320,'ALX-105',28),
 (1321,'ALX-107',28),
 (1322,'ALX-109',28),
 (1323,'ALX-111',28),
 (1324,'ALX-113',28),
 (1325,'ALX-115',28),
 (1326,'ALX-117',28),
 (1327,'ALX-119',28),
 (1328,'ALX-121',28),
 (1329,'ALX-123',28),
 (1330,'ALX-125',28),
 (1331,'ALX-127',28),
 (1332,'ALX-129',28),
 (1333,'ALX-131',28),
 (1334,'ALX-133',28),
 (1335,'ALX-135',28),
 (1336,'ALX-137',28),
 (1337,'ALX-139',28),
 (1338,'ALX-141',28),
 (1339,'ALX-143',28),
 (1340,'ALX-145',28),
 (1341,'ALX-147',28),
 (1342,'ALX-149',28),
 (1343,'ALX-151',28),
 (1344,'ALX-153',28),
 (1345,'ALX-155',28),
 (1346,'ALX-157',28),
 (1347,'ALX-159',28),
 (1348,'ALX-161',28),
 (1349,'ALX-163',28),
 (1350,'ALX-165',28),
 (1351,'ALX-167',28),
 (1352,'ALX-169',28),
 (1353,'ALX-171',28),
 (1354,'ALX-173',28),
 (1355,'ALX-175',28),
 (1356,'ALX-177',28),
 (1357,'ALX-179',28),
 (1358,'ALX-181',28),
 (1359,'ALX-183',28),
 (1360,'ALX-002',28),
 (1361,'ALX-004',28),
 (1362,'ALX-006',28),
 (1363,'ALX-008',28),
 (1364,'ALX-010',28),
 (1365,'ALX-012',28),
 (1366,'ALX-014',28),
 (1367,'ALX-016',28),
 (1368,'ALX-018',28),
 (1369,'ALX-020',28),
 (1370,'ALX-022',28),
 (1371,'ALX-024',28),
 (1372,'ALX-026',28),
 (1373,'ALX-028',28),
 (1374,'ALX-030',28),
 (1375,'ALX-032',28),
 (1376,'ALX-034',28),
 (1377,'ALX-036',28),
 (1378,'ALX-038',28),
 (1379,'ALX-040',28),
 (1380,'ALX-042',28),
 (1381,'ALX-044',28),
 (1382,'ALX-046',28),
 (1383,'ALX-048',28),
 (1384,'ALX-050',28),
 (1385,'ALX-052',28),
 (1386,'ALX-054',28),
 (1387,'ALX-056',28),
 (1388,'ALX-058',28),
 (1389,'ALX-060',28),
 (1390,'ALX-062',28),
 (1391,'ALX-064',28),
 (1392,'ALX-066',28),
 (1393,'ALX-068',28),
 (1394,'ALX-070',28),
 (1395,'ALX-072',28),
 (1396,'ALX-074',28),
 (1397,'ALX-076',28),
 (1398,'ALX-078',28),
 (1399,'ALX-080',28),
 (1400,'ALX-082',28),
 (1401,'ALX-084',28),
 (1402,'ALX-086',28),
 (1403,'ALX-088',28),
 (1404,'ALX-090',28),
 (1405,'ALX-092',28),
 (1406,'ALX-094',28),
 (1407,'ALX-096',28),
 (1408,'ALX-098',28),
 (1409,'ALX-100',28),
 (1410,'ALX-102',28),
 (1411,'ALX-104',28),
 (1412,'ALX-106',28),
 (1413,'ALX-108',28),
 (1414,'ALX-110',28),
 (1415,'ALX-112',28),
 (1416,'ALX-114',28),
 (1417,'ALX-116',28),
 (1418,'ALX-118',28),
 (1419,'ALX-120',28),
 (1420,'LKE-001',27),
 (1421,'LKE-003',27),
 (1422,'LKE-005',27),
 (1423,'LKE-007',27),
 (1424,'LKE-009',27),
 (1425,'LKE-011',27),
 (1426,'LKE-013',27),
 (1427,'LKE-015',27),
 (1428,'LKE-017',27),
 (1429,'LKE-019',27),
 (1430,'LKE-021',27),
 (1431,'LKE-023',27),
 (1432,'LKE-025',27),
 (1433,'LKE-027',27),
 (1434,'LKE-029',27),
 (1435,'LKE-002',27),
 (1436,'LKE-004',27),
 (1437,'LKE-006',27),
 (1438,'LKE-008',27),
 (1439,'LKE-010',27),
 (1440,'LKE-012',27),
 (1441,'LKE-014',27),
 (1442,'LKE-016',27),
 (1443,'LKE-018',27),
 (1444,'LKE-020',27),
 (1445,'LKE-022',27),
 (1446,'LKE-024',27),
 (1447,'LKE-026',27),
 (1448,'LKE-028',27),
 (1449,'LKE-030',27),
 (1450,'LKE-032',27),
 (1451,'LKE-034',27),
 (1452,'LKE-036',27),
 (1453,'LKE-038',27),
 (1454,'LKE-040',27),
 (1455,'LKE-042',27),
 (1456,'LKE-044',27),
 (1457,'SHU-000',31),
 (1458,'CP1-042',25),
 (1459,'CP1-044',25);
/*!40000 ALTER TABLE `test_drop` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;