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

(-)a/installer/data/mysql/atomicupdate/14296.sql (+8 lines)
Line 0 Link Here
1
CREATE TABLE upload_settings (
2
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
3
    borrowernumber int,
4
    type enum('filesize','itemquota','spacequota') NOT NULL,
5
    count1 int,
6
    count2 int,
7
    FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber)
8
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
(-)a/installer/data/mysql/kohastructure.sql (-1 / +14 lines)
Lines 3351-3356 CREATE TABLE IF NOT EXISTS `borrower_modifications` ( Link Here
3351
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3351
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3352
3352
3353
--
3353
--
3354
-- Table structure for table upload_settings
3355
--
3356
3357
DROP TABLE IF EXISTS upload_settings;
3358
CREATE TABLE upload_settings (
3359
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
3360
    borrowernumber int,
3361
    type enum('filesize','itemquota','spacequota') NOT NULL,
3362
    count1 int, -- number of bytes or items
3363
    count2 int, -- number of days for quota
3364
    FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber)
3365
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3366
3367
--
3354
-- Table structure for table uploaded_files
3368
-- Table structure for table uploaded_files
3355
--
3369
--
3356
3370
3357
- 

Return to bug 14296