MySQL errorno:150 [SOLVED]

wish02 0 Newbie Poster
14 Years Ago
i get an error here
Can't create table '.\itams\assets.frm' (errno: 150)
--
-- Definition of table `branch`
--

DROP TABLE IF EXISTS `branch`;
CREATE TABLE `branch` (
  `_id` int(10) NOT NULL auto_increment,
  `_branchName` varchar(255) default NULL,
  `_branchAddress` varchar(255) default NULL,
  PRIMARY KEY  (`_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `branch`
--

/*!40000 ALTER TABLE `branch` DISABLE KEYS */;
INSERT INTO `branch` (`_id`,`_branchName`,`_branchAddress`) VALUES
 (1,'Main','44 Sen. Gil Puyat Avenue, Makati City'),
 (2,'Antipolo','149 M.L. Quezon St., Bgy. San Roque, Antipolo City'),
 (3,'Cainta','New CRV Bldg., Feliz Ave. cor. Karangalan Ave., Gate 2, Karangalan Village 1'),
 (4,'Caloocan','231-233 EDSA Monumento Caloocan City'),
 (5,'Zapote','158 G/F Burgos Bldg., Zapote 1, Zapote Road, Bacoor 4102 Cavite');
/*!40000 ALTER TABLE `branch` ENABLE KEYS */;

--
-- Definition of table `user_accounts`
--

DROP TABLE IF EXISTS `user_accounts`;
CREATE TABLE `user_accounts` (
  `_id` int(10) NOT NULL auto_increment,
  `_userId` varchar(255) NOT NULL,
  `_firstName` varchar(255) NOT NULL,
  `_lastName` varchar(255) NOT NULL,
  `_password` varchar(255) NOT NULL,
  `_email` varchar(255) NOT NULL,
  `_department` varchar(255) default NULL,
  `_accountType` int(10) unsigned NOT NULL,
  `_position` varchar(255) NOT NULL,
  `_dateRegistered` date NOT NULL,
  `_branch_id` int(10) default NULL,
  PRIMARY KEY  (`_id`),
  KEY `_branch_id` (`_branch_id`),
  CONSTRAINT `user_accounts_ibfk_1` FOREIGN KEY (`_branch_id`) REFERENCES `branch` (`_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_accounts`
--

/*!40000 ALTER TABLE `user_accounts` DISABLE KEYS */;
INSERT INTO `user_accounts` (`_id`,`_userId`,`_firstName`,`_lastName`,`_password`,`_email`,`_department`,`_accountType`,`_position`,`_dateRegistered`,`_branch_id`) VALUES
 (1,'cladebussy','Debussy','Claude','admin','cla.debussy@rbmi.com.ph','Information Technology',5,'Administrator','2010-03-03',1),
 (2,'wolmozart','Wolfgang','Mozart','user','wol.mozart@rbmi.com.ph','Human Resource',1,'User','2010-03-03',1),
 (3,'frechopin','Frederic','Chopin','head','fre.chopin@rbmi.com.ph','Human Resource',2,'Department Head','2010-03-02',1),
 (4,'johbach','Johann','Bach','tech','joh.bach@rbmi.com.ph','Information Technology',3,'Technician','2010-03-02',1),
 (5,'ludbeethoven','Ludwig','Beethoven','ithead','lud.beethoven@rbmi.com.ph','Information Technology',4,'IT Head','2010-03-02',1),
 (6,'kenchoi','Kenny','Choi','head1','ken.choi@rbmi.com.ph',NULL,6,'Branch Head','2010-03-02',2);
/*!40000 ALTER TABLE `user_accounts` ENABLE KEYS */;


--
-- Definition of table `workstation`
--

DROP TABLE IF EXISTS `workstation`;
CREATE TABLE `workstation` (
  `_id` int(10) NOT NULL auto_increment,
  `_wsNum` varchar(255) default NULL,
  `_user_accounts_id` int(10) default NULL,
  PRIMARY KEY  (`_id`),
  KEY `_user_accounts_id` (`_user_accounts_id`),
  CONSTRAINT `workstation_ibfk_1` FOREIGN KEY (`_user_accounts_id`) REFERENCES `user_accounts` (`_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `workstation`
--

/*!40000 ALTER TABLE `workstation` DISABLE KEYS */;
INSERT INTO `workstation` (`_id`,`_wsNum`,`_user_accounts_id`) VALUES
  (1,'WS00001',3),
  (2,'WS00002',2);
/*!40000 ALTER TABLE `workstation` ENABLE KEYS */;


--
-- Definition of table `supplier`
--

DROP TABLE IF EXISTS `supplier`;
CREATE TABLE `supplier` (
  `_id` int(10) NOT NULL auto_increment,
  `_name` varchar(255) default NULL,
  `_address` varchar(255) default NULL,
  `_email` varchar(255) default NULL,
  `_contactNumber` int(10) default NULL,
  PRIMARY KEY  (`_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier`
--

/*!40000 ALTER TABLE `supplier` DISABLE KEYS */;
INSERT INTO `supplier` (`_id`,`_name`,`_address`,`_email`,`_contactNumber`) VALUES
 (1,'North Star','sample1','northstarph@gmail.com',8249959),
 (2,'Digital Escape','sample2','digital.escape@gmail.com',5421121),
 (3,'Virtual Unlimited','sample3','alice.feliz@virtualunlimited.com.ph',8667154),
 (4,'Office Solutions','sample4','softwaresupplies@officesolutions.com.ph',4852211);
/*!40000 ALTER TABLE `supplier` ENABLE KEYS */;


--
-- Definition of table `assets`
--

DROP TABLE IF EXISTS `assets`;
CREATE TABLE `assets` (
  `_id` int(10) NOT NULL auto_increment,
  `_controlNum` varchar(255) NOT NULL,
  `_category` varchar(255) NOT NULL,
  `_subcategory` varchar(255) NOT NULL,
  `_brand` varchar(255) NOT NULL,
  `_product` varchar(255) default NULL,
  `_memory` varchar(255) default NULL,
  `_processor` varchar(255) default NULL,
  `_motherboard` varchar(255) default NULL,
  `_graphicsCard` varchar(255) default NULL,
  `_hardDrive` varchar(255) default NULL,
  `_productNum` varchar(255) default NULL,
  `_serialNum` varchar(255) default NULL,
  `_warrantyPeriod` varchar(255) default NULL,
  `_warrantyEnd` date default NULL,
  `_datePurchased` date NOT NULL,
  `_supplier_id` int(10) default NULL,
  `_cost` float default NULL,
  `_status` varchar(255) default NULL,
  `_assignedDate` date default NULL,
  `_expectedLifeCycle` date default NULL,
  `_retirementNoticeDate` date default NULL,
  `_retireDate` date default NULL,
  `_workstation_id` varchar(255) default NULL,
  `_user_accounts_id` int(10) default NULL,
  PRIMARY KEY  (`_id`),
  KEY `_supplier_id` (`_supplier_id`),
  KEY `_workstation_id` (`_workstation_id`),
  KEY `_user_accounts_id` (`_user_accounts_id`),
  CONSTRAINT `assets_ibfk_1` FOREIGN KEY (`_supplier_id`) REFERENCES `supplier` (`_id`),
  CONSTRAINT `assets_ibfk_2` FOREIGN KEY (`_workstation_id`) REFERENCES `workstation` (`_id`),
  CONSTRAINT `assets_ibfk_3` FOREIGN KEY (`_user_accounts_id`) REFERENCES `user_accounts` (`_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `assets`
--

/*!40000 ALTER TABLE `assets` DISABLE KEYS */;
INSERT INTO `assets` (`_id`,`_controlNum`,`_category`,`_subcategory`,`_brand`,`_product`,`_memory`,`_processor`,`_motherboard`,`_graphicsCard`,`_hardDrive`,`_productNum`,`_serialNum`,`_warrantyPeriod`,`_warrantyEnd`,`_datePurchased`,`_supplier_id`,`_cost`,`_status`,`_assignedDate`,`_expectedLifeCycle`,`_retirementNoticeDate`,`_retireDate`,`_wsNum`,`_user_accounts_id`) VALUES
 (1,'MTR00001','Hardware','Monitor','NEC','52V-bk 15\" LCD',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,NULL,1,3),
 (2,'CPU00001','Hardware','CPU','Stilla','CB+ 100','mem1','proc1','moth1','gcar1','hddr1','105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,NULL,1,3),
 (3,'KYB00001','Hardware','Keyboard','Logitech','K110',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,NULL,1,3),
 (4,'MSE00001','Hardware','Mouse','Logitech','M110',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,NULL,1,3),
 (5,'APP00001','Software','Microsoft Excel 2007','Microsoft','Excel 2007',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,NULL,1,3),
 (6,'MTR00002','Hardware','Monitor','NEC','52V-bk 15\" LCD',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,NULL,2,2),
 (7,'CPU00002','Hardware','CPU','Stilla','CB+ 200','mem2','proc2','moth2','gcar2','hddr1','105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,NULL,2,2),
 (8,'KYB00002','Hardware','Keyboard','Logitech','K111',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,NULL,2,2),
 (9,'MSE00002','Hardware','Mouse','Logitech','M111',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,NULL,2,2),
 (10,'APP00002','Software','Microsoft Powerpoint 2007','Microsoft','Powerpoint 2007',NULL,NULL,NULL,NULL,NULL,'105a2V-bk21','03RK001BV','1 Year','2011-06-19','2010-06-19',1,3459,'In Use','0000-00-00','2010-07-01',NULL,NULL,NULL,2,2);
/*!40000 ALTER TABLE `assets` ENABLE KEYS */;
how do i fix this? thanks!
mysql
1 Contributor
0 Replies
66 Views
Be the first to reply
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.