|
Lines 2783-2795
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
Link Here
|
| 2783 |
`address3` LONGTEXT, -- third line of vendor physical address |
2783 |
`address3` LONGTEXT, -- third line of vendor physical address |
| 2784 |
`address4` LONGTEXT, -- fourth line of vendor physical address |
2784 |
`address4` LONGTEXT, -- fourth line of vendor physical address |
| 2785 |
`phone` varchar(30) default NULL, -- vendor phone number |
2785 |
`phone` varchar(30) default NULL, -- vendor phone number |
| 2786 |
`accountnumber` LONGTEXT, -- unused in Koha |
2786 |
`accountnumber` LONGTEXT, -- vendor account number |
| 2787 |
`othersupplier` LONGTEXT, -- unused in Koha |
|
|
| 2788 |
`currency` varchar(10) NOT NULL default '', -- unused in Koha |
| 2789 |
`booksellerfax` LONGTEXT, -- vendor fax number |
| 2790 |
`notes` LONGTEXT, -- order notes |
2787 |
`notes` LONGTEXT, -- order notes |
| 2791 |
`bookselleremail` LONGTEXT, -- vendor email |
|
|
| 2792 |
`booksellerurl` LONGTEXT, -- unused in Koha |
| 2793 |
`postal` LONGTEXT, -- vendor postal address (all lines) |
2788 |
`postal` LONGTEXT, -- vendor postal address (all lines) |
| 2794 |
`url` varchar(255) default NULL, -- vendor web address |
2789 |
`url` varchar(255) default NULL, -- vendor web address |
| 2795 |
`active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no) |
2790 |
`active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no) |
| 2796 |
- |
|
|