Changes between Version 18 and Version 19 of phase0

Timestamp:

03/07/24 00:03:23 (10 months ago)

Author:

201166

Comment:

--

phase0

@@ -149 +149 @@
            ELSE 'USER'\\
            END\\
-FROM generate_series(10003, 12500) AS i;\\
+FROM generate_series(1, 10000) AS i;\\
+
+----
+
+SELECT setseed(0.5);\\
+DO\\
+$$\\
+    DECLARE\\
+        i integer;\\
+    BEGIN\\
+        FOR i IN 1..(500 + floor(random() * 501))\\
+            LOOP\\
+                INSERT INTO category (name, category_id)\\
+                VALUES ('Category_' !|| i,\\
+                        CASE\\
+                            WHEN random() < 0.2 THEN NULL\\
+                            ELSE (SELECT id FROM category WHERE random() < 0.4 LIMIT 1)\\
+                            END);\\
+            END LOOP;\\
+    END\\
+$$;\\