Advertisement
karthik_pamidimarri

Sql file for sampl app

Jun 18th, 2014
362
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. CREATE TABLE `country` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `name` varchar(60) NOT NULL,
  4. PRIMARY KEY (`id`)
  5. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  6.  
  7. CREATE TABLE `state` (
  8. `id` int(11) NOT NULL AUTO_INCREMENT,
  9. `countryid` int(11) NOT NULL,
  10. `name` varchar(60) NOT NULL,
  11. `country` int(11) NOT NULL,
  12. PRIMARY KEY (`id`),
  13. KEY `fk_country_id_idx` (`countryid`),
  14. KEY `FK_osnw35w0p3a1spsw4s8dqelv8` (`country`),
  15. CONSTRAINT `FK_osnw35w0p3a1spsw4s8dqelv8` FOREIGN KEY (`country`) REFERENCES `country` (`id`),
  16. CONSTRAINT `fk_country_id` FOREIGN KEY (`countryid`) REFERENCES `country` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  17. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  18.  
  19. CREATE TABLE `qualification` (
  20. `id` int(11) NOT NULL AUTO_INCREMENT,
  21. `name` varchar(60) DEFAULT NULL,
  22. PRIMARY KEY (`id`)
  23. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement