Create and query databases using SQL
gurkna_kai
prime_minister_2000.sql# Dump File # # Database is ported from MS Access #-------------------------------------------------------- # Program Version 3.0.148 CREATE DATABASE IF NOT EXISTS `prime_minister_2000`; USE `prime_minister_2000`; # # Table structure for table 'deputy_pm' # DROP TABLE IF EXISTS `deputy_pm`; CREATE TABLE `deputy_pm` ( `min_nr` INTEGER NOT NULL DEFAULT 0, `deputy_name` VARCHAR(50) NOT NULL, `party` VARCHAR(50), INDEX (`min_nr`), PRIMARY KEY (`min_nr`, `deputy_name`) ) ENGINE=myisam DEFAULT CHARSET=utf8; SET autocommit=1; # # Dumping data for table 'deputy_pm' # INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (1, 'Deakin A', 'Protectionist'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (2, 'Lyne W J', 'Protectionist'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (3, 'Hughes W M', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (4, 'McLean A', 'Protectionist'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (5, 'Isaacs I A', 'Protectionist'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (6, 'Hughes W M', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (7, 'Cook J', 'Free Trade'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (8, 'Hughes W M', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (9, 'Forrest J', 'Liberal'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (10, 'Hughes W M', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (11, 'Tudor F G', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (12, 'Pearce G F', 'National Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (13, 'Cook J', 'Nationalist'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (14, 'Cook J', 'Nationalist'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (15, 'Page C G', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (16, 'Theodore E G', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (17, 'Latham J G', 'United Australia'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (18, 'Page E C G', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (19, 'Hughes W M', 'United Australia'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (20, 'Hughes W M', 'United Australia'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (21, 'Cameron A G', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (22, 'Fadden A W', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (23, 'Menzies R G', 'United Australia'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (24, 'Forde F M', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (25, 'Forde F M', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (26, 'Chifley J B', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (27, 'Forde F M', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (28, 'Evatt H V', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (29, 'Fadden A W', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (30, 'Fadden A W', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (31, 'Fadden A W', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (32, 'McEwen J', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (33, 'McEwen J', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (34, 'McEwen J', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (35, 'McEwen J', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (36, 'McMahon W', 'Liberal'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (37, 'McEwen J', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (38, 'McEwen J', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (39, 'Anthony J D', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (39, 'McEwen J', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (40, 'Anthony J D', 'Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (41, 'Barnard L H', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (42, 'Barnard L H', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (42, 'Cairns J', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (42, 'Crean F', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (43, 'Anthony J D', 'National Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (44, 'Anthony J D', 'National Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (45, 'Anthony J D', 'National Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (46, 'Anthony J D', 'National Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (47, 'Anthony J D', 'National Country'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (48, 'Bowen L', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (49, 'Bowen L', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (50, 'Bowen L', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (51, 'Howe B L', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (51, 'Keating P J', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (52, 'Howe B L', 'Labor'); INSERT INTO `deputy_pm` (`min_nr`, `deputy_name`, `party`) VALUES (53, 'Howe B L', 'Labor'); # 57 records # # Table structure for table 'ministry' # DROP TABLE IF EXISTS `ministry`; CREATE TABLE `ministry` ( `min_nr` INTEGER NOT NULL DEFAULT 0, `pm_name` VARCHAR(50), `party` VARCHAR(50), `day_comm` INTEGER DEFAULT 0, `mth_comm` INTEGER DEFAULT 0, `yr_comm` INTEGER DEFAULT 0, INDEX (`pm_name`), PRIMARY KEY (`min_nr`) ) ENGINE=myisam DEFAULT CHARSET=utf8; SET autocommit=1; # # Dumping data for table 'ministry' # INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (1, 'Barton E', 'Protectionist', 1, 1, 1901); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (2, 'Deakin A', 'Protectionist', 24, 9, 1903); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (3, 'Watson J C', 'Labor', 27, 4, 1904); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (4, 'Reid G H', 'Free Trade', 18, 8, 1904); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (5, 'Deakin A', 'Protectionist', 5, 7, 1905); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (6, 'Fisher A', 'Labor', 13, 11, 1908); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (7, 'Deakin A', 'Protectionist', 2, 6, 1909); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (8, 'Fisher A', 'Labor', 29, 4, 1910); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (9, 'Cook J', 'Liberal', 24, 6, 1913); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (10, 'Fisher A', 'Labor', 17, 9, 1914); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (11, 'Hughes W M', 'Labor', 27, 10, 1915); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (12, 'Hughes W M', 'National labor', 14, 11, 1916); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (13, 'Hughes W M', 'Nationalist', 17, 2, 1917); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (14, 'Hughes W M', 'Nationalist', 10, 1, 1918); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (15, 'Bruce S M', 'Nationalist', 9, 2, 1923); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (16, 'Scullin J H', 'Labor', 22, 10, 1929); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (17, 'Lyons J A', 'United Australia', 6, 1, 1932); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (18, 'Lyons J A', 'United Australia', 7, 11, 1938); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (19, 'Page E C G', 'Country', 7, 4, 1939); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (20, 'Menzies R G', 'United Australia', 26, 4, 1939); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (21, 'Menzies R G', 'United Australia', 14, 3, 1940); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (22, 'Menzies R G', 'United Australia', 28, 10, 1940); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (23, 'Fadden A W', 'Country', 29, 8, 1941); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (24, 'Curtin J', 'Labor', 7, 10, 1941); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (25, 'Curtin J', 'Labor', 21, 9, 1943); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (26, 'Forde F M', 'Labor', 6, 7, 1945); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (27, 'Chifley J B', 'Labor', 13, 7, 1945); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (28, 'Chifley J B', 'Labor', 1, 11, 1946); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (29, 'Menzies R G', 'Liberal', 19, 12, 1949); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (30, 'Menzies R G', 'Liberal', 11, 5, 1951); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (31, 'Menzies R G', 'Liberal', 11, 1, 1956); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (32, 'Menzies R G', 'Liberal', 10, 12, 1958); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (33, 'Menzies R G', 'Liberal', 18, 12, 1963); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (34, 'Holt H E', 'Liberal', 26, 1, 1966); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (35, 'Holt H E', 'Liberal', 14, 12, 1966); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (36, 'McEwen J', 'Country', 19, 12, 1967); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (37, 'Gorton J G', 'Liberal', 10, 1, 1968); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (38, 'Gorton J G', 'Liberal', 28, 2, 1968); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (39, 'Gorton J G', 'Liberal', 12, 11, 1969); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (40, 'McMahon W', 'Liberal', 10, 3, 1971); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (41, 'Whitlam E G', 'Labor', 5, 12, 1972); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (42, 'Whitlam E G', 'Labor', 19, 12, 1972); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (43, 'Fraser J M', 'Liberal', 11, 11, 1975); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (44, 'Fraser J M', 'Liberal', 22, 12, 1975); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (45, 'Fraser J M', 'Liberal', 20, 12, 1977); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (46, 'Fraser J M', 'Liberal', 3, 11, 1980); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (47, 'Fraser J M', 'Liberal', 7, 5, 1982); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (48, 'Hawke R J L', 'Labor', 11, 3, 1983); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (49, 'Hawke R J L', 'Labor', 7, 12, 1984); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (50, 'Hawke R J L', 'Labor', 11, 7, 1987); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (51, 'Hawke R J L', 'Labor', 4, 4, 1990); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (52, 'Keating P J', 'Labor', 20, 12, 1991); INSERT INTO `ministry` (`min_nr`, `pm_name`, `party`, `day_comm`, `mth_comm`, `yr_comm`) VALUES (53, 'Keating P J', 'Labor', 24, 3, 1993); # 53 records # # Table structure for table 'pm_marriage' # DROP TABLE IF EXISTS `pm_marriage`; CREATE TABLE `pm_marriage` ( `pm_name` VARCHAR(50) NOT NULL, `spouse_name` VARCHAR(50) NOT NULL, `mar_yr` INTEGER DEFAULT 0, `pm_age` INTEGER DEFAULT 0, `nr_children` INTEGER DEFAULT 0, INDEX (`pm_name`), PRIMARY KEY (`pm_name`, `spouse_name`) ) ENGINE=myisam DEFAULT CHARSET=utf8; SET autocommit=1; # # Dumping data for table 'pm_marriage' # INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Barton E', 'Ross JM', 1877, 28, 6); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Bruce S M', 'Anderson E', 1913, 30, 0); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Chifley J B', 'Mackenzie E', 1914, 29, 0); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Cook J', 'Turner M', 1885, 25, 9); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Curtin J', 'Needham E', 1917, 32, 2); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Deakin A', 'Browne E M', 1882, 26, 3); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Fadden A W', 'Thornber I', 1916, 21, 4); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Fisher A', 'Irvine M J', 1901, 39, 5); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Forde F M', 'O\'Reilly V C', 1925, 35, 4); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Fraser J M', 'Beggs T', 1956, 26, 4); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Gorton J G', 'Brown B', 1935, 23, 3); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Hawke R J L', 'Masterson H', 1956, 26, 3); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Holt H E', 'Fell Z K', 1946, 38, 3); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Hughes W M', 'Campbell M E', 1911, 49, 1); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Hughes W M', 'Cutts E', 1890, 28, 6); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Keating P J', 'Van Iersel A', 1975, 30, 4); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Lyons J A', 'Burnell E M', 1915, 36, 11); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('McEwen J', 'Byrne M', 1968, 68, 0); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('McEwen J', 'McLeod A M', 1921, 21, 0); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('McMahon W', 'Hopkins W R', 1965, 57, 3); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Menzies R G', 'Leckie P M', 1920, 26, 3); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Page E C G', 'Blunt E', 1906, 26, 4); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Reid G H', 'Bromby F', 1891, 46, 0); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Scullin J H', 'McNamara M', 1907, 31, 0); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Watson J C', 'Lane A', 1925, 58, 1); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Watson J C', 'Low A J', 1889, 22, 0); INSERT INTO `pm_marriage` (`pm_name`, `spouse_name`, `mar_yr`, `pm_age`, `nr_children`) VALUES ('Whitlam E G', 'Dovey M E', 1942, 26, 4); # 27 records # # Table structure for table 'pm_recreation' # DROP TABLE IF EXISTS `pm_recreation`; CREATE TABLE `pm_recreation` ( `pm_name` VARCHAR(50) NOT NULL, `recreation` VARCHAR(50) NOT NULL, INDEX (`pm_name`), PRIMARY KEY (`pm_name`, `recreation`) ) ENGINE=myisam DEFAULT CHARSET=utf8; SET autocommit=1; # # Dumping data for table 'pm_recreation' # INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Barton E', 'reading'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Bruce S M', 'golf'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Bruce S M', 'riding'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Curtin J', 'swimming'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Curtin J', 'walking'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Deakin A', 'cycling'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Deakin A', 'reading'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Fadden A W', 'golf'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Forde F M', 'golf'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Forde F M', 'shooting'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Forde F M', 'tennis'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Fraser J M', 'fishing'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Fraser J M', 'photography'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Fraser J M', 'vintage cars'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Gorton J G', 'reading'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Hawke R J L', 'cricket'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Hawke R J L', 'reading'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Hawke R J L', 'tennis'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Holt H E', 'golf'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Holt H E', 'racing'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Holt H E', 'spear fishing'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Hughes W M', 'golf'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Hughes W M', 'motoring'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Hughes W M', 'riding'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Keating P J', 'antique clocks'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Keating P J', 'sailing'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Keating P J', 'vintage cars'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Lyons J A', 'tennis'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('McEwen J', 'farming'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('McEwen J', 'reading'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('McMahon W', 'golf'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('McMahon W', 'music'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('McMahon W', 'squash'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Menzies R G', 'cricket'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Menzies R G', 'walking'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Page E C G', 'tennis'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Scullin J H', 'bowls'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Scullin J H', 'reading'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Scullin J H', 'walking'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Watson J C', 'golf'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Whitlam E G', 'music'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Whitlam E G', 'swimming'); INSERT INTO `pm_recreation` (`pm_name`, `recreation`) VALUES ('Whitlam E G', 'theatre'); # 43 records # # Table structure for table 'prime_minister' # DROP TABLE IF EXISTS `prime_minister`; CREATE TABLE `prime_minister` ( `pm_name` VARCHAR(12) NOT NULL, `birth_yr` INTEGER DEFAULT 0, `yrs_served` FLOAT NULL DEFAULT 0, `death_age` INTEGER DEFAULT 0, `state_born` VARCHAR(3), `state_rep` VARCHAR(3), PRIMARY KEY (`pm_name`) ) ENGINE=myisam DEFAULT CHARSET=utf8; SET autocommit=1; # # Dumping data for table 'prime_minister' # INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Barton E', 1849, 2.72, 71, 'NSW', 'NSW'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Bruce S M', 1883, 6.71, 84, 'VIC', 'VIC'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Chifley J B', 1885, 4.42, 66, 'NSW', 'NSW'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Cook J', 1860, 1.23, 87, '?', 'NSW'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Curtin J', 1885, 3.75, 60, 'VIC', 'WA'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Deakin A', 1856, 4.84, 63, 'VIC', 'VIC'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Fadden A W', 1895, .11, 78, 'QLD', 'QLD'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Fisher A', 1862, 4.81, 66, '?', 'QLD'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Forde F M', 1890, .02, 93, 'QLD', 'QLD'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Fraser J M', 1930, 7.33, 0, 'VIC', 'VIC'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Gorton J G', 1911, 3.17, 0, 'VIC', 'VIC'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Hawke R J L', 1929, 8.78, 0, 'SA', 'VIC'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Holt H E', 1908, 1.88, 59, 'NSW', 'VIC'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Hughes W M', 1862, 7.29, 90, '?', 'NSW'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Keating P J', 1944, 0, 0, 'NSW', 'NSW'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Lyons J A', 1879, 7.25, 60, 'TAS', 'TAS'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('McEwen J', 1900, .06, 80, 'VIC', 'VIC'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('McMahon W', 1908, 1.72, 80, 'NSW', 'NSW'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Menzies R G', 1894, 18.41, 84, 'VIC', 'VIC'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Page E C G', 1880, .05, 81, 'NSW', 'NSW'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Reid G H', 1845, .87, 73, '?', 'NSW'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Scullin J H', 1876, 2.17, 77, 'VIC', 'VIC'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Watson J C', 1867, .28, 74, '?', 'NSW'); INSERT INTO `prime_minister` (`pm_name`, `birth_yr`, `yrs_served`, `death_age`, `state_born`, `state_rep`) VALUES ('Whitlam E G', 1916, 2.92, 0, 'NSW', 'NSW'); # 24 records
