Changes between Version 9 and Version 10 of phase0

Timestamp:

03/06/24 23:58:13 (7 months ago)

Author:

201166

Comment:

--

phase0

@@ -133 +133 @@
     primary key (order_id, product_id)\\
 );\\
+
+----
+
+= Полнење на табели со информации (пример скрипти)
+----
+
+INSERT INTO users (first_name, last_name, phone_number, email, password, role)\\
+SELECT 'First' || (i) + 1,\\
+       'Last' || (i) + 1,\\
+       '123-456-7890',\\
+       'user' || (i) + 1 || '@example.com',\\
+       'password' || (i) + 1,\\
+       CASE\\
+           WHEN i <= 2 THEN 'ADMIN'\\
+           ELSE 'USER'\\
+           END\\
+FROM generate_series(10003, 12500) AS i;\\