-- Table: public.detections_plates_allowed

-- DROP TABLE public.detections_plates_allowed;

CREATE TABLE public.detections_plates_allowed
(
    location text COLLATE pg_catalog."default" NOT NULL,
    insertiontimestamp bigint NOT NULL,
    detectiontimestamp bigint NOT NULL,
    ticketabsolutenumber bigint,
    tickettimetoleave bigint,
    timetoleavereal bigint,
    priority boolean,
    parking text COLLATE pg_catalog."default",
    manual boolean,
    detectionplate text COLLATE pg_catalog."default" NOT NULL,
    detectionlane integer,
    detectioncountry text COLLATE pg_catalog."default",
    ticketrelativenumber bigint,
    tickettimestamp bigint,
    length double precision,
    value jsonb,
    CONSTRAINT detections_plates_allowed_pkey1 PRIMARY KEY (detectionplate)
        USING INDEX TABLESPACE artic
)
WITH (
    OIDS = FALSE
)
TABLESPACE artic;

ALTER TABLE public.detections_plates_allowed
    OWNER to aluvisa;

-- Index: detectiontimestampallowedn

-- DROP INDEX public.detectiontimestampallowedn;

CREATE INDEX detectiontimestampallowedn
    ON public.detections_plates_allowed USING btree
    (detectiontimestamp)
    TABLESPACE artic;

-- Index: insertiontimestampallowedn

-- DROP INDEX public.insertiontimestampallowedn;

CREATE INDEX insertiontimestampallowedn
    ON public.detections_plates_allowed USING btree
    (insertiontimestamp)
    TABLESPACE artic;

-- Index: locationallowedn

-- DROP INDEX public.locationallowedn;

CREATE INDEX locationallowedn
    ON public.detections_plates_allowed USING btree
    (location COLLATE pg_catalog."default")
    TABLESPACE artic;

-- Index: manualallowedn

-- DROP INDEX public.manualallowedn;

CREATE INDEX manualallowedn
    ON public.detections_plates_allowed USING btree
    (manual)
    TABLESPACE artic;

-- Index: parkingallowedn

-- DROP INDEX public.parkingallowedn;

CREATE INDEX parkingallowedn
    ON public.detections_plates_allowed USING btree
    (parking COLLATE pg_catalog."default")
    TABLESPACE artic;

-- Index: priorityallowedn

-- DROP INDEX public.priorityallowedn;

CREATE INDEX priorityallowedn
    ON public.detections_plates_allowed USING btree
    (priority)
    TABLESPACE artic;

-- Index: ticketabsolutenumberallowedn

-- DROP INDEX public.ticketabsolutenumberallowedn;

CREATE INDEX ticketabsolutenumberallowedn
    ON public.detections_plates_allowed USING btree
    (ticketabsolutenumber)
    TABLESPACE artic;

-- Index: tickettimetoleaveallowedn

-- DROP INDEX public.tickettimetoleaveallowedn;

CREATE INDEX tickettimetoleaveallowedn
    ON public.detections_plates_allowed USING btree
    (tickettimetoleave)
    TABLESPACE artic;

-- Index: timetoleaverealallowedn

-- DROP INDEX public.timetoleaverealallowedn;

CREATE INDEX timetoleaverealallowedn
    ON public.detections_plates_allowed USING btree
    (timetoleavereal)
    TABLESPACE artic;
	
	
	
-- Table: public.detections_plates_border

-- DROP TABLE public.detections_plates_border;

CREATE TABLE public.detections_plates_border
(
    location text COLLATE pg_catalog."default" NOT NULL,
    insertiontimestamp bigint NOT NULL,
    detectiontimestamp bigint NOT NULL,
    ticketabsolutenumber bigint,
    tickettimetoleave bigint,
    timetoleavereal bigint,
    timestampexit bigint,
    timestampbarrier1 bigint,
    timestampbarrier2 bigint,
    priority boolean,
    parking text COLLATE pg_catalog."default",
    manual boolean,
    accessmethodbarrier2 integer,
    detectionplate text COLLATE pg_catalog."default" NOT NULL,
    detectionlane integer,
    detectioncountry text COLLATE pg_catalog."default",
    ticketrelativenumber bigint,
    tickettimestamp bigint,
    length double precision,
    value jsonb,
    CONSTRAINT detections_plates_border_pkey1 PRIMARY KEY (detectionplate)
        USING INDEX TABLESPACE artic
)
WITH (
    OIDS = FALSE
)
TABLESPACE artic;

