Skip to content

Instantly share code, notes, and snippets.

@PabloCastellano
Created July 8, 2023 10:21
Show Gist options
  • Save PabloCastellano/6c493d5adaa76c274af1871925821bde to your computer and use it in GitHub Desktop.
Save PabloCastellano/6c493d5adaa76c274af1871925821bde to your computer and use it in GitHub Desktop.
Differences between staging and production blobscan db schema
--- staging.sql 2023-07-08 12:19:13.712663068 +0200
+++ production.sql 2023-07-08 12:20:09.848668875 +0200
@@ -41,9 +41,9 @@
id text NOT NULL,
"versionedHash" text NOT NULL,
commitment text NOT NULL,
+ size integer NOT NULL,
"gsUri" text NOT NULL,
- "swarmHash" text,
- size integer NOT NULL
+ "swarmHash" text
);
@@ -146,8 +146,8 @@
id integer NOT NULL,
hash text NOT NULL,
number integer NOT NULL,
- "timestamp" timestamp(3) without time zone NOT NULL,
- slot integer NOT NULL
+ slot integer NOT NULL,
+ "timestamp" timestamp(3) without time zone NOT NULL
);
@@ -242,10 +242,10 @@
CREATE TABLE public."Transaction" (
id text NOT NULL,
hash text NOT NULL,
- "fromId" text NOT NULL,
- "toId" text,
"blockNumber" integer NOT NULL,
- "timestamp" timestamp(3) without time zone NOT NULL
+ "timestamp" timestamp(3) without time zone NOT NULL,
+ "fromId" text NOT NULL,
+ "toId" text
);
@@ -326,6 +326,24 @@
--
+-- Name: _prisma_migrations; Type: TABLE; Schema: public; Owner: blobscan
+--
+
+CREATE TABLE public._prisma_migrations (
+ id character varying(36) NOT NULL,
+ checksum character varying(64) NOT NULL,
+ finished_at timestamp with time zone,
+ migration_name character varying(255) NOT NULL,
+ logs text,
+ rolled_back_at timestamp with time zone,
+ started_at timestamp with time zone DEFAULT now() NOT NULL,
+ applied_steps_count integer DEFAULT 0 NOT NULL
+);
+
+
+ALTER TABLE public._prisma_migrations OWNER TO blobscan;
+
+--
-- Name: BlobDailyStats id; Type: DEFAULT; Schema: public; Owner: blobscan
--
@@ -464,6 +482,14 @@
--
+-- Name: _prisma_migrations _prisma_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: blobscan
+--
+
+ALTER TABLE ONLY public._prisma_migrations
+ ADD CONSTRAINT _prisma_migrations_pkey PRIMARY KEY (id);
+
+
+--
-- Name: BlobDailyStats_day_idx; Type: INDEX; Schema: public; Owner: blobscan
--
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment