Lines 2778-2787
DROP TABLE IF EXISTS `aqbooksellers`;
Link Here
|
2778 |
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions |
2778 |
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions |
2779 |
`id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha |
2779 |
`id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha |
2780 |
`name` LONGTEXT NOT NULL, -- vendor name |
2780 |
`name` LONGTEXT NOT NULL, -- vendor name |
2781 |
`address1` LONGTEXT, -- first line of vendor physical address |
2781 |
`address` LONGTEXT, -- vendor physical address |
2782 |
`address2` LONGTEXT, -- second line of vendor physical address |
|
|
2783 |
`address3` LONGTEXT, -- third line of vendor physical address |
2784 |
`address4` LONGTEXT, -- fourth line of vendor physical address |
2785 |
`phone` varchar(30) default NULL, -- vendor phone number |
2782 |
`phone` varchar(30) default NULL, -- vendor phone number |
2786 |
`accountnumber` LONGTEXT, -- vendor account number |
2783 |
`accountnumber` LONGTEXT, -- vendor account number |
2787 |
`notes` LONGTEXT, -- order notes |
2784 |
`notes` LONGTEXT, -- order notes |
2788 |
- |
|
|