Lines 2-8
Link Here
|
2 |
-- |
2 |
-- |
3 |
-- Host: localhost Database: koha30test |
3 |
-- Host: localhost Database: koha30test |
4 |
-- ------------------------------------------------------ |
4 |
-- ------------------------------------------------------ |
5 |
-- Server version 4.1.22 |
5 |
-- Server version 4.1.22 |
6 |
|
6 |
|
7 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
7 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
8 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
8 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
Lines 2111-2120
CREATE TABLE `suggestions` ( -- purchase suggestions
Link Here
|
2111 |
branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table |
2111 |
branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table |
2112 |
collectiontitle text default NULL, -- collection name for the suggested item |
2112 |
collectiontitle text default NULL, -- collection name for the suggested item |
2113 |
itemtype VARCHAR(30) default NULL, -- suggested item type |
2113 |
itemtype VARCHAR(30) default NULL, -- suggested item type |
2114 |
quantity SMALLINT(6) default NULL, -- suggested quantity to be purchased |
2114 |
quantity SMALLINT(6) default NULL, -- suggested quantity to be purchased |
2115 |
currency VARCHAR(3) default NULL, -- suggested currency for the suggested price |
2115 |
currency VARCHAR(3) default NULL, -- suggested currency for the suggested price |
2116 |
price DECIMAL(28,6) default NULL, -- suggested price |
2116 |
price DECIMAL(28,6) default NULL, -- suggested price |
2117 |
total DECIMAL(28,6) default NULL, -- suggested total cost (price*quantity updated for currency) |
2117 |
total DECIMAL(28,6) default NULL, -- suggested total cost (price*quantity updated for currency) |
2118 |
PRIMARY KEY (`suggestionid`), |
2118 |
PRIMARY KEY (`suggestionid`), |
2119 |
KEY `suggestedby` (`suggestedby`), |
2119 |
KEY `suggestedby` (`suggestedby`), |
2120 |
KEY `managedby` (`managedby`) |
2120 |
KEY `managedby` (`managedby`) |
Lines 2412-2423
CREATE TABLE `permissions` (
Link Here
|
2412 |
|
2412 |
|
2413 |
DROP TABLE IF EXISTS `serialitems`; |
2413 |
DROP TABLE IF EXISTS `serialitems`; |
2414 |
CREATE TABLE `serialitems` ( |
2414 |
CREATE TABLE `serialitems` ( |
2415 |
`itemnumber` int(11) NOT NULL, |
2415 |
`itemnumber` int(11) NOT NULL, |
2416 |
`serialid` int(11) NOT NULL, |
2416 |
`serialid` int(11) NOT NULL, |
2417 |
UNIQUE KEY `serialitemsidx` (`itemnumber`), |
2417 |
UNIQUE KEY `serialitemsidx` (`itemnumber`), |
2418 |
KEY `serialitems_sfk_1` (`serialid`), |
2418 |
KEY `serialitems_sfk_1` (`serialid`), |
2419 |
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, |
2419 |
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, |
2420 |
CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2420 |
CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2421 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2421 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2422 |
|
2422 |
|
2423 |
-- |
2423 |
-- |
Lines 3286-3288
ALTER TABLE `patron_list_patrons`
Link Here
|
3286 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
3286 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
3287 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
3287 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
3288 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
3288 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
|
|
3289 |
|