Leaked AUSTRALIA BASE Included CIA AGENT NGUYEN RICARD ! Cybernatic Spy By : Anon1337 --------------------- PremanKeyboard | --------------------- -- -- The SQL for the CIA World Fact Book Database -- Database Design by Richard Nguyen, Spring 2006 -- -- Only data for a small number of has been entered -- DROP table CIA_Language CASCADE; DROP table CIA_Religion CASCADE; DROP table CIA_Ethnic CASCADE; DROP table CIA_Neighbour CASCADE; DROP table CountryOcean CASCADE; DROP table CIA_Country CASCADE; DROP table CIA_Ocean CASCADE; -- -- Table creation -- Create table CIA_Country ( Country TEXT, -- Name of the Country Location TEXT, -- Geographic location Land DOUBLE PRECISION, -- Land area, in square kilometers HighestName TEXT, -- Name of the highest point. null if no name. Highest INTEGER, -- Highest point in metres LowestName TEXT, -- Name of the lowest point. null if no name. Lowest INTEGER, -- Lowest point in metres. 0), CONSTRAINT CIA_Country_Height CHECK (Highest > Lowest), CONSTRAINT CIA_Country_Arable CHECK ((Arable >= 0) AND (Arable 0), CONSTRAINT CIA_Country_Age14 CHECK ((Age14 >= 0) AND (Age14 = 0) AND (Age65 = -100) AND (PopGrowth = -1000) AND (Migration = 0) AND (InfantMort 0) AND (LifeExpectM < 100)), CONSTRAINT CIA_Country_LifeExpectF CHECK ((LifeExpectF > 0) AND (LifeExpectF < 100)), CONSTRAINT CIA_Country_HIV CHECK ((HIV >= 0) AND (HIV = 0) AND (Literacy = 0), CONSTRAINT CIA_Country_OilConsum CHECK (OilConsum >= 0), CONSTRAINT CIA_Country_OilExport CHECK (OilExport >= 0), CONSTRAINT CIA_Country_Mobiles CHECK (Mobiles >= 0), CONSTRAINT CIA_Country_Internet CHECK (Internet >= 0), CONSTRAINT CIA_Country_Paved CHECK (Paved >= 0), CONSTRAINT CIA_Country_Unpaved CHECK (Unpaved >= 0), CONSTRAINT CIA_Country_Military CHECK (Military >= 0) ); Create table CIA_Ocean ( Ocean TEXT, -- Name of the ocean Area NUMERIC, -- in millions of square kilometers DeepestName TEXT, -- Name of the deepest point. null if no name. Deepest INTEGER, -- Deepest point in metres CONSTRAINT CIA_OceanPK PRIMARY KEY (Ocean) ); Create table CountryOcean ( Country TEXT, -- Name of the country Ocean TEXT, -- Name of the ocean CONSTRAINT CountryOceanPK PRIMARY KEY (Country,Ocean), CONSTRAINT CountryOceanFK_Invalid_Country FOREIGN KEY (Country) REFERENCES CIA_Country ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT CountryOceanFK_Invalid_Ocean FOREIGN KEY (Ocean) REFERENCES CIA_Ocean ON DELETE CASCADE ON UPDATE CASCADE ); Create table CIA_Neighbour ( CountryA TEXT, -- Name of one neighbour country CountryB TEXT, -- Name of the other neighbour country Length DOUBLE PRECISION, -- Length of the border between neighbours CONSTRAINT CIA_NeighbourPK PRIMARY KEY (CountryA,CountryB), CONSTRAINT CIA_NeighbourFK_Invalid_CountryA FOREIGN KEY (CountryA) REFERENCES CIA_Country (Country) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT CIA_NeighbourFK_Invalid_CountryB FOREIGN KEY (CountryB) REFERENCES CIA_Country (Country) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT CIA_Neighbour_Same_Country CHECK (CountryA CountryB), CONSTRAINT CIA_Neighbour_Alphabetical CHECK (CountryA < CountryB), CONSTRAINT CIA_Neighbour_Length CHECK (Length > 0) ); Create table CIA_Language ( Country TEXT, Language TEXT, Percentage DOUBLE PRECISION, CONSTRAINT CIA_LanguagePK PRIMARY KEY (Country,Language), CONSTRAINT CIA_LanguageFK FOREIGN KEY (Country) REFERENCES CIA_Country ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT CIA_Language_Percentage CHECK (((Percentage > 0) AND (Percentage 0) AND (Percentage 0) AND (Percentage
Posted on: Thu, 14 Nov 2013 13:47:11 +0000
Recently Viewed Topics
© 2015