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 |
- |
|
|