Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `country` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(60) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- CREATE TABLE `state` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `countryid` int(11) NOT NULL,
- `name` varchar(60) NOT NULL,
- `country` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_country_id_idx` (`countryid`),
- KEY `FK_osnw35w0p3a1spsw4s8dqelv8` (`country`),
- CONSTRAINT `FK_osnw35w0p3a1spsw4s8dqelv8` FOREIGN KEY (`country`) REFERENCES `country` (`id`),
- CONSTRAINT `fk_country_id` FOREIGN KEY (`countryid`) REFERENCES `country` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- CREATE TABLE `qualification` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(60) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement