|
Lines 492-497
CREATE TABLE `currency` (
Link Here
|
| 492 |
PRIMARY KEY (`currency`) |
492 |
PRIMARY KEY (`currency`) |
| 493 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
493 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 494 |
|
494 |
|
|
|
495 |
-- |
| 496 |
-- Table structure for table `aqbooksellers` |
| 497 |
-- |
| 498 |
|
| 499 |
DROP TABLE IF EXISTS `aqbooksellers`; |
| 500 |
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions |
| 501 |
`id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha |
| 502 |
`name` LONGTEXT NOT NULL, -- vendor name |
| 503 |
`address1` LONGTEXT, -- first line of vendor physical address |
| 504 |
`address2` LONGTEXT, -- second line of vendor physical address |
| 505 |
`address3` LONGTEXT, -- third line of vendor physical address |
| 506 |
`address4` LONGTEXT, -- fourth line of vendor physical address |
| 507 |
`phone` varchar(30) default NULL, -- vendor phone number |
| 508 |
`accountnumber` LONGTEXT, -- unused in Koha |
| 509 |
`othersupplier` LONGTEXT, -- unused in Koha |
| 510 |
`currency` varchar(10) NOT NULL default '', -- unused in Koha |
| 511 |
`booksellerfax` LONGTEXT, -- vendor fax number |
| 512 |
`notes` LONGTEXT, -- order notes |
| 513 |
`bookselleremail` LONGTEXT, -- vendor email |
| 514 |
`booksellerurl` LONGTEXT, -- unused in Koha |
| 515 |
`postal` LONGTEXT, -- vendor postal address (all lines) |
| 516 |
`url` varchar(255) default NULL, -- vendor web address |
| 517 |
`active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no) |
| 518 |
`listprice` varchar(10) default NULL, -- currency code for list prices |
| 519 |
`invoiceprice` varchar(10) default NULL, -- currency code for invoice prices |
| 520 |
`gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no) |
| 521 |
`listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no) |
| 522 |
`invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no) |
| 523 |
`tax_rate` decimal(6,4) default NULL, -- the tax rate the library is charged |
| 524 |
`discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor |
| 525 |
`fax` varchar(50) default NULL, -- vendor fax number |
| 526 |
deliverytime int(11) default NULL, -- vendor delivery time |
| 527 |
PRIMARY KEY (`id`), |
| 528 |
KEY `listprice` (`listprice`), |
| 529 |
KEY `invoiceprice` (`invoiceprice`), |
| 530 |
KEY `name` (`name`(255)), |
| 531 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 532 |
CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE |
| 533 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 534 |
|
| 495 |
-- |
535 |
-- |
| 496 |
-- Table structure for table `deletedbiblio` |
536 |
-- Table structure for table `deletedbiblio` |
| 497 |
-- |
537 |
-- |
|
Lines 2799-2844
CREATE TABLE `alert` (
Link Here
|
| 2799 |
KEY `type` (`type`,`externalid`) |
2839 |
KEY `type` (`type`,`externalid`) |
| 2800 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2840 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2801 |
|
2841 |
|
| 2802 |
-- |
|
|
| 2803 |
-- Table structure for table `aqbooksellers` |
| 2804 |
-- |
| 2805 |
|
| 2806 |
DROP TABLE IF EXISTS `aqbooksellers`; |
| 2807 |
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions |
| 2808 |
`id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha |
| 2809 |
`name` LONGTEXT NOT NULL, -- vendor name |
| 2810 |
`address1` LONGTEXT, -- first line of vendor physical address |
| 2811 |
`address2` LONGTEXT, -- second line of vendor physical address |
| 2812 |
`address3` LONGTEXT, -- third line of vendor physical address |
| 2813 |
`address4` LONGTEXT, -- fourth line of vendor physical address |
| 2814 |
`phone` varchar(30) default NULL, -- vendor phone number |
| 2815 |
`accountnumber` LONGTEXT, -- unused in Koha |
| 2816 |
`othersupplier` LONGTEXT, -- unused in Koha |
| 2817 |
`currency` varchar(10) NOT NULL default '', -- unused in Koha |
| 2818 |
`booksellerfax` LONGTEXT, -- vendor fax number |
| 2819 |
`notes` LONGTEXT, -- order notes |
| 2820 |
`bookselleremail` LONGTEXT, -- vendor email |
| 2821 |
`booksellerurl` LONGTEXT, -- unused in Koha |
| 2822 |
`postal` LONGTEXT, -- vendor postal address (all lines) |
| 2823 |
`url` varchar(255) default NULL, -- vendor web address |
| 2824 |
`active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no) |
| 2825 |
`listprice` varchar(10) default NULL, -- currency code for list prices |
| 2826 |
`invoiceprice` varchar(10) default NULL, -- currency code for invoice prices |
| 2827 |
`gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no) |
| 2828 |
`listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no) |
| 2829 |
`invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no) |
| 2830 |
`tax_rate` decimal(6,4) default NULL, -- the tax rate the library is charged |
| 2831 |
`discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor |
| 2832 |
`fax` varchar(50) default NULL, -- vendor fax number |
| 2833 |
deliverytime int(11) default NULL, -- vendor delivery time |
| 2834 |
PRIMARY KEY (`id`), |
| 2835 |
KEY `listprice` (`listprice`), |
| 2836 |
KEY `invoiceprice` (`invoiceprice`), |
| 2837 |
KEY `name` (`name`(255)), |
| 2838 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2839 |
CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2840 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2841 |
|
| 2842 |
-- |
2842 |
-- |
| 2843 |
-- Table structure for table `aqbasketgroups` |
2843 |
-- Table structure for table `aqbasketgroups` |
| 2844 |
-- |
2844 |
-- |
| 2845 |
- |
|
|