forked from spurtcms/spurtcms
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdefaults.sql
More file actions
executable file
·40 lines (16 loc) · 12.6 KB
/
Copy pathdefaults.sql
File metadata and controls
executable file
·40 lines (16 loc) · 12.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
-- channels default
INSERT INTO tbl_channels(channel_name, slug_name, field_group_id, is_active, is_deleted, created_on, created_by,channel_description,channel_type,tenant_id) VALUES ('Default Channel', 'default_channel', 0, 1, 0, 'current-time', u_id, 'default description','mychannels',tid);
INSERT INTO tbl_channel_categories(channel_id, category_id, created_at, created_on,tenant_id) VALUES (chid,'mapcat', u_id, 'current-time',tid);
INSERT INTO tbl_member_groups(name,slug,description,is_active,is_deleted,created_on,created_by,tenant_id) VALUES ('Default Group', 'default-group', 'Default Group', 1,0, 'current-time', u_id,tid);
-- only three block is tenant based
INSERT INTO tbl_member_settings (allow_registration,member_login,notification_users,tenant_id) VALUES (1,'password','u_id',tid)
INSERT INTO tbl_email_configurations (selected_type,tenant_id) VALUES ('environment',tid)
INSERT INTO tbl_general_settings (date_format,expand_logo_path,language_id,logo_path,storage_type,tenant_id,time_format,time_zone) VALUES ('dd mmm yyyy','/public/img/logo-bg.svg',1,'/public/img/logo1.svg','aws',tid,'12','Asia/Kolkata')
INSERT INTO tbl_graphql_settings (token_name,description,duration,created_by,created_on,is_deleted,token,is_default,tenant_id) VALUES ('Default Token','Default Token','Unlimited',u_id,'current-time',0,'apikey',1,tid)
-- default Email-template based on tenant
INSERT INTO tbl_email_templates(template_slug, template_subject, template_message, template_description, module_id, created_on, created_by, is_deleted, is_active,template_name,tenant_id)VALUES ('createuser', 'Confirm user registration', '<tr><td><p style="margin-left:0;"> </p><h1 style="font-size: 1.25rem; font-weight: bold;line-height: 1.6875rem;color:#000000; margin:0 0 .75rem 0;">Dear <strong>{FirstName}</strong>,</h1></td></tr><tr><td><p style="color:#000000;font-size:.875rem;">Congratulations! Your SpurtCMS account has been successfully created.</p><p style="color:#000000;font-size:.875rem;">Log in at</p><p style="color:#000000;font-size:.875rem;">{Loginurl}</p><p style="color:#000000;font-size:.875rem;margin:0 0 1rem;">and start using your Admin Account.</p></td></tr><tr><td><p style="color:#000000;font-size:1rem;line-height:normal;margin:0 0 .75rem;">Best Regards,</p><p style="color:#000000;font-size:1rem;font-weight:500;line-height:1.5rem;margin:0 0 1rem;"><strong>Spurt CMS Admin</strong></p></td></tr>', 'Change Password: Enable this toggle to activate the Change Password email template, which confirms to users that their password has been successfully changed.', 0, 'current-time', 1, 0, 1,'Create Admin User',tid);
INSERT INTO tbl_email_templates(template_slug,template_subject,template_description,template_message,module_id,created_on,created_by,is_deleted,is_active,template_name,tenant_id)VALUES('OTPGenerate','Confirm OTPs','OTP email template, which sends a One-Time Password (OTP) to users for verification.','<tr><td><p style="margin-left:0;"> </p><h1 style="font-size: 1.25rem; font-weight: bold;line-height: 1.6875rem;color:#000000; margin:0 0 1rem 0;">Dear {FirstName}</h1></td></tr><tr><td><p style="font-size: .875rem; line-height: 1.5rem; color: #000000;margin:0;">As requsted, here is your One-Time Password (OTP) to log in to SpurtCMS:</p><h3 style="font-size: 1.25rem; line-height:1; font-weight: bold; color: #000000; margin:1.25rem 0;">OTP:{OTP}</h3><p style="font-size: .875rem; line-height: 1.5rem; color: #000000;margin:0 0 1.25rem 0;">Please use this OTP within <span style="font-size: 1rem; font-weight:bold;">{Expirytime}</span> to complete the login process. If you do not log in within this time frame, you may request a new OTP.</p><p style="font-size: .875rem; line-height: 1.5rem; color: #000000;margin:0 0 1.25rem 0;">If you encounter any issue or need assistance, feel free to reach out to our support team.</p><p style="font-size: .875rem; line-height: 1.5rem; color: #000000;margin:0 0 1.25rem 0;">Thank you for using <span style="font-size: 1rem;">SpurtCMS.</span></p><p style="font-size: 1rem; line-height: normal; color: #000000;margin:0 0 .9375rem 0;">Best Regards,</p><p style="font-size: 1rem; line-height:normal; color: #000000;margin:0 0 .625rem 0;"><b>SpurtCMS Team</b></p></td></tr>',0,'current-time',1, 0,1,'OTP Generation',tid)
INSERT INTO tbl_email_templates(template_slug,template_subject,template_description,template_message,module_id,created_on,created_by,is_deleted,is_active,template_name,tenant_id)VALUES('Createmember','Member registration','Notifies member that they have been created as a member on the platform.','<tr><td><p style="margin-left:0;"> </p><h1 style="font-size: 1.25rem; font-weight: bold;line-height: 1.6875rem;color:#000000; margin:0 0 .75rem 0;">Dear <strong>{FirstName}</strong>,</h1></td></tr><tr><td><p style="color:#000000;font-size:.875rem;">Were glad to have you as a member at spurtCMS. Your membership has been confirmed.</p><p style="color:#000000;font-size:.875rem;">Log in at</p><p style="color:#000000;font-size:.875rem;">{Loginurl}</p><p style="color:#000000;font-size:.875rem;margin:0 0 1rem;">and indulge in Member related activities and explore our exclusive content.</p></td></tr><tr><td><p style="color:#000000;font-size:1rem;line-height:normal;margin:0 0 .75rem;">Best Regards,</p><p style="color:#000000;font-size:1rem;font-weight:500;line-height:1.5rem;margin:0 0 1rem;"><strong>Spurt CMS Admin</strong></p></td></tr>' ,6,'current-time',1, 0,1,'Send Member Login credentials',tid)
INSERT INTO tbl_email_templates(template_slug,template_subject,template_description,template_message,module_id,created_on,created_by,is_deleted,is_active,template_name,tenant_id)VALUES('Logined successfully','User login successfully','User conformation account is login successfully','<tr><td><p style="margin-left:0;"> </p><h1 style="font-size: 1.25rem; font-weight: bold;line-height: 1.6875rem;color:#000000; margin:0 0 .75rem 0;">Dear <strong>{FirstName}</strong>,</h1></td></tr><tr><td><p style="color:#000000;font-size:.875rem;">Congratulations! Your SpurtCMS account has been logged in successfully.</p><p style="color:#000000;font-size:.875rem;margin:0 0 1rem;">Start using your Admin Account.</p></td></tr><tr><td><p style="color:#000000;font-size:1rem;line-height:normal;margin:0 0 .75rem;">Best Regards,</p><p style="color:#000000;font-size:1rem;font-weight:500;line-height:1.5rem;margin:0 0 1rem;"><strong>Spurt CMS Admin</strong></p></td></tr>',0,'current-time',1, 0,1,'Send User Login Email',tid)
INSERT INTO tbl_email_templates(template_slug,template_subject,template_description,template_message,module_id,created_on,created_by,is_deleted,is_active,template_name,tenant_id)VALUES('Forgot Password','Reset password link','Forgot Password email template, which sends a confirmation and reset password link to users.', '<tr><td style="padding: 1.7188rem 1.5rem;border-bottom: .0625rem solid #F5F5F6;background-color: #FDFDFE;"><a href="javascript:void(0)" style="display: inline-block;"><img src="{AdminLogo}" alt="" style="display: block; height:20px"></a></td></tr><tr><td style="padding:2.5rem 1.5rem 0rem;"><h2 style="font-family: "Lexend", sans-serif;font-size: .875rem;font-weight: 400;line-height: 1.125rem;letter-spacing: 0em;text-align: left;color: #525252;margin-bottom: 1.25rem;">Dear <span style="font-family: "Lexend", sans-serif;font-size: 1rem;font-weight: 500;line-height: 20px;letter-spacing: 0em;text-align: left;color: #152027;">{FirstName},</span></h2></td></tr><tr><td style="padding: 0rem 1.5rem;"><p style="font-family: "Lexend", sans-serif;font-size: 14px;font-weight: 400;line-height: 18px;letter-spacing: 0em;text-align: left;color: #525252;margin: 0;">You recently requested to reset your password for spurtCMS admin login.</p><p style="font-family: "Lexend", sans-serif;font-size: 14px;font-weight: 400;line-height: 18px;letter-spacing: 0em;text-align: left;color: #525252;margin-bottom: 1.5rem">Click the link below to reset it.</p></td></tr><tr><td style="padding: 0rem 1.5rem;"><a href="{Passwordurl}" style="color: #2FACD6;text-decoration: underline;">{Passwordurlpath}</a><p class="mb-1" style="font-family: "Lexend", sans-serif;font-size: 14px;font-weight: 400;line-height: 18px;letter-spacing: 0em;text-align: left;color: #525252;">If you did not request a password reset, please ignore this email.</p></td></tr><tr><td style=" padding: 0rem 1.5rem 2.5rem;"><h2 style="font-family: "Lexend", sans-serif;font-size: .75rem;font-weight: 400;line-height: .9375rem;letter-spacing: 0em;text-align: left;color: #525252;margin-bottom: .5rem;">Best Regards,</h2><p style="font-family: "Lexend", sans-serif;font-size: .875rem;font-weight: 400;line-height: 1.125rem;letter-spacing: 0em;text-align: left;color: #152027;"> Spurt CMS Admin</p></td></tr><tr><td style="padding: 1.5rem 1.5rem 2.5rem;text-align: center;border-top: 1px solid #EDEDED;"><a href="javascript:void(0)" style="font-family: "Lexend", sans-serif;font-size: .75rem;font-weight: 300;line-height: .9375rem;letter-spacing: 0em;text-align: center;color: #525252;text-decoration: none;">Privacy policy • Contact us • Read our blog • Join SpurtCMS</a><div style="margin-top: 1rem;"><a href="javascript:void(0)" style="display: inline-block;"><img style="width:24px" src="{TwitterLogo}" alt="" style="margin-right: 1rem;"></a> <a href="javascript:void(0)" style="display: inline-block;"><img style="width:24px" src="{FbLogo}" alt="" style="margin-right: 1rem;"></a><a href="javascript:void(0)" style="display: inline-block;"><img style="width:24px" src="{LinkedinLogo}" alt="" style="margin-right: 1rem;"></a></div></td></tr></tr>' ,6,'2023-11-24 14:56:12',1, 0,1,'Forgot Password',tid)
INSERT INTO tbl_email_templates(template_slug,template_subject,template_description,template_message,module_id,created_on,created_by,is_deleted,is_active,template_name,tenant_id)VALUES('Forgot Password','Reset password link','Forgot Password email template, which sends a confirmation and reset password link to users.', '<tr><td style="padding: 1.7188rem 1.5rem;border-bottom: .0625rem solid #F5F5F6;background-color: #FDFDFE;"><a href="javascript:void(0)" style="display: inline-block;"><img src="{AdminLogo}" alt="" style="display: block; height:20px"></a></td></tr><tr><td style="padding:2.5rem 1.5rem 0rem;"><h2 style="font-family: "Lexend", sans-serif;font-size: .875rem;font-weight: 400;line-height: 1.125rem;letter-spacing: 0em;text-align: left;color: #525252;margin-bottom: 1.25rem;">Dear <span style="font-family: "Lexend", sans-serif;font-size: 1rem;font-weight: 500;line-height: 20px;letter-spacing: 0em;text-align: left;color: #152027;">{FirstName},</span></h2></td></tr><tr><td style="padding: 0rem 1.5rem;"><p style="font-family: "Lexend", sans-serif;font-size: 14px;font-weight: 400;line-height: 18px;letter-spacing: 0em;text-align: left;color: #525252;margin: 0;">You recently requested to reset your password for spurtCMS admin login.</p><p style="font-family: "Lexend", sans-serif;font-size: 14px;font-weight: 400;line-height: 18px;letter-spacing: 0em;text-align: left;color: #525252;margin-bottom: 1.5rem">Click the link below to reset it.</p></td></tr><tr><td style="padding: 0rem 1.5rem;"><a href="{Passwordurl}" style="color: #2FACD6;text-decoration: underline;">{Passwordurlpath}</a><p class="mb-1" style="font-family: "Lexend", sans-serif;font-size: 14px;font-weight: 400;line-height: 18px;letter-spacing: 0em;text-align: left;color: #525252;">If you did not request a password reset, please ignore this email.</p></td></tr><tr><td style=" padding: 0rem 1.5rem 2.5rem;"><h2 style="font-family: "Lexend", sans-serif;font-size: .75rem;font-weight: 400;line-height: .9375rem;letter-spacing: 0em;text-align: left;color: #525252;margin-bottom: .5rem;">Best Regards,</h2><p style="font-family: "Lexend", sans-serif;font-size: .875rem;font-weight: 400;line-height: 1.125rem;letter-spacing: 0em;text-align: left;color: #152027;"> Spurt CMS Admin</p></td></tr><tr><td style="padding: 1.5rem 1.5rem 2.5rem;text-align: center;border-top: 1px solid #EDEDED;"><a href="javascript:void(0)" style="font-family: "Lexend", sans-serif;font-size: .75rem;font-weight: 300;line-height: .9375rem;letter-spacing: 0em;text-align: center;color: #525252;text-decoration: none;">Privacy policy • Contact us • Read our blog • Join SpurtCMS</a><div style="margin-top: 1rem;"><a href="javascript:void(0)" style="display: inline-block;"><img style="width:24px" src="{TwitterLogo}" alt="" style="margin-right: 1rem;"></a> <a href="javascript:void(0)" style="display: inline-block;"><img style="width:24px" src="{FbLogo}" alt="" style="margin-right: 1rem;"></a><a href="javascript:void(0)" style="display: inline-block;"><img style="width:24px" src="{LinkedinLogo}" alt="" style="margin-right: 1rem;"></a></div></td></tr></tr>' ,6,'2023-11-24 14:56:12',1, 0,1,'Forgot Password',tid)