ALTER TABLE public.detections_plates_border
    OWNER to aluvisa;

-- Index: accessbarrier2bordern

-- DROP INDEX public.accessbarrier2bordern;

CREATE INDEX accessbarrier2bordern
    ON public.detections_plates_border USING btree
    (accessmethodbarrier2)
    TABLESPACE artic;

-- Index: detectiontimestampbordern

-- DROP INDEX public.detectiontimestampbordern;

CREATE INDEX detectiontimestampbordern
    ON public.detections_plates_border USING btree
    (detectiontimestamp)
    TABLESPACE artic;

-- Index: insertiontimestampbordern

-- DROP INDEX public.insertiontimestampbordern;

CREATE INDEX insertiontimestampbordern
    ON public.detections_plates_border USING btree
    (insertiontimestamp)
    TABLESPACE artic;

-- Index: locationbordern

-- DROP INDEX public.locationbordern;

CREATE INDEX locationbordern
    ON public.detections_plates_border USING btree
    (location COLLATE pg_catalog."default")
    TABLESPACE artic;

-- Index: manualbordern

-- DROP INDEX public.manualbordern;

CREATE INDEX manualbordern
    ON public.detections_plates_border USING btree
    (manual)
    TABLESPACE artic;

-- Index: parkingbordern

-- DROP INDEX public.parkingbordern;

CREATE INDEX parkingbordern
    ON public.detections_plates_border USING btree
    (parking COLLATE pg_catalog."default")
    TABLESPACE artic;

-- Index: prioritybordern

-- DROP INDEX public.prioritybordern;

CREATE INDEX prioritybordern
    ON public.detections_plates_border USING btree
    (priority)
    TABLESPACE artic;

-- Index: ticketabsolutenumberbordern

-- DROP INDEX public.ticketabsolutenumberbordern;

CREATE INDEX ticketabsolutenumberbordern
    ON public.detections_plates_border USING btree
    (ticketabsolutenumber)
    TABLESPACE artic;

-- Index: tickettimetoleavebordern

-- DROP INDEX public.tickettimetoleavebordern;

CREATE INDEX tickettimetoleavebordern
    ON public.detections_plates_border USING btree
    (tickettimetoleave)
    TABLESPACE artic;

-- Index: timestampbarrier1bordern

-- DROP INDEX public.timestampbarrier1bordern;

CREATE INDEX timestampbarrier1bordern
    ON public.detections_plates_border USING btree
    (timestampbarrier1)
    TABLESPACE artic;

-- Index: timestampbarrier2bordern

-- DROP INDEX public.timestampbarrier2bordern;

CREATE INDEX timestampbarrier2bordern
    ON public.detections_plates_border USING btree
    (timestampbarrier2)
    TABLESPACE artic;

-- Index: timestampexitbordern

-- DROP INDEX public.timestampexitbordern;

CREATE INDEX timestampexitbordern
    ON public.detections_plates_border USING btree
    (timestampexit)
    TABLESPACE artic;

-- Index: timetoleaverealbordern

-- DROP INDEX public.timetoleaverealbordern;

CREATE INDEX timetoleaverealbordern
    ON public.detections_plates_border USING btree
    (timetoleavereal)
    TABLESPACE artic;
	
	
	-- Table: public.detections_plates_distracted

-- DROP TABLE public.detections_plates_distracted;

CREATE TABLE public.detections_plates_distracted
(
    location text COLLATE pg_catalog."default" NOT NULL,
    insertiontimestamp bigint NOT NULL,
    detectiontimestamp bigint NOT NULL,
    ticketabsolutenumber bigint,
    tickettimetoleave bigint,
    timetoleavereal bigint,
    priority boolean,
    parking text COLLATE pg_catalog."default",
    manual boolean,
    detectionplate text COLLATE pg_catalog."default" NOT NULL,
    detectionlane integer,
    detectioncountry text COLLATE pg_catalog."default",
    ticketrelativenumber bigint,
    tickettimestamp bigint,
    length double precision,
    value jsonb,
    CONSTRAINT detections_plates_distracted_pkey1 PRIMARY KEY (detectionplate)
        USING INDEX TABLESPACE artic
)
WITH (
    OIDS = FALSE
)
TABLESPACE artic;

ALTER TABLE public.detections_plates_distracted
    OWNER to aluvisa;

-- Index: detectiontimestampdistractedn

