Login   Register  
PHP Classes
elePHPant
Icontem

File: db.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Pravin Sonawane  >  AJAX List Box  >  db.sql  >  Download  
File: db.sql
Role: Auxiliary data
Content type: text/plain
Description: MySql Database File
Class: AJAX List Box
Retrieve MySQL query results into arrays
Author: By
Last change:
Date: 4 years ago
Size: 942 bytes
 

Contents

Class file image Download
--
-- Table structure for table `city`
--

CREATE TABLE IF NOT EXISTS `city` (
  `city_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `state_id` bigint(20) NOT NULL,
  `country_id` int(11) NOT NULL,
  `city_name` varchar(255) NOT NULL,
  PRIMARY KEY (`city_id`)
) ENGINE=MyISAM   ;

--
-- Dumping data for table `city`
--

INSERT INTO `city` (`city_id`, `state_id`, `country_id`, `city_name`) VALUES
(1, 1, 98, 'Mumbai'),
(2, 1, 98, 'Nashik'),
(3, 2, 98, 'Surat'),
(4, 2, 98, 'Baroda');

-- --------------------------------------------------------

--
-- Table structure for table `state`
--

CREATE TABLE IF NOT EXISTS `state` (
  `state_id` int(11) NOT NULL AUTO_INCREMENT,
  `country_id` int(11) NOT NULL,
  `state_name` varchar(255) NOT NULL,
  PRIMARY KEY (`state_id`)
) ENGINE=MyISAM  ;

--
-- Dumping data for table `state`
--

INSERT INTO `state` (`state_id`, `country_id`, `state_name`) VALUES
(1, 98, 'Maharashtra'),
(2, 98, 'Gujarat');