/*
SQLyog - Free MySQL GUI v5.11
Host - 5.0.18-nt : Database - new_sfa
*********************************************************************
Server version : 5.0.18-nt
*/


SET NAMES utf8;

SET SQL_MODE='';

create database if not exists `new_sfa`;

USE `new_sfa`;

/*Table structure for table `city` */

DROP TABLE IF EXISTS `city`;

CREATE TABLE `city` (
  `cityId` int(11) NOT NULL,
  `cityname` varchar(20) NOT NULL,
  `stateId` int(11) NOT NULL,
  PRIMARY KEY  (`cityId`),
  KEY `FK_city` (`stateId`),
  CONSTRAINT `city_ibfk_1` FOREIGN KEY (`stateId`) REFERENCES `state` (`stateId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `city` */

insert into `city` (`cityId`,`cityname`,`stateId`) values (1,'Kanpur',2),(2,'Laxmi Nagar',1);