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

(-)a/installer/data/mysql/kohastructure.sql (-41 / +40 lines)
Lines 489-494 CREATE TABLE `currency` ( Link Here
489
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
489
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
490
490
491
--
491
--
492
-- Table structure for table `aqbooksellers`
493
--
494
495
DROP TABLE IF EXISTS `aqbooksellers`;
496
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions
497
  `id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha
498
  `name` mediumtext NOT NULL, -- vendor name
499
  `address1` mediumtext, -- first line of vendor physical address
500
  `address2` mediumtext, -- second line of vendor physical address
501
  `address3` mediumtext, -- third line of vendor physical address
502
  `address4` mediumtext, -- fourth line of vendor physical address
503
  `phone` varchar(30) default NULL, -- vendor phone number
504
  `accountnumber` mediumtext, -- unused in Koha
505
  `othersupplier` mediumtext,  -- unused in Koha
506
  `currency` varchar(10) NOT NULL default '', -- unused in Koha
507
  `booksellerfax` mediumtext, -- vendor fax number
508
  `notes` mediumtext, -- order notes
509
  `bookselleremail` mediumtext, -- vendor email
510
  `booksellerurl` mediumtext, -- unused in Koha
511
  `postal` mediumtext, -- vendor postal address (all lines)
512
  `url` varchar(255) default NULL, -- vendor web address
513
  `active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no)
514
  `listprice` varchar(10) default NULL, -- currency code for list prices
515
  `invoiceprice` varchar(10) default NULL, -- currency code for invoice prices
516
  `gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no)
517
  `listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no)
518
  `invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no)
519
  `tax_rate` decimal(6,4) default NULL, -- the tax rate the library is charged
520
  `discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor
521
  `fax` varchar(50) default NULL, -- vendor fax number
522
  deliverytime int(11) default NULL, -- vendor delivery time
523
  PRIMARY KEY  (`id`),
524
  KEY `listprice` (`listprice`),
525
  KEY `invoiceprice` (`invoiceprice`),
526
  KEY `name` (`name`(255)),
527
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
528
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
529
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
530
531
--
492
-- Table structure for table `deletedbiblio`
532
-- Table structure for table `deletedbiblio`
493
--
533
--
494
534
Lines 2766-2811 CREATE TABLE `alert` ( Link Here
2766
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2806
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2767
2807
2768
--
2808
--
2769
-- Table structure for table `aqbooksellers`
2770
--
2771
2772
DROP TABLE IF EXISTS `aqbooksellers`;
2773
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions
2774
  `id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha
2775
  `name` mediumtext NOT NULL, -- vendor name
2776
  `address1` mediumtext, -- first line of vendor physical address
2777
  `address2` mediumtext, -- second line of vendor physical address
2778
  `address3` mediumtext, -- third line of vendor physical address
2779
  `address4` mediumtext, -- fourth line of vendor physical address
2780
  `phone` varchar(30) default NULL, -- vendor phone number
2781
  `accountnumber` mediumtext, -- unused in Koha
2782
  `othersupplier` mediumtext,  -- unused in Koha
2783
  `currency` varchar(10) NOT NULL default '', -- unused in Koha
2784
  `booksellerfax` mediumtext, -- vendor fax number
2785
  `notes` mediumtext, -- order notes
2786
  `bookselleremail` mediumtext, -- vendor email
2787
  `booksellerurl` mediumtext, -- unused in Koha
2788
  `postal` mediumtext, -- vendor postal address (all lines)
2789
  `url` varchar(255) default NULL, -- vendor web address
2790
  `active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no)
2791
  `listprice` varchar(10) default NULL, -- currency code for list prices
2792
  `invoiceprice` varchar(10) default NULL, -- currency code for invoice prices
2793
  `gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no)
2794
  `listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no)
2795
  `invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no)
2796
  `tax_rate` decimal(6,4) default NULL, -- the tax rate the library is charged
2797
  `discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor
2798
  `fax` varchar(50) default NULL, -- vendor fax number
2799
  deliverytime int(11) default NULL, -- vendor delivery time
2800
  PRIMARY KEY  (`id`),
2801
  KEY `listprice` (`listprice`),
2802
  KEY `invoiceprice` (`invoiceprice`),
2803
  KEY `name` (`name`(255)),
2804
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2805
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2806
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2807
2808
--
2809
-- Table structure for table `aqbasketgroups`
2809
-- Table structure for table `aqbasketgroups`
2810
--
2810
--
2811
2811
2812
- 

Return to bug 18745