# 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");
|
Download
