 CREATE TABLE cities
 (
 	countyid char(4) NOT NULL
-	,citycode int NOT NULL
+	,citycode #loc.intColumnType# NOT NULL
 	,name varchar(50) NOT NULL
 	,PRIMARY KEY(countyid,citycode)
 ) #loc.storageEngine#

CREATE TABLE profiles
(
	id #loc.identityColumnType#
	,authorid int NULL
	,dateofbirth #loc.datetimeColumnType# NOT NULL
	,bio #loc.textColumnType# NULL
	,PRIMARY KEY(id)

CREATE TABLE shops
(
	shopid char(9) NOT NULL
	,citycode #loc.intColumnType# NULL
	,name varchar(80) NOT NULL
	,PRIMARY KEY(shopid)
) #loc.storageEngine#
