[Koha-bugs] [Bug 7621] Circulation: Match age restriction of title with borrower's age without using categories
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Jun 27 16:52:26 CEST 2012
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7621
--- Comment #29 from delaye <stephane.delaye at biblibre.com> ---
mysql> desc biblioitems;
+-----------------------+--------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra
|
+-----------------------+--------------+------+-----+-------------------+-----------------------------+
| biblioitemnumber | int(11) | NO | PRI | NULL |
auto_increment |
| biblionumber | int(11) | NO | MUL | 0 |
|
| volume | mediumtext | YES | | NULL |
|
| number | mediumtext | YES | | NULL |
|
| itemtype | varchar(10) | YES | | NULL |
|
| isbn | varchar(30) | YES | MUL | NULL |
|
| issn | varchar(9) | YES | MUL | NULL |
|
| ean | varchar(13) | YES | MUL | NULL |
|
| publicationyear | text | YES | | NULL |
|
| publishercode | varchar(255) | YES | MUL | NULL |
|
| volumedate | date | YES | | NULL |
|
| volumedesc | text | YES | | NULL |
|
| collectiontitle | mediumtext | YES | | NULL |
|
| collectionissn | text | YES | | NULL |
|
| collectionvolume | mediumtext | YES | | NULL |
|
| editionstatement | text | YES | | NULL |
|
| editionresponsibility | text | YES | | NULL |
|
| timestamp | timestamp | NO | | CURRENT_TIMESTAMP | on
update CURRENT_TIMESTAMP |
| illus | varchar(255) | YES | | NULL |
|
| pages | varchar(255) | YES | | NULL |
|
| notes | mediumtext | YES | | NULL |
|
| size | varchar(255) | YES | | NULL |
|
| place | varchar(255) | YES | | NULL |
|
| lccn | varchar(25) | YES | | NULL |
|
| marc | longblob | YES | | NULL |
|
| url | varchar(255) | YES | | NULL |
|
| cn_source | varchar(10) | YES | | NULL |
|
| cn_class | varchar(30) | YES | | NULL |
|
| cn_item | varchar(10) | YES | | NULL |
|
| cn_suffix | varchar(10) | YES | | NULL |
|
| cn_sort | varchar(30) | YES | | NULL |
|
| agerestriction | varchar(250) | YES | | NULL |
|
| totalissues | int(10) | YES | | NULL |
|
| marcxml | longtext | NO | | NULL |
|
+-----------------------+--------------+------+-----+-------------------+----------------
INSERT INTO systempreferences (variable,value,explanation,options,type)
VALUES('AgeRestrictionMarker','','Markers for age restriction indication, e.g.
FSK|PEGI|Age|. See:
http://wiki.koha-community.org/wiki/Age_restriction',NULL,'free');
INSERT INTO systempreferences (variable,value,explanation,options,type)
VALUES('AgeRestrictionOverride',0,'Allow staff to check out an item with age
restriction.',NULL,'YesNo');
select * from biblioitems where biblionumber=1979\G
*************************** 1. row ***************************
biblioitemnumber: 1979
biblionumber: 1979
volume: NULL
number: NULL
itemtype: LIVR
isbn: 2869672020
issn: NULL
ean: NULL
publicationyear: 1993
publishercode: Vents d'ouest
volumedate: NULL
volumedesc: NULL
collectiontitle: Grand large.
collectionissn: NULL
collectionvolume: NULL
editionstatement: NULL
editionresponsibility: NULL
timestamp: 2012-06-27 16:41:24
illus: NULL
pages: 46 p.
notes: NULL
size: 30 cm
place: NULL
lccn: NULL
marc: 00516 2200193
4500001000500000010002100005090000900026100004100035200007300076210002400149215003400173225002300207101000800230615001200238676000700250333001100257700002600268701002800294
1979
a2869672020 d6.10
a1979
a20020311 frey50
1 aLe
vol des urubus : La fièvre de l'or dtome 2 fEric Gutierrez bLIVR
1 cVents
d'ouest d1993
1 a46 p. cBande dessinée d30 cm
1 aGrand large. vN°2
afre
aFiction
1 aBD
aFSK 16
1 92508 aGutierrez bEric
1 92509 aMigeat bFrançois
url: NULL
cn_source: NULL
cn_class: NULL
cn_item: NULL
cn_suffix: NULL
cn_sort:
agerestriction: FSK 16
totalissues: NULL
BUT the user who have 14 years can chekout the biblionumber 1979
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list