add index for ops version. dont create table if existed.

zbryikt · zbryikt · commit 3abe1a04fcad · 2020-05-25T15:39:23.000+08:00
diff --git a/structure.sql b/structure.sql
@@ -1,16 +1,28 @@
-CREATE TABLE ops (
+CREATE TABLE IF NOT EXISTS ops (
   collection character varying(255) not null,
   doc_id character varying(255) not null,
   version integer not null,
   operation jsonb not null, -- {v:0, create:{...}} or {v:n, op:[...]}
   PRIMARY KEY (collection, doc_id, version)
 );
 
-CREATE TABLE snapshots (
+CREATE TABLE IF NOT EXISTS snapshots (
   collection character varying(255) not null,
   doc_id character varying(255) not null,
   doc_type character varying(255) not null,
   version integer not null,
   data jsonb not null,
   PRIMARY KEY (collection, doc_id)
 );
+
+CREATE INDEX IF NOT EXISTS ops_version ON snapshots (collection, doc_id, version);
+
+ALTER TABLE ops
+  ALTER COLUMN operation
+  SET DATA TYPE jsonb
+  USING operation::jsonb;
+
+ALTER TABLE snapshots
+  ALTER COLUMN data
+  SET DATA TYPE jsonb
+  USING data::jsonb;
