File: jMySQL.sql

# MySQL-Front Dump 2.2
#
# Host: localhost   Database: dbname
#--------------------------------------------------------
# Server version 3.23.49-nt


#
# Table structure for table 'country'
#

CREATE TABLE `country` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `country` varchar(50) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'country'
#
INSERT INTO country VALUES("1","South Africa");
INSERT INTO country VALUES("2","England");
INSERT INTO country VALUES("3","Australia");
INSERT INTO country VALUES("4","USA");
INSERT INTO country VALUES("5","France");
INSERT INTO country VALUES("6","Spain");


#
# Table structure for table 'details'
#

CREATE TABLE `details` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `name` char(50) NOT NULL default '0',
  `surname` char(50) NOT NULL default '0',
  `countryId` int(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `countryId` (`countryId`)
) TYPE=MyISAM;



#
# Dumping data for table 'details'
#
INSERT INTO details VALUES("1","name 1","surname 1","1");
INSERT INTO details VALUES("2","johan","de klerk","2");
INSERT INTO details VALUES("3","name 3","surname 3","3");
INSERT INTO details VALUES("4","name 4","surname 4","4");
INSERT INTO details VALUES("5","name 5","surname 5","5");
INSERT INTO details VALUES("16","name","surname","6");
INSERT INTO details VALUES("7","name 7","surname 7","1");
INSERT INTO details VALUES("8","name 8","surname 8","2");
INSERT INTO details VALUES("9","name 9","surname 9","3");
INSERT INTO details VALUES("10","name 10","surname 10","3");
INSERT INTO details VALUES("11","name 1","surname 11","4");
INSERT INTO details VALUES("12","johan","de klerk","3");
INSERT INTO details VALUES("13","johan","de klerk","3");
INSERT INTO details VALUES("17","name","surname","6");