Lines 2759-2768
DROP TABLE IF EXISTS `aqbooksellers`;
Link Here
|
2759 |
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions |
2759 |
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions |
2760 |
`id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha |
2760 |
`id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha |
2761 |
`name` LONGTEXT NOT NULL, -- vendor name |
2761 |
`name` LONGTEXT NOT NULL, -- vendor name |
2762 |
`address1` LONGTEXT, -- first line of vendor physical address |
2762 |
`address` LONGTEXT, -- vendor physical address |
2763 |
`address2` LONGTEXT, -- second line of vendor physical address |
|
|
2764 |
`address3` LONGTEXT, -- third line of vendor physical address |
2765 |
`address4` LONGTEXT, -- fourth line of vendor physical address |
2766 |
`phone` varchar(30) default NULL, -- vendor phone number |
2763 |
`phone` varchar(30) default NULL, -- vendor phone number |
2767 |
`accountnumber` LONGTEXT, -- vendor account number |
2764 |
`accountnumber` LONGTEXT, -- vendor account number |
2768 |
`notes` LONGTEXT, -- order notes |
2765 |
`notes` LONGTEXT, -- order notes |
2769 |
- |
|
|