Edit File by line
/home/barbar84/www/wp-conte.../plugins/sujqvwi/AnonR/smanonr..../var/softacul.../phpsch
File: phpsch.sql
[1000] Fix | Delete
INSERT INTO `time_blocks` VALUES
[1001] Fix | Delete
(1, NULL, NULL, 2, 1, '00:00:00', '08:00:00', NULL),
[1002] Fix | Delete
(2, NULL, NULL, 1, 1, '08:00:00', '08:30:00', NULL),
[1003] Fix | Delete
(3, NULL, NULL, 1, 1, '08:30:00', '09:00:00', NULL),
[1004] Fix | Delete
(4, NULL, NULL, 1, 1, '09:00:00', '09:30:00', NULL),
[1005] Fix | Delete
(5, NULL, NULL, 1, 1, '09:30:00', '10:00:00', NULL),
[1006] Fix | Delete
(6, NULL, NULL, 1, 1, '10:00:00', '10:30:00', NULL),
[1007] Fix | Delete
(7, NULL, NULL, 1, 1, '10:30:00', '11:00:00', NULL),
[1008] Fix | Delete
(8, NULL, NULL, 1, 1, '11:00:00', '11:30:00', NULL),
[1009] Fix | Delete
(9, NULL, NULL, 1, 1, '11:30:00', '12:00:00', NULL),
[1010] Fix | Delete
(10, NULL, NULL, 1, 1, '12:00:00', '12:30:00', NULL),
[1011] Fix | Delete
(11, NULL, NULL, 1, 1, '12:30:00', '13:00:00', NULL),
[1012] Fix | Delete
(12, NULL, NULL, 1, 1, '13:00:00', '13:30:00', NULL),
[1013] Fix | Delete
(13, NULL, NULL, 1, 1, '13:30:00', '14:00:00', NULL),
[1014] Fix | Delete
(14, NULL, NULL, 1, 1, '14:00:00', '14:30:00', NULL),
[1015] Fix | Delete
(15, NULL, NULL, 1, 1, '14:30:00', '15:00:00', NULL),
[1016] Fix | Delete
(16, NULL, NULL, 1, 1, '15:00:00', '15:30:00', NULL),
[1017] Fix | Delete
(17, NULL, NULL, 1, 1, '15:30:00', '16:00:00', NULL),
[1018] Fix | Delete
(18, NULL, NULL, 1, 1, '16:00:00', '16:30:00', NULL),
[1019] Fix | Delete
(19, NULL, NULL, 1, 1, '16:30:00', '17:00:00', NULL),
[1020] Fix | Delete
(20, NULL, NULL, 1, 1, '17:00:00', '17:30:00', NULL),
[1021] Fix | Delete
(21, NULL, NULL, 1, 1, '17:30:00', '18:00:00', NULL),
[1022] Fix | Delete
(22, NULL, NULL, 2, 1, '18:00:00', '00:00:00', NULL);
[1023] Fix | Delete
[1024] Fix | Delete
-- --------------------------------------------------------
[1025] Fix | Delete
[1026] Fix | Delete
--
[1027] Fix | Delete
-- Table structure for table `users`
[1028] Fix | Delete
--
[1029] Fix | Delete
[1030] Fix | Delete
CREATE TABLE `users` (
[1031] Fix | Delete
`user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[1032] Fix | Delete
`fname` varchar(85) DEFAULT NULL,
[1033] Fix | Delete
`lname` varchar(85) DEFAULT NULL,
[1034] Fix | Delete
`username` varchar(85) DEFAULT NULL,
[1035] Fix | Delete
`email` varchar(85) NOT NULL,
[1036] Fix | Delete
`password` varchar(85) NOT NULL,
[1037] Fix | Delete
`salt` varchar(85) NOT NULL,
[1038] Fix | Delete
`organization` varchar(85) DEFAULT NULL,
[1039] Fix | Delete
`position` varchar(85) DEFAULT NULL,
[1040] Fix | Delete
`phone` varchar(85) DEFAULT NULL,
[1041] Fix | Delete
`timezone` varchar(85) NOT NULL,
[1042] Fix | Delete
`language` varchar(10) NOT NULL,
[1043] Fix | Delete
`homepageid` tinyint(2) unsigned NOT NULL DEFAULT '1',
[1044] Fix | Delete
`date_created` datetime NOT NULL,
[1045] Fix | Delete
`last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
[1046] Fix | Delete
`lastlogin` datetime DEFAULT NULL,
[1047] Fix | Delete
`status_id` tinyint(2) unsigned NOT NULL,
[1048] Fix | Delete
`legacyid` char(16) DEFAULT NULL,
[1049] Fix | Delete
`legacypassword` varchar(32) DEFAULT NULL,
[1050] Fix | Delete
`public_id` varchar(20) DEFAULT NULL,
[1051] Fix | Delete
`allow_calendar_subscription` tinyint(1) NOT NULL DEFAULT '0',
[1052] Fix | Delete
`default_schedule_id` smallint(5) unsigned DEFAULT NULL,
[1053] Fix | Delete
`credit_count` decimal(7,2) DEFAULT '0.00',
[1054] Fix | Delete
`terms_date_accepted` datetime DEFAULT NULL,
[1055] Fix | Delete
PRIMARY KEY (`user_id`),
[1056] Fix | Delete
UNIQUE KEY `public_id` (`public_id`),
[1057] Fix | Delete
KEY `status_id` (`status_id`)
[1058] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
[1059] Fix | Delete
[1060] Fix | Delete
--
[1061] Fix | Delete
-- Dumping data for table `users`
[1062] Fix | Delete
--
[1063] Fix | Delete
[1064] Fix | Delete
INSERT INTO `users` VALUES
[1065] Fix | Delete
(1, 'User', 'User', 'user', 'user@example.com', '7b6aec38ff9b7650d64d0374194307bdde711425', '3b3dbb9b', 'XYZ Org Inc.', NULL, NULL, 'America/New_York', 'en_us', 1, '[[regtime]]', '[[regtime]]', '2008-09-16 01:59:00', 1, NULL, NULL, NULL, 0, NULL, '0.00', NULL),
[1066] Fix | Delete
(2, '[[admin_fname]]', '[[admin_lname]]', '[[admin_username]]', '[[admin_email]]', '[[admin_pass]]', '[[salt]]', '[[site_name]]', NULL, NULL, 'America/New_York', 'en_us', 1, '[[regtime]]', '[[regtime]]', '2010-03-26 12:44:00', 1, NULL, NULL, NULL, 0, NULL, '0.00', NULL);
[1067] Fix | Delete
[1068] Fix | Delete
-- --------------------------------------------------------
[1069] Fix | Delete
[1070] Fix | Delete
--
[1071] Fix | Delete
-- Table structure for table `user_email_preferences`
[1072] Fix | Delete
--
[1073] Fix | Delete
[1074] Fix | Delete
CREATE TABLE `user_email_preferences` (
[1075] Fix | Delete
`user_id` mediumint(8) unsigned NOT NULL,
[1076] Fix | Delete
`event_category` varchar(45) NOT NULL,
[1077] Fix | Delete
`event_type` varchar(45) NOT NULL,
[1078] Fix | Delete
PRIMARY KEY (`user_id`,`event_category`,`event_type`)
[1079] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[1080] Fix | Delete
[1081] Fix | Delete
-- --------------------------------------------------------
[1082] Fix | Delete
[1083] Fix | Delete
--
[1084] Fix | Delete
-- Table structure for table `user_groups`
[1085] Fix | Delete
--
[1086] Fix | Delete
[1087] Fix | Delete
CREATE TABLE `user_groups` (
[1088] Fix | Delete
`user_id` mediumint(8) unsigned NOT NULL,
[1089] Fix | Delete
`group_id` smallint(5) unsigned NOT NULL,
[1090] Fix | Delete
PRIMARY KEY (`group_id`,`user_id`),
[1091] Fix | Delete
KEY `user_id` (`user_id`),
[1092] Fix | Delete
KEY `group_id` (`group_id`)
[1093] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[1094] Fix | Delete
[1095] Fix | Delete
--
[1096] Fix | Delete
-- Dumping data for table `user_groups`
[1097] Fix | Delete
--
[1098] Fix | Delete
[1099] Fix | Delete
INSERT INTO `user_groups` VALUES
[1100] Fix | Delete
(2, 2);
[1101] Fix | Delete
[1102] Fix | Delete
-- --------------------------------------------------------
[1103] Fix | Delete
[1104] Fix | Delete
--
[1105] Fix | Delete
-- Table structure for table `user_preferences`
[1106] Fix | Delete
--
[1107] Fix | Delete
[1108] Fix | Delete
CREATE TABLE `user_preferences` (
[1109] Fix | Delete
`user_preferences_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[1110] Fix | Delete
`user_id` mediumint(8) unsigned NOT NULL,
[1111] Fix | Delete
`name` varchar(100) NOT NULL,
[1112] Fix | Delete
`value` text,
[1113] Fix | Delete
PRIMARY KEY (`user_preferences_id`),
[1114] Fix | Delete
KEY `user_id` (`user_id`)
[1115] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[1116] Fix | Delete
[1117] Fix | Delete
-- --------------------------------------------------------
[1118] Fix | Delete
[1119] Fix | Delete
--
[1120] Fix | Delete
-- Table structure for table `user_resource_permissions`
[1121] Fix | Delete
--
[1122] Fix | Delete
[1123] Fix | Delete
CREATE TABLE `user_resource_permissions` (
[1124] Fix | Delete
`user_id` mediumint(8) unsigned NOT NULL,
[1125] Fix | Delete
`resource_id` smallint(5) unsigned NOT NULL,
[1126] Fix | Delete
`permission_id` tinyint(2) unsigned NOT NULL DEFAULT '1',
[1127] Fix | Delete
`permission_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
[1128] Fix | Delete
PRIMARY KEY (`user_id`,`resource_id`),
[1129] Fix | Delete
KEY `user_id` (`user_id`),
[1130] Fix | Delete
KEY `resource_id` (`resource_id`),
[1131] Fix | Delete
KEY `user_id_2` (`user_id`),
[1132] Fix | Delete
KEY `resource_id_2` (`resource_id`)
[1133] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[1134] Fix | Delete
[1135] Fix | Delete
--
[1136] Fix | Delete
-- Dumping data for table `user_resource_permissions`
[1137] Fix | Delete
--
[1138] Fix | Delete
[1139] Fix | Delete
INSERT INTO `user_resource_permissions` VALUES
[1140] Fix | Delete
(1, 1, 1, 0),
[1141] Fix | Delete
(1, 2, 1, 0),
[1142] Fix | Delete
(2, 1, 1, 0),
[1143] Fix | Delete
(2, 2, 1, 0);
[1144] Fix | Delete
[1145] Fix | Delete
-- --------------------------------------------------------
[1146] Fix | Delete
[1147] Fix | Delete
--
[1148] Fix | Delete
-- Table structure for table `user_session`
[1149] Fix | Delete
--
[1150] Fix | Delete
[1151] Fix | Delete
CREATE TABLE `user_session` (
[1152] Fix | Delete
`user_session_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[1153] Fix | Delete
`user_id` mediumint(8) unsigned NOT NULL,
[1154] Fix | Delete
`last_modified` datetime NOT NULL,
[1155] Fix | Delete
`session_token` varchar(50) NOT NULL,
[1156] Fix | Delete
`user_session_value` text NOT NULL,
[1157] Fix | Delete
PRIMARY KEY (`user_session_id`),
[1158] Fix | Delete
KEY `user_session_user_id` (`user_id`),
[1159] Fix | Delete
KEY `user_session_session_token` (`session_token`)
[1160] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[1161] Fix | Delete
[1162] Fix | Delete
-- --------------------------------------------------------
[1163] Fix | Delete
[1164] Fix | Delete
--
[1165] Fix | Delete
-- Table structure for table `user_statuses`
[1166] Fix | Delete
--
[1167] Fix | Delete
[1168] Fix | Delete
CREATE TABLE `user_statuses` (
[1169] Fix | Delete
`status_id` tinyint(2) unsigned NOT NULL,
[1170] Fix | Delete
`description` varchar(85) DEFAULT NULL,
[1171] Fix | Delete
PRIMARY KEY (`status_id`)
[1172] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[1173] Fix | Delete
[1174] Fix | Delete
--
[1175] Fix | Delete
-- Dumping data for table `user_statuses`
[1176] Fix | Delete
--
[1177] Fix | Delete
[1178] Fix | Delete
INSERT INTO `user_statuses` VALUES
[1179] Fix | Delete
(1, 'Active'),
[1180] Fix | Delete
(2, 'Awaiting'),
[1181] Fix | Delete
(3, 'Inactive');
[1182] Fix | Delete
[1183] Fix | Delete
--
[1184] Fix | Delete
-- Constraints for dumped tables
[1185] Fix | Delete
--
[1186] Fix | Delete
[1187] Fix | Delete
--
[1188] Fix | Delete
-- Constraints for table `account_activation`
[1189] Fix | Delete
--
[1190] Fix | Delete
ALTER TABLE `account_activation`
[1191] Fix | Delete
ADD CONSTRAINT `account_activation_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;
[1192] Fix | Delete
[1193] Fix | Delete
--
[1194] Fix | Delete
-- Constraints for table `announcement_groups`
[1195] Fix | Delete
--
[1196] Fix | Delete
ALTER TABLE `announcement_groups`
[1197] Fix | Delete
ADD CONSTRAINT `announcement_groups_ibfk_1` FOREIGN KEY (`announcementid`) REFERENCES `announcements` (`announcementid`) ON DELETE CASCADE,
[1198] Fix | Delete
ADD CONSTRAINT `announcement_groups_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`) ON DELETE CASCADE;
[1199] Fix | Delete
[1200] Fix | Delete
--
[1201] Fix | Delete
-- Constraints for table `announcement_resources`
[1202] Fix | Delete
--
[1203] Fix | Delete
ALTER TABLE `announcement_resources`
[1204] Fix | Delete
ADD CONSTRAINT `announcement_resources_ibfk_1` FOREIGN KEY (`announcementid`) REFERENCES `announcements` (`announcementid`) ON DELETE CASCADE,
[1205] Fix | Delete
ADD CONSTRAINT `announcement_resources_ibfk_2` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`resource_id`) ON DELETE CASCADE;
[1206] Fix | Delete
[1207] Fix | Delete
--
[1208] Fix | Delete
-- Constraints for table `blackout_instances`
[1209] Fix | Delete
--
[1210] Fix | Delete
ALTER TABLE `blackout_instances`
[1211] Fix | Delete
ADD CONSTRAINT `blackout_instances_ibfk_1` FOREIGN KEY (`blackout_series_id`) REFERENCES `blackout_series` (`blackout_series_id`) ON DELETE CASCADE;
[1212] Fix | Delete
[1213] Fix | Delete
--
[1214] Fix | Delete
-- Constraints for table `blackout_series_resources`
[1215] Fix | Delete
--
[1216] Fix | Delete
ALTER TABLE `blackout_series_resources`
[1217] Fix | Delete
ADD CONSTRAINT `blackout_series_resources_ibfk_1` FOREIGN KEY (`blackout_series_id`) REFERENCES `blackout_series` (`blackout_series_id`) ON DELETE CASCADE,
[1218] Fix | Delete
ADD CONSTRAINT `blackout_series_resources_ibfk_2` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`resource_id`) ON DELETE CASCADE;
[1219] Fix | Delete
[1220] Fix | Delete
--
[1221] Fix | Delete
-- Constraints for table `custom_attribute_entities`
[1222] Fix | Delete
--
[1223] Fix | Delete
ALTER TABLE `custom_attribute_entities`
[1224] Fix | Delete
ADD CONSTRAINT `custom_attribute_entities_ibfk_1` FOREIGN KEY (`custom_attribute_id`) REFERENCES `custom_attributes` (`custom_attribute_id`) ON DELETE CASCADE;
[1225] Fix | Delete
[1226] Fix | Delete
--
[1227] Fix | Delete
-- Constraints for table `custom_time_blocks`
[1228] Fix | Delete
--
[1229] Fix | Delete
ALTER TABLE `custom_time_blocks`
[1230] Fix | Delete
ADD CONSTRAINT `custom_time_blocks_ibfk_1` FOREIGN KEY (`layout_id`) REFERENCES `layouts` (`layout_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1231] Fix | Delete
[1232] Fix | Delete
--
[1233] Fix | Delete
-- Constraints for table `groups`
[1234] Fix | Delete
--
[1235] Fix | Delete
ALTER TABLE `groups`
[1236] Fix | Delete
ADD CONSTRAINT `groups_ibfk_1` FOREIGN KEY (`admin_group_id`) REFERENCES `groups` (`group_id`);
[1237] Fix | Delete
[1238] Fix | Delete
--
[1239] Fix | Delete
-- Constraints for table `group_resource_permissions`
[1240] Fix | Delete
--
[1241] Fix | Delete
ALTER TABLE `group_resource_permissions`
[1242] Fix | Delete
ADD CONSTRAINT `group_resource_permissions_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
[1243] Fix | Delete
ADD CONSTRAINT `group_resource_permissions_ibfk_2` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`resource_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1244] Fix | Delete
[1245] Fix | Delete
--
[1246] Fix | Delete
-- Constraints for table `group_roles`
[1247] Fix | Delete
--
[1248] Fix | Delete
ALTER TABLE `group_roles`
[1249] Fix | Delete
ADD CONSTRAINT `group_roles_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
[1250] Fix | Delete
ADD CONSTRAINT `group_roles_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1251] Fix | Delete
[1252] Fix | Delete
--
[1253] Fix | Delete
-- Constraints for table `peak_times`
[1254] Fix | Delete
--
[1255] Fix | Delete
ALTER TABLE `peak_times`
[1256] Fix | Delete
ADD CONSTRAINT `peak_times_ibfk_1` FOREIGN KEY (`schedule_id`) REFERENCES `schedules` (`schedule_id`) ON DELETE CASCADE;
[1257] Fix | Delete
[1258] Fix | Delete
--
[1259] Fix | Delete
-- Constraints for table `quotas`
[1260] Fix | Delete
--
[1261] Fix | Delete
ALTER TABLE `quotas`
[1262] Fix | Delete
ADD CONSTRAINT `quotas_ibfk_1` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`resource_id`) ON DELETE CASCADE ON UPDATE CASCADE,
[1263] Fix | Delete
ADD CONSTRAINT `quotas_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
[1264] Fix | Delete
ADD CONSTRAINT `quotas_ibfk_3` FOREIGN KEY (`schedule_id`) REFERENCES `schedules` (`schedule_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1265] Fix | Delete
[1266] Fix | Delete
--
[1267] Fix | Delete
-- Constraints for table `refund_transaction_log`
[1268] Fix | Delete
--
[1269] Fix | Delete
ALTER TABLE `refund_transaction_log`
[1270] Fix | Delete
ADD CONSTRAINT `refund_transaction_log_ibfk_1` FOREIGN KEY (`payment_transaction_log_id`) REFERENCES `payment_transaction_log` (`payment_transaction_log_id`) ON DELETE CASCADE;
[1271] Fix | Delete
[1272] Fix | Delete
--
[1273] Fix | Delete
-- Constraints for table `reminders`
[1274] Fix | Delete
--
[1275] Fix | Delete
ALTER TABLE `reminders`
[1276] Fix | Delete
ADD CONSTRAINT `reminders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;
[1277] Fix | Delete
[1278] Fix | Delete
--
[1279] Fix | Delete
-- Constraints for table `reservation_accessories`
[1280] Fix | Delete
--
[1281] Fix | Delete
ALTER TABLE `reservation_accessories`
[1282] Fix | Delete
ADD CONSTRAINT `reservation_accessories_ibfk_1` FOREIGN KEY (`accessory_id`) REFERENCES `accessories` (`accessory_id`) ON DELETE CASCADE ON UPDATE CASCADE,
[1283] Fix | Delete
ADD CONSTRAINT `reservation_accessories_ibfk_2` FOREIGN KEY (`series_id`) REFERENCES `reservation_series` (`series_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1284] Fix | Delete
[1285] Fix | Delete
--
[1286] Fix | Delete
-- Constraints for table `reservation_color_rules`
[1287] Fix | Delete
--
[1288] Fix | Delete
ALTER TABLE `reservation_color_rules`
[1289] Fix | Delete
ADD CONSTRAINT `reservation_color_rules_ibfk_1` FOREIGN KEY (`custom_attribute_id`) REFERENCES `custom_attributes` (`custom_attribute_id`) ON DELETE CASCADE;
[1290] Fix | Delete
[1291] Fix | Delete
--
[1292] Fix | Delete
-- Constraints for table `reservation_files`
[1293] Fix | Delete
--
[1294] Fix | Delete
ALTER TABLE `reservation_files`
[1295] Fix | Delete
ADD CONSTRAINT `reservation_files_ibfk_1` FOREIGN KEY (`series_id`) REFERENCES `reservation_series` (`series_id`) ON DELETE CASCADE;
[1296] Fix | Delete
[1297] Fix | Delete
--
[1298] Fix | Delete
-- Constraints for table `reservation_guests`
[1299] Fix | Delete
--
[1300] Fix | Delete
ALTER TABLE `reservation_guests`
[1301] Fix | Delete
ADD CONSTRAINT `reservation_guests_ibfk_1` FOREIGN KEY (`reservation_instance_id`) REFERENCES `reservation_instances` (`reservation_instance_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1302] Fix | Delete
[1303] Fix | Delete
--
[1304] Fix | Delete
-- Constraints for table `reservation_instances`
[1305] Fix | Delete
--
[1306] Fix | Delete
ALTER TABLE `reservation_instances`
[1307] Fix | Delete
ADD CONSTRAINT `reservations_series` FOREIGN KEY (`series_id`) REFERENCES `reservation_series` (`series_id`) ON DELETE CASCADE;
[1308] Fix | Delete
[1309] Fix | Delete
--
[1310] Fix | Delete
-- Constraints for table `reservation_reminders`
[1311] Fix | Delete
--
[1312] Fix | Delete
ALTER TABLE `reservation_reminders`
[1313] Fix | Delete
ADD CONSTRAINT `reservation_reminders_ibfk_1` FOREIGN KEY (`series_id`) REFERENCES `reservation_series` (`series_id`) ON DELETE CASCADE;
[1314] Fix | Delete
[1315] Fix | Delete
--
[1316] Fix | Delete
-- Constraints for table `reservation_resources`
[1317] Fix | Delete
--
[1318] Fix | Delete
ALTER TABLE `reservation_resources`
[1319] Fix | Delete
ADD CONSTRAINT `reservation_resources_ibfk_1` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`resource_id`) ON DELETE CASCADE ON UPDATE CASCADE,
[1320] Fix | Delete
ADD CONSTRAINT `reservation_resources_ibfk_2` FOREIGN KEY (`series_id`) REFERENCES `reservation_series` (`series_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1321] Fix | Delete
[1322] Fix | Delete
--
[1323] Fix | Delete
-- Constraints for table `reservation_series`
[1324] Fix | Delete
--
[1325] Fix | Delete
ALTER TABLE `reservation_series`
[1326] Fix | Delete
ADD CONSTRAINT `reservations_owner` FOREIGN KEY (`owner_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE,
[1327] Fix | Delete
ADD CONSTRAINT `reservations_status` FOREIGN KEY (`status_id`) REFERENCES `reservation_statuses` (`status_id`) ON UPDATE CASCADE,
[1328] Fix | Delete
ADD CONSTRAINT `reservations_type` FOREIGN KEY (`type_id`) REFERENCES `reservation_types` (`type_id`) ON UPDATE CASCADE;
[1329] Fix | Delete
[1330] Fix | Delete
--
[1331] Fix | Delete
-- Constraints for table `reservation_users`
[1332] Fix | Delete
--
[1333] Fix | Delete
ALTER TABLE `reservation_users`
[1334] Fix | Delete
ADD CONSTRAINT `reservation_users_ibfk_1` FOREIGN KEY (`reservation_instance_id`) REFERENCES `reservation_instances` (`reservation_instance_id`) ON DELETE CASCADE ON UPDATE CASCADE,
[1335] Fix | Delete
ADD CONSTRAINT `reservation_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1336] Fix | Delete
[1337] Fix | Delete
--
[1338] Fix | Delete
-- Constraints for table `reservation_waitlist_requests`
[1339] Fix | Delete
--
[1340] Fix | Delete
ALTER TABLE `reservation_waitlist_requests`
[1341] Fix | Delete
ADD CONSTRAINT `reservation_waitlist_requests_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE,
[1342] Fix | Delete
ADD CONSTRAINT `reservation_waitlist_requests_ibfk_2` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`resource_id`) ON DELETE CASCADE;
[1343] Fix | Delete
[1344] Fix | Delete
--
[1345] Fix | Delete
-- Constraints for table `resources`
[1346] Fix | Delete
--
[1347] Fix | Delete
ALTER TABLE `resources`
[1348] Fix | Delete
ADD CONSTRAINT `admin_group_id` FOREIGN KEY (`admin_group_id`) REFERENCES `groups` (`group_id`) ON DELETE SET NULL,
[1349] Fix | Delete
ADD CONSTRAINT `resources_ibfk_1` FOREIGN KEY (`schedule_id`) REFERENCES `schedules` (`schedule_id`) ON DELETE CASCADE ON UPDATE CASCADE,
[1350] Fix | Delete
ADD CONSTRAINT `resources_ibfk_2` FOREIGN KEY (`resource_type_id`) REFERENCES `resource_types` (`resource_type_id`) ON DELETE SET NULL,
[1351] Fix | Delete
ADD CONSTRAINT `resources_ibfk_3` FOREIGN KEY (`resource_status_reason_id`) REFERENCES `resource_status_reasons` (`resource_status_reason_id`) ON DELETE SET NULL;
[1352] Fix | Delete
[1353] Fix | Delete
--
[1354] Fix | Delete
-- Constraints for table `resource_accessories`
[1355] Fix | Delete
--
[1356] Fix | Delete
ALTER TABLE `resource_accessories`
[1357] Fix | Delete
ADD CONSTRAINT `resource_accessories_ibfk_1` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`resource_id`) ON DELETE CASCADE,
[1358] Fix | Delete
ADD CONSTRAINT `resource_accessories_ibfk_2` FOREIGN KEY (`accessory_id`) REFERENCES `accessories` (`accessory_id`) ON DELETE CASCADE;
[1359] Fix | Delete
[1360] Fix | Delete
--
[1361] Fix | Delete
-- Constraints for table `resource_groups`
[1362] Fix | Delete
--
[1363] Fix | Delete
ALTER TABLE `resource_groups`
[1364] Fix | Delete
ADD CONSTRAINT `resource_groups_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `resource_groups` (`resource_group_id`) ON DELETE CASCADE;
[1365] Fix | Delete
[1366] Fix | Delete
--
[1367] Fix | Delete
-- Constraints for table `resource_group_assignment`
[1368] Fix | Delete
--
[1369] Fix | Delete
ALTER TABLE `resource_group_assignment`
[1370] Fix | Delete
ADD CONSTRAINT `resource_group_assignment_ibfk_1` FOREIGN KEY (`resource_group_id`) REFERENCES `resource_groups` (`resource_group_id`) ON DELETE CASCADE,
[1371] Fix | Delete
ADD CONSTRAINT `resource_group_assignment_ibfk_2` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`resource_id`) ON DELETE CASCADE;
[1372] Fix | Delete
[1373] Fix | Delete
--
[1374] Fix | Delete
-- Constraints for table `resource_images`
[1375] Fix | Delete
--
[1376] Fix | Delete
ALTER TABLE `resource_images`
[1377] Fix | Delete
ADD CONSTRAINT `resource_images_ibfk_1` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`resource_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1378] Fix | Delete
[1379] Fix | Delete
--
[1380] Fix | Delete
-- Constraints for table `resource_type_assignment`
[1381] Fix | Delete
--
[1382] Fix | Delete
ALTER TABLE `resource_type_assignment`
[1383] Fix | Delete
ADD CONSTRAINT `resource_type_assignment_ibfk_1` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`resource_id`) ON DELETE CASCADE,
[1384] Fix | Delete
ADD CONSTRAINT `resource_type_assignment_ibfk_2` FOREIGN KEY (`resource_type_id`) REFERENCES `resource_types` (`resource_type_id`) ON DELETE CASCADE;
[1385] Fix | Delete
[1386] Fix | Delete
--
[1387] Fix | Delete
-- Constraints for table `saved_reports`
[1388] Fix | Delete
--
[1389] Fix | Delete
ALTER TABLE `saved_reports`
[1390] Fix | Delete
ADD CONSTRAINT `saved_reports_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;
[1391] Fix | Delete
[1392] Fix | Delete
--
[1393] Fix | Delete
-- Constraints for table `schedules`
[1394] Fix | Delete
--
[1395] Fix | Delete
ALTER TABLE `schedules`
[1396] Fix | Delete
ADD CONSTRAINT `schedules_groups_admin_group_id` FOREIGN KEY (`admin_group_id`) REFERENCES `groups` (`group_id`) ON DELETE SET NULL,
[1397] Fix | Delete
ADD CONSTRAINT `schedules_ibfk_1` FOREIGN KEY (`layout_id`) REFERENCES `layouts` (`layout_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1398] Fix | Delete
[1399] Fix | Delete
--
[1400] Fix | Delete
-- Constraints for table `time_blocks`
[1401] Fix | Delete
--
[1402] Fix | Delete
ALTER TABLE `time_blocks`
[1403] Fix | Delete
ADD CONSTRAINT `time_blocks_ibfk_1` FOREIGN KEY (`layout_id`) REFERENCES `layouts` (`layout_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1404] Fix | Delete
[1405] Fix | Delete
--
[1406] Fix | Delete
-- Constraints for table `users`
[1407] Fix | Delete
--
[1408] Fix | Delete
ALTER TABLE `users`
[1409] Fix | Delete
ADD CONSTRAINT `users_ibfk_1` FOREIGN KEY (`status_id`) REFERENCES `user_statuses` (`status_id`) ON UPDATE CASCADE;
[1410] Fix | Delete
[1411] Fix | Delete
--
[1412] Fix | Delete
-- Constraints for table `user_email_preferences`
[1413] Fix | Delete
--
[1414] Fix | Delete
ALTER TABLE `user_email_preferences`
[1415] Fix | Delete
ADD CONSTRAINT `user_email_preferences_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1416] Fix | Delete
[1417] Fix | Delete
--
[1418] Fix | Delete
-- Constraints for table `user_groups`
[1419] Fix | Delete
--
[1420] Fix | Delete
ALTER TABLE `user_groups`
[1421] Fix | Delete
ADD CONSTRAINT `user_groups_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
[1422] Fix | Delete
ADD CONSTRAINT `user_groups_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1423] Fix | Delete
[1424] Fix | Delete
--
[1425] Fix | Delete
-- Constraints for table `user_preferences`
[1426] Fix | Delete
--
[1427] Fix | Delete
ALTER TABLE `user_preferences`
[1428] Fix | Delete
ADD CONSTRAINT `user_preferences_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1429] Fix | Delete
[1430] Fix | Delete
--
[1431] Fix | Delete
-- Constraints for table `user_resource_permissions`
[1432] Fix | Delete
--
[1433] Fix | Delete
ALTER TABLE `user_resource_permissions`
[1434] Fix | Delete
ADD CONSTRAINT `user_resource_permissions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
[1435] Fix | Delete
ADD CONSTRAINT `user_resource_permissions_ibfk_2` FOREIGN KEY (`resource_id`) REFERENCES `resources` (`resource_id`) ON DELETE CASCADE ON UPDATE CASCADE;
[1436] Fix | Delete
[1437] Fix | Delete
--
[1438] Fix | Delete
-- Constraints for table `user_session`
[1439] Fix | Delete
--
[1440] Fix | Delete
ALTER TABLE `user_session`
[1441] Fix | Delete
ADD CONSTRAINT `user_session_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;
[1442] Fix | Delete
[1443] Fix | Delete
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
[1444] Fix | Delete
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
[1445] Fix | Delete
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
[1446] Fix | Delete
[1447] Fix | Delete
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function