-- Drop the table if exists

-- Create the table and then add the geometry column to the table
CREATE TABLE rg1000 (
	pkey SERIAL,	-- primary key, system allocated
	geo_type CHAR(2) NOT NULL,	-- [ bg | rg | sg ]
	map_20k SMALLINT NOT NULL,	-- [ 1 ~ 20 ]
	map_10k CHAR(2) NOT NULL,	-- [ nw | ne | sw | se ]
	local_id SMALLINT,	-- localized street ID
	road_code INTEGER,
	road_name_en VARCHAR(60)
);

SELECT AddGeometryColumn('', 'rg1000', 'rg1000_geom', 2326, 'GEOMETRY', 2);
