Changes between Version 5 and Version 6 of ddlScript

Timestamp:

01/22/25 15:43:09 (8 days ago)

Author:

223270

Comment:

--

ddlScript

@@ -1 +1 @@
 {{{
-DROP TABLE IF EXISTS DESTINACII CASCADE;
-DROP TABLE IF EXISTS KORISNICI CASCADE;
-DROP TABLE IF EXISTS STANDARD CASCADE;
-DROP TABLE IF EXISTS PREMIUM  CASCADE;
-DROP TABLE IF EXISTS RECENZII CASCADE;
-DROP TABLE IF EXISTS METEROLOSHKASOSTOJBA CASCADE;
-DROP TABLE IF EXISTS PAKETI CASCADE;
-DROP TABLE IF EXISTS AKTIVNOSTI CASCADE;
-DROP TABLE IF EXISTS REZERVACII CASCADE;
-DROP TABLE IF EXISTS PREFERENCI CASCADE;
-DROP TABLE IF EXISTS NASTANI CASCADE;
-DROP TABLE IF EXISTS TAGOVI CASCADE;
+DROP TABLE IF EXISTS NASTANI;
+DROP TABLE IF EXISTS PREFERENCI;
+DROP TABLE IF EXISTS PAKETI;
+DROP TABLE IF EXISTS RECENZII;
+DROP TABLE IF EXISTS REZERVACII;
+DROP TABLE IF EXISTS PREMIUM;
+DROP TABLE IF EXISTS STANDARD;
+DROP TABLE IF EXISTS KORISNICI;
+DROP TABLE IF EXISTS AKTIVNOSTI;
+DROP TABLE IF EXISTS METEROLOSHKASOSTOJBA;
+DROP TABLE IF EXISTS DESTINACII;
+DROP TABLE IF EXISTS TAGOVI;
 
 CREATE TABLE TAGOVI (
@@ -25 +25 @@
     preporachanaSezona VARCHAR(255) NOT NULL,
     prosechnaTemp DECIMAL(5, 2),
-    -- geoLokacija GEOGRAPHY(Point, 4326)  KOORDINATI
     lat DECIMAL(9, 6),   
-        lon DECIMAL(9, 6),
+    lon DECIMAL(9, 6),
     drzhava VARCHAR(255),
     popularnost INT,
@@ -33 +32 @@
     opis VARCHAR(255) NOT NULL, 
     idTag INT,
-        CONSTRAINT fk_tag_dest FOREIGN KEY (idTag) REFERENCES TAGOVI(idTag)
+    CONSTRAINT fk_tag_dest FOREIGN KEY (idTag) REFERENCES TAGOVI(idTag)
 );
 
@@ -150 +149 @@
     CONSTRAINT fk_dest_nastan FOREIGN KEY (idDest) REFERENCES DESTINACII(idDest)
 );
-
-ALTER TABLE DESTINACII ADD FOREIGN KEY (idTag) REFERENCES TAGOVI(idTag);
 }}}