[Koha] itemtypes not in koha DB

[MJ Ray]

Matthew Stockfleth asked:
> itemtypes table was not put into the koha db, what are the fields and
> types required?

I found this answer:

  "CREATE TABLE `itemtypes` (
    `itemtype` varchar(10) NOT NULL default '',
    `description` mediumtext,
    `renewalsallowed` smallint(6) default NULL,
    `rentalcharge` double(16,4) default NULL,
    `notforloan` smallint(6) default NULL,
    `imageurl` varchar(200) default NULL,
    `summary` text,
    PRIMARY KEY  (`itemtype`),
    UNIQUE KEY `itemtype` (`itemtype`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"

at http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob_plain;f=installer/kohastructure.sql;hb=feea56bfd8d5b62c79aa40b176980b37e256173a

Hope that helps,
-- 
MJ Ray http://mjr.towers.org.uk/email.html tel:+44-844-4437-237 -
Webmaster-developer, statistician, sysadmin, online shop builder,
consumer and workers co-operative member http://www.ttllp.co.uk/ -
Writing on koha, debian, sat TV, Kewstoke http://mjr.towers.org.uk/