Airbnb sql file to make a database for its Listings

airbnb-sql-fis002-alex-au

CREATE TABLE Hosts (
  HostID int primary key,
	PlacesID int,
	EmailAddress varchar(100),
	PhoneNumber varchar(50),
	AddressLine1 varchar(100),
	AddressLine2 varchar(100),
	City varchar(100),
	Region varchar(50),
	ZipCode varchar(50),
	Country varchar(100)
);

CREATE TABLE Places (
	PlacesID int,
	PropertyType varchar(30),
	Accomodates int,
	RoomType varchar(30),
	Bedrooms int,
	Title varchar(35),
	Description text,
	Currency varchar(10)
);

INSERT INTO Hosts
VALUES (1, 1, '[email protected]', '7137137131', 'a', 'a', 'Houston', 'Texas', '77019', 'USA'),
	   (2, 2, '[email protected]', '1231234123', 'b', 'b', 'Houstoo', 'Texas', '77020', 'USA'),
	   (3, 3, '[email protected]', '1231234124', 'c', 'c', 'Houstop', 'Texas', '77021', 'USA'),
	   (4, 4, '[email protected]', '1231234125', 'd', 'd', 'Houston', 'Texas', '77019', 'USA'),
	   (5, 5, '[email protected]', '1231234126', 'e', 'e', 'Houston', 'Texas', '77019', 'USA'),
	   (6, 6, '[email protected]', '1231234127', 'f', 'f', 'Houston', 'Texas', '77019', 'USA'),
	   (7, 7, '[email protected]', '1231234128', 'g', 'g', 'Houston', 'Texas', '77019', 'USA'),
	   (8, 8, '[email protected]', '1231234129', 'h', 'h', 'Houston', 'Texas', '77019', 'USA'), 
	   (9, 9, '[email protected]', '1234123412', 'i', 'i', 'Houston', 'Texas', '77019', 'USA'),
	   (10, 10, '[email protected]', '1234123413', 'j', 'j', 'Houston', 'Texas', '77019', 'USA');

INSERT INTO Places
VALUES (1, 'Apartment', 1, 'Private Room', 3, 'Wow', 'No really, wow!', 'USD'),
	   (2, 'Apartment', 1, 'Private Room', 3, 'Woa', 'No really, woa!', 'USD'),
	   (3, 'Apartment', 1, 'Private Room', 3, 'Wob', 'No really, wob!', 'USD'),
	   (4, 'Apartment', 1, 'Private Room', 3, 'Woc', 'No really, woc!', 'USD'),
	   (5, 'Apartment', 1, 'Private Room', 3, 'Wod', 'No really, wod!', 'USD'),
	   (6, 'Apartment', 1, 'Private Room', 3, 'Woe', 'No really, woe!', 'USD'),
	   (7, 'Apartment', 1, 'Private Room', 3, 'Wof', 'No really, wof!', 'USD'),
	   (8, 'Apartment', 1, 'Private Room', 3, 'Wog', 'No really, wog!', 'USD'),
	   (9, 'Apartment', 1, 'Private Room', 3, 'Woh', 'No really, woh!', 'USD'),
	   (10, 'Apartment', 1, 'Private Room', 3, 'Woi', 'No really, woi!', 'USD');