View | Details | Raw Unified | Return to bug 36755
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-5 / +4 lines)
Lines 1247-1253 DROP TABLE IF EXISTS `borrower_attribute_types`; Link Here
1247
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1247
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1248
/*!40101 SET character_set_client = utf8 */;
1248
/*!40101 SET character_set_client = utf8 */;
1249
CREATE TABLE `borrower_attribute_types` (
1249
CREATE TABLE `borrower_attribute_types` (
1250
  `code` varchar(10) NOT NULL COMMENT 'unique key used to identify each custom field',
1250
  `code` varchar(64) NOT NULL COMMENT 'unique key used to identify each custom field',
1251
  `description` varchar(255) NOT NULL COMMENT 'description for each custom field',
1251
  `description` varchar(255) NOT NULL COMMENT 'description for each custom field',
1252
  `repeatable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines whether one patron/borrower can have multiple values for this custom field  (1 for yes, 0 for no)',
1252
  `repeatable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines whether one patron/borrower can have multiple values for this custom field  (1 for yes, 0 for no)',
1253
  `unique_id` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this value needs to be unique (1 for yes, 0 for no)',
1253
  `unique_id` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this value needs to be unique (1 for yes, 0 for no)',
Lines 1277-1283 DROP TABLE IF EXISTS `borrower_attribute_types_branches`; Link Here
1277
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1277
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1278
/*!40101 SET character_set_client = utf8 */;
1278
/*!40101 SET character_set_client = utf8 */;
1279
CREATE TABLE `borrower_attribute_types_branches` (
1279
CREATE TABLE `borrower_attribute_types_branches` (
1280
  `bat_code` varchar(10) DEFAULT NULL,
1280
  `bat_code` varchar(64) DEFAULT NULL,
1281
  `b_branchcode` varchar(10) DEFAULT NULL,
1281
  `b_branchcode` varchar(10) DEFAULT NULL,
1282
  KEY `bat_code` (`bat_code`),
1282
  KEY `bat_code` (`bat_code`),
1283
  KEY `b_branchcode` (`b_branchcode`),
1283
  KEY `b_branchcode` (`b_branchcode`),
Lines 1296-1302 DROP TABLE IF EXISTS `borrower_attributes`; Link Here
1296
CREATE TABLE `borrower_attributes` (
1296
CREATE TABLE `borrower_attributes` (
1297
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field',
1297
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field',
1298
  `borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines which patron/borrower has this attribute',
1298
  `borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines which patron/borrower has this attribute',
1299
  `code` varchar(10) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for',
1299
  `code` varchar(64) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for',
1300
  `attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value',
1300
  `attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value',
1301
  PRIMARY KEY (`id`),
1301
  PRIMARY KEY (`id`),
1302
  KEY `borrowernumber` (`borrowernumber`),
1302
  KEY `borrowernumber` (`borrowernumber`),
Lines 5301-5307 DROP TABLE IF EXISTS `pseudonymized_borrower_attributes`; Link Here
5301
CREATE TABLE `pseudonymized_borrower_attributes` (
5301
CREATE TABLE `pseudonymized_borrower_attributes` (
5302
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field',
5302
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field',
5303
  `transaction_id` int(11) NOT NULL,
5303
  `transaction_id` int(11) NOT NULL,
5304
  `code` varchar(10) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for',
5304
  `code` varchar(64) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for',
5305
  `attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value',
5305
  `attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value',
5306
  PRIMARY KEY (`id`),
5306
  PRIMARY KEY (`id`),
5307
  KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`),
5307
  KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`),
5308
- 

Return to bug 36755