-
Notifications
You must be signed in to change notification settings - Fork 29
/
test-spaces_and_components-dataset.sql
149 lines (124 loc) · 7.13 KB
/
test-spaces_and_components-dataset.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
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
/**
* Silverpeas domains
*/
INSERT INTO st_domain (id, name, propFilename, className, authenticationServer, silverpeasServerURL)
VALUES (0, 'Silverpeas', 'org.silverpeas.domains.domainSP',
'org.silverpeas.core.admin.domain.driver.SilverpeasDomainDriver', 'autDomainSP', '');
/**
* users
*/
INSERT INTO st_user (id, domainId, specificId, lastName, login, accessLevel, state, stateSaveDate)
VALUES (0, 0, '0', 'Administrateur', 'SilverAdmin', 'A', 'VALID', '2012-01-01 00:00:00.000');
INSERT INTO st_user (id, domainId, specificId, lastName, login, accessLevel, state, stateSaveDate)
VALUES (1, 0, '1', 'Toto', 'toto', 'U', 'VALID', '2012-01-01 00:00:00.000');
INSERT INTO st_user (id, domainId, specificId, lastName, login, accessLevel, state, stateSaveDate)
VALUES (2, 0, '2', 'SimpleUser', 'SimpleUser', 'U', 'VALID', '2012-01-01 00:00:00.000');
INSERT INTO st_user (id, domainId, specificId, lastName, login, accessLevel, state, stateSaveDate)
VALUES (3, 0, '3', 'Hetfield', 'Hetfield', 'U', 'VALID', '2012-01-01 00:00:00.000');
/**
* user groups
*/
INSERT INTO st_group (id, domainId, specificId, name, state, stateSaveDate)
VALUES (1, 0, '1', 'Groupe 1', 'VALID', '2012-01-01 00:00:00.000');
INSERT INTO st_group (id, domainId, specificId, name, state, stateSaveDate)
VALUES (2, 0, '2', 'Groupe 2', 'VALID', '2012-01-01 00:00:00.000');
/**
* users in the default Silverpeas domain
*/
INSERT INTO domainsp_user (id, lastName, login) VALUES (0, 'Administrateur', 'SilverAdmin');
INSERT INTO domainsp_user (id, lastName, login) VALUES (1, 'Toto', 'toto');
INSERT INTO domainsp_user (id, lastName, login) VALUES (2, 'SimpleUser', 'SimpleUser');
INSERT INTO domainsp_user (id, lastName, login) VALUES (3, 'Hetfield', 'Hetfield');
/**
* groups in the default Silverpeas domain
*/
INSERT INTO domainsp_group (id, name) VALUES (1, 'Groupe 1');
INSERT INTO domainsp_group (id, name) VALUES (2, 'Groupe 2');
/**
* spaces
*/
INSERT INTO st_space (id, domainFatherId, name, lang, firstPageType, isInheritanceBlocked)
VALUES (1, NULL, 'Space 1', 'fr', 0, 0);
INSERT INTO st_space (id, domainFatherId, name, firstPageType, isInheritanceBlocked)
VALUES (2, 1, 'Space 1-2', 0, 0);
INSERT INTO st_space (id, domainFatherId, name, firstPageType, isInheritanceBlocked)
VALUES (3, NULL, 'Space 2', 0, 0);
INSERT INTO st_space (id, domainFatherId, name, firstPageType, isInheritanceBlocked)
VALUES (4, NULL, 'Space 4', 0, 0);
INSERT INTO st_space (id, domainFatherId, name, firstPageType, isInheritanceBlocked)
VALUES (5, 4, '4.1 (Inheritance blocked)', 0, 1);
INSERT INTO st_space (id, domainFatherId, name, firstPageType, isInheritanceBlocked)
VALUES (6, 4, '4.2 (Inheritance enabled)', 0, 0);
INSERT INTO st_space (id, domainFatherId, name, firstPageType, isInheritanceBlocked)
VALUES (100, NULL, 'Space 100', 0, 0);
INSERT INTO st_space (id, domainFatherId, name, firstPageType, isInheritanceBlocked)
VALUES (110, 100, 'Space 110', 0, 0);
/**
* multilang support in spaces
*/
INSERT INTO st_spacei18n (id, spaceId, lang, name) VALUES (1, 2, 'en', 'Space 1-2 in english');
/**
* component instances (application instances)
*/
INSERT INTO st_componentinstance (id, spaceId, name, componentName, isInheritanceBlocked)
VALUES (1, 1, 'GED', 'kmelia', 0);
INSERT INTO st_componentinstance (id, spaceId, name, componentName, isInheritanceBlocked)
VALUES (4, 1, 'GED (Inheritance blocked)', 'kmelia', 1);
INSERT INTO st_componentinstance (id, spaceId, name, componentName, isInheritanceBlocked)
VALUES (2, 2, 'Dates clés', 'almanach', 0);
INSERT INTO st_componentinstance (id, spaceId, name, componentName, isInheritanceBlocked)
VALUES (3, 3, 'Documents', 'kmelia', 0);
INSERT INTO st_componentinstance (id, spaceId, name, componentName, isInheritanceBlocked)
VALUES (200, 100, 'Documents In root Space', 'kmelia', 0);
INSERT INTO st_componentinstance (id, spaceId, name, componentName, isInheritanceBlocked)
VALUES (210, 110, 'Documents in sub space', 'kmelia', 0);
/**
* roles the users play in the spaces
*/
// Administrateur is publisher and user on space 1
INSERT INTO st_spaceuserrole (id, spaceId, roleName, isInherited) VALUES (1, 1, 'publisher', 0);
INSERT INTO st_spaceuserrole (id, spaceId, roleName, isInherited) VALUES (2, 1, 'reader', 0);
INSERT INTO st_spaceuserrole_user_rel (spaceUserRoleId, userId) VALUES (1, 1);
INSERT INTO st_spaceuserrole_user_rel (spaceUserRoleId, userId) VALUES (2, 1);
// SimpleUser is publisher on space 3 and subspace 2
INSERT INTO st_spaceuserrole (id, spaceId, roleName, isInherited) VALUES (3, 3, 'publisher', 0);
INSERT INTO st_spaceuserrole (id, spaceId, roleName, isInherited) VALUES (4, 2, 'publisher', 0);
INSERT INTO st_spaceuserrole_user_rel (spaceUserRoleId, userId) VALUES (3, 2);
INSERT INTO st_spaceuserrole_user_rel (spaceUserRoleId, userId) VALUES (4, 2);
// Inherited profiles from space 1
INSERT INTO st_spaceuserrole (id, spaceId, roleName, isInherited) VALUES (5, 2, 'publisher', 1);
INSERT INTO st_spaceuserrole (id, spaceId, roleName, isInherited) VALUES (6, 2, 'reader', 1);
INSERT INTO st_spaceuserrole_user_rel (spaceUserRoleId, userId) VALUES (5, 1);
INSERT INTO st_spaceuserrole_user_rel (spaceUserRoleId, userId) VALUES (6, 1);
/**
* roles the users play in the component instances
*/
// Application GED inherits rights of its space
INSERT INTO st_userrole (id, instanceId, roleName, isInherited) VALUES (1, 1, 'publisher', 1);
INSERT INTO st_userrole (id, instanceId, roleName, isInherited) VALUES (2, 1, 'user', 1);
INSERT INTO st_userrole_user_rel (userRoleId, userId) VALUES (1, 1);
INSERT INTO st_userrole_user_rel (userRoleId, userId) VALUES (2, 1);
// Application Almanach inherits rights of its space
INSERT INTO st_userrole (id, instanceId, roleName, isInherited) VALUES (3, 2, 'publisher', 1);
INSERT INTO st_userrole (id, instanceId, roleName, isInherited) VALUES (4, 2, 'user', 1);
INSERT INTO st_userrole (id, instanceId, roleName, isInherited) VALUES (5, 2, 'user', 0);
INSERT INTO st_userrole_user_rel (userRoleId, userId) VALUES (3, 1);
INSERT INTO st_userrole_user_rel (userRoleId, userId) VALUES (3, 2);
INSERT INTO st_userrole_user_rel (userRoleId, userId) VALUES (4, 1);
INSERT INTO st_userrole_user_rel (userRoleId, userId) VALUES (5, 3);
// Application Documents inherits rights of its space
INSERT INTO st_userrole (id, instanceId, roleName, isInherited) VALUES (6, 3, 'publisher', 1);
INSERT INTO st_userrole_user_rel (userRoleId, userId) VALUES (6, 2);
/**
* Last Unique Id for tables used in tests
*/
INSERT INTO uniqueid (maxid, tableName) VALUES (3, 'st_user');
INSERT INTO uniqueid (maxid, tableName) VALUES (0, 'st_domain');
INSERT INTO uniqueid (maxid, tableName) VALUES (3, 'domainsp_user');
INSERT INTO uniqueid (maxid, tableName) VALUES (1, 'st_group');
INSERT INTO uniqueid (maxid, tableName) VALUES (1, 'domainsp_group');
INSERT INTO uniqueid (maxid, tableName) VALUES (199, 'st_space');
INSERT INTO uniqueid (maxid, tableName) VALUES (4, 'st_componentinstance');
INSERT INTO uniqueid (maxid, tableName) VALUES (6, 'st_spaceuserrole');
INSERT INTO uniqueid (maxid, tableName) VALUES (6, 'st_userrole');
INSERT INTO uniqueid (maxid, tableName) VALUES (1, 'st_spacei18n');