View | Details | Raw Unified | Return to bug 2797
Collapse All | Expand All

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-2 / +2 lines)
Lines 2829-2840 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
2829
		('852', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2829
		('852', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2830
		('852', '8', 'Sequence number', 'Sequence number', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2830
		('852', '8', 'Sequence number', 'Sequence number', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2831
		('852', 'a', 'Location', 'Location', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2831
		('852', 'a', 'Location', 'Location', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2832
		('852', 'b', 'Sublocation or collection', 'Sublocation or collection', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2832
		('852', 'b', 'Sublocation or collection', 'Sublocation or collection', 1, 0, 'summaries.homebranch', 8, '', '', '', NULL, 5, '', '', '', NULL),
2833
		('852', 'c', 'Shelving location', 'Shelving location', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2833
		('852', 'c', 'Shelving location', 'Shelving location', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2834
		('852', 'e', 'Address', 'Address', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2834
		('852', 'e', 'Address', 'Address', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2835
		('852', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2835
		('852', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2836
		('852', 'g', 'Non-coded location qualifier', 'Non-coded location qualifier', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2836
		('852', 'g', 'Non-coded location qualifier', 'Non-coded location qualifier', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2837
		('852', 'h', 'Classification part', 'Classification part', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2837
		('852', 'h', 'Classification part', 'Classification part', 0, 0, 'summaries.callnumber', 8, '', '', '', NULL, 5, '', '', '', NULL),
2838
		('852', 'i', 'Item part', 'Item part', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2838
		('852', 'i', 'Item part', 'Item part', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2839
		('852', 'j', 'Shelving control number', 'Shelving control number', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2839
		('852', 'j', 'Shelving control number', 'Shelving control number', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2840
		('852', 'k', 'Call number prefix', 'Call number prefix', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
2840
		('852', 'k', 'Call number prefix', 'Call number prefix', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
(-)a/installer/data/mysql/kohastructure.sql (-1 / +99 lines)
Lines 1158-1172 CREATE TABLE `items` ( Link Here
1158
  `more_subfields_xml` longtext default NULL,
1158
  `more_subfields_xml` longtext default NULL,
1159
  `enumchron` varchar(80) default NULL,
1159
  `enumchron` varchar(80) default NULL,
1160
  `copynumber` varchar(32) default NULL,
1160
  `copynumber` varchar(32) default NULL,
1161
  `summary_id` int(11) default NULL,
1161
  PRIMARY KEY  (`itemnumber`),
1162
  PRIMARY KEY  (`itemnumber`),
1162
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1163
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1163
  KEY `itembinoidx` (`biblioitemnumber`),
1164
  KEY `itembinoidx` (`biblioitemnumber`),
1164
  KEY `itembibnoidx` (`biblionumber`),
1165
  KEY `itembibnoidx` (`biblionumber`),
1165
  KEY `homebranch` (`homebranch`),
1166
  KEY `homebranch` (`homebranch`),
1166
  KEY `holdingbranch` (`holdingbranch`),
1167
  KEY `holdingbranch` (`holdingbranch`),
1168
  KEY `items_ibfk_4` (`summary_id`),
1167
  CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1169
  CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1168
  CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1170
  CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1169
  CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE
1171
  CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1172
  CONSTRAINT `items_ibfk_4` FOREIGN KEY (`summary_id`) REFERENCES `summaries` (`summary_id`)
1170
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1173
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1171
1174
1172
--
1175
--
Lines 2303-2305 CREATE TABLE `borrower_message_transport_preferences` ( Link Here
2303
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2306
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2304
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2307
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2305
2308
2309
DROP TABLE IF EXISTS `summaries`;
2310
CREATE TABLE `summaries` (
2311
`summary_id` INTEGER auto_increment ,
2312
`biblionumber` int(11) DEFAULT NULL,
2313
`homebranch` VARCHAR(10) default NULL,
2314
`holdingbranch` VARCHAR(10) default NULL,
2315
`callnumber` char (30) default '',
2316
`shelvinglocation` int (11) default NULL,
2317
`call_number_source` char (10) default '',
2318
`collection_code` int (11) default NULL,
2319
`URI` char (255) default '',
2320
`itemtype` varchar(10) default NULL,
2321
`copy_number` INTEGER default '0',
2322
`last_modified_by` INTEGER default '0',
2323
`last_modified_timestamp` TIMESTAMP NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2324
`created_by` INTEGER default '0',
2325
`created_timestamp` TIMESTAMP,
2326
PRIMARY KEY (`summary_id`),
2327
CONSTRAINT `summaries_ibfk_1` FOREIGN KEY (`biblionumber`)        REFERENCES `biblio`    (`biblionumber`)   ON DELETE CASCADE ON UPDATE CASCADE,
2328
CONSTRAINT `summaries_ibfk_2` FOREIGN KEY (`homebranch`)          REFERENCES `branches`  (`branchcode`)     ON DELETE CASCADE ON UPDATE CASCADE,
2329
CONSTRAINT `summaries_ibfk_3` FOREIGN KEY (`holdingbranch`)       REFERENCES `branches`  (`branchcode`)     ON DELETE CASCADE ON UPDATE CASCADE,
2330
CONSTRAINT `summaries_ibfk_4` FOREIGN KEY (`shelvinglocation`)    REFERENCES `authorised_values` (`id`)     ON DELETE CASCADE ON UPDATE CASCADE,
2331
CONSTRAINT `summaries_ibfk_5` FOREIGN KEY (`call_number_source`)  REFERENCES `class_sources` (`cn_source`)  ON DELETE CASCADE ON UPDATE CASCADE,
2332
CONSTRAINT `summaries_ibfk_6` FOREIGN KEY (`collection_code`)     REFERENCES `authorised_values` (`id`)     ON DELETE CASCADE ON UPDATE CASCADE,
2333
CONSTRAINT `summaries_ibfk_7` FOREIGN KEY (`itemtype`)            REFERENCES `itemtypes` (`itemtype`)       ON DELETE CASCADE ON UPDATE CASCADE,
2334
CONSTRAINT `summaries_ibfk_8` FOREIGN KEY (`last_modified_by`)    REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2335
CONSTRAINT `summaries_ibfk_9` FOREIGN KEY (`created_by`)          REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
2336
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2337
2338
DROP TABLE IF EXISTS `unstructured_summary_holdings_statements`;
2339
CREATE TABLE `unstructured_summary_holdings_statements` (
2340
`unstructured_summary_holdings_statement_id` INTEGER auto_increment ,
2341
`summary_id` INTEGER default '0',
2342
`sequence_number` INTEGER NOT NULL default '0',
2343
`public_note` char (100) NOT NULL default '',
2344
`staff_note` char (100) NOT NULL default '',
2345
`statement` MEDIUMTEXT NOT NULL default '',
2346
`display_template` MEDIUMTEXT NOT NULL default '',
2347
PRIMARY KEY (`unstructured_summary_holdings_statement_id`),
2348
CONSTRAINT `unstructured_summary_holdings_statements_ibfk_1` FOREIGN KEY (`summary_id`) REFERENCES `summaries` (`summary_id`) ON DELETE CASCADE ON UPDATE CASCADE
2349
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2350
2351
DROP TABLE IF EXISTS `structured_summary_holdings_statements`;
2352
CREATE TABLE `structured_summary_holdings_statements` (
2353
`structured_summary_holdings_statement_id` INTEGER auto_increment ,
2354
`summary_id` INTEGER default '0',
2355
`sequence_number` INTEGER NOT NULL default '0',
2356
`public_note` char (100) NOT NULL default '',
2357
`staff_note` char (100) NOT NULL default '',
2358
`display_template` MEDIUMTEXT NOT NULL default '',
2359
PRIMARY KEY (`structured_summary_holdings_statement_id`),
2360
CONSTRAINT `structured_summary_holdings_statements` FOREIGN KEY (`summary_id`) REFERENCES `summaries` (`summary_id`) ON DELETE CASCADE ON UPDATE CASCADE
2361
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2362
2363
2364
DROP TABLE IF EXISTS `structured_summary_holding_statement_levels`;
2365
CREATE TABLE `structured_summary_holding_statement_levels` (
2366
`id` INTEGER NOT NULL auto_increment ,
2367
`structured_summary_holdings_statement_id` INTEGER default '0',
2368
`level` INTEGER NOT NULL default '0',
2369
`beginning_label` char (32) NOT NULL default '',
2370
`beginning_value` char (32) NOT NULL default '',
2371
`ending_label` char (32) NOT NULL default '',
2372
`ending_value` char (32) NOT NULL default '',
2373
PRIMARY KEY (`id`),
2374
CONSTRAINT `structured_summary_holding_statement_levels_ibfk_1` FOREIGN KEY (`structured_summary_holdings_statement_id`) REFERENCES `structured_summary_holdings_statements` (`structured_summary_holdings_statement_id`) ON DELETE CASCADE ON UPDATE CASCADE
2375
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2376
2377
DROP TABLE IF EXISTS `summary_record_templates`;
2378
CREATE TABLE `summary_record_templates` (
2379
`id` INTEGER auto_increment ,
2380
`homebranch` varchar(10) NOT NULL default '',
2381
`holdingbranch` varchar(10) NOT NULL default '',
2382
`itemtype` varchar(10) NOT NULL default '',
2383
`shelvinglocation` char (80) NOT NULL default '',
2384
`call_number_source` char (10) NOT NULL default '',
2385
`collection_code` char (10) NOT NULL default '',
2386
`URI` char (255) NOT NULL default '',
2387
PRIMARY KEY (`id`),
2388
CONSTRAINT `summary_record_templates_ibfk_1` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
2389
CONSTRAINT `summary_record_templates_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
2390
CONSTRAINT `summary_record_templates_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE
2391
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2392
2393
DROP TABLE IF EXISTS `import_summaries`;
2394
CREATE TABLE `import_summaries` (
2395
  `import_record_id` int(11) NOT NULL,
2396
  `control_number` varchar(25) default NULL,
2397
  `biblio_control_number` varchar(25) default NULL,
2398
  `original_source` varchar(25) default NULL,
2399
  KEY `import_record_ibfk_1` (`import_record_id`),
2400
  KEY `biblio_control_number` (`biblio_control_number`),
2401
  CONSTRAINT `import_summaries_ibfk_1` FOREIGN KEY (`import_record_id`) REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE
2402
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2403
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +139 lines)
Lines 2040-2045 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
2040
    SetVersion ($DBversion);
2040
    SetVersion ($DBversion);
2041
}
2041
}
2042
2042
2043
$DBversion = '3.01.00.004';
2044
if ( C4::Context->preference('Version') < TransformToNum($DBversion) ) {
2045
2046
    $dbh->do(<<'END_SQL');
2047
CREATE TABLE `summaries` (
2048
`summary_id` INTEGER auto_increment ,
2049
`biblionumber` int(11) DEFAULT NULL,
2050
`homebranch` VARCHAR(10) default NULL,
2051
`holdingbranch` VARCHAR(10) default NULL,
2052
`callnumber` char (30) default '',
2053
`shelvinglocation` int (11) default NULL,
2054
`call_number_source` char (10) default '',
2055
`collection_code` int (11) default NULL,
2056
`URI` char (255) default '',
2057
`itemtype` varchar(10) default NULL,
2058
`copy_number` INTEGER default '0',
2059
`last_modified_by` INTEGER default '0',
2060
`last_modified_timestamp` TIMESTAMP NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2061
`created_by` INTEGER default '0',
2062
`created_timestamp` TIMESTAMP,
2063
PRIMARY KEY (`summary_id`),
2064
CONSTRAINT `summaries_ibfk_1` FOREIGN KEY (`biblionumber`)        REFERENCES `biblio`    (`biblionumber`)   ON DELETE CASCADE ON UPDATE CASCADE,
2065
CONSTRAINT `summaries_ibfk_2` FOREIGN KEY (`homebranch`)          REFERENCES `branches`  (`branchcode`)     ON DELETE CASCADE ON UPDATE CASCADE,
2066
CONSTRAINT `summaries_ibfk_3` FOREIGN KEY (`holdingbranch`)       REFERENCES `branches`  (`branchcode`)     ON DELETE CASCADE ON UPDATE CASCADE,
2067
CONSTRAINT `summaries_ibfk_4` FOREIGN KEY (`shelvinglocation`)    REFERENCES `authorised_values` (`id`)     ON DELETE CASCADE ON UPDATE CASCADE,
2068
CONSTRAINT `summaries_ibfk_5` FOREIGN KEY (`call_number_source`)  REFERENCES `class_sources` (`cn_source`)  ON DELETE CASCADE ON UPDATE CASCADE,
2069
CONSTRAINT `summaries_ibfk_6` FOREIGN KEY (`collection_code`)     REFERENCES `authorised_values` (`id`)     ON DELETE CASCADE ON UPDATE CASCADE,
2070
CONSTRAINT `summaries_ibfk_7` FOREIGN KEY (`itemtype`)            REFERENCES `itemtypes` (`itemtype`)       ON DELETE CASCADE ON UPDATE CASCADE,
2071
CONSTRAINT `summaries_ibfk_8` FOREIGN KEY (`last_modified_by`)    REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2072
CONSTRAINT `summaries_ibfk_9` FOREIGN KEY (`created_by`)          REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
2073
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2074
END_SQL
2075
2076
    $dbh->do(<<'END_SQL');
2077
CREATE TABLE `unstructured_summary_holdings_statements` (
2078
`unstructured_summary_holdings_statement_id` INTEGER auto_increment ,
2079
`summary_id` INTEGER default '0',
2080
`sequence_number` INTEGER NOT NULL default '0',
2081
`public_note` char (100) NOT NULL default '',
2082
`staff_note` char (100) NOT NULL default '',
2083
`statement` MEDIUMTEXT NOT NULL default '',
2084
`display_template` MEDIUMTEXT NOT NULL default '',
2085
PRIMARY KEY (`unstructured_summary_holdings_statement_id`),
2086
CONSTRAINT `unstructured_summary_holdings_statements_ibfk_1` FOREIGN KEY (`summary_id`) REFERENCES `summaries` (`summary_id`) ON DELETE CASCADE ON UPDATE CASCADE
2087
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2088
END_SQL
2089
2090
    $dbh->do(<<'END_SQL');
2091
CREATE TABLE `structured_summary_holdings_statements` (
2092
`structured_summary_holdings_statement_id` INTEGER auto_increment ,
2093
`summary_id` INTEGER default '0',
2094
`sequence_number` INTEGER NOT NULL default '0',
2095
`public_note` char (100) NOT NULL default '',
2096
`staff_note` char (100) NOT NULL default '',
2097
`display_template` MEDIUMTEXT NOT NULL default '',
2098
PRIMARY KEY (`structured_summary_holdings_statement_id`),
2099
CONSTRAINT `structured_summary_holdings_statements` FOREIGN KEY (`summary_id`) REFERENCES `summaries` (`summary_id`) ON DELETE CASCADE ON UPDATE CASCADE
2100
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2101
END_SQL
2102
2103
    $dbh->do(<<'END_SQL');
2104
CREATE TABLE `structured_summary_holding_statement_levels` (
2105
`id` INTEGER NOT NULL auto_increment ,
2106
`structured_summary_holdings_statement_id` INTEGER default '0',
2107
`level` INTEGER NOT NULL default '0',
2108
`beginning_label` char (32) NOT NULL default '',
2109
`beginning_value` char (32) NOT NULL default '',
2110
`ending_label` char (32) NOT NULL default '',
2111
`ending_value` char (32) NOT NULL default '',
2112
PRIMARY KEY (`id`),
2113
CONSTRAINT `structured_summary_holding_statement_levels_ibfk_1` FOREIGN KEY (`structured_summary_holdings_statement_id`) REFERENCES `structured_summary_holdings_statements` (`structured_summary_holdings_statement_id`) ON DELETE CASCADE ON UPDATE CASCADE
2114
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2115
END_SQL
2116
2117
    $dbh->do(<<'END_SQL');
2118
CREATE TABLE `summary_record_templates` (
2119
`id` INTEGER auto_increment ,
2120
`homebranch` varchar(10) NOT NULL default '',
2121
`holdingbranch` varchar(10) NOT NULL default '',
2122
`itemtype` varchar(10) NOT NULL default '',
2123
`shelvinglocation` char (80) NOT NULL default '',
2124
`call_number_source` char (10) NOT NULL default '',
2125
`collection_code` char (10) NOT NULL default '',
2126
`URI` char (255) NOT NULL default '',
2127
PRIMARY KEY (`id`),
2128
CONSTRAINT `summary_record_templates_ibfk_1` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
2129
CONSTRAINT `summary_record_templates_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
2130
CONSTRAINT `summary_record_templates_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE
2131
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2132
END_SQL
2133
2134
    $dbh->do(<<'END_SQL');
2135
CREATE TABLE `import_summaries` (
2136
  `import_record_id` int(11) NOT NULL,
2137
  `control_number` varchar(25) default NULL,
2138
  `biblio_control_number` varchar(25) default NULL,
2139
  `original_source` varchar(25) default NULL,
2140
  KEY `import_record_ibfk_1` (`import_record_id`),
2141
  KEY `biblio_control_number` (`biblio_control_number`),
2142
  CONSTRAINT `import_summaries_ibfk_1` FOREIGN KEY (`import_record_id`) REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE
2143
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2144
END_SQL
2145
2146
2147
    $dbh->do(<<'END_SQL');
2148
alter table items
2149
  add column summary_id int
2150
END_SQL
2151
2152
    $dbh->do(<<'END_SQL');
2153
alter table items
2154
  add constraint `items_ibfk_4`
2155
  foreign key (`summary_id`)
2156
  references `summaries` (`summary_id`)
2157
END_SQL
2158
2159
    $dbh->do(<<'END_SQL');
2160
UPDATE marc_subfield_structure
2161
 SET kohafield = 'summaries.homebranch'
2162
 WHERE tagfield = '852'
2163
 AND tagsubfield = 'b'
2164
END_SQL
2165
2166
    $dbh->do(<<'END_SQL');
2167
UPDATE marc_subfield_structure
2168
 SET kohafield = 'summaries.callnumber'
2169
 WHERE tagfield = '852'
2170
 AND tagsubfield = 'h'
2171
END_SQL
2172
2173
    $dbh->do(<<'END_SQL');
2174
ALTER TABLE import_batches
2175
  ADD COLUMN `num_summaries` int(11) NOT NULL default '0'
2176
END_SQL
2177
2178
    print "Upgrade to $DBversion done (DDL for summary records)\n";
2179
    SetVersion ($DBversion);
2180
}
2181
2043
=item DropAllForeignKeys($table)
2182
=item DropAllForeignKeys($table)
2044
2183
2045
  Drop all foreign keys of the table $table
2184
  Drop all foreign keys of the table $table
2046
- 

Return to bug 2797