Create schema and table

Text

DROP SCHEMA IF EXISTS addressbaseplus CASCADE;
COMMIT;

CREATE SCHEMA addressbaseplus;
COMMIT;

CREATE TABLE addressbaseplus.addressbaseplus (
UPRN bigint NOT NULL,
RM_UDPRN bigint,
CHANGE_TYPE varchar,
STATE bigint,
STATE_DATE Date,
CLASS varchar,
PARENT_UPRN bigint,
X_COORDINATE numeric,
Y_COORDINATE numeric,
RPC bigint,
LOCAL_CUSTODIAN_CODE bigint,
START_DATE Date,
END_DATE Date,
LAST_UPDATE_DATE Date,
ENTRY_DATE Date,
ORGANISATION_NAME varchar,
ORGANISATION varchar,
DEPARTMENT_NAME varchar,
SCOTTISH_DEPARTMENT_NAME varchar,
BUILDING_NAME varchar,
SUB_BUILDING_NAME varchar,
SAO_START_NUMBER bigint,
SAO_START_SUFFIX varchar,
SAO_END_NUMBER bigint,
SAO_END_SUFFIX varchar,
SAO_TEXT varchar,
ALT_LANGUAGE_SAO_TEXT varchar,
PAO_START_NUMBER bigint,
PAO_START_SUFFIX varchar,
PAO_END_NUMBER bigint,
PAO_END_SUFFIX varchar,
PAO_TEXT varchar,
ALT_LANGUAGE_PAO_TEXT varchar,
USRN bigint,
USRN_MATCH_INDICATOR varchar,
AREA_NAME varchar,
LEVEL varchar,
OFFICIAL_FLAG varchar,
OS_ADDRESS_TOID varchar,
OS_ADDRESS_TOID_VERSION bigint,
OS_ROADLINE_TOID varchar,
OS_ROADLINE_TOID_VERSION bigint,
OS_TOPO_TOID varchar,
OS_TOPO_TOID_VERSION bigint,
VOA_CT_RECORD bigint,
VOA_NDR_RECORD bigint,
STREET_DESCRIPTION varchar,
ALT_LANGUAGE_STREET_DESCRIPTION varchar,
DEPENDENT_THOROUGHFARE_NAME varchar,
THOROUGHFARE_NAME varchar,
WELSH_DEPENDENT_THOROUGHFARE_NAME varchar,
WELSH_THOROUGHFARE_NAME varchar,
DOUBLE_DEPENDENT_LOCALITY varchar,
DEPENDENT_LOCALITY varchar,
LOCALITY_NAME varchar,
WELSH_DEPENDENT_LOCALITY varchar,
WELSH_DOUBLE_DEPENDENT_LOCALITY varchar,
TOWN_NAME varchar,
ADMINISTRATIVE_AREA varchar,
POST_TOWN varchar,
POSTCODE varchar,
POSTCODE_LOCATOR varchar,
POSTCODE_TYPE varchar,
POSTAL_ADDRESS varchar,
PO_BOX_NUMBER varchar,
WARD_CODE varchar,
PARISH_CODE varchar,
PROCESS_DATE Date,
MULTI_OCC_COUNT bigint,
VOA_NDR_P_DESC_CODE varchar,
VOA_NDR_SCAT_CODE varchar,
ALT_LANGUAGE varchar);