diff options
| author | Sergey Chebotar <s.chebotar@gmail.com> | 2023-05-06 09:26:31 +0300 |
|---|---|---|
| committer | Sergey Chebotar <s.chebotar@gmail.com> | 2023-05-06 09:26:31 +0300 |
| commit | afe19fcf7e7b20acf0b55c454e965f1144330c00 (patch) | |
| tree | bfb3d0ce9a171d083dd5e73bb61154da8eebf05c /RhSolutions.Deploy/database/init-database.sql | |
| parent | ed6800e11d0636a518745b4504b47d5fe07c7592 (diff) | |
Deploy files edit
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 |