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 4410-4415
CREATE TABLE `library_groups` (
Link Here
|
4410 |
`ft_search_groups_staff` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group for opac side search groups', |
4411 |
`ft_search_groups_staff` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group for opac side search groups', |
4411 |
`ft_local_hold_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as pick up location for holds', |
4412 |
`ft_local_hold_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as pick up location for holds', |
4412 |
`ft_local_float_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as part of float group', |
4413 |
`ft_local_float_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as part of float group', |
|
|
4414 |
`ft_acquisitions` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group in the acquisitions module', |
4413 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Date and time of creation', |
4415 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Date and time of creation', |
4414 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date and time of last', |
4416 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date and time of last', |
4415 |
PRIMARY KEY (`id`), |
4417 |
PRIMARY KEY (`id`), |
4416 |
- |
|
|