Lines 1243-1248
CREATE TABLE `itemtypes` ( -- defines the item types
Link Here
|
1243 |
itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type |
1243 |
itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type |
1244 |
description mediumtext, -- a plain text explanation of the item type |
1244 |
description mediumtext, -- a plain text explanation of the item type |
1245 |
rentalcharge double(16,4) default NULL, -- the amount charged when this item is checked out/issued |
1245 |
rentalcharge double(16,4) default NULL, -- the amount charged when this item is checked out/issued |
|
|
1246 |
gstrate decimal(6,4) default NULL, -- default gst rate to use when ordering this item type |
1246 |
notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan |
1247 |
notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan |
1247 |
imageurl varchar(200) default NULL, -- URL for the item type icon |
1248 |
imageurl varchar(200) default NULL, -- URL for the item type icon |
1248 |
summary text, -- information from the summary field, may include HTML |
1249 |
summary text, -- information from the summary field, may include HTML |