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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 3577-3582 CREATE TABLE discharges ( Link Here
3577
-- This table add the ability to add new fields for a record
3577
-- This table add the ability to add new fields for a record
3578
--
3578
--
3579
3579
3580
DROP TABLE IF EXISTS additional_fields;
3580
CREATE TABLE `additional_fields` (
3581
CREATE TABLE `additional_fields` (
3581
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3582
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3582
  `tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field
3583
  `tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field
Lines 3593-3598 CREATE TABLE `additional_fields` ( Link Here
3593
-- This table store values for additional fields
3594
-- This table store values for additional fields
3594
--
3595
--
3595
3596
3597
DROP TABLE IF EXISTS additional_field_values;
3596
CREATE TABLE `additional_field_values` (
3598
CREATE TABLE `additional_field_values` (
3597
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3599
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3598
  `field_id` int(11) NOT NULL, -- foreign key references additional_fields(id)
3600
  `field_id` int(11) NOT NULL, -- foreign key references additional_fields(id)
3599
- 

Return to bug 16565