diff options
| author | Serghei Cebotari <serghei@cebotari.ru> | 2024-01-18 22:35:09 +0300 |
|---|---|---|
| committer | Serghei Cebotari <serghei@cebotari.ru> | 2024-01-23 23:30:48 +0300 |
| commit | 2a759b8d39697c6d5512ec41c2b64d3099479d00 (patch) | |
| tree | 1c4db350985d37722b1cab1aceedd6e976932d87 /Database | |
| parent | 3580e84f53338770f09153cfc9ac10e59bb869c3 (diff) | |
Update sql script
Diffstat (limited to 'Database')
| -rw-r--r-- | Database/init-database.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/Database/init-database.sql b/Database/init-database.sql index 91e9f95..9adc7c8 100644 --- a/Database/init-database.sql +++ b/Database/init-database.sql @@ -14,12 +14,14 @@ CREATE TABLE "Products" ( "ProductLines" text[] NOT NULL, "IsOnWarehouse" boolean NOT NULL, "ProductMeasure" integer NOT NULL, - "DeliveryMakeUp" double precision NULL, + "DeliveryMakeUp" double precision, "Price" numeric NOT NULL, CONSTRAINT "PK_Products" PRIMARY KEY ("Id") ); +CREATE INDEX "IX_Products_Name" ON "Products" USING GIN (to_tsvector('russian', "Name")); + INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion") -VALUES ('20230511043408_Init', '7.0.5'); +VALUES ('20240117210635_Init', '8.0.0'); COMMIT;
\ No newline at end of file |