diff options
Diffstat (limited to 'RhSolutions.Deploy/database/init-database.sql')
-rw-r--r-- | RhSolutions.Deploy/database/init-database.sql | 25 |
1 files changed, 0 insertions, 25 deletions
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 |