Lines 457-462
CREATE TABLE `currency` (
Link Here
|
457 |
PRIMARY KEY (`currency`) |
457 |
PRIMARY KEY (`currency`) |
458 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
458 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
459 |
|
459 |
|
|
|
460 |
-- |
461 |
-- Table structure for table `aqbooksellers` |
462 |
-- |
463 |
|
464 |
DROP TABLE IF EXISTS `aqbooksellers`; |
465 |
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions |
466 |
`id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha |
467 |
`name` LONGTEXT NOT NULL, -- vendor name |
468 |
`address1` LONGTEXT, -- first line of vendor physical address |
469 |
`address2` LONGTEXT, -- second line of vendor physical address |
470 |
`address3` LONGTEXT, -- third line of vendor physical address |
471 |
`address4` LONGTEXT, -- fourth line of vendor physical address |
472 |
`phone` varchar(30) default NULL, -- vendor phone number |
473 |
`accountnumber` LONGTEXT, -- unused in Koha |
474 |
`othersupplier` LONGTEXT, -- unused in Koha |
475 |
`currency` varchar(10) NOT NULL default '', -- unused in Koha |
476 |
`booksellerfax` LONGTEXT, -- vendor fax number |
477 |
`notes` LONGTEXT, -- order notes |
478 |
`bookselleremail` LONGTEXT, -- vendor email |
479 |
`booksellerurl` LONGTEXT, -- unused in Koha |
480 |
`postal` LONGTEXT, -- vendor postal address (all lines) |
481 |
`url` varchar(255) default NULL, -- vendor web address |
482 |
`active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no) |
483 |
`listprice` varchar(10) default NULL, -- currency code for list prices |
484 |
`invoiceprice` varchar(10) default NULL, -- currency code for invoice prices |
485 |
`gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no) |
486 |
`listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no) |
487 |
`invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no) |
488 |
`tax_rate` decimal(6,4) default NULL, -- the tax rate the library is charged |
489 |
`discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor |
490 |
`fax` varchar(50) default NULL, -- vendor fax number |
491 |
deliverytime int(11) default NULL, -- vendor delivery time |
492 |
PRIMARY KEY (`id`), |
493 |
KEY `listprice` (`listprice`), |
494 |
KEY `invoiceprice` (`invoiceprice`), |
495 |
KEY `name` (`name`(255)), |
496 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
497 |
CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE |
498 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
499 |
|
460 |
-- |
500 |
-- |
461 |
-- Table structure for table `deletedbiblio` |
501 |
-- Table structure for table `deletedbiblio` |
462 |
-- |
502 |
-- |
Lines 2764-2809
CREATE TABLE `alert` (
Link Here
|
2764 |
KEY `type` (`type`,`externalid`) |
2804 |
KEY `type` (`type`,`externalid`) |
2765 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2805 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2766 |
|
2806 |
|
2767 |
-- |
|
|
2768 |
-- Table structure for table `aqbooksellers` |
2769 |
-- |
2770 |
|
2771 |
DROP TABLE IF EXISTS `aqbooksellers`; |
2772 |
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquisitions |
2773 |
`id` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha |
2774 |
`name` LONGTEXT NOT NULL, -- vendor name |
2775 |
`address1` LONGTEXT, -- first line of vendor physical address |
2776 |
`address2` LONGTEXT, -- second line of vendor physical address |
2777 |
`address3` LONGTEXT, -- third line of vendor physical address |
2778 |
`address4` LONGTEXT, -- fourth line of vendor physical address |
2779 |
`phone` varchar(30) default NULL, -- vendor phone number |
2780 |
`accountnumber` LONGTEXT, -- unused in Koha |
2781 |
`othersupplier` LONGTEXT, -- unused in Koha |
2782 |
`currency` varchar(10) NOT NULL default '', -- unused in Koha |
2783 |
`booksellerfax` LONGTEXT, -- vendor fax number |
2784 |
`notes` LONGTEXT, -- order notes |
2785 |
`bookselleremail` LONGTEXT, -- vendor email |
2786 |
`booksellerurl` LONGTEXT, -- unused in Koha |
2787 |
`postal` LONGTEXT, -- vendor postal address (all lines) |
2788 |
`url` varchar(255) default NULL, -- vendor web address |
2789 |
`active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no) |
2790 |
`listprice` varchar(10) default NULL, -- currency code for list prices |
2791 |
`invoiceprice` varchar(10) default NULL, -- currency code for invoice prices |
2792 |
`gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no) |
2793 |
`listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no) |
2794 |
`invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no) |
2795 |
`tax_rate` decimal(6,4) default NULL, -- the tax rate the library is charged |
2796 |
`discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor |
2797 |
`fax` varchar(50) default NULL, -- vendor fax number |
2798 |
deliverytime int(11) default NULL, -- vendor delivery time |
2799 |
PRIMARY KEY (`id`), |
2800 |
KEY `listprice` (`listprice`), |
2801 |
KEY `invoiceprice` (`invoiceprice`), |
2802 |
KEY `name` (`name`(255)), |
2803 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
2804 |
CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE |
2805 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2806 |
|
2807 |
-- |
2807 |
-- |
2808 |
-- Table structure for table `aqbasketgroups` |
2808 |
-- Table structure for table `aqbasketgroups` |
2809 |
-- |
2809 |
-- |
2810 |
- |
|
|