http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7621
--- Comment #29 from delaye <stephane.del...@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 45000010005000000100021000050900009000261000041000352000073000762100024001492150034001732250023002071010008002306150012002386760007002503330011002577000026002687010028002941979 a2869672020d6.10 a1979 a20020311 frey50 1 aLe vol des urubus : La fièvre de l'ordtome 2fEric GutierrezbLIVR 1cVents d'ouestd1993 1a46 p.cBande dessinéed30 cm1 aGrand large.vN°2 afre aFiction 1aBD aFSK 16 192508aGutierrezbEric 192509aMigeatbFranç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. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/