table_cleanup.sql
3.21 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
-- Drop unused tables
DROP TABLE IF EXISTS `metadata_lookup_condition`;
DROP TABLE IF EXISTS `metadata_lookup_condition_chain`;
DROP TABLE IF EXISTS `zseq_metadata_lookup_condition`;
DROP TABLE IF EXISTS `zseq_metadata_lookup_condition_chain`;
-- Make sure sequence tables are MyISAM to avoid transaction-safety.
ALTER TABLE `zseq_active_sessions` ENGINE=MyISAM;
ALTER TABLE `zseq_archive_restoration_request` ENGINE=MyISAM;
ALTER TABLE `zseq_archiving_settings` ENGINE=MyISAM;
ALTER TABLE `zseq_archiving_type_lookup` ENGINE=MyISAM;
ALTER TABLE `zseq_browse_criteria` ENGINE=MyISAM;
ALTER TABLE `zseq_data_types` ENGINE=MyISAM;
ALTER TABLE `zseq_dependant_document_instance` ENGINE=MyISAM;
ALTER TABLE `zseq_dependant_document_template` ENGINE=MyISAM;
ALTER TABLE `zseq_discussion_comments` ENGINE=MyISAM;
ALTER TABLE `zseq_discussion_threads` ENGINE=MyISAM;
ALTER TABLE `zseq_document_archiving_link` ENGINE=MyISAM;
ALTER TABLE `zseq_document_fields` ENGINE=MyISAM;
ALTER TABLE `zseq_document_fields_link` ENGINE=MyISAM;
ALTER TABLE `zseq_document_link` ENGINE=MyISAM;
ALTER TABLE `zseq_document_link_types` ENGINE=MyISAM;
ALTER TABLE `zseq_document_subscriptions` ENGINE=MyISAM;
ALTER TABLE `zseq_document_transaction_types_lookup` ENGINE=MyISAM;
ALTER TABLE `zseq_document_transactions` ENGINE=MyISAM;
ALTER TABLE `zseq_document_type_fields_link` ENGINE=MyISAM;
ALTER TABLE `zseq_document_types_lookup` ENGINE=MyISAM;
ALTER TABLE `zseq_documents` ENGINE=MyISAM;
ALTER TABLE `zseq_folder_doctypes_link` ENGINE=MyISAM;
ALTER TABLE `zseq_folder_subscriptions` ENGINE=MyISAM;
ALTER TABLE `zseq_folders` ENGINE=MyISAM;
ALTER TABLE `zseq_folders_users_roles_link` ENGINE=MyISAM;
ALTER TABLE `zseq_groups_folders_approval_link` ENGINE=MyISAM;
ALTER TABLE `zseq_groups_folders_link` ENGINE=MyISAM;
ALTER TABLE `zseq_groups_groups_link` ENGINE=MyISAM;
ALTER TABLE `zseq_groups_lookup` ENGINE=MyISAM;
ALTER TABLE `zseq_groups_units_link` ENGINE=MyISAM;
ALTER TABLE `zseq_help` ENGINE=MyISAM;
ALTER TABLE `zseq_help_replacement` ENGINE=MyISAM;
ALTER TABLE `zseq_links` ENGINE=MyISAM;
ALTER TABLE `zseq_metadata_lookup` ENGINE=MyISAM;
ALTER TABLE `zseq_mime_types` ENGINE=MyISAM;
ALTER TABLE `zseq_news` ENGINE=MyISAM;
ALTER TABLE `zseq_organisations_lookup` ENGINE=MyISAM;
ALTER TABLE `zseq_permission_assignments` ENGINE=MyISAM;
ALTER TABLE `zseq_permission_descriptors` ENGINE=MyISAM;
ALTER TABLE `zseq_permission_lookup_assignments` ENGINE=MyISAM;
ALTER TABLE `zseq_permission_lookups` ENGINE=MyISAM;
ALTER TABLE `zseq_permission_objects` ENGINE=MyISAM;
ALTER TABLE `zseq_permissions` ENGINE=MyISAM;
ALTER TABLE `zseq_roles` ENGINE=MyISAM;
ALTER TABLE `zseq_search_document_user_link` ENGINE=MyISAM;
ALTER TABLE `zseq_status_lookup` ENGINE=MyISAM;
ALTER TABLE `zseq_system_settings` ENGINE=MyISAM;
ALTER TABLE `zseq_time_period` ENGINE=MyISAM;
ALTER TABLE `zseq_time_unit_lookup` ENGINE=MyISAM;
ALTER TABLE `zseq_units_lookup` ENGINE=MyISAM;
ALTER TABLE `zseq_units_organisations_link` ENGINE=MyISAM;
ALTER TABLE `zseq_upgrades` ENGINE=MyISAM;
ALTER TABLE `zseq_users` ENGINE=MyISAM;
ALTER TABLE `zseq_users_groups_link` ENGINE=MyISAM;
ALTER TABLE `zseq_web_documents` ENGINE=MyISAM;
ALTER TABLE `zseq_web_documents_status_lookup` ENGINE=MyISAM;
ALTER TABLE `zseq_web_sites` ENGINE=MyISAM;