Create schema and table

Text

DROP SCHEMA IF EXISTS addressbase CASCADE;
COMMIT;

CREATE SCHEMA addressbase;
COMMIT;

CREATE TABLE addressbase.addressbase (
UPRN bigint NOT NULL,
OS_ADDRESS_TOID varchar,
RM_UDPRN bigint,
ORGANISATION_NAME varchar,
DEPARTMENT_NAME varchar,
PO_BOX varchar,
BUILDING_NAME varchar,
SUB_BUILDING_NAME varchar,
BUILDING_NUMBER varchar,
DEPENDENT_THOROUGHFARE_NAME varchar,
THROUGHFARE_NAME varchar,
POST_TOWN varchar,
DOUBLE_DEPENDENT_LOCALITY varchar,
DEPENDENT_LOCALITY varchar,
POSTCODE varchar,
POSTCODE_TYPE varchar,
X_COORDINATE numeric,
Y_COORDINATE numeric,
RPC integer,
CHANGE_TYPE varchar,
START_DATE Date,
LAST_UPDATE_DATE Date,
ENTRY_DATE Date,
CLASS varchar,
PROCESS_DATE Date);
COMMIT;