Changes between Version 5 and Version 6 of DmlScript

Timestamp:

05/05/26 22:08:43 (3 weeks ago)

Author:

231141

Comment:

--

DmlScript

@@ -884 +884 @@
 
 
-
-
+INSERT INTO NotificationPreference
+(is_enabled, channel, user_id, notification_type_id)
+SELECT
+    (random() > 0.25)                     AS is_enabled,
+    channel                               AS channel,
+    u                                     AS user_id,
+    nt                                    AS notification_type_id
+FROM
+    generate_series((SELECT min(id) FROM useraccount), (SELECT max(id) FROM useraccount)) AS u,
+    generate_series(1, 20)                AS nt,
+    (VALUES ('EMAIL'), ('SMS'), ('PUSH')) AS c(channel)
+WHERE u IN (SELECT id FROM useraccount)  -- only real user IDs
+LIMIT 7000000;  
+
+--++++++++++ compalaints +++++++++++
 
 DO $$
@@ -984 +997 @@
 
 
---++++++++++ compalaints +++++++++++
 CREATE TEMP TABLE complaints_ordered AS
 SELECT