|
Lines 2764-2776
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
Link Here
|
| 2764 |
`address3` LONGTEXT, -- third line of vendor physical address |
2764 |
`address3` LONGTEXT, -- third line of vendor physical address |
| 2765 |
`address4` LONGTEXT, -- fourth line of vendor physical address |
2765 |
`address4` LONGTEXT, -- fourth line of vendor physical address |
| 2766 |
`phone` varchar(30) default NULL, -- vendor phone number |
2766 |
`phone` varchar(30) default NULL, -- vendor phone number |
| 2767 |
`accountnumber` LONGTEXT, -- unused in Koha |
2767 |
`accountnumber` LONGTEXT, -- vendor account number |
| 2768 |
`othersupplier` LONGTEXT, -- unused in Koha |
|
|
| 2769 |
`currency` varchar(10) NOT NULL default '', -- unused in Koha |
| 2770 |
`booksellerfax` LONGTEXT, -- vendor fax number |
| 2771 |
`notes` LONGTEXT, -- order notes |
2768 |
`notes` LONGTEXT, -- order notes |
| 2772 |
`bookselleremail` LONGTEXT, -- vendor email |
|
|
| 2773 |
`booksellerurl` LONGTEXT, -- unused in Koha |
| 2774 |
`postal` LONGTEXT, -- vendor postal address (all lines) |
2769 |
`postal` LONGTEXT, -- vendor postal address (all lines) |
| 2775 |
`url` varchar(255) default NULL, -- vendor web address |
2770 |
`url` varchar(255) default NULL, -- vendor web address |
| 2776 |
`active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no) |
2771 |
`active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no) |
| 2777 |
- |
|
|