SQL的语句：
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(34) DEFAULT NULL,
`password` varchar(34) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `massage1`;
CREATE TABLE `massage1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`setdate` datetime DEFAULT NULL,
`context` varchar(255) DEFAULT NULL,
`setperons_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `setperons_id` (`setperons_id`),
CONSTRAINT `setperons_id` FOREIGN KEY (`setperons_id`) REFERENCES `person` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
在用逆向工程中无法达到要求。
要改为：
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(34) DEFAULT NULL,
`password` varchar(34) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `massage1`;
CREATE TABLE `massage1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`setdate` datetime DEFAULT NULL,
`context` varchar(255) DEFAULT NULL,
`setperons_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `setperons_id` (`setperons_id`),
CONSTRAINT `setperons_id` FOREIGN KEY (`setperons_id`) REFERENCES `person` (`id`)
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(34) DEFAULT NULL,
`password` varchar(34) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `massage1`;
CREATE TABLE `massage1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`setdate` datetime DEFAULT NULL,
`context` varchar(255) DEFAULT NULL,
`setperons_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `setperons_id` (`setperons_id`),
CONSTRAINT `setperons_id` FOREIGN KEY (`setperons_id`) REFERENCES `person` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
在用逆向工程中无法达到要求。
要改为：
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(34) DEFAULT NULL,
`password` varchar(34) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `massage1`;
CREATE TABLE `massage1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`setdate` datetime DEFAULT NULL,
`context` varchar(255) DEFAULT NULL,
`setperons_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `setperons_id` (`setperons_id`),
CONSTRAINT `setperons_id` FOREIGN KEY (`setperons_id`) REFERENCES `person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
本文转自yunlielai51CTO博客，原文链接：http://blog.51cto.com/4925054/1107063，如需转载请自行联系原作者
