Lines 3042-3048
CREATE TABLE `erm_counter_files` (
Link Here
|
3042 |
`type` varchar(80) DEFAULT NULL COMMENT 'type of counter file', |
3042 |
`type` varchar(80) DEFAULT NULL COMMENT 'type of counter file', |
3043 |
`filename` varchar(80) DEFAULT NULL COMMENT 'name of the counter file', |
3043 |
`filename` varchar(80) DEFAULT NULL COMMENT 'name of the counter file', |
3044 |
`file_content` longblob DEFAULT NULL COMMENT 'content of the counter file', |
3044 |
`file_content` longblob DEFAULT NULL COMMENT 'content of the counter file', |
3045 |
`date_uploaded` timestamp NULL DEFAULT current_timestamp() COMMENT 'counter file upload date', |
3045 |
`date_uploaded` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'counter file upload date', |
3046 |
PRIMARY KEY (`erm_counter_files_id`), |
3046 |
PRIMARY KEY (`erm_counter_files_id`), |
3047 |
KEY `erm_counter_files_ibfk_1` (`usage_data_provider_id`), |
3047 |
KEY `erm_counter_files_ibfk_1` (`usage_data_provider_id`), |
3048 |
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 |
3048 |
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 |
Lines 3061-3067
CREATE TABLE `erm_counter_logs` (
Link Here
|
3061 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key to borrowers', |
3061 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key to borrowers', |
3062 |
`counter_files_id` int(11) DEFAULT NULL COMMENT 'foreign key to erm_counter_files', |
3062 |
`counter_files_id` int(11) DEFAULT NULL COMMENT 'foreign key to erm_counter_files', |
3063 |
`usage_data_provider_id` int(11) DEFAULT NULL COMMENT 'foreign key to erm_usage_data_providers', |
3063 |
`usage_data_provider_id` int(11) DEFAULT NULL COMMENT 'foreign key to erm_usage_data_providers', |
3064 |
`importdate` timestamp NULL DEFAULT current_timestamp() COMMENT 'counter file import date', |
3064 |
`importdate` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'counter file import date', |
3065 |
`filename` varchar(80) DEFAULT NULL COMMENT 'name of the counter file', |
3065 |
`filename` varchar(80) DEFAULT NULL COMMENT 'name of the counter file', |
3066 |
`logdetails` longtext DEFAULT NULL COMMENT 'details from the counter log', |
3066 |
`logdetails` longtext DEFAULT NULL COMMENT 'details from the counter log', |
3067 |
PRIMARY KEY (`erm_counter_log_id`), |
3067 |
PRIMARY KEY (`erm_counter_log_id`), |
3068 |
- |
|
|