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

(-)a/installer/data/mysql/kohastructure.sql (-34 / +33 lines)
Lines 2461-2499 CREATE TABLE `aqbasket` ( Link Here
2461
--
2461
--
2462
2462
2463
DROP TABLE IF EXISTS `aqbooksellers`;
2463
DROP TABLE IF EXISTS `aqbooksellers`;
2464
CREATE TABLE `aqbooksellers` (
2464
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions
2465
  `id` int(11) NOT NULL auto_increment,
2465
  `id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha
2466
  `name` mediumtext NOT NULL,
2466
  `name` mediumtext NOT NULL, -- vendor name
2467
  `address1` mediumtext,
2467
  `address1` mediumtext, -- first line of vendor physical address
2468
  `address2` mediumtext,
2468
  `address2` mediumtext, -- second line of vendor physical address
2469
  `address3` mediumtext,
2469
  `address3` mediumtext, -- third line of vendor physical address
2470
  `address4` mediumtext,
2470
  `address4` mediumtext, -- fourth line of vendor physical address
2471
  `phone` varchar(30) default NULL,
2471
  `phone` varchar(30) default NULL, -- vendor phone number
2472
  `accountnumber` mediumtext,
2472
  `accountnumber` mediumtext, -- unused in Koha
2473
  `othersupplier` mediumtext,
2473
  `othersupplier` mediumtext,  -- unused in Koha
2474
  `currency` varchar(3) NOT NULL default '',
2474
  `currency` varchar(3) NOT NULL default '', -- unused in Koha
2475
  `booksellerfax` mediumtext,
2475
  `booksellerfax` mediumtext, -- vendor fax number
2476
  `notes` mediumtext,
2476
  `notes` mediumtext, -- order notes
2477
  `bookselleremail` mediumtext,
2477
  `bookselleremail` mediumtext, -- vendor email
2478
  `booksellerurl` mediumtext,
2478
  `booksellerurl` mediumtext, -- unused in Koha
2479
  `contact` varchar(100) default NULL,
2479
  `contact` varchar(100) default NULL, -- name of contact at vendor
2480
  `postal` mediumtext,
2480
  `postal` mediumtext, -- vendor postal address (all lines)
2481
  `url` varchar(255) default NULL,
2481
  `url` varchar(255) default NULL, -- vendor web address
2482
  `contpos` varchar(100) default NULL,
2482
  `contpos` varchar(100) default NULL, -- contact person's position
2483
  `contphone` varchar(100) default NULL,
2483
  `contphone` varchar(100) default NULL, -- contact's phone number
2484
  `contfax` varchar(100) default NULL,
2484
  `contfax` varchar(100) default NULL,  -- contact's fax number
2485
  `contaltphone` varchar(100) default NULL,
2485
  `contaltphone` varchar(100) default NULL, -- contact's alternate phone number
2486
  `contemail` varchar(100) default NULL,
2486
  `contemail` varchar(100) default NULL, -- contact's email address
2487
  `contnotes` mediumtext,
2487
  `contnotes` mediumtext, -- notes related to the contact
2488
  `active` tinyint(4) default NULL,
2488
  `active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no)
2489
  `listprice` varchar(10) default NULL,
2489
  `listprice` varchar(10) default NULL, -- currency code for list prices
2490
  `invoiceprice` varchar(10) default NULL,
2490
  `invoiceprice` varchar(10) default NULL, -- currency code for invoice prices
2491
  `gstreg` tinyint(4) default NULL,
2491
  `gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no)
2492
  `listincgst` tinyint(4) default NULL,
2492
  `listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no)
2493
  `invoiceincgst` tinyint(4) default NULL,
2493
  `invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no)
2494
  `gstrate` decimal(6,4) default NULL,
2494
  `gstrate` decimal(6,4) default NULL, -- the tax rate the library is charged
2495
  `discount` float(6,4) default NULL,
2495
  `discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor
2496
  `fax` varchar(50) default NULL,
2496
  `fax` varchar(50) default NULL, -- vendor fax number
2497
  PRIMARY KEY  (`id`),
2497
  PRIMARY KEY  (`id`),
2498
  KEY `listprice` (`listprice`),
2498
  KEY `listprice` (`listprice`),
2499
  KEY `invoiceprice` (`invoiceprice`),
2499
  KEY `invoiceprice` (`invoiceprice`),
2500
- 

Return to bug 6716