From afe19fcf7e7b20acf0b55c454e965f1144330c00 Mon Sep 17 00:00:00 2001 From: Sergey Chebotar Date: Sat, 6 May 2023 09:26:31 +0300 Subject: Deploy files edit --- RhSolutions.Deploy/database/init-database.sql | 25 ------------------------- 1 file changed, 25 deletions(-) delete mode 100644 RhSolutions.Deploy/database/init-database.sql (limited to 'RhSolutions.Deploy/database/init-database.sql') diff --git a/RhSolutions.Deploy/database/init-database.sql b/RhSolutions.Deploy/database/init-database.sql deleted file mode 100644 index ec6ac7d..0000000 --- a/RhSolutions.Deploy/database/init-database.sql +++ /dev/null @@ -1,25 +0,0 @@ -CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" ( - "MigrationId" character varying(150) NOT NULL, - "ProductVersion" character varying(32) NOT NULL, - CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId") -); - -START TRANSACTION; - -CREATE TABLE "Products" ( - "Id" integer GENERATED BY DEFAULT AS IDENTITY, - "ProductSku" text NULL, - "DeprecatedSkus" text[] NOT NULL, - "Name" text NOT NULL, - "ProductLine" text NULL, - "IsOnWarehouse" boolean NULL, - "ProductMeasure" integer NOT NULL, - "DeliveryMakeUp" double precision NULL, - "Price" numeric(8,2) NOT NULL, - CONSTRAINT "PK_Products" PRIMARY KEY ("Id") -); - -INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion") -VALUES ('20221201071323_Init', '7.0.0'); - -COMMIT; \ No newline at end of file -- cgit v1.2.3