-- DROP INDEX public.detectiontimestampdistractedn;

CREATE INDEX detectiontimestampdistractedn
    ON public.detections_plates_distracted USING btree
    (detectiontimestamp)
    TABLESPACE artic;

-- Index: insertiontimestampdistractedn

-- DROP INDEX public.insertiontimestampdistractedn;

CREATE INDEX insertiontimestampdistractedn
    ON public.detections_plates_distracted USING btree
    (insertiontimestamp)
    TABLESPACE artic;

-- Index: locationdistractedn

-- DROP INDEX public.locationdistractedn;

CREATE INDEX locationdistractedn
    ON public.detections_plates_distracted USING btree
    (location COLLATE pg_catalog."default")
    TABLESPACE artic;

-- Index: manualdistractedn

-- DROP INDEX public.manualdistractedn;

CREATE INDEX manualdistractedn
    ON public.detections_plates_distracted USING btree
    (manual)
    TABLESPACE artic;

-- Index: parkingdistractedn

-- DROP INDEX public.parkingdistractedn;

CREATE INDEX parkingdistractedn
    ON public.detections_plates_distracted USING btree
    (parking COLLATE pg_catalog."default")
    TABLESPACE artic;

-- Index: prioritydistractedn

-- DROP INDEX public.prioritydistractedn;

CREATE INDEX prioritydistractedn
    ON public.detections_plates_distracted USING btree
    (priority)
    TABLESPACE artic;

-- Index: ticketabsolutenumberdistractedn

-- DROP INDEX public.ticketabsolutenumberdistractedn;

CREATE INDEX ticketabsolutenumberdistractedn
    ON public.detections_plates_distracted USING btree
    (ticketabsolutenumber)
    TABLESPACE artic;

-- Index: tickettimetoleavedistractedn

-- DROP INDEX public.tickettimetoleavedistractedn;

CREATE INDEX tickettimetoleavedistractedn
    ON public.detections_plates_distracted USING btree
    (tickettimetoleave)
    TABLESPACE artic;

-- Index: timetoleaverealdistractedn

-- DROP INDEX public.timetoleaverealdistractedn;

CREATE INDEX timetoleaverealdistractedn
    ON public.detections_plates_distracted USING btree
    (timetoleavereal)
    TABLESPACE artic;
	
	
	
	-- Table: public.detections_plates_parking

-- DROP TABLE public.detections_plates_parking;

CREATE TABLE public.detections_plates_parking
(
    location text COLLATE pg_catalog."default" NOT NULL,
    insertiontimestamp bigint NOT NULL,
    detectiontimestamp bigint NOT NULL,
    ticketabsolutenumber bigint,
    tickettimetoleave bigint,
    timetoleavereal bigint,
    priority boolean,
    parking text COLLATE pg_catalog."default",
    manual boolean,
    detectionplate text COLLATE pg_catalog."default" NOT NULL,
    detectionlane integer,
    detectioncountry text COLLATE pg_catalog."default",
    ticketrelativenumber bigint,
    tickettimestamp bigint,
    length double precision,
    value jsonb,
    CONSTRAINT detections_plates_parking_pkey1 PRIMARY KEY (detectionplate)
        USING INDEX TABLESPACE artic
)
WITH (
    OIDS = FALSE
)
TABLESPACE artic;

ALTER TABLE public.detections_plates_parking
    OWNER to aluvisa;

-- Index: detectiontimestampparkingn

-- DROP INDEX public.detectiontimestampparkingn;

CREATE INDEX detectiontimestampparkingn
    ON public.detections_plates_parking USING btree
    (detectiontimestamp)
    TABLESPACE artic;

-- Index: insertiontimestampparkingn

-- DROP INDEX public.insertiontimestampparkingn;

CREATE INDEX insertiontimestampparkingn
    ON public.detections_plates_parking USING btree
    (insertiontimestamp)
    TABLESPACE artic;

-- Index: locationparkingn

-- DROP INDEX public.locationparkingn;

CREATE INDEX locationparkingn
    ON public.detections_plates_parking USING btree
    (location COLLATE pg_catalog."default")
    TABLESPACE artic;

-- Index: manualparkingn

-- DROP INDEX public.manualparkingn;

CREATE INDEX manualparkingn
    ON public.detections_plates_parking USING btree
    (manual)
    TABLESPACE artic;

-- Index: parkingparkingn

-- DROP INDEX public.parkingparkingn;

CREATE INDEX parkingparkingn
    ON public.detections_plates_parking USING btree
    (parking COLLATE pg_catalog."default")
    TABLESPACE artic;

-- Index: priorityparkingn

-- DROP INDEX public.priorityparkingn;

CREATE INDEX priorityparkingn
    ON public.detections_plates_parking USING btree
    (priority)
    TABLESPACE artic;

-- Index: ticketabsolutenumberparkingn

-- DROP INDEX public.ticketabsolutenumberparkingn;

CREATE INDEX ticketabsolutenumberparkingn
    ON public.detections_plates_parking USING btree
    (ticketabsolutenumber)
    TABLESPACE artic;

-- Index: tickettimetoleaveparkingn

-- DROP INDEX public.tickettimetoleaveparkingn;

CREATE INDEX tickettimetoleaveparkingn
    ON public.detections_plates_parking USING btree
    (tickettimetoleave)
    TABLESPACE artic;

-- Index: timetoleaverealparkingn

-- DROP INDEX public.timetoleaverealparkingn;

CREATE INDEX timetoleaverealparkingn
    ON public.detections_plates_parking USING btree
    (timetoleavereal)
    TABLESPACE artic;
	
	
	
	-- Table: public.detections_plates_ticket

-- DROP TABLE public.detections_plates_ticket;

CREATE TABLE public.detections_plates_ticket
(
    location text COLLATE pg_catalog."default" NOT NULL,
    insertiontimestamp bigint NOT NULL,
    detectiontimestamp bigint NOT NULL,
    ticketabsolutenumber bigint,
    tickettimetoleave bigint,
    priority boolean,
    detectionplate text COLLATE pg_catalog."default" NOT NULL,
    detectionlane integer,
    detectioncountry text COLLATE pg_catalog."default",
    ticketrelativenumber bigint,
    tickettimestamp bigint,
    length double precision,
    value jsonb,
    CONSTRAINT detections_plates_ticket_pkey PRIMARY KEY (detectionplate)
        USING INDEX TABLESPACE artic
)
WITH (
    OIDS = FALSE
)
TABLESPACE artic;

ALTER TABLE public.detections_plates_ticket
    OWNER to aluvisa;

-- Index: detectiontimestampticket

-- DROP INDEX public.detectiontimestampticket;

CREATE INDEX detectiontimestampticket
    ON public.detections_plates_ticket USING btree
    (detectiontimestamp)
    TABLESPACE artic;

-- Index: insertiontimestampticket

-- DROP INDEX public.insertiontimestampticket;

CREATE INDEX insertiontimestampticket
    ON public.detections_plates_ticket USING btree
    (insertiontimestamp)
    TABLESPACE artic;

-- Index: locationticket

-- DROP INDEX public.locationticket;

CREATE INDEX locationticket
    ON public.detections_plates_ticket USING btree
    (location COLLATE pg_catalog."default")
    TABLESPACE artic;

-- Index: priorityticket

-- DROP INDEX public.priorityticket;

CREATE INDEX priorityticket
    ON public.detections_plates_ticket USING btree
    (priority)
    TABLESPACE artic;

-- Index: ticketabsolutenumberticket

-- DROP INDEX public.ticketabsolutenumberticket;

CREATE INDEX ticketabsolutenumberticket
    ON public.detections_plates_ticket USING btree
    (ticketabsolutenumber)
    TABLESPACE artic;

-- Index: tickettimetoleaveticket

-- DROP INDEX public.tickettimetoleaveticket;

CREATE INDEX tickettimetoleaveticket
    ON public.detections_plates_ticket USING btree
    (tickettimetoleave)
    TABLESPACE artic;
	
	
	
	-- Table: public.detections_plates_transit

-- DROP TABLE public.detections_plates_transit;

CREATE TABLE public.detections_plates_transit
(
    location text COLLATE pg_catalog."default" NOT NULL,
    insertiontimestamp bigint NOT NULL,
    detectiontimestamp bigint NOT NULL,
    ticketabsolutenumber bigint,
    tickettimetoleave bigint,
    timetoleavereal bigint,
    timestampexit bigint,
    timestampbarrier1 bigint,
    timestampbarrier2 bigint,
    priority boolean,
    parking text COLLATE pg_catalog."default",
    manual boolean,
    accessmethodbarrier2 integer,
    detectionplate text COLLATE pg_catalog."default" NOT NULL,
    detectionlane integer,
    detectioncountry text COLLATE pg_catalog."default",
    ticketrelativenumber bigint,
    tickettimestamp bigint,
    length double precision,
    value jsonb,
    CONSTRAINT detections_plates_transit_pkey1 PRIMARY KEY (detectionplate)
        USING INDEX TABLESPACE artic
)
WITH (
    OIDS = FALSE
)
TABLESPACE artic;

ALTER TABLE public.detections_plates_transit
    OWNER to aluvisa;

-- Index: accessbarrier2transitn

-- DROP INDEX public.accessbarrier2transitn;

CREATE INDEX accessbarrier2transitn
    ON public.detections_plates_transit USING btree
    (accessmethodbarrier2)
    TABLESPACE artic;

-- Index: detectiontimestamptransitn

-- DROP INDEX public.detectiontimestamptransitn;

CREATE INDEX detectiontimestamptransitn
    ON public.detections_plates_transit USING btree
    (detectiontimestamp)
    TABLESPACE artic;

-- Index: insertiontimestamptransitn

-- DROP INDEX public.insertiontimestamptransitn;

CREATE INDEX insertiontimestamptransitn
    ON public.detections_plates_transit USING btree
    (insertiontimestamp)
    TABLESPACE artic;

-- Index: locationtransitn

-- DROP INDEX public.locationtransitn;

CREATE INDEX locationtransitn
    ON public.detections_plates_transit USING btree
    (location COLLATE pg_catalog."default")
    TABLESPACE artic;

-- Index: manualtransitn

-- DROP INDEX public.manualtransitn;

CREATE INDEX manualtransitn
    ON public.detections_plates_transit USING btree
    (manual)
    TABLESPACE artic;

-- Index: parkingtransitn

-- DROP INDEX public.parkingtransitn;

CREATE INDEX parkingtransitn
    ON public.detections_plates_transit USING btree
    (parking COLLATE pg_catalog."default")
    TABLESPACE artic;

-- Index: prioritytransitn

-- DROP INDEX public.prioritytransitn;

CREATE INDEX prioritytransitn
    ON public.detections_plates_transit USING btree
    (priority)
    TABLESPACE artic;

-- Index: ticketabsolutenumbertransitn

-- DROP INDEX public.ticketabsolutenumbertransitn;

CREATE INDEX ticketabsolutenumbertransitn
    ON public.detections_plates_transit USING btree
    (ticketabsolutenumber)
    TABLESPACE artic;

-- Index: tickettimetoleavetransitn

-- DROP INDEX public.tickettimetoleavetransitn;

CREATE INDEX tickettimetoleavetransitn
    ON public.detections_plates_transit USING btree
    (tickettimetoleave)
    TABLESPACE artic;

-- Index: timestampbarrier1transitn

-- DROP INDEX public.timestampbarrier1transitn;

CREATE INDEX timestampbarrier1transitn
    ON public.detections_plates_transit USING btree
    (timestampbarrier1)
    TABLESPACE artic;

-- Index: timestampbarrier2transitn

-- DROP INDEX public.timestampbarrier2transitn;

CREATE INDEX timestampbarrier2transitn
    ON public.detections_plates_transit USING btree
    (timestampbarrier2)
    TABLESPACE artic;

-- Index: timestampexittransitn

-- DROP INDEX public.timestampexittransitn;

CREATE INDEX timestampexittransitn
    ON public.detections_plates_transit USING btree
    (timestampexit)
    TABLESPACE artic;

-- Index: timetoleaverealtransitn

-- DROP INDEX public.timetoleaverealtransitn;

CREATE INDEX timetoleaverealtransitn
    ON public.detections_plates_transit USING btree
    (timetoleavereal)
    TABLESPACE artic;
	
	
	
	-- Table: public.ticket_machine_plates

-- DROP TABLE public.ticket_machine_plates;

CREATE TABLE public.ticket_machine_plates
(
    "timestamp" bigint NOT NULL,
    plate text COLLATE pg_catalog."default" NOT NULL,
    absolutenumber bigint,
    relativenumber bigint,
    parking text COLLATE pg_catalog."default",
    priority boolean,
    manual boolean,
    result integer,
    timetoleave bigint,
    type integer,
    value jsonb,
    CONSTRAINT ticket_machine_plates_pkey PRIMARY KEY ("timestamp", plate)
        USING INDEX TABLESPACE artic
)
WITH (
    OIDS = FALSE
)
TABLESPACE artic;

ALTER TABLE public.ticket_machine_plates
    OWNER to aluvisa;