here is part of the create table CREATE TABLE `assets` ( `assetID` int(11) NOT NULL auto_increment, `barcode_number` varchar(20) NOT NULL default '', `asset_code` varchar(20) NOT NULL default '', `serial_number` varchar(100) NOT NULL default '', `asset_user` varchar(100) NOT NULL default '', `purchase_price` double NOT NULL default '0', `rental_amount` double NOT NULL default '0', `start_date` date NOT NULL default '0000-00-00', `asset_typeID` tinyint(4) NOT NULL default '0', `manufacturerID` int(11) NOT NULL default '0', `departmentID` int(11) NOT NULL default '0', `asset_modelID` tinyint(4) NOT NULL default '0', `rental_gst` double NOT NULL default '0', `peripherals` text NOT NULL, `asset_description` text NOT NULL, `end_dateID` tinyint(4) NOT NULL default '0', PRIMARY KEY (`assetID`), KEY `barcode_number` (`barcode_number`), KEY `serial_number` (`serial_number`), KEY `asset_user` (`asset_user`), KEY `asset_typeID` (`asset_typeID`), KEY `manufacturerID` (`manufacturerID`), KEY `departmentID` (`departmentID`), KEY `modelID` (`asset_modelID`), KEY `end_dateID` (`end_dateID`), FOREIGN KEY (`end_dateID`) REFERENCES `end_dates` (`end_dateID`) ON DELETE CASCADE ON UPDATE NO ACTION ) TYPE=InnoDB
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]