Lines 43-49
return {
Link Here
|
43 |
`type` varchar(80) DEFAULT NULL COMMENT 'type of counter file', |
43 |
`type` varchar(80) DEFAULT NULL COMMENT 'type of counter file', |
44 |
`filename` varchar(80) DEFAULT NULL COMMENT 'name of the counter file', |
44 |
`filename` varchar(80) DEFAULT NULL COMMENT 'name of the counter file', |
45 |
`file_content` longblob DEFAULT NULL COMMENT 'content of the counter file', |
45 |
`file_content` longblob DEFAULT NULL COMMENT 'content of the counter file', |
46 |
`date_uploaded` timestamp DEFAULT NULL DEFAULT current_timestamp() COMMENT 'counter file upload date', |
46 |
`date_uploaded` timestamp DEFAULT current_timestamp() COMMENT 'counter file upload date', |
47 |
PRIMARY KEY (`erm_counter_files_id`), |
47 |
PRIMARY KEY (`erm_counter_files_id`), |
48 |
CONSTRAINT `erm_counter_files_ibfk_1` FOREIGN KEY (`usage_data_provider_id`) REFERENCES `erm_usage_data_providers` (`erm_usage_data_provider_id`) ON DELETE CASCADE ON UPDATE CASCADE |
48 |
CONSTRAINT `erm_counter_files_ibfk_1` FOREIGN KEY (`usage_data_provider_id`) REFERENCES `erm_usage_data_providers` (`erm_usage_data_provider_id`) ON DELETE CASCADE ON UPDATE CASCADE |
49 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
49 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 61-67
return {
Link Here
|
61 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key to borrowers', |
61 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key to borrowers', |
62 |
`counter_files_id` int(11) DEFAULT NULL COMMENT 'foreign key to erm_counter_files', |
62 |
`counter_files_id` int(11) DEFAULT NULL COMMENT 'foreign key to erm_counter_files', |
63 |
`usage_data_provider_id` int(11) DEFAULT NULL COMMENT 'foreign key to erm_usage_data_providers', |
63 |
`usage_data_provider_id` int(11) DEFAULT NULL COMMENT 'foreign key to erm_usage_data_providers', |
64 |
`importdate` timestamp DEFAULT NULL DEFAULT current_timestamp() COMMENT 'counter file import date', |
64 |
`importdate` timestamp DEFAULT current_timestamp() COMMENT 'counter file import date', |
65 |
`filename` varchar(80) DEFAULT NULL COMMENT 'name of the counter file', |
65 |
`filename` varchar(80) DEFAULT NULL COMMENT 'name of the counter file', |
66 |
`logdetails` longtext DEFAULT NULL COMMENT 'details from the counter log', |
66 |
`logdetails` longtext DEFAULT NULL COMMENT 'details from the counter log', |
67 |
PRIMARY KEY (`erm_counter_log_id`), |
67 |
PRIMARY KEY (`erm_counter_log_id`), |
68 |
- |
|
|