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

(-)a/installer/data/mysql/kohastructure.sql (-41 / +40 lines)
Lines 457-462 CREATE TABLE `currency` ( Link Here
457
  PRIMARY KEY  (`currency`)
457
  PRIMARY KEY  (`currency`)
458
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
458
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
459
459
460
--
461
-- Table structure for table `aqbooksellers`
462
--
463
464
DROP TABLE IF EXISTS `aqbooksellers`;
465
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions
466
  `id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha
467
  `name` LONGTEXT NOT NULL, -- vendor name
468
  `address1` LONGTEXT, -- first line of vendor physical address
469
  `address2` LONGTEXT, -- second line of vendor physical address
470
  `address3` LONGTEXT, -- third line of vendor physical address
471
  `address4` LONGTEXT, -- fourth line of vendor physical address
472
  `phone` varchar(30) default NULL, -- vendor phone number
473
  `accountnumber` LONGTEXT, -- unused in Koha
474
  `othersupplier` LONGTEXT,  -- unused in Koha
475
  `currency` varchar(10) NOT NULL default '', -- unused in Koha
476
  `booksellerfax` LONGTEXT, -- vendor fax number
477
  `notes` LONGTEXT, -- order notes
478
  `bookselleremail` LONGTEXT, -- vendor email
479
  `booksellerurl` LONGTEXT, -- unused in Koha
480
  `postal` LONGTEXT, -- vendor postal address (all lines)
481
  `url` varchar(255) default NULL, -- vendor web address
482
  `active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no)
483
  `listprice` varchar(10) default NULL, -- currency code for list prices
484
  `invoiceprice` varchar(10) default NULL, -- currency code for invoice prices
485
  `gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no)
486
  `listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no)
487
  `invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no)
488
  `tax_rate` decimal(6,4) default NULL, -- the tax rate the library is charged
489
  `discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor
490
  `fax` varchar(50) default NULL, -- vendor fax number
491
  deliverytime int(11) default NULL, -- vendor delivery time
492
  PRIMARY KEY  (`id`),
493
  KEY `listprice` (`listprice`),
494
  KEY `invoiceprice` (`invoiceprice`),
495
  KEY `name` (`name`(255)),
496
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
497
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
498
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
499
460
--
500
--
461
-- Table structure for table `deletedbiblio`
501
-- Table structure for table `deletedbiblio`
462
--
502
--
Lines 2764-2809 CREATE TABLE `alert` ( Link Here
2764
  KEY `type` (`type`,`externalid`)
2804
  KEY `type` (`type`,`externalid`)
2765
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2805
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2766
2806
2767
--
2768
-- Table structure for table `aqbooksellers`
2769
--
2770
2771
DROP TABLE IF EXISTS `aqbooksellers`;
2772
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions
2773
  `id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha
2774
  `name` LONGTEXT NOT NULL, -- vendor name
2775
  `address1` LONGTEXT, -- first line of vendor physical address
2776
  `address2` LONGTEXT, -- second line of vendor physical address
2777
  `address3` LONGTEXT, -- third line of vendor physical address
2778
  `address4` LONGTEXT, -- fourth line of vendor physical address
2779
  `phone` varchar(30) default NULL, -- vendor phone number
2780
  `accountnumber` LONGTEXT, -- unused in Koha
2781
  `othersupplier` LONGTEXT,  -- unused in Koha
2782
  `currency` varchar(10) NOT NULL default '', -- unused in Koha
2783
  `booksellerfax` LONGTEXT, -- vendor fax number
2784
  `notes` LONGTEXT, -- order notes
2785
  `bookselleremail` LONGTEXT, -- vendor email
2786
  `booksellerurl` LONGTEXT, -- unused in Koha
2787
  `postal` LONGTEXT, -- vendor postal address (all lines)
2788
  `url` varchar(255) default NULL, -- vendor web address
2789
  `active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no)
2790
  `listprice` varchar(10) default NULL, -- currency code for list prices
2791
  `invoiceprice` varchar(10) default NULL, -- currency code for invoice prices
2792
  `gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no)
2793
  `listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no)
2794
  `invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no)
2795
  `tax_rate` decimal(6,4) default NULL, -- the tax rate the library is charged
2796
  `discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor
2797
  `fax` varchar(50) default NULL, -- vendor fax number
2798
  deliverytime int(11) default NULL, -- vendor delivery time
2799
  PRIMARY KEY  (`id`),
2800
  KEY `listprice` (`listprice`),
2801
  KEY `invoiceprice` (`invoiceprice`),
2802
  KEY `name` (`name`(255)),
2803
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2804
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2805
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2806
2807
--
2807
--
2808
-- Table structure for table `aqbasketgroups`
2808
-- Table structure for table `aqbasketgroups`
2809
--
2809
--
2810
- 

Return to bug 18745