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

(-)a/installer/data/mysql/kohastructure.sql (-41 / +40 lines)
Lines 492-497 CREATE TABLE `currency` ( Link Here
492
  PRIMARY KEY  (`currency`)
492
  PRIMARY KEY  (`currency`)
493
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
493
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
494
494
495
--
496
-- Table structure for table `aqbooksellers`
497
--
498
499
DROP TABLE IF EXISTS `aqbooksellers`;
500
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions
501
  `id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha
502
  `name` LONGTEXT NOT NULL, -- vendor name
503
  `address1` LONGTEXT, -- first line of vendor physical address
504
  `address2` LONGTEXT, -- second line of vendor physical address
505
  `address3` LONGTEXT, -- third line of vendor physical address
506
  `address4` LONGTEXT, -- fourth line of vendor physical address
507
  `phone` varchar(30) default NULL, -- vendor phone number
508
  `accountnumber` LONGTEXT, -- unused in Koha
509
  `othersupplier` LONGTEXT,  -- unused in Koha
510
  `currency` varchar(10) NOT NULL default '', -- unused in Koha
511
  `booksellerfax` LONGTEXT, -- vendor fax number
512
  `notes` LONGTEXT, -- order notes
513
  `bookselleremail` LONGTEXT, -- vendor email
514
  `booksellerurl` LONGTEXT, -- unused in Koha
515
  `postal` LONGTEXT, -- vendor postal address (all lines)
516
  `url` varchar(255) default NULL, -- vendor web address
517
  `active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no)
518
  `listprice` varchar(10) default NULL, -- currency code for list prices
519
  `invoiceprice` varchar(10) default NULL, -- currency code for invoice prices
520
  `gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no)
521
  `listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no)
522
  `invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no)
523
  `tax_rate` decimal(6,4) default NULL, -- the tax rate the library is charged
524
  `discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor
525
  `fax` varchar(50) default NULL, -- vendor fax number
526
  deliverytime int(11) default NULL, -- vendor delivery time
527
  PRIMARY KEY  (`id`),
528
  KEY `listprice` (`listprice`),
529
  KEY `invoiceprice` (`invoiceprice`),
530
  KEY `name` (`name`(255)),
531
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
532
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
533
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
534
495
--
535
--
496
-- Table structure for table `deletedbiblio`
536
-- Table structure for table `deletedbiblio`
497
--
537
--
Lines 2799-2844 CREATE TABLE `alert` ( Link Here
2799
  KEY `type` (`type`,`externalid`)
2839
  KEY `type` (`type`,`externalid`)
2800
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2840
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2801
2841
2802
--
2803
-- Table structure for table `aqbooksellers`
2804
--
2805
2806
DROP TABLE IF EXISTS `aqbooksellers`;
2807
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions
2808
  `id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha
2809
  `name` LONGTEXT NOT NULL, -- vendor name
2810
  `address1` LONGTEXT, -- first line of vendor physical address
2811
  `address2` LONGTEXT, -- second line of vendor physical address
2812
  `address3` LONGTEXT, -- third line of vendor physical address
2813
  `address4` LONGTEXT, -- fourth line of vendor physical address
2814
  `phone` varchar(30) default NULL, -- vendor phone number
2815
  `accountnumber` LONGTEXT, -- unused in Koha
2816
  `othersupplier` LONGTEXT,  -- unused in Koha
2817
  `currency` varchar(10) NOT NULL default '', -- unused in Koha
2818
  `booksellerfax` LONGTEXT, -- vendor fax number
2819
  `notes` LONGTEXT, -- order notes
2820
  `bookselleremail` LONGTEXT, -- vendor email
2821
  `booksellerurl` LONGTEXT, -- unused in Koha
2822
  `postal` LONGTEXT, -- vendor postal address (all lines)
2823
  `url` varchar(255) default NULL, -- vendor web address
2824
  `active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no)
2825
  `listprice` varchar(10) default NULL, -- currency code for list prices
2826
  `invoiceprice` varchar(10) default NULL, -- currency code for invoice prices
2827
  `gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no)
2828
  `listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no)
2829
  `invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no)
2830
  `tax_rate` decimal(6,4) default NULL, -- the tax rate the library is charged
2831
  `discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor
2832
  `fax` varchar(50) default NULL, -- vendor fax number
2833
  deliverytime int(11) default NULL, -- vendor delivery time
2834
  PRIMARY KEY  (`id`),
2835
  KEY `listprice` (`listprice`),
2836
  KEY `invoiceprice` (`invoiceprice`),
2837
  KEY `name` (`name`(255)),
2838
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2839
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2840
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2841
2842
--
2842
--
2843
-- Table structure for table `aqbasketgroups`
2843
-- Table structure for table `aqbasketgroups`
2844
--
2844
--
2845
- 

Return to bug 18745