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

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

SELECT AddGeometryColumn('', 'sg1000', 'sg1000_label', 2326, 'GEOMETRY', 2);
SELECT AddGeometryColumn('', 'sg1000', 'sg1000_geom', 2326, 'GEOMETRY', 2);
