Lines 904-912
CREATE TABLE `itemtypes` ( -- defines the item types
Link Here
|
904 |
description LONGTEXT, -- a plain text explanation of the item type |
904 |
description LONGTEXT, -- a plain text explanation of the item type |
905 |
rentalcharge decimal(28,6) default NULL, -- the amount charged when this item is checked out/issued |
905 |
rentalcharge decimal(28,6) default NULL, -- the amount charged when this item is checked out/issued |
906 |
rentalcharge_daily decimal(28,6) default NULL, -- the amount charged for each day between checkout date and due date |
906 |
rentalcharge_daily decimal(28,6) default NULL, -- the amount charged for each day between checkout date and due date |
907 |
rentalcharge_daily_calendar tinyint(1) NOT NULL DEFAULT 1, -- controls if the daily retnal fee is calculated directly or using finesCalendar |
907 |
rentalcharge_daily_calendar tinyint(1) NOT NULL DEFAULT 1, -- controls if the daily rental fee is calculated directly or using finesCalendar |
908 |
rentalcharge_hourly decimal(28,6) default NULL, -- the amount charged for each hour between checkout date and due date |
908 |
rentalcharge_hourly decimal(28,6) default NULL, -- the amount charged for each hour between checkout date and due date |
909 |
rentalcharge_hourly_calendar tinyint(1) NOT NULL DEFAULT 1, -- controls if the hourly retnal fee is calculated directly or using finesCalendar |
909 |
rentalcharge_hourly_calendar tinyint(1) NOT NULL DEFAULT 1, -- controls if the hourly rental fee is calculated directly or using finesCalendar |
910 |
defaultreplacecost decimal(28,6) default NULL, -- default replacement cost |
910 |
defaultreplacecost decimal(28,6) default NULL, -- default replacement cost |
911 |
processfee decimal(28,6) default NULL, -- default text be recorded in the column note when the processing fee is applied |
911 |
processfee decimal(28,6) default NULL, -- default text be recorded in the column note when the processing fee is applied |
912 |
notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan |
912 |
notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan |