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

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

Return to bug 6716