1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
DROP TABLE IF EXISTS `account_type`;
CREATE TABLE `account_type` (
`id_account_type` int(4) NOT NULL,
`ref_message` int(4) NOT NULL,
`price` decimal(4,2) NOT NULL,
PRIMARY KEY (`id_account_type`,`ref_message`),
KEY `FK_ACCOUNT_TYPE_MESSAGE` (`ref_message`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `account_type`
--
/*!40000 ALTER TABLE `account_type` DISABLE KEYS */;
LOCK TABLES `account_type` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `account_type` ENABLE KEYS */; |