-- Drop the table if exists
DROP TABLE IF EXISTS bg1000;

-- Create the table and then add the geometry column to the table
CREATE TABLE bg1000 (
	pkey SERIAL,
	geo_ref_nr CHAR(10),	-- geographic reference no. of the label point of building block
	bldg_name_en VARCHAR(120),
	site_code INTEGER
);

SELECT AddGeometryColumn('', 'bg1000', 'bg1000_geom', 2326, 'GEOMETRY', 2);
