Changeset 9dd4182 for SQLScripts

Timestamp:

07/09/23 17:51:32 (17 months ago)

Author:

DarkoSasanski <darko.sasanski@…>

Branches:

main

Children:

99d8816

Parents:

708a5bc

Message:

updated sql scripts

File:

• SQLScripts/kreiranje.sql (modified) (2 diffs)

SQLScripts/kreiranje.sql

@@ -129 +129 @@
         dateCreated timestamp default now(),
         dateApproved timestamp,
+        dateDelivered timestamp,
         priority varchar(50) not null,
         managerUserId integer not null,
@@ -245 +246 @@
 
 );
+
+-------------------------
+
+alter table question_availability_for_storedarticle add constraint pk_question_availability_for_storedarticle primary key (questionId, sArticleId);
+
+-------------------------
+
+alter table article_belongs_to_category add constraint pk_article_belongs_to_category primary key (articleId, categoryId);
+
+-------------------------
+
+alter table supplier_supplies_category add constraint pk_supplier_supplies_category primary key (userId, categoryId);