forked from Platformus/Platformus
-
Notifications
You must be signed in to change notification settings - Fork 0
/
sqlite_data.sql
99 lines (94 loc) · 5.47 KB
/
sqlite_data.sql
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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
BEGIN TRANSACTION;
--
-- Extension: Platformus.Security
-- Version: beta4
--
INSERT INTO "Users" VALUES (1,'Administrator','2017-01-01 00:00:00.0000000');
INSERT INTO "CredentialTypes" VALUES (1,'Email','Email',1);
INSERT INTO "Credentials" VALUES (1,1,1,'admin@platformus.net','8lE3xN2Ijiv/Y/aIGwaZLrbcqrt/1jDmzPTdudKbVD0=','0O/ZGwhScZRGbsmiUEckOg==');
INSERT INTO "Roles" VALUES (1,'Administrator','Administrator',100);
INSERT INTO "Roles" VALUES (2,'ApplicationOwner','Application owner',200);
INSERT INTO "Roles" VALUES (3,'ContentManager','Content manager',300);
INSERT INTO "UserRoles" VALUES (1,1);
INSERT INTO "UserRoles" VALUES (1,2);
INSERT INTO "Permissions" VALUES (1,'BrowseBackend','Browse backend',1);
INSERT INTO "Permissions" VALUES (2,'DoEverything','Do everything',100);
INSERT INTO "Permissions" VALUES (3,'BrowsePermissions','Browse permissions',200);
INSERT INTO "Permissions" VALUES (4,'BrowseRoles','Browse roles',210);
INSERT INTO "Permissions" VALUES (5,'BrowseUsers','Browse users',220);
INSERT INTO "Permissions" VALUES (6,'BrowseConfigurations','Browse configurations',300);
INSERT INTO "Permissions" VALUES (7,'BrowseCultures','Browse cultures',400);
INSERT INTO "Permissions" VALUES (8,'BrowseEndpoints','Browse endpoints',500);
INSERT INTO "Permissions" VALUES (9,'BrowseObjects','Browse objects',600);
INSERT INTO "Permissions" VALUES (10,'BrowseDataTypes','Browse data types',610);
INSERT INTO "Permissions" VALUES (11,'BrowseClasses','Browse classes',620);
INSERT INTO "Permissions" VALUES (12,'BrowseMenus','Browse menus',700);
INSERT INTO "Permissions" VALUES (13,'BrowseForms','Browse forms',800);
INSERT INTO "Permissions" VALUES (14,'BrowseFileManager','Browse file manager',900);
INSERT INTO "Permissions" VALUES (15,'BrowseViews','Browse views',1000);
INSERT INTO "Permissions" VALUES (16,'BrowseStyles','Browse styles',1010);
INSERT INTO "Permissions" VALUES (17,'BrowseScripts','Browse scripts',1020);
INSERT INTO "Permissions" VALUES (18,'BrowseBundles','Browse bundles',1030);
INSERT INTO "Permissions" VALUES (19,'BrowseCatalogs','Browse catalogs',1100);
INSERT INTO "Permissions" VALUES (20,'BrowseCategories','Browse categories',1110);
INSERT INTO "Permissions" VALUES (21,'BrowseProducts','Browse products',1120);
INSERT INTO "Permissions" VALUES (22,'BrowseCarts','Browse carts',1130);
INSERT INTO "Permissions" VALUES (23,'BrowseOrderStates','Browse order states',1140);
INSERT INTO "Permissions" VALUES (24,'BrowsePaymentMethods','Browse payment methods',1150);
INSERT INTO "Permissions" VALUES (25,'BrowseDeliveryMethods','Browse delivery methods',1160);
INSERT INTO "Permissions" VALUES (26,'BrowseOrders','Browse orders',1170);
INSERT INTO "RolePermissions" VALUES (1,1);
INSERT INTO "RolePermissions" VALUES (2,2);
INSERT INTO "RolePermissions" VALUES (3,9);
INSERT INTO "RolePermissions" VALUES (3,12);
INSERT INTO "RolePermissions" VALUES (3,13);
INSERT INTO "RolePermissions" VALUES (3,14);
--
-- Extension: Platformus.Configurations
-- Version: beta4
--
INSERT INTO "Configurations" VALUES (1,'Email','Email');
INSERT INTO "Configurations" VALUES (2,'Globalization','Globalization');
INSERT INTO "Variables" VALUES (1,1,'SmtpServer','SMTP server','test',1);
INSERT INTO "Variables" VALUES (2,1,'SmtpPort','SMTP port','25',2);
INSERT INTO "Variables" VALUES (3,1,'SmtpLogin','SMTP login','test',3);
INSERT INTO "Variables" VALUES (4,1,'SmtpPassword','SMTP password','test',4);
INSERT INTO "Variables" VALUES (5,1,'SmtpSenderEmail','SMTP sender email','test',5);
INSERT INTO "Variables" VALUES (6,1,'SmtpSenderName','SMTP sender name','test',6);
INSERT INTO "Variables" VALUES (7,2,'SpecifyCultureInUrl','Specify culture in URL','yes',1);
--
-- Extension: Platformus.Globalization
-- Version: beta4
--
INSERT INTO "Cultures" VALUES (1,'__','Neutral',1,0,0);
INSERT INTO "Cultures" VALUES (2,'en','English',0,1,1);
--
-- Extension: Platformus.Domain
-- Version: beta4
--
INSERT INTO "DataTypes" VALUES (1,'string','singleLinePlainText','Single line plain text',1);
INSERT INTO "DataTypes" VALUES (2,'string','multilinePlainText','Multiline plain text',2);
INSERT INTO "DataTypes" VALUES (3,'string','html','Html',3);
INSERT INTO "DataTypes" VALUES (4,'integer','integerNumber','Integer number',4);
INSERT INTO "DataTypes" VALUES (5,'decimal','decimalNumber','Decimal number',5);
INSERT INTO "DataTypes" VALUES (6,'integer','booleanFlag','Boolean flag',6);
INSERT INTO "DataTypes" VALUES (7,'string','image','Image',7);
INSERT INTO "DataTypes" VALUES (8,'datetime','date','Date',8);
INSERT INTO "DataTypeParameters" VALUES (1,1,'checkbox','IsRequired','Is required');
INSERT INTO "DataTypeParameters" VALUES (2,1,'numericTextBox','MaxLength','Max length');
INSERT INTO "DataTypeParameters" VALUES (3,2,'checkbox','IsRequired','Is required');
INSERT INTO "DataTypeParameters" VALUES (4,2,'numericTextBox','MaxLength','Max length');
INSERT INTO "DataTypeParameters" VALUES (5,7,'numericTextBox','Width','Width');
INSERT INTO "DataTypeParameters" VALUES (6,7,'numericTextBox','Height','Height');
INSERT INTO "DataTypeParameters" VALUES (7,8,'checkbox','IsRequired','Is required');
--
-- Extension: Platformus.Forms
-- Version: beta4
--
INSERT INTO "FieldTypes" VALUES (1,'TextBox','Text box',1);
INSERT INTO "FieldTypes" VALUES (2,'TextArea','Text area',2);
INSERT INTO "FieldTypes" VALUES (3,'Checkbox','Checkbox',3);
INSERT INTO "FieldTypes" VALUES (4,'RadioButtonList','Radio button list',4);
INSERT INTO "FieldTypes" VALUES (5,'DropDownList','Drop down list',5);
INSERT INTO "FieldTypes" VALUES (6,'FileUpload','File upload',6);
COMMIT;