The file was missing the starting comments before a few tables, this patch adds those in for consistencies sake.
Signed-off-by: Nicole C. Engard <[email protected]> --- installer/data/mysql/kohastructure.sql | 41 +++++++++++++++++++++++++++++++- 1 files changed, 40 insertions(+), 1 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e9edf25..186d547 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -306,6 +306,10 @@ CREATE TABLE `borrower_attributes` ( ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `branch_item_rules` +-- + DROP TABLE IF EXISTS `branch_item_rules`; CREATE TABLE `branch_item_rules` ( `branchcode` varchar(10) NOT NULL, @@ -2021,6 +2025,10 @@ CREATE TABLE `zebraqueue` ( KEY `zebraqueue_lookup` (`server`, `biblio_auth_number`, `operation`, `done`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `services_throttle` +-- + DROP TABLE IF EXISTS `services_throttle`; CREATE TABLE `services_throttle` ( `service_type` varchar(10) NOT NULL default '', @@ -2028,9 +2036,12 @@ CREATE TABLE `services_throttle` ( PRIMARY KEY (`service_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `language_subtag_registry` -- http://www.w3.org/International/articles/language-tags/ - -- RFC4646 +-- + DROP TABLE IF EXISTS language_subtag_registry; CREATE TABLE language_subtag_registry ( subtag varchar(25), @@ -2042,9 +2053,13 @@ CREATE TABLE language_subtag_registry ( KEY `subtag` (`subtag`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `language_rfc4646_to_iso639` -- TODO: add suppress_scripts -- this maps three letter codes defined in iso639.2 back to their -- two letter equivilents in rfc4646 (LOC maintains iso639+) +-- + DROP TABLE IF EXISTS language_rfc4646_to_iso639; CREATE TABLE language_rfc4646_to_iso639 ( rfc4646_subtag varchar(25), @@ -2054,6 +2069,10 @@ CREATE TABLE language_rfc4646_to_iso639 ( KEY `rfc4646_subtag` (`rfc4646_subtag`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `language_descriptions` +-- + DROP TABLE IF EXISTS language_descriptions; CREATE TABLE language_descriptions ( subtag varchar(25), @@ -2066,7 +2085,11 @@ CREATE TABLE language_descriptions ( KEY `subtag_type_lang` (`subtag`, `type`, `lang`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `language_script_bidi` -- bi-directional support, keyed by script subcode +-- + DROP TABLE IF EXISTS language_script_bidi; CREATE TABLE language_script_bidi ( rfc4646_subtag varchar(25), -- script subtag, Arab, Hebr, etc. @@ -2074,8 +2097,12 @@ CREATE TABLE language_script_bidi ( KEY `rfc4646_subtag` (`rfc4646_subtag`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `language_script_mapping` -- TODO: need to map language subtags to script subtags for detection -- of bidi when script is not specified (like ar, he) +-- + DROP TABLE IF EXISTS language_script_mapping; CREATE TABLE language_script_mapping ( language_subtag varchar(25), @@ -2083,6 +2110,10 @@ CREATE TABLE language_script_mapping ( KEY `language_subtag` (`language_subtag`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `permissions` +-- + DROP TABLE IF EXISTS `permissions`; CREATE TABLE `permissions` ( `module_bit` int(11) NOT NULL DEFAULT 0, @@ -2093,6 +2124,10 @@ CREATE TABLE `permissions` ( ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `serialitems` +-- + DROP TABLE IF EXISTS `serialitems`; CREATE TABLE `serialitems` ( `itemnumber` int(11) NOT NULL, @@ -2103,6 +2138,10 @@ CREATE TABLE `serialitems` ( CONSTRAINT serialitems_sfk_2 FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `user_permissions` +-- + DROP TABLE IF EXISTS `user_permissions`; CREATE TABLE `user_permissions` ( `borrowernumber` int(11) NOT NULL DEFAULT 0, -- 1.7.2.3 _______________________________________________ Koha-patches mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
