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

(-)a/api/v1/swagger/definitions/vendor_alias.yaml (-1 / +1 lines)
Lines 1-7 Link Here
1
---
1
---
2
type: object
2
type: object
3
properties:
3
properties:
4
  id:
4
  alias_id:
5
    description: Internal ID for the extended attribute
5
    description: Internal ID for the extended attribute
6
    type: integer
6
    type: integer
7
  vendor_id:
7
  vendor_id:
(-)a/installer/data/mysql/atomicupdate/bug_33103.pl (-2 / +2 lines)
Lines 9-18 return { Link Here
9
        unless ( TableExists('aqbookseller_aliases') ) {
9
        unless ( TableExists('aqbookseller_aliases') ) {
10
            $dbh->do(q{
10
            $dbh->do(q{
11
                CREATE TABLE `aqbookseller_aliases` (
11
                CREATE TABLE `aqbookseller_aliases` (
12
                  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha',
12
                  `alias_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha',
13
                  `vendor_id` int(11) NOT NULL COMMENT 'link to the vendor',
13
                  `vendor_id` int(11) NOT NULL COMMENT 'link to the vendor',
14
                  `alias` varchar(255) NOT NULL COMMENT "the alias",
14
                  `alias` varchar(255) NOT NULL COMMENT "the alias",
15
                  PRIMARY KEY (`id`),
15
                  PRIMARY KEY (`alias_id`),
16
                  CONSTRAINT `aqbookseller_aliases_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
16
                  CONSTRAINT `aqbookseller_aliases_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
17
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
17
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
18
            });
18
            });
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 432-441 DROP TABLE IF EXISTS `aqbookseller_aliases`; Link Here
432
/*!40101 SET @saved_cs_client     = @@character_set_client */;
432
/*!40101 SET @saved_cs_client     = @@character_set_client */;
433
/*!40101 SET character_set_client = utf8 */;
433
/*!40101 SET character_set_client = utf8 */;
434
CREATE TABLE `aqbookseller_aliases` (
434
CREATE TABLE `aqbookseller_aliases` (
435
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha',
435
  `alias_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha',
436
  `vendor_id` int(11) NOT NULL COMMENT 'link to the vendor',
436
  `vendor_id` int(11) NOT NULL COMMENT 'link to the vendor',
437
  `alias` varchar(255) NOT NULL COMMENT "the alias",
437
  `alias` varchar(255) NOT NULL COMMENT "the alias",
438
  PRIMARY KEY (`id`),
438
  PRIMARY KEY (`alias_id`),
439
  CONSTRAINT `aqbookseller_aliases_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
439
  CONSTRAINT `aqbookseller_aliases_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
440
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
440
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
441
/*!40101 SET character_set_client = @saved_cs_client */;
441
/*!40101 SET character_set_client = @saved_cs_client */;
442
- 

Return to bug 33103