From 2a759b8d39697c6d5512ec41c2b64d3099479d00 Mon Sep 17 00:00:00 2001
From: Serghei Cebotari <serghei@cebotari.ru>
Date: Thu, 18 Jan 2024 22:35:09 +0300
Subject: Update sql script

---
 Database/init-database.sql | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'Database/init-database.sql')

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
-- 
cgit v1.2.3

