projects
/
koha.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Extending branch categories : adding search domains. partial commit.
[koha.git]
/
installer
/
kohastructure.sql
diff --git
a/installer/kohastructure.sql
b/installer/kohastructure.sql
index
50d53c5
..
59aa4f7
100644
(file)
--- a/
installer/kohastructure.sql
+++ b/
installer/kohastructure.sql
@@
-489,9
+489,10
@@
CREATE TABLE `borrowers` (
DROP TABLE IF EXISTS `branchcategories`;
CREATE TABLE `branchcategories` (
DROP TABLE IF EXISTS `branchcategories`;
CREATE TABLE `branchcategories` (
- `categorycode`
varchar(4
) NOT NULL default '',
- `categoryname`
mediumtext
,
+ `categorycode`
char(10
) NOT NULL default '',
+ `categoryname`
varchar(32)
,
`codedescription` mediumtext,
`codedescription` mediumtext,
+ `categorytype` varchar(16),
PRIMARY KEY (`categorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
PRIMARY KEY (`categorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@
-522,7
+523,8
@@
CREATE TABLE `branches` (
DROP TABLE IF EXISTS `branchrelations`;
CREATE TABLE `branchrelations` (
`branchcode` char(10) NOT NULL default '',
DROP TABLE IF EXISTS `branchrelations`;
CREATE TABLE `branchrelations` (
`branchcode` char(10) NOT NULL default '',
- `categorycode` varchar(4) NOT NULL default '',
+ `categorycode` char(10) NOT NULL default '',
+ `relation` char(10) default NULL,
PRIMARY KEY (`branchcode`,`categorycode`),
KEY `branchcode` (`branchcode`),
KEY `categorycode` (`categorycode`),
PRIMARY KEY (`branchcode`,`categorycode`),
KEY `branchcode` (`branchcode`),
KEY `categorycode` (`categorycode`),