Packages

eventstore

1.3.1
1.4.8 1.4.7 1.4.6 1.4.4 1.4.3 1.4.2 1.4.1 1.4.0 1.3.2 1.3.1 1.3.0 1.2.3 1.2.2 1.2.1 1.2.0 1.1.0 1.0.3 1.0.2 1.0.1 1.0.0 1.0.0-rc.0 0.17.0 0.16.2 0.16.1 0.16.0 0.15.1 0.15.0 0.14.0 0.14.0-rc.0 0.13.2 0.13.1 0.13.0 0.12.1 0.12.0 0.11.0 0.11.0-rc.0 0.10.1 0.10.0 0.9.0 0.8.1 0.8.0 0.7.4 0.7.3 0.7.2 0.7.1 0.7.0 0.6.2 0.6.1 0.6.0 0.5.2 0.5.1 0.5.0 0.4.3 0.4.2 0.4.1 0.4.0 0.3.0 0.2.1 0.2.0 0.1.0 0.0.5 0.0.4 0.0.3 0.0.2 0.0.1

Event store using PostgreSQL for persistence.

HexDocs

Current section

Files

Jump to
Readme
65 Versions
6 Dependencies
8 Dependants
Files
Activity
eventstore priv event_store migrations v0.13.0.sql
Raw

priv/event_store/migrations/v0.13.0.sql 

DO $$

BEGIN



  CREATE EXTENSION IF NOT EXISTS "uuid-ossp";



  CREATE TABLE IF NOT EXISTS schema_migrations

  (

      major_version int NOT NULL,

      minor_version int NOT NULL,

      patch_version int NOT NULL,

      migrated_at timestamp without time zone default (now() at time zone 'UTC') NOT NULL,

      PRIMARY KEY(major_version, minor_version, patch_version)

  );



  -- record schema migration

  INSERT INTO schema_migrations (major_version, minor_version, patch_version) VALUES (0, 13, 0);



  -- alter correlation_id and causation_id columns to type UUID

  ALTER TABLE events ALTER COLUMN correlation_id TYPE uuid USING correlation_id::uuid;

  ALTER TABLE events ALTER COLUMN causation_id TYPE uuid USING causation_id::uuid;



  -- rename event_id to event_number

  ALTER TABLE event_counter RENAME COLUMN event_id TO event_number;

  ALTER TABLE events RENAME COLUMN event_id TO event_number;

  ALTER TABLE subscriptions RENAME COLUMN last_seen_event_id TO last_seen_event_number;



  CREATE UNIQUE INDEX ix_events_event_number ON events (event_number);



  -- add event_id (UUID) as primary key

  ALTER TABLE events DROP CONSTRAINT events_pkey;

  ALTER TABLE events ADD COLUMN event_id uuid PRIMARY KEY default uuid_generate_v4();



END;

$$ LANGUAGE plpgsql;