|
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 |
- |
|
|