Lines 503-508
CREATE TABLE `aqbooksellers` (
Link Here
|
503 |
`external_id` varchar(255) DEFAULT NULL COMMENT 'external id of the vendor', |
503 |
`external_id` varchar(255) DEFAULT NULL COMMENT 'external id of the vendor', |
504 |
`payment_method` varchar(255) DEFAULT NULL COMMENT 'the payment method for the vendor', |
504 |
`payment_method` varchar(255) DEFAULT NULL COMMENT 'the payment method for the vendor', |
505 |
`language` varchar(255) DEFAULT NULL COMMENT 'the language for the vendor', |
505 |
`language` varchar(255) DEFAULT NULL COMMENT 'the language for the vendor', |
|
|
506 |
`lib_group_visibility` varchar(255) DEFAULT NULL COMMENT 'the library groups the vendor is visible to', |
506 |
PRIMARY KEY (`id`), |
507 |
PRIMARY KEY (`id`), |
507 |
KEY `listprice` (`listprice`), |
508 |
KEY `listprice` (`listprice`), |
508 |
KEY `invoiceprice` (`invoiceprice`), |
509 |
KEY `invoiceprice` (`invoiceprice`), |
Lines 4366-4371
CREATE TABLE `library_groups` (
Link Here
|
4366 |
`ft_search_groups_staff` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group for opac side search groups', |
4367 |
`ft_search_groups_staff` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group for opac side search groups', |
4367 |
`ft_local_hold_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as pick up location for holds', |
4368 |
`ft_local_hold_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as pick up location for holds', |
4368 |
`ft_local_float_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as part of float group', |
4369 |
`ft_local_float_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as part of float group', |
|
|
4370 |
`ft_acquisitions` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group in the acquisitions module', |
4369 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Date and time of creation', |
4371 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Date and time of creation', |
4370 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date and time of last', |
4372 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date and time of last', |
4371 |
PRIMARY KEY (`id`), |
4373 |
PRIMARY KEY (`id`), |
4372 |
- |
|
|