· 6 years ago · Apr 08, 2019, 05:40 AM
1apiVersion: v1
2kind: Namespace
3metadata:
4 name: wso2
5spec:
6 finalizers:
7 - kubernetes
8---
9
10apiVersion: v1
11kind: ServiceAccount
12metadata:
13 name: wso2svc-account
14 namespace: wso2
15secrets:
16 - name: wso2svc-account-token-t7s49
17---
18
19apiVersion: v1
20data:
21 .dockerconfigjson: eyJhdXRocyI6eyJkb2NrZXIud3NvMi5jb20iOiB7InVzZXJuYW1lIjoiZWR1c3N1cml5YWNAZ21haWwuY29tIiwicGFzc3dvcmQiOiJrYW5keSBzcmlsYW5rYSIsImVtYWlsIjoiZWR1c3N1cml5YWNAZ21haWwuY29tIiwiYXV0aCI6IlpXUjFjM04xY21sNVlXTkFaMjFoYVd3dVkyOXRPbXRoYm1SNUlITnlhV3hoYm10aCJ9fX0=
22kind: Secret
23metadata:
24 name: wso2creds
25 namespace: wso2
26type: kubernetes.io/dockerconfigjson
27---
28
29apiVersion: v1
30data:
31 carbon.xml: |
32 <?xml version="1.0" encoding="ISO-8859-1"?>
33 <Server xmlns="http://wso2.org/projects/carbon/carbon.xml">
34 <Name>WSO2 Identity Server</Name>
35 <ServerKey>IS</ServerKey>
36 <Version>5.7.0</Version>
37 <HostName>wso2is</HostName>
38 <MgtHostName>wso2is</MgtHostName>
39 <ServerURL>local:/${carbon.context}/services/</ServerURL>
40 <ServerRoles>
41 <Role>IdentityServer</Role>
42 </ServerRoles>
43 <Package>org.wso2.carbon</Package>
44 <WebContextRoot>/</WebContextRoot>
45 <ItemsPerPage>15</ItemsPerPage>
46 <Ports>
47 <Offset>0</Offset>
48 <JMX>
49 <RMIRegistryPort>9999</RMIRegistryPort>
50 <RMIServerPort>11111</RMIServerPort>
51 </JMX>
52 <EmbeddedLDAP>
53 <LDAPServerPort>10389</LDAPServerPort>
54 <KDCServerPort>8000</KDCServerPort>
55 </EmbeddedLDAP>
56 <ThriftEntitlementReceivePort>10500</ThriftEntitlementReceivePort>
57 </Ports>
58 <JNDI>
59 <DefaultInitialContextFactory>org.wso2.carbon.tomcat.jndi.CarbonJavaURLContextFactory</DefaultInitialContextFactory>
60 <Restrictions>
61 <AllTenants>
62 <UrlContexts>
63 <UrlContext>
64 <Scheme>java</Scheme>
65 </UrlContext>
66 </UrlContexts>
67 </AllTenants>
68 </Restrictions>
69 </JNDI>
70 <IsCloudDeployment>false</IsCloudDeployment>
71 <EnableMetering>false</EnableMetering>
72 <MaxThreadExecutionTime>600</MaxThreadExecutionTime>
73 <GhostDeployment>
74 <Enabled>false</Enabled>
75 </GhostDeployment>
76 <Tenant>
77 <LoadingPolicy>
78 <LazyLoading>
79 <IdleTime>30</IdleTime>
80 </LazyLoading>
81 </LoadingPolicy>
82 </Tenant>
83 <Cache>
84 <DefaultCacheTimeout>15</DefaultCacheTimeout>
85 <ForceLocalCache>false</ForceLocalCache>
86 </Cache>
87 <Axis2Config>
88 <RepositoryLocation>${carbon.home}/repository/deployment/server/</RepositoryLocation>
89 <DeploymentUpdateInterval>15</DeploymentUpdateInterval>
90 <ConfigurationFile>${carbon.home}/repository/conf/axis2/axis2.xml</ConfigurationFile>
91 <ServiceGroupContextIdleTime>30000</ServiceGroupContextIdleTime>
92 <clientAxis2XmlLocation>${carbon.home}/repository/conf/axis2/axis2_client.xml</clientAxis2XmlLocation>
93 <HideAdminServiceWSDLs>true</HideAdminServiceWSDLs>
94 </Axis2Config>
95 <ServiceUserRoles>
96 <Role>
97 <Name>admin</Name>
98 <Description>Default Administrator Role</Description>
99 </Role>
100 <Role>
101 <Name>user</Name>
102 <Description>Default User Role</Description>
103 </Role>
104 </ServiceUserRoles>
105 <CryptoService>
106 <Enabled>true</Enabled>
107 <InternalCryptoProviderClassName>org.wso2.carbon.crypto.provider.KeyStoreBasedInternalCryptoProvider</InternalCryptoProviderClassName>
108 <ExternalCryptoProviderClassName>org.wso2.carbon.core.encryption.KeyStoreBasedExternalCryptoProvider</ExternalCryptoProviderClassName>
109 <KeyResolvers>
110 <KeyResolver className="org.wso2.carbon.crypto.defaultProvider.resolver.ContextIndependentKeyResolver" priority="-1"/>
111 </KeyResolvers>
112 </CryptoService>
113 <Security>
114 <KeyStore>
115 <Location>${carbon.home}/repository/resources/security/wso2carbon.jks</Location>
116 <Type>JKS</Type>
117 <Password>wso2carbon</Password>
118 <KeyAlias>wso2carbon</KeyAlias>
119 <KeyPassword>wso2carbon</KeyPassword>
120 </KeyStore>
121 <InternalKeyStore>
122 <Location>${carbon.home}/repository/resources/security/wso2carbon.jks</Location>
123 <Type>JKS</Type>
124 <Password>wso2carbon</Password>
125 <KeyAlias>wso2carbon</KeyAlias>
126 <KeyPassword>wso2carbon</KeyPassword>
127 </InternalKeyStore>
128 <TrustStore>
129 <Location>${carbon.home}/repository/resources/security/client-truststore.jks</Location>
130 <Type>JKS</Type>
131 <Password>wso2carbon</Password>
132 </TrustStore>
133 <NetworkAuthenticatorConfig>
134 </NetworkAuthenticatorConfig>
135 <TomcatRealm>UserManager</TomcatRealm>
136 <DisableTokenStore>false</DisableTokenStore>
137 <STSCallBackHandlerName>org.wso2.carbon.identity.provider.AttributeCallbackHandler</STSCallBackHandlerName>
138 <TokenStoreClassName>org.wso2.carbon.identity.sts.store.DBTokenStore</TokenStoreClassName>
139 <XSSPreventionConfig>
140 <Enabled>true</Enabled>
141 <Rule>allow</Rule>
142 <Patterns>
143 </Patterns>
144 </XSSPreventionConfig>
145 </Security>
146 <HideMenuItemIds>
147 <HideMenuItemId>claim_mgt_menu</HideMenuItemId>
148 <HideMenuItemId>identity_mgt_emailtemplate_menu</HideMenuItemId>
149 <HideMenuItemId>identity_security_questions_menu</HideMenuItemId>
150 </HideMenuItemIds>
151 <WorkDirectory>${carbon.home}/tmp/work</WorkDirectory>
152 <HouseKeeping>
153 <AutoStart>true</AutoStart>
154 <Interval>10</Interval>
155 <MaxTempFileLifetime>30</MaxTempFileLifetime>
156 </HouseKeeping>
157 <FileUploadConfig>
158 <TotalFileSizeLimit>100</TotalFileSizeLimit>
159 <Mapping>
160 <Actions>
161 <Action>keystore</Action>
162 <Action>certificate</Action>
163 <Action>*</Action>
164 </Actions>
165 <Class>org.wso2.carbon.ui.transports.fileupload.AnyFileUploadExecutor</Class>
166 </Mapping>
167 <Mapping>
168 <Actions>
169 <Action>jarZip</Action>
170 </Actions>
171 <Class>org.wso2.carbon.ui.transports.fileupload.JarZipUploadExecutor</Class>
172 </Mapping>
173 <Mapping>
174 <Actions>
175 <Action>dbs</Action>
176 </Actions>
177 <Class>org.wso2.carbon.ui.transports.fileupload.DBSFileUploadExecutor</Class>
178 </Mapping>
179 <Mapping>
180 <Actions>
181 <Action>tools</Action>
182 </Actions>
183 <Class>org.wso2.carbon.ui.transports.fileupload.ToolsFileUploadExecutor</Class>
184 </Mapping>
185 <Mapping>
186 <Actions>
187 <Action>toolsAny</Action>
188 </Actions>
189 <Class>org.wso2.carbon.ui.transports.fileupload.ToolsAnyFileUploadExecutor</Class>
190 </Mapping>
191 </FileUploadConfig>
192 <HttpGetRequestProcessors>
193 <Processor>
194 <Item>info</Item>
195 <Class>org.wso2.carbon.core.transports.util.InfoProcessor</Class>
196 </Processor>
197 <Processor>
198 <Item>wsdl</Item>
199 <Class>org.wso2.carbon.core.transports.util.Wsdl11Processor</Class>
200 </Processor>
201 <Processor>
202 <Item>wsdl2</Item>
203 <Class>org.wso2.carbon.core.transports.util.Wsdl20Processor</Class>
204 </Processor>
205 <Processor>
206 <Item>xsd</Item>
207 <Class>org.wso2.carbon.core.transports.util.XsdProcessor</Class>
208 </Processor>
209 </HttpGetRequestProcessors>
210 <DeploymentSynchronizer>
211 <Enabled>false</Enabled>
212 <AutoCommit>false</AutoCommit>
213 <AutoCheckout>true</AutoCheckout>
214 <RepositoryType>svn</RepositoryType>
215 <SvnUrl>http://svnrepo.example.com/repos/</SvnUrl>
216 <SvnUser>username</SvnUser>
217 <SvnPassword>password</SvnPassword>
218 <SvnUrlAppendTenantId>true</SvnUrlAppendTenantId>
219 </DeploymentSynchronizer>
220 <ServerInitializers>
221 </ServerInitializers>
222 <RequireCarbonServlet>${require.carbon.servlet}</RequireCarbonServlet>
223 <StatisticsReporterDisabled>true</StatisticsReporterDisabled>
224 <FeatureRepository>
225 <RepositoryName>default repository</RepositoryName>
226 <RepositoryURL>http://product-dist.wso2.com/p2/carbon/releases/wilkes/</RepositoryURL>
227 </FeatureRepository>
228 <APIManagement>
229 <Enabled>true</Enabled>
230 <LoadAPIContextsInServerStartup>true</LoadAPIContextsInServerStartup>
231 </APIManagement>
232 </Server>
233kind: ConfigMap
234metadata:
235 name: identity-server-conf
236 namespace: wso2
237---
238
239apiVersion: v1
240data:
241 bps-datasources.xml: |
242 <datasources-configuration xmlns:svns="http://org.wso2.securevault/configuration">
243 <providers>
244 <provider>org.wso2.carbon.ndatasource.rdbms.RDBMSDataSourceReader</provider>
245 </providers>
246 <datasources>
247 <datasource>
248 <name>BPS_DS</name>
249 <description></description>
250 <jndiConfig>
251 <name>bpsds</name>
252 </jndiConfig>
253 <definition type="RDBMS">
254 <configuration>
255 <url>jdbc:h2:./repository/database/WSO2IS_BPS_DB?autoReconnect=true&useSSL=false</url>
256 <username>wso2carbon</username>
257 <password>wso2carbon</password>
258 <driverClassName>org.h2.Driver</driverClassName>
259 <maxActive>100</maxActive>
260 <maxWait>10000</maxWait>
261 <maxIdle>20</maxIdle>
262 <testOnBorrow>true</testOnBorrow>
263 <validationQuery>SELECT 1</validationQuery>
264 <validationInterval>30000</validationInterval>
265 <useDataSourceFactory>false</useDataSourceFactory>
266 <defaultAutoCommit>true</defaultAutoCommit>
267 </configuration>
268 </definition>
269 </datasource>
270 </datasources>
271 </datasources-configuration>
272 master-datasources.xml: |
273 <datasources-configuration xmlns:svns="http://org.wso2.securevault/configuration">
274 <providers>
275 <provider>org.wso2.carbon.ndatasource.rdbms.RDBMSDataSourceReader</provider>
276 </providers>
277 <datasources>
278 <datasource>
279 <name>WSO2_CARBON_DB</name>
280 <description>The datasource used for registry and user manager</description>
281 <jndiConfig>
282 <name>jdbc/WSO2CarbonDB</name>
283 </jndiConfig>
284 <definition type="RDBMS">
285 <configuration>
286 <url>jdbc:h2:./repository/database/WSO2CARBON_DB;DB_CLOSE_ON_EXIT=FALSE;LOCK_TIMEOUT=60000</url>
287 <username>wso2carbon</username>
288 <password>wso2carbon</password>
289 <driverClassName>org.h2.Driver</driverClassName>
290 <maxActive>50</maxActive>
291 <maxWait>60000</maxWait>
292 <testOnBorrow>true</testOnBorrow>
293 <validationQuery>SELECT 1</validationQuery>
294 <validationInterval>30000</validationInterval>
295 <defaultAutoCommit>false</defaultAutoCommit>
296 </configuration>
297 </definition>
298 </datasource>
299 <datasource>
300 <name>WSO2_USER_DB</name>
301 <description>The data source used for user management and user store</description>
302 <jndiConfig>
303 <name>jdbc/WSO2UserDS</name>
304 </jndiConfig>
305 <definition type="RDBMS">
306 <configuration>
307 <url>jdbc:mysql://wso2is-rdbms-service:3306/WSO2IS_USER_DB?autoReconnect=true&useSSL=false</url>
308 <username>wso2carbon</username>
309 <password>wso2carbon</password>
310 <driverClassName>com.mysql.jdbc.Driver</driverClassName>
311 <maxActive>80</maxActive>
312 <maxWait>60000</maxWait>
313 <minIdle>5</minIdle>
314 <testOnBorrow>true</testOnBorrow>
315 <validationQuery>SELECT 1</validationQuery>
316 <validationInterval>30000</validationInterval>
317 <defaultAutoCommit>false</defaultAutoCommit>
318 </configuration>
319 </definition>
320 </datasource>
321 <datasource>
322 <name>WSO2_CONFIG_REG_DB</name>
323 <description>The data source used for config registry</description>
324 <jndiConfig>
325 <name>jdbc/WSO2ConfigDS</name>
326 </jndiConfig>
327 <definition type="RDBMS">
328 <configuration>
329 <url>jdbc:h2:./repository/database/WSO2IS_REG_DB?autoReconnect=true&useSSL=false</url>
330 <username>wso2carbon</username>
331 <password>wso2carbon</password>
332 <driverClassName>org.h2.Driver</driverClassName>
333 <maxActive>50</maxActive>
334 <maxWait>60000</maxWait>
335 <testOnBorrow>true</testOnBorrow>
336 <validationQuery>SELECT 1</validationQuery>
337 <validationInterval>30000</validationInterval>
338 </configuration>
339 </definition>
340 </datasource>
341 <datasource>
342 <name>WSO2_IDENTITY_DB</name>
343 <description>The data source used for identity</description>
344 <jndiConfig>
345 <name>jdbc/WSO2IdentityDS</name>
346 </jndiConfig>
347 <definition type="RDBMS">
348 <configuration>
349 <url>jdbc:mysql://wso2is-rdbms-service:3306/WSO2IS_IDENTITY_DB?autoReconnect=true&useSSL=false</url>
350 <username>wso2carbon</username>
351 <password>wso2carbon</password>
352 <driverClassName>com.mysql.jdbc.Driver</driverClassName>
353 <maxActive>80</maxActive>
354 <maxWait>60000</maxWait>
355 <minIdle>5</minIdle>
356 <testOnBorrow>true</testOnBorrow>
357 <validationQuery>SELECT 1</validationQuery>
358 <validationInterval>30000</validationInterval>
359 <defaultAutoCommit>false</defaultAutoCommit>
360 </configuration>
361 </definition>
362 </datasource>
363 <datasource>
364 <name>WSO2_CONSENT_DB</name>
365 <description>The data source used for consent management</description>
366 <jndiConfig>
367 <name>jdbc/WSO2ConsentDS</name>
368 </jndiConfig>
369 <definition type="RDBMS">
370 <configuration>
371 <url>jdbc:h2:./repository/database/WSO2IS_CONSENT_DB?autoReconnect=true&useSSL=false</url>
372 <username>wso2carbon</username>
373 <password>wso2carbon</password>
374 <driverClassName>org.h2.Driver</driverClassName>
375 <maxActive>80</maxActive>
376 <maxWait>60000</maxWait>
377 <minIdle>5</minIdle>
378 <testOnBorrow>true</testOnBorrow>
379 <validationQuery>SELECT 1</validationQuery>
380 <validationInterval>30000</validationInterval>
381 <defaultAutoCommit>false</defaultAutoCommit>
382 </configuration>
383 </definition>
384 </datasource>
385 </datasources>
386 </datasources-configuration>
387kind: ConfigMap
388metadata:
389 name: identity-server-conf-datasources
390 namespace: wso2
391---
392
393apiVersion: v1
394data:
395 init.sql: |
396 DROP DATABASE IF EXISTS WSO2IS_USER_DB;
397 DROP DATABASE IF EXISTS WSO2IS_IDENTITY_DB;
398 DROP DATABASE IF EXISTS IS_ANALYTICS_DB;
399 CREATE DATABASE WSO2IS_USER_DB;
400 CREATE DATABASE WSO2IS_IDENTITY_DB;
401 CREATE DATABASE IS_ANALYTICS_DB;
402 CREATE USER IF NOT EXISTS 'wso2carbon'@'%' IDENTIFIED BY 'wso2carbon';
403 GRANT ALL ON WSO2IS_USER_DB.* TO 'wso2carbon'@'%' IDENTIFIED BY 'wso2carbon';
404 GRANT ALL ON WSO2IS_IDENTITY_DB.* TO 'wso2carbon'@'%' IDENTIFIED BY 'wso2carbon';
405 GRANT ALL ON IS_ANALYTICS_DB.* TO 'wso2carbon'@'%' IDENTIFIED BY 'wso2carbon';
406 USE WSO2IS_USER_DB;
407 CREATE TABLE UM_TENANT (
408 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
409 UM_DOMAIN_NAME VARCHAR(255) NOT NULL,
410 UM_EMAIL VARCHAR(255),
411 UM_ACTIVE BOOLEAN DEFAULT FALSE,
412 UM_CREATED_DATE TIMESTAMP NOT NULL,
413 UM_USER_CONFIG LONGBLOB,
414 PRIMARY KEY (UM_ID),
415 UNIQUE(UM_DOMAIN_NAME)
416 )ENGINE INNODB;
417 CREATE TABLE UM_DOMAIN(
418 UM_DOMAIN_ID INTEGER NOT NULL AUTO_INCREMENT,
419 UM_DOMAIN_NAME VARCHAR(255),
420 UM_TENANT_ID INTEGER DEFAULT 0,
421 PRIMARY KEY (UM_DOMAIN_ID, UM_TENANT_ID)
422 )ENGINE INNODB;
423 CREATE UNIQUE INDEX INDEX_UM_TENANT_UM_DOMAIN_NAME
424 ON UM_TENANT (UM_DOMAIN_NAME);
425 CREATE TABLE UM_USER (
426 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
427 UM_USER_NAME VARCHAR(255) NOT NULL,
428 UM_USER_PASSWORD VARCHAR(255) NOT NULL,
429 UM_SALT_VALUE VARCHAR(31),
430 UM_REQUIRE_CHANGE BOOLEAN DEFAULT FALSE,
431 UM_CHANGED_TIME TIMESTAMP NOT NULL,
432 UM_TENANT_ID INTEGER DEFAULT 0,
433 PRIMARY KEY (UM_ID, UM_TENANT_ID),
434 UNIQUE(UM_USER_NAME, UM_TENANT_ID)
435 )ENGINE INNODB;
436 CREATE TABLE UM_SYSTEM_USER (
437 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
438 UM_USER_NAME VARCHAR(255) NOT NULL,
439 UM_USER_PASSWORD VARCHAR(255) NOT NULL,
440 UM_SALT_VALUE VARCHAR(31),
441 UM_REQUIRE_CHANGE BOOLEAN DEFAULT FALSE,
442 UM_CHANGED_TIME TIMESTAMP NOT NULL,
443 UM_TENANT_ID INTEGER DEFAULT 0,
444 PRIMARY KEY (UM_ID, UM_TENANT_ID),
445 UNIQUE(UM_USER_NAME, UM_TENANT_ID)
446 )ENGINE INNODB;
447 CREATE TABLE UM_ROLE (
448 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
449 UM_ROLE_NAME VARCHAR(255) NOT NULL,
450 UM_TENANT_ID INTEGER DEFAULT 0,
451 UM_SHARED_ROLE BOOLEAN DEFAULT FALSE,
452 PRIMARY KEY (UM_ID, UM_TENANT_ID),
453 UNIQUE(UM_ROLE_NAME, UM_TENANT_ID)
454 )ENGINE INNODB;
455 CREATE TABLE UM_MODULE(
456 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
457 UM_MODULE_NAME VARCHAR(100),
458 UNIQUE(UM_MODULE_NAME),
459 PRIMARY KEY(UM_ID)
460 )ENGINE INNODB;
461 CREATE TABLE UM_MODULE_ACTIONS(
462 UM_ACTION VARCHAR(255) NOT NULL,
463 UM_MODULE_ID INTEGER NOT NULL,
464 PRIMARY KEY(UM_ACTION, UM_MODULE_ID),
465 FOREIGN KEY (UM_MODULE_ID) REFERENCES UM_MODULE(UM_ID) ON DELETE CASCADE
466 )ENGINE INNODB;
467 CREATE TABLE UM_PERMISSION (
468 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
469 UM_RESOURCE_ID VARCHAR(255) NOT NULL,
470 UM_ACTION VARCHAR(255) NOT NULL,
471 UM_TENANT_ID INTEGER DEFAULT 0,
472 UM_MODULE_ID INTEGER DEFAULT 0,
473 UNIQUE(UM_RESOURCE_ID,UM_ACTION, UM_TENANT_ID),
474 PRIMARY KEY (UM_ID, UM_TENANT_ID)
475 )ENGINE INNODB;
476 CREATE INDEX INDEX_UM_PERMISSION_UM_RESOURCE_ID_UM_ACTION ON UM_PERMISSION (UM_RESOURCE_ID, UM_ACTION, UM_TENANT_ID);
477 CREATE TABLE UM_ROLE_PERMISSION (
478 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
479 UM_PERMISSION_ID INTEGER NOT NULL,
480 UM_ROLE_NAME VARCHAR(255) NOT NULL,
481 UM_IS_ALLOWED SMALLINT NOT NULL,
482 UM_TENANT_ID INTEGER DEFAULT 0,
483 UM_DOMAIN_ID INTEGER,
484 UNIQUE (UM_PERMISSION_ID, UM_ROLE_NAME, UM_TENANT_ID, UM_DOMAIN_ID),
485 FOREIGN KEY (UM_PERMISSION_ID, UM_TENANT_ID) REFERENCES UM_PERMISSION(UM_ID, UM_TENANT_ID) ON DELETE CASCADE,
486 FOREIGN KEY (UM_DOMAIN_ID, UM_TENANT_ID) REFERENCES UM_DOMAIN(UM_DOMAIN_ID, UM_TENANT_ID) ON DELETE CASCADE,
487 PRIMARY KEY (UM_ID, UM_TENANT_ID)
488 )ENGINE INNODB;
489 CREATE TABLE UM_USER_PERMISSION (
490 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
491 UM_PERMISSION_ID INTEGER NOT NULL,
492 UM_USER_NAME VARCHAR(255) NOT NULL,
493 UM_IS_ALLOWED SMALLINT NOT NULL,
494 UM_TENANT_ID INTEGER DEFAULT 0,
495 FOREIGN KEY (UM_PERMISSION_ID, UM_TENANT_ID) REFERENCES UM_PERMISSION(UM_ID, UM_TENANT_ID) ON DELETE CASCADE,
496 PRIMARY KEY (UM_ID, UM_TENANT_ID)
497 )ENGINE INNODB;
498 CREATE TABLE UM_USER_ROLE (
499 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
500 UM_ROLE_ID INTEGER NOT NULL,
501 UM_USER_ID INTEGER NOT NULL,
502 UM_TENANT_ID INTEGER DEFAULT 0,
503 UNIQUE (UM_USER_ID, UM_ROLE_ID, UM_TENANT_ID),
504 FOREIGN KEY (UM_ROLE_ID, UM_TENANT_ID) REFERENCES UM_ROLE(UM_ID, UM_TENANT_ID),
505 FOREIGN KEY (UM_USER_ID, UM_TENANT_ID) REFERENCES UM_USER(UM_ID, UM_TENANT_ID),
506 PRIMARY KEY (UM_ID, UM_TENANT_ID)
507 )ENGINE INNODB;
508 CREATE TABLE UM_SHARED_USER_ROLE(
509 UM_ROLE_ID INTEGER NOT NULL,
510 UM_USER_ID INTEGER NOT NULL,
511 UM_USER_TENANT_ID INTEGER NOT NULL,
512 UM_ROLE_TENANT_ID INTEGER NOT NULL,
513 UNIQUE(UM_USER_ID,UM_ROLE_ID,UM_USER_TENANT_ID, UM_ROLE_TENANT_ID),
514 FOREIGN KEY(UM_ROLE_ID,UM_ROLE_TENANT_ID) REFERENCES UM_ROLE(UM_ID,UM_TENANT_ID) ON DELETE CASCADE,
515 FOREIGN KEY(UM_USER_ID,UM_USER_TENANT_ID) REFERENCES UM_USER(UM_ID,UM_TENANT_ID) ON DELETE CASCADE
516 )ENGINE INNODB;
517 CREATE TABLE UM_ACCOUNT_MAPPING(
518 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
519 UM_USER_NAME VARCHAR(255) NOT NULL,
520 UM_TENANT_ID INTEGER NOT NULL,
521 UM_USER_STORE_DOMAIN VARCHAR(100),
522 UM_ACC_LINK_ID INTEGER NOT NULL,
523 UNIQUE(UM_USER_NAME, UM_TENANT_ID, UM_USER_STORE_DOMAIN, UM_ACC_LINK_ID),
524 FOREIGN KEY (UM_TENANT_ID) REFERENCES UM_TENANT(UM_ID) ON DELETE CASCADE,
525 PRIMARY KEY (UM_ID)
526 )ENGINE INNODB;
527 CREATE TABLE UM_USER_ATTRIBUTE (
528 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
529 UM_ATTR_NAME VARCHAR(255) NOT NULL,
530 UM_ATTR_VALUE VARCHAR(1024),
531 UM_PROFILE_ID VARCHAR(255),
532 UM_USER_ID INTEGER,
533 UM_TENANT_ID INTEGER DEFAULT 0,
534 FOREIGN KEY (UM_USER_ID, UM_TENANT_ID) REFERENCES UM_USER(UM_ID, UM_TENANT_ID),
535 PRIMARY KEY (UM_ID, UM_TENANT_ID)
536 )ENGINE INNODB;
537 CREATE INDEX UM_USER_ID_INDEX ON UM_USER_ATTRIBUTE(UM_USER_ID);
538 CREATE TABLE UM_DIALECT(
539 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
540 UM_DIALECT_URI VARCHAR(255) NOT NULL,
541 UM_TENANT_ID INTEGER DEFAULT 0,
542 UNIQUE(UM_DIALECT_URI, UM_TENANT_ID),
543 PRIMARY KEY (UM_ID, UM_TENANT_ID)
544 )ENGINE INNODB;
545 CREATE TABLE UM_CLAIM(
546 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
547 UM_DIALECT_ID INTEGER NOT NULL,
548 UM_CLAIM_URI VARCHAR(255) NOT NULL,
549 UM_DISPLAY_TAG VARCHAR(255),
550 UM_DESCRIPTION VARCHAR(255),
551 UM_MAPPED_ATTRIBUTE_DOMAIN VARCHAR(255),
552 UM_MAPPED_ATTRIBUTE VARCHAR(255),
553 UM_REG_EX VARCHAR(255),
554 UM_SUPPORTED SMALLINT,
555 UM_REQUIRED SMALLINT,
556 UM_DISPLAY_ORDER INTEGER,
557 UM_CHECKED_ATTRIBUTE SMALLINT,
558 UM_READ_ONLY SMALLINT,
559 UM_TENANT_ID INTEGER DEFAULT 0,
560 UNIQUE(UM_DIALECT_ID, UM_CLAIM_URI, UM_TENANT_ID,UM_MAPPED_ATTRIBUTE_DOMAIN),
561 FOREIGN KEY(UM_DIALECT_ID, UM_TENANT_ID) REFERENCES UM_DIALECT(UM_ID, UM_TENANT_ID),
562 PRIMARY KEY (UM_ID, UM_TENANT_ID)
563 )ENGINE INNODB;
564 CREATE TABLE UM_PROFILE_CONFIG(
565 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
566 UM_DIALECT_ID INTEGER NOT NULL,
567 UM_PROFILE_NAME VARCHAR(255),
568 UM_TENANT_ID INTEGER DEFAULT 0,
569 FOREIGN KEY(UM_DIALECT_ID, UM_TENANT_ID) REFERENCES UM_DIALECT(UM_ID, UM_TENANT_ID),
570 PRIMARY KEY (UM_ID, UM_TENANT_ID)
571 )ENGINE INNODB;
572 CREATE TABLE IF NOT EXISTS UM_CLAIM_BEHAVIOR(
573 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
574 UM_PROFILE_ID INTEGER,
575 UM_CLAIM_ID INTEGER,
576 UM_BEHAVIOUR SMALLINT,
577 UM_TENANT_ID INTEGER DEFAULT 0,
578 FOREIGN KEY(UM_PROFILE_ID, UM_TENANT_ID) REFERENCES UM_PROFILE_CONFIG(UM_ID,UM_TENANT_ID),
579 FOREIGN KEY(UM_CLAIM_ID, UM_TENANT_ID) REFERENCES UM_CLAIM(UM_ID,UM_TENANT_ID),
580 PRIMARY KEY(UM_ID, UM_TENANT_ID)
581 )ENGINE INNODB;
582 CREATE TABLE UM_HYBRID_ROLE(
583 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
584 UM_ROLE_NAME VARCHAR(255),
585 UM_TENANT_ID INTEGER DEFAULT 0,
586 PRIMARY KEY (UM_ID, UM_TENANT_ID)
587 )ENGINE INNODB;
588 CREATE TABLE UM_HYBRID_USER_ROLE(
589 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
590 UM_USER_NAME VARCHAR(255),
591 UM_ROLE_ID INTEGER NOT NULL,
592 UM_TENANT_ID INTEGER DEFAULT 0,
593 UM_DOMAIN_ID INTEGER,
594 UNIQUE (UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID, UM_DOMAIN_ID),
595 FOREIGN KEY (UM_ROLE_ID, UM_TENANT_ID) REFERENCES UM_HYBRID_ROLE(UM_ID, UM_TENANT_ID) ON DELETE CASCADE,
596 FOREIGN KEY (UM_DOMAIN_ID, UM_TENANT_ID) REFERENCES UM_DOMAIN(UM_DOMAIN_ID, UM_TENANT_ID) ON DELETE CASCADE,
597 PRIMARY KEY (UM_ID, UM_TENANT_ID)
598 )ENGINE INNODB;
599 CREATE TABLE UM_SYSTEM_ROLE(
600 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
601 UM_ROLE_NAME VARCHAR(255),
602 UM_TENANT_ID INTEGER DEFAULT 0,
603 PRIMARY KEY (UM_ID, UM_TENANT_ID)
604 )ENGINE INNODB;
605 CREATE INDEX SYSTEM_ROLE_IND_BY_RN_TI ON UM_SYSTEM_ROLE(UM_ROLE_NAME, UM_TENANT_ID);
606 CREATE TABLE UM_SYSTEM_USER_ROLE(
607 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
608 UM_USER_NAME VARCHAR(255),
609 UM_ROLE_ID INTEGER NOT NULL,
610 UM_TENANT_ID INTEGER DEFAULT 0,
611 UNIQUE (UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID),
612 FOREIGN KEY (UM_ROLE_ID, UM_TENANT_ID) REFERENCES UM_SYSTEM_ROLE(UM_ID, UM_TENANT_ID),
613 PRIMARY KEY (UM_ID, UM_TENANT_ID)
614 )ENGINE INNODB;
615 CREATE TABLE UM_HYBRID_REMEMBER_ME(
616 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
617 UM_USER_NAME VARCHAR(255) NOT NULL,
618 UM_COOKIE_VALUE VARCHAR(1024),
619 UM_CREATED_TIME TIMESTAMP,
620 UM_TENANT_ID INTEGER DEFAULT 0,
621 PRIMARY KEY (UM_ID, UM_TENANT_ID)
622 )ENGINE INNODB;
623 USE WSO2IS_IDENTITY_DB;
624 CREATE TABLE UM_TENANT (
625 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
626 UM_DOMAIN_NAME VARCHAR(255) NOT NULL,
627 UM_EMAIL VARCHAR(255),
628 UM_ACTIVE BOOLEAN DEFAULT FALSE,
629 UM_CREATED_DATE TIMESTAMP NOT NULL,
630 UM_USER_CONFIG LONGBLOB,
631 PRIMARY KEY (UM_ID),
632 UNIQUE(UM_DOMAIN_NAME)
633 )ENGINE INNODB;
634 CREATE TABLE UM_DOMAIN(
635 UM_DOMAIN_ID INTEGER NOT NULL AUTO_INCREMENT,
636 UM_DOMAIN_NAME VARCHAR(255),
637 UM_TENANT_ID INTEGER DEFAULT 0,
638 PRIMARY KEY (UM_DOMAIN_ID, UM_TENANT_ID)
639 )ENGINE INNODB;
640 CREATE UNIQUE INDEX INDEX_UM_TENANT_UM_DOMAIN_NAME
641 ON UM_TENANT (UM_DOMAIN_NAME);
642 CREATE TABLE UM_USER (
643 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
644 UM_USER_NAME VARCHAR(255) NOT NULL,
645 UM_USER_PASSWORD VARCHAR(255) NOT NULL,
646 UM_SALT_VALUE VARCHAR(31),
647 UM_REQUIRE_CHANGE BOOLEAN DEFAULT FALSE,
648 UM_CHANGED_TIME TIMESTAMP NOT NULL,
649 UM_TENANT_ID INTEGER DEFAULT 0,
650 PRIMARY KEY (UM_ID, UM_TENANT_ID),
651 UNIQUE(UM_USER_NAME, UM_TENANT_ID)
652 )ENGINE INNODB;
653 CREATE TABLE UM_SYSTEM_USER (
654 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
655 UM_USER_NAME VARCHAR(255) NOT NULL,
656 UM_USER_PASSWORD VARCHAR(255) NOT NULL,
657 UM_SALT_VALUE VARCHAR(31),
658 UM_REQUIRE_CHANGE BOOLEAN DEFAULT FALSE,
659 UM_CHANGED_TIME TIMESTAMP NOT NULL,
660 UM_TENANT_ID INTEGER DEFAULT 0,
661 PRIMARY KEY (UM_ID, UM_TENANT_ID),
662 UNIQUE(UM_USER_NAME, UM_TENANT_ID)
663 )ENGINE INNODB;
664 CREATE TABLE UM_ROLE (
665 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
666 UM_ROLE_NAME VARCHAR(255) NOT NULL,
667 UM_TENANT_ID INTEGER DEFAULT 0,
668 UM_SHARED_ROLE BOOLEAN DEFAULT FALSE,
669 PRIMARY KEY (UM_ID, UM_TENANT_ID),
670 UNIQUE(UM_ROLE_NAME, UM_TENANT_ID)
671 )ENGINE INNODB;
672 CREATE TABLE UM_MODULE(
673 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
674 UM_MODULE_NAME VARCHAR(100),
675 UNIQUE(UM_MODULE_NAME),
676 PRIMARY KEY(UM_ID)
677 )ENGINE INNODB;
678 CREATE TABLE UM_MODULE_ACTIONS(
679 UM_ACTION VARCHAR(255) NOT NULL,
680 UM_MODULE_ID INTEGER NOT NULL,
681 PRIMARY KEY(UM_ACTION, UM_MODULE_ID),
682 FOREIGN KEY (UM_MODULE_ID) REFERENCES UM_MODULE(UM_ID) ON DELETE CASCADE
683 )ENGINE INNODB;
684 CREATE TABLE UM_PERMISSION (
685 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
686 UM_RESOURCE_ID VARCHAR(255) NOT NULL,
687 UM_ACTION VARCHAR(255) NOT NULL,
688 UM_TENANT_ID INTEGER DEFAULT 0,
689 UM_MODULE_ID INTEGER DEFAULT 0,
690 UNIQUE(UM_RESOURCE_ID,UM_ACTION, UM_TENANT_ID),
691 PRIMARY KEY (UM_ID, UM_TENANT_ID)
692 )ENGINE INNODB;
693 CREATE INDEX INDEX_UM_PERMISSION_UM_RESOURCE_ID_UM_ACTION ON UM_PERMISSION (UM_RESOURCE_ID, UM_ACTION, UM_TENANT_ID);
694 CREATE TABLE UM_ROLE_PERMISSION (
695 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
696 UM_PERMISSION_ID INTEGER NOT NULL,
697 UM_ROLE_NAME VARCHAR(255) NOT NULL,
698 UM_IS_ALLOWED SMALLINT NOT NULL,
699 UM_TENANT_ID INTEGER DEFAULT 0,
700 UM_DOMAIN_ID INTEGER,
701 UNIQUE (UM_PERMISSION_ID, UM_ROLE_NAME, UM_TENANT_ID, UM_DOMAIN_ID),
702 FOREIGN KEY (UM_PERMISSION_ID, UM_TENANT_ID) REFERENCES UM_PERMISSION(UM_ID, UM_TENANT_ID) ON DELETE CASCADE,
703 FOREIGN KEY (UM_DOMAIN_ID, UM_TENANT_ID) REFERENCES UM_DOMAIN(UM_DOMAIN_ID, UM_TENANT_ID) ON DELETE CASCADE,
704 PRIMARY KEY (UM_ID, UM_TENANT_ID)
705 )ENGINE INNODB;
706 CREATE TABLE UM_USER_PERMISSION (
707 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
708 UM_PERMISSION_ID INTEGER NOT NULL,
709 UM_USER_NAME VARCHAR(255) NOT NULL,
710 UM_IS_ALLOWED SMALLINT NOT NULL,
711 UM_TENANT_ID INTEGER DEFAULT 0,
712 FOREIGN KEY (UM_PERMISSION_ID, UM_TENANT_ID) REFERENCES UM_PERMISSION(UM_ID, UM_TENANT_ID) ON DELETE CASCADE,
713 PRIMARY KEY (UM_ID, UM_TENANT_ID)
714 )ENGINE INNODB;
715 CREATE TABLE UM_USER_ROLE (
716 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
717 UM_ROLE_ID INTEGER NOT NULL,
718 UM_USER_ID INTEGER NOT NULL,
719 UM_TENANT_ID INTEGER DEFAULT 0,
720 UNIQUE (UM_USER_ID, UM_ROLE_ID, UM_TENANT_ID),
721 FOREIGN KEY (UM_ROLE_ID, UM_TENANT_ID) REFERENCES UM_ROLE(UM_ID, UM_TENANT_ID),
722 FOREIGN KEY (UM_USER_ID, UM_TENANT_ID) REFERENCES UM_USER(UM_ID, UM_TENANT_ID),
723 PRIMARY KEY (UM_ID, UM_TENANT_ID)
724 )ENGINE INNODB;
725 CREATE TABLE UM_SHARED_USER_ROLE(
726 UM_ROLE_ID INTEGER NOT NULL,
727 UM_USER_ID INTEGER NOT NULL,
728 UM_USER_TENANT_ID INTEGER NOT NULL,
729 UM_ROLE_TENANT_ID INTEGER NOT NULL,
730 UNIQUE(UM_USER_ID,UM_ROLE_ID,UM_USER_TENANT_ID, UM_ROLE_TENANT_ID),
731 FOREIGN KEY(UM_ROLE_ID,UM_ROLE_TENANT_ID) REFERENCES UM_ROLE(UM_ID,UM_TENANT_ID) ON DELETE CASCADE,
732 FOREIGN KEY(UM_USER_ID,UM_USER_TENANT_ID) REFERENCES UM_USER(UM_ID,UM_TENANT_ID) ON DELETE CASCADE
733 )ENGINE INNODB;
734 CREATE TABLE UM_ACCOUNT_MAPPING(
735 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
736 UM_USER_NAME VARCHAR(255) NOT NULL,
737 UM_TENANT_ID INTEGER NOT NULL,
738 UM_USER_STORE_DOMAIN VARCHAR(100),
739 UM_ACC_LINK_ID INTEGER NOT NULL,
740 UNIQUE(UM_USER_NAME, UM_TENANT_ID, UM_USER_STORE_DOMAIN, UM_ACC_LINK_ID),
741 FOREIGN KEY (UM_TENANT_ID) REFERENCES UM_TENANT(UM_ID) ON DELETE CASCADE,
742 PRIMARY KEY (UM_ID)
743 )ENGINE INNODB;
744 CREATE TABLE UM_USER_ATTRIBUTE (
745 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
746 UM_ATTR_NAME VARCHAR(255) NOT NULL,
747 UM_ATTR_VALUE VARCHAR(1024),
748 UM_PROFILE_ID VARCHAR(255),
749 UM_USER_ID INTEGER,
750 UM_TENANT_ID INTEGER DEFAULT 0,
751 FOREIGN KEY (UM_USER_ID, UM_TENANT_ID) REFERENCES UM_USER(UM_ID, UM_TENANT_ID),
752 PRIMARY KEY (UM_ID, UM_TENANT_ID)
753 )ENGINE INNODB;
754 CREATE INDEX UM_USER_ID_INDEX ON UM_USER_ATTRIBUTE(UM_USER_ID);
755 CREATE TABLE UM_DIALECT(
756 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
757 UM_DIALECT_URI VARCHAR(255) NOT NULL,
758 UM_TENANT_ID INTEGER DEFAULT 0,
759 UNIQUE(UM_DIALECT_URI, UM_TENANT_ID),
760 PRIMARY KEY (UM_ID, UM_TENANT_ID)
761 )ENGINE INNODB;
762 CREATE TABLE UM_CLAIM(
763 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
764 UM_DIALECT_ID INTEGER NOT NULL,
765 UM_CLAIM_URI VARCHAR(255) NOT NULL,
766 UM_DISPLAY_TAG VARCHAR(255),
767 UM_DESCRIPTION VARCHAR(255),
768 UM_MAPPED_ATTRIBUTE_DOMAIN VARCHAR(255),
769 UM_MAPPED_ATTRIBUTE VARCHAR(255),
770 UM_REG_EX VARCHAR(255),
771 UM_SUPPORTED SMALLINT,
772 UM_REQUIRED SMALLINT,
773 UM_DISPLAY_ORDER INTEGER,
774 UM_CHECKED_ATTRIBUTE SMALLINT,
775 UM_READ_ONLY SMALLINT,
776 UM_TENANT_ID INTEGER DEFAULT 0,
777 UNIQUE(UM_DIALECT_ID, UM_CLAIM_URI, UM_TENANT_ID,UM_MAPPED_ATTRIBUTE_DOMAIN),
778 FOREIGN KEY(UM_DIALECT_ID, UM_TENANT_ID) REFERENCES UM_DIALECT(UM_ID, UM_TENANT_ID),
779 PRIMARY KEY (UM_ID, UM_TENANT_ID)
780 )ENGINE INNODB;
781 CREATE TABLE UM_PROFILE_CONFIG(
782 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
783 UM_DIALECT_ID INTEGER NOT NULL,
784 UM_PROFILE_NAME VARCHAR(255),
785 UM_TENANT_ID INTEGER DEFAULT 0,
786 FOREIGN KEY(UM_DIALECT_ID, UM_TENANT_ID) REFERENCES UM_DIALECT(UM_ID, UM_TENANT_ID),
787 PRIMARY KEY (UM_ID, UM_TENANT_ID)
788 )ENGINE INNODB;
789 CREATE TABLE IF NOT EXISTS UM_CLAIM_BEHAVIOR(
790 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
791 UM_PROFILE_ID INTEGER,
792 UM_CLAIM_ID INTEGER,
793 UM_BEHAVIOUR SMALLINT,
794 UM_TENANT_ID INTEGER DEFAULT 0,
795 FOREIGN KEY(UM_PROFILE_ID, UM_TENANT_ID) REFERENCES UM_PROFILE_CONFIG(UM_ID,UM_TENANT_ID),
796 FOREIGN KEY(UM_CLAIM_ID, UM_TENANT_ID) REFERENCES UM_CLAIM(UM_ID,UM_TENANT_ID),
797 PRIMARY KEY(UM_ID, UM_TENANT_ID)
798 )ENGINE INNODB;
799 CREATE TABLE UM_HYBRID_ROLE(
800 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
801 UM_ROLE_NAME VARCHAR(255),
802 UM_TENANT_ID INTEGER DEFAULT 0,
803 PRIMARY KEY (UM_ID, UM_TENANT_ID)
804 )ENGINE INNODB;
805 CREATE TABLE UM_HYBRID_USER_ROLE(
806 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
807 UM_USER_NAME VARCHAR(255),
808 UM_ROLE_ID INTEGER NOT NULL,
809 UM_TENANT_ID INTEGER DEFAULT 0,
810 UM_DOMAIN_ID INTEGER,
811 UNIQUE (UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID, UM_DOMAIN_ID),
812 FOREIGN KEY (UM_ROLE_ID, UM_TENANT_ID) REFERENCES UM_HYBRID_ROLE(UM_ID, UM_TENANT_ID) ON DELETE CASCADE,
813 FOREIGN KEY (UM_DOMAIN_ID, UM_TENANT_ID) REFERENCES UM_DOMAIN(UM_DOMAIN_ID, UM_TENANT_ID) ON DELETE CASCADE,
814 PRIMARY KEY (UM_ID, UM_TENANT_ID)
815 )ENGINE INNODB;
816 CREATE TABLE UM_SYSTEM_ROLE(
817 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
818 UM_ROLE_NAME VARCHAR(255),
819 UM_TENANT_ID INTEGER DEFAULT 0,
820 PRIMARY KEY (UM_ID, UM_TENANT_ID)
821 )ENGINE INNODB;
822 CREATE INDEX SYSTEM_ROLE_IND_BY_RN_TI ON UM_SYSTEM_ROLE(UM_ROLE_NAME, UM_TENANT_ID);
823 CREATE TABLE UM_SYSTEM_USER_ROLE(
824 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
825 UM_USER_NAME VARCHAR(255),
826 UM_ROLE_ID INTEGER NOT NULL,
827 UM_TENANT_ID INTEGER DEFAULT 0,
828 UNIQUE (UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID),
829 FOREIGN KEY (UM_ROLE_ID, UM_TENANT_ID) REFERENCES UM_SYSTEM_ROLE(UM_ID, UM_TENANT_ID),
830 PRIMARY KEY (UM_ID, UM_TENANT_ID)
831 )ENGINE INNODB;
832 CREATE TABLE UM_HYBRID_REMEMBER_ME(
833 UM_ID INTEGER NOT NULL AUTO_INCREMENT,
834 UM_USER_NAME VARCHAR(255) NOT NULL,
835 UM_COOKIE_VALUE VARCHAR(1024),
836 UM_CREATED_TIME TIMESTAMP,
837 UM_TENANT_ID INTEGER DEFAULT 0,
838 PRIMARY KEY (UM_ID, UM_TENANT_ID)
839 )ENGINE INNODB;
840 CREATE TABLE IF NOT EXISTS IDN_BASE_TABLE (
841 PRODUCT_NAME VARCHAR(20),
842 PRIMARY KEY (PRODUCT_NAME)
843 )ENGINE INNODB;
844 INSERT INTO IDN_BASE_TABLE values ('WSO2 Identity Server');
845 CREATE TABLE IF NOT EXISTS IDN_OAUTH_CONSUMER_APPS (
846 ID INTEGER NOT NULL AUTO_INCREMENT,
847 CONSUMER_KEY VARCHAR(255),
848 CONSUMER_SECRET VARCHAR(2048),
849 USERNAME VARCHAR(255),
850 TENANT_ID INTEGER DEFAULT 0,
851 USER_DOMAIN VARCHAR(50),
852 APP_NAME VARCHAR(255),
853 OAUTH_VERSION VARCHAR(128),
854 CALLBACK_URL VARCHAR(1024),
855 GRANT_TYPES VARCHAR (1024),
856 PKCE_MANDATORY CHAR(1) DEFAULT '0',
857 PKCE_SUPPORT_PLAIN CHAR(1) DEFAULT '0',
858 APP_STATE VARCHAR (25) DEFAULT 'ACTIVE',
859 USER_ACCESS_TOKEN_EXPIRE_TIME BIGINT DEFAULT 3600,
860 APP_ACCESS_TOKEN_EXPIRE_TIME BIGINT DEFAULT 3600,
861 REFRESH_TOKEN_EXPIRE_TIME BIGINT DEFAULT 84600,
862 ID_TOKEN_EXPIRE_TIME BIGINT DEFAULT 3600,
863 CONSTRAINT CONSUMER_KEY_CONSTRAINT UNIQUE (CONSUMER_KEY),
864 PRIMARY KEY (ID)
865 )ENGINE INNODB;
866 CREATE TABLE IF NOT EXISTS IDN_OAUTH2_SCOPE_VALIDATORS (
867 APP_ID INTEGER NOT NULL,
868 SCOPE_VALIDATOR VARCHAR (128) NOT NULL,
869 PRIMARY KEY (APP_ID,SCOPE_VALIDATOR),
870 FOREIGN KEY (APP_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE
871 )ENGINE INNODB;
872 CREATE TABLE IF NOT EXISTS IDN_OAUTH1A_REQUEST_TOKEN (
873 REQUEST_TOKEN VARCHAR(255),
874 REQUEST_TOKEN_SECRET VARCHAR(512),
875 CONSUMER_KEY_ID INTEGER,
876 CALLBACK_URL VARCHAR(1024),
877 SCOPE VARCHAR(2048),
878 AUTHORIZED VARCHAR(128),
879 OAUTH_VERIFIER VARCHAR(512),
880 AUTHZ_USER VARCHAR(512),
881 TENANT_ID INTEGER DEFAULT -1,
882 PRIMARY KEY (REQUEST_TOKEN),
883 FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE
884 )ENGINE INNODB;
885 CREATE TABLE IF NOT EXISTS IDN_OAUTH1A_ACCESS_TOKEN (
886 ACCESS_TOKEN VARCHAR(255),
887 ACCESS_TOKEN_SECRET VARCHAR(512),
888 CONSUMER_KEY_ID INTEGER,
889 SCOPE VARCHAR(2048),
890 AUTHZ_USER VARCHAR(512),
891 TENANT_ID INTEGER DEFAULT -1,
892 PRIMARY KEY (ACCESS_TOKEN),
893 FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE
894 )ENGINE INNODB;
895 CREATE TABLE IF NOT EXISTS IDN_OAUTH2_ACCESS_TOKEN (
896 TOKEN_ID VARCHAR (255),
897 ACCESS_TOKEN VARCHAR(2048),
898 REFRESH_TOKEN VARCHAR(2048),
899 CONSUMER_KEY_ID INTEGER,
900 AUTHZ_USER VARCHAR (100),
901 TENANT_ID INTEGER,
902 USER_DOMAIN VARCHAR(50),
903 USER_TYPE VARCHAR (25),
904 GRANT_TYPE VARCHAR (50),
905 TIME_CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
906 REFRESH_TOKEN_TIME_CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
907 VALIDITY_PERIOD BIGINT,
908 REFRESH_TOKEN_VALIDITY_PERIOD BIGINT,
909 TOKEN_SCOPE_HASH VARCHAR(32),
910 TOKEN_STATE VARCHAR(25) DEFAULT 'ACTIVE',
911 TOKEN_STATE_ID VARCHAR (128) DEFAULT 'NONE',
912 SUBJECT_IDENTIFIER VARCHAR(255),
913 ACCESS_TOKEN_HASH VARCHAR(512),
914 REFRESH_TOKEN_HASH VARCHAR(512),
915 PRIMARY KEY (TOKEN_ID),
916 FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE,
917 CONSTRAINT CON_APP_KEY UNIQUE (CONSUMER_KEY_ID,AUTHZ_USER,TENANT_ID,USER_DOMAIN,USER_TYPE,TOKEN_SCOPE_HASH,
918 TOKEN_STATE,TOKEN_STATE_ID)
919 )ENGINE INNODB;
920 CREATE INDEX IDX_AT_CK_AU ON IDN_OAUTH2_ACCESS_TOKEN(CONSUMER_KEY_ID, AUTHZ_USER, TOKEN_STATE, USER_TYPE);
921 CREATE INDEX IDX_TC ON IDN_OAUTH2_ACCESS_TOKEN(TIME_CREATED);
922 CREATE INDEX IDX_ATH ON IDN_OAUTH2_ACCESS_TOKEN(ACCESS_TOKEN_HASH);
923 CREATE INDEX IDX_AT_TI_UD ON IDN_OAUTH2_ACCESS_TOKEN(AUTHZ_USER, TENANT_ID, TOKEN_STATE, USER_DOMAIN);
924 CREATE TABLE IF NOT EXISTS IDN_OAUTH2_ACCESS_TOKEN_AUDIT (
925 TOKEN_ID VARCHAR (255),
926 ACCESS_TOKEN VARCHAR(2048),
927 REFRESH_TOKEN VARCHAR(2048),
928 CONSUMER_KEY_ID INTEGER,
929 AUTHZ_USER VARCHAR (100),
930 TENANT_ID INTEGER,
931 USER_DOMAIN VARCHAR(50),
932 USER_TYPE VARCHAR (25),
933 GRANT_TYPE VARCHAR (50),
934 TIME_CREATED TIMESTAMP NULL,
935 REFRESH_TOKEN_TIME_CREATED TIMESTAMP NULL,
936 VALIDITY_PERIOD BIGINT,
937 REFRESH_TOKEN_VALIDITY_PERIOD BIGINT,
938 TOKEN_SCOPE_HASH VARCHAR(32),
939 TOKEN_STATE VARCHAR(25),
940 TOKEN_STATE_ID VARCHAR (128) ,
941 SUBJECT_IDENTIFIER VARCHAR(255),
942 ACCESS_TOKEN_HASH VARCHAR(512),
943 REFRESH_TOKEN_HASH VARCHAR(512),
944 INVALIDATED_TIME TIMESTAMP NULL
945 );
946 CREATE TABLE IF NOT EXISTS IDN_OAUTH2_AUTHORIZATION_CODE (
947 CODE_ID VARCHAR (255),
948 AUTHORIZATION_CODE VARCHAR(2048),
949 CONSUMER_KEY_ID INTEGER,
950 CALLBACK_URL VARCHAR(1024),
951 SCOPE VARCHAR(2048),
952 AUTHZ_USER VARCHAR (100),
953 TENANT_ID INTEGER,
954 USER_DOMAIN VARCHAR(50),
955 TIME_CREATED TIMESTAMP,
956 VALIDITY_PERIOD BIGINT,
957 STATE VARCHAR (25) DEFAULT 'ACTIVE',
958 TOKEN_ID VARCHAR(255),
959 SUBJECT_IDENTIFIER VARCHAR(255),
960 PKCE_CODE_CHALLENGE VARCHAR(255),
961 PKCE_CODE_CHALLENGE_METHOD VARCHAR(128),
962 AUTHORIZATION_CODE_HASH VARCHAR(512),
963 PRIMARY KEY (CODE_ID),
964 FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE
965 )ENGINE INNODB;
966 CREATE INDEX IDX_AUTHORIZATION_CODE_HASH ON IDN_OAUTH2_AUTHORIZATION_CODE (AUTHORIZATION_CODE_HASH,CONSUMER_KEY_ID);
967 CREATE INDEX IDX_AUTHORIZATION_CODE_AU_TI ON IDN_OAUTH2_AUTHORIZATION_CODE (AUTHZ_USER,TENANT_ID, USER_DOMAIN, STATE);
968 CREATE TABLE IF NOT EXISTS IDN_OAUTH2_ACCESS_TOKEN_SCOPE (
969 TOKEN_ID VARCHAR (255),
970 TOKEN_SCOPE VARCHAR (60),
971 TENANT_ID INTEGER DEFAULT -1,
972 PRIMARY KEY (TOKEN_ID, TOKEN_SCOPE),
973 FOREIGN KEY (TOKEN_ID) REFERENCES IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) ON DELETE CASCADE
974 )ENGINE INNODB;
975 CREATE TABLE IF NOT EXISTS IDN_OAUTH2_SCOPE (
976 SCOPE_ID INTEGER NOT NULL AUTO_INCREMENT,
977 NAME VARCHAR(255) NOT NULL,
978 DISPLAY_NAME VARCHAR(255) NOT NULL,
979 DESCRIPTION VARCHAR(512),
980 TENANT_ID INTEGER NOT NULL DEFAULT -1,
981 PRIMARY KEY (SCOPE_ID)
982 )ENGINE INNODB;
983 CREATE TABLE IF NOT EXISTS IDN_OAUTH2_SCOPE_BINDING (
984 SCOPE_ID INTEGER NOT NULL,
985 SCOPE_BINDING VARCHAR(255),
986 FOREIGN KEY (SCOPE_ID) REFERENCES IDN_OAUTH2_SCOPE(SCOPE_ID) ON DELETE CASCADE
987 )ENGINE INNODB;
988 CREATE TABLE IF NOT EXISTS IDN_OAUTH2_RESOURCE_SCOPE (
989 RESOURCE_PATH VARCHAR(255) NOT NULL,
990 SCOPE_ID INTEGER NOT NULL,
991 TENANT_ID INTEGER DEFAULT -1,
992 PRIMARY KEY (RESOURCE_PATH),
993 FOREIGN KEY (SCOPE_ID) REFERENCES IDN_OAUTH2_SCOPE (SCOPE_ID) ON DELETE CASCADE
994 )ENGINE INNODB;
995 CREATE TABLE IF NOT EXISTS IDN_SCIM_GROUP (
996 ID INTEGER AUTO_INCREMENT,
997 TENANT_ID INTEGER NOT NULL,
998 ROLE_NAME VARCHAR(255) NOT NULL,
999 ATTR_NAME VARCHAR(1024) NOT NULL,
1000 ATTR_VALUE VARCHAR(1024),
1001 PRIMARY KEY (ID)
1002 )ENGINE INNODB;
1003 CREATE INDEX IDX_IDN_SCIM_GROUP_TI_RN ON IDN_SCIM_GROUP (TENANT_ID, ROLE_NAME);
1004 CREATE INDEX IDX_IDN_SCIM_GROUP_TI_RN_AN ON IDN_SCIM_GROUP (TENANT_ID, ROLE_NAME, ATTR_NAME);
1005 CREATE TABLE IF NOT EXISTS IDN_OPENID_REMEMBER_ME (
1006 USER_NAME VARCHAR(255) NOT NULL,
1007 TENANT_ID INTEGER DEFAULT 0,
1008 COOKIE_VALUE VARCHAR(1024),
1009 CREATED_TIME TIMESTAMP,
1010 PRIMARY KEY (USER_NAME, TENANT_ID)
1011 )ENGINE INNODB;
1012 CREATE TABLE IF NOT EXISTS IDN_OPENID_USER_RPS (
1013 USER_NAME VARCHAR(255) NOT NULL,
1014 TENANT_ID INTEGER DEFAULT 0,
1015 RP_URL VARCHAR(255) NOT NULL,
1016 TRUSTED_ALWAYS VARCHAR(128) DEFAULT 'FALSE',
1017 LAST_VISIT DATE NOT NULL,
1018 VISIT_COUNT INTEGER DEFAULT 0,
1019 DEFAULT_PROFILE_NAME VARCHAR(255) DEFAULT 'DEFAULT',
1020 PRIMARY KEY (USER_NAME, TENANT_ID, RP_URL)
1021 )ENGINE INNODB;
1022 CREATE TABLE IF NOT EXISTS IDN_OPENID_ASSOCIATIONS (
1023 HANDLE VARCHAR(255) NOT NULL,
1024 ASSOC_TYPE VARCHAR(255) NOT NULL,
1025 EXPIRE_IN TIMESTAMP NOT NULL,
1026 MAC_KEY VARCHAR(255) NOT NULL,
1027 ASSOC_STORE VARCHAR(128) DEFAULT 'SHARED',
1028 TENANT_ID INTEGER DEFAULT -1,
1029 PRIMARY KEY (HANDLE)
1030 )ENGINE INNODB;
1031 CREATE TABLE IF NOT EXISTS IDN_STS_STORE (
1032 ID INTEGER AUTO_INCREMENT,
1033 TOKEN_ID VARCHAR(255) NOT NULL,
1034 TOKEN_CONTENT BLOB(1024) NOT NULL,
1035 CREATE_DATE TIMESTAMP NOT NULL,
1036 EXPIRE_DATE TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1037 STATE INTEGER DEFAULT 0,
1038 PRIMARY KEY (ID)
1039 )ENGINE INNODB;
1040 CREATE TABLE IF NOT EXISTS IDN_IDENTITY_USER_DATA (
1041 TENANT_ID INTEGER DEFAULT -1234,
1042 USER_NAME VARCHAR(255) NOT NULL,
1043 DATA_KEY VARCHAR(255) NOT NULL,
1044 DATA_VALUE VARCHAR(2048),
1045 PRIMARY KEY (TENANT_ID, USER_NAME, DATA_KEY)
1046 )ENGINE INNODB;
1047 CREATE TABLE IF NOT EXISTS IDN_IDENTITY_META_DATA (
1048 USER_NAME VARCHAR(255) NOT NULL,
1049 TENANT_ID INTEGER DEFAULT -1234,
1050 METADATA_TYPE VARCHAR(255) NOT NULL,
1051 METADATA VARCHAR(255) NOT NULL,
1052 VALID VARCHAR(255) NOT NULL,
1053 PRIMARY KEY (TENANT_ID, USER_NAME, METADATA_TYPE,METADATA)
1054 )ENGINE INNODB;
1055 CREATE TABLE IF NOT EXISTS IDN_THRIFT_SESSION (
1056 SESSION_ID VARCHAR(255) NOT NULL,
1057 USER_NAME VARCHAR(255) NOT NULL,
1058 CREATED_TIME VARCHAR(255) NOT NULL,
1059 LAST_MODIFIED_TIME VARCHAR(255) NOT NULL,
1060 TENANT_ID INTEGER DEFAULT -1,
1061 PRIMARY KEY (SESSION_ID)
1062 )ENGINE INNODB;
1063 CREATE TABLE IF NOT EXISTS IDN_AUTH_SESSION_STORE (
1064 SESSION_ID VARCHAR (100) NOT NULL,
1065 SESSION_TYPE VARCHAR(100) NOT NULL,
1066 OPERATION VARCHAR(10) NOT NULL,
1067 SESSION_OBJECT BLOB,
1068 TIME_CREATED BIGINT,
1069 TENANT_ID INTEGER DEFAULT -1,
1070 EXPIRY_TIME BIGINT,
1071 PRIMARY KEY (SESSION_ID, SESSION_TYPE, TIME_CREATED, OPERATION)
1072 )ENGINE INNODB;
1073 CREATE INDEX IDX_IDN_AUTH_SESSION_TIME ON IDN_AUTH_SESSION_STORE (TIME_CREATED);
1074 CREATE TABLE IF NOT EXISTS IDN_AUTH_TEMP_SESSION_STORE (
1075 SESSION_ID VARCHAR (100) NOT NULL,
1076 SESSION_TYPE VARCHAR(100) NOT NULL,
1077 OPERATION VARCHAR(10) NOT NULL,
1078 SESSION_OBJECT BLOB,
1079 TIME_CREATED BIGINT,
1080 TENANT_ID INTEGER DEFAULT -1,
1081 EXPIRY_TIME BIGINT,
1082 PRIMARY KEY (SESSION_ID, SESSION_TYPE, TIME_CREATED, OPERATION)
1083 )ENGINE INNODB;
1084 CREATE INDEX IDX_IDN_AUTH_TMP_SESSION_TIME ON IDN_AUTH_TEMP_SESSION_STORE (TIME_CREATED);
1085 CREATE TABLE IF NOT EXISTS SP_APP (
1086 ID INTEGER NOT NULL AUTO_INCREMENT,
1087 TENANT_ID INTEGER NOT NULL,
1088 APP_NAME VARCHAR (255) NOT NULL ,
1089 USER_STORE VARCHAR (255) NOT NULL,
1090 USERNAME VARCHAR (255) NOT NULL ,
1091 DESCRIPTION VARCHAR (1024),
1092 ROLE_CLAIM VARCHAR (512),
1093 AUTH_TYPE VARCHAR (255) NOT NULL,
1094 PROVISIONING_USERSTORE_DOMAIN VARCHAR (512),
1095 IS_LOCAL_CLAIM_DIALECT CHAR(1) DEFAULT '1',
1096 IS_SEND_LOCAL_SUBJECT_ID CHAR(1) DEFAULT '0',
1097 IS_SEND_AUTH_LIST_OF_IDPS CHAR(1) DEFAULT '0',
1098 IS_USE_TENANT_DOMAIN_SUBJECT CHAR(1) DEFAULT '1',
1099 IS_USE_USER_DOMAIN_SUBJECT CHAR(1) DEFAULT '1',
1100 ENABLE_AUTHORIZATION CHAR(1) DEFAULT '0',
1101 SUBJECT_CLAIM_URI VARCHAR (512),
1102 IS_SAAS_APP CHAR(1) DEFAULT '0',
1103 IS_DUMB_MODE CHAR(1) DEFAULT '0',
1104 PRIMARY KEY (ID)
1105 )ENGINE INNODB;
1106 ALTER TABLE SP_APP ADD CONSTRAINT APPLICATION_NAME_CONSTRAINT UNIQUE(APP_NAME, TENANT_ID);
1107 CREATE TABLE IF NOT EXISTS SP_METADATA (
1108 ID INTEGER AUTO_INCREMENT,
1109 SP_ID INTEGER,
1110 NAME VARCHAR(255) NOT NULL,
1111 VALUE VARCHAR(255) NOT NULL,
1112 DISPLAY_NAME VARCHAR(255),
1113 TENANT_ID INTEGER DEFAULT -1,
1114 PRIMARY KEY (ID),
1115 CONSTRAINT SP_METADATA_CONSTRAINT UNIQUE (SP_ID, NAME),
1116 FOREIGN KEY (SP_ID) REFERENCES SP_APP(ID) ON DELETE CASCADE
1117 )ENGINE INNODB;
1118 CREATE TABLE IF NOT EXISTS SP_INBOUND_AUTH (
1119 ID INTEGER NOT NULL AUTO_INCREMENT,
1120 TENANT_ID INTEGER NOT NULL,
1121 INBOUND_AUTH_KEY VARCHAR (255),
1122 INBOUND_AUTH_TYPE VARCHAR (255) NOT NULL,
1123 INBOUND_CONFIG_TYPE VARCHAR (255) NOT NULL,
1124 PROP_NAME VARCHAR (255),
1125 PROP_VALUE VARCHAR (1024) ,
1126 APP_ID INTEGER NOT NULL,
1127 PRIMARY KEY (ID)
1128 )ENGINE INNODB;
1129 ALTER TABLE SP_INBOUND_AUTH ADD CONSTRAINT APPLICATION_ID_CONSTRAINT FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
1130 CREATE TABLE IF NOT EXISTS SP_AUTH_STEP (
1131 ID INTEGER NOT NULL AUTO_INCREMENT,
1132 TENANT_ID INTEGER NOT NULL,
1133 STEP_ORDER INTEGER DEFAULT 1,
1134 APP_ID INTEGER NOT NULL ,
1135 IS_SUBJECT_STEP CHAR(1) DEFAULT '0',
1136 IS_ATTRIBUTE_STEP CHAR(1) DEFAULT '0',
1137 PRIMARY KEY (ID)
1138 )ENGINE INNODB;
1139 ALTER TABLE SP_AUTH_STEP ADD CONSTRAINT APPLICATION_ID_CONSTRAINT_STEP FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
1140 CREATE TABLE IF NOT EXISTS SP_FEDERATED_IDP (
1141 ID INTEGER NOT NULL,
1142 TENANT_ID INTEGER NOT NULL,
1143 AUTHENTICATOR_ID INTEGER NOT NULL,
1144 PRIMARY KEY (ID, AUTHENTICATOR_ID)
1145 )ENGINE INNODB;
1146 ALTER TABLE SP_FEDERATED_IDP ADD CONSTRAINT STEP_ID_CONSTRAINT FOREIGN KEY (ID) REFERENCES SP_AUTH_STEP (ID) ON DELETE CASCADE;
1147 CREATE TABLE IF NOT EXISTS SP_CLAIM_DIALECT (
1148 ID INTEGER NOT NULL AUTO_INCREMENT,
1149 TENANT_ID INTEGER NOT NULL,
1150 SP_DIALECT VARCHAR (512) NOT NULL,
1151 APP_ID INTEGER NOT NULL,
1152 PRIMARY KEY (ID));
1153 ALTER TABLE SP_CLAIM_DIALECT ADD CONSTRAINT DIALECTID_APPID_CONSTRAINT FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
1154 CREATE TABLE IF NOT EXISTS SP_CLAIM_MAPPING (
1155 ID INTEGER NOT NULL AUTO_INCREMENT,
1156 TENANT_ID INTEGER NOT NULL,
1157 IDP_CLAIM VARCHAR (512) NOT NULL ,
1158 SP_CLAIM VARCHAR (512) NOT NULL ,
1159 APP_ID INTEGER NOT NULL,
1160 IS_REQUESTED VARCHAR(128) DEFAULT '0',
1161 IS_MANDATORY VARCHAR(128) DEFAULT '0',
1162 DEFAULT_VALUE VARCHAR(255),
1163 PRIMARY KEY (ID)
1164 )ENGINE INNODB;
1165 ALTER TABLE SP_CLAIM_MAPPING ADD CONSTRAINT CLAIMID_APPID_CONSTRAINT FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
1166 CREATE TABLE IF NOT EXISTS SP_ROLE_MAPPING (
1167 ID INTEGER NOT NULL AUTO_INCREMENT,
1168 TENANT_ID INTEGER NOT NULL,
1169 IDP_ROLE VARCHAR (255) NOT NULL ,
1170 SP_ROLE VARCHAR (255) NOT NULL ,
1171 APP_ID INTEGER NOT NULL,
1172 PRIMARY KEY (ID)
1173 )ENGINE INNODB;
1174 ALTER TABLE SP_ROLE_MAPPING ADD CONSTRAINT ROLEID_APPID_CONSTRAINT FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
1175 CREATE TABLE IF NOT EXISTS SP_REQ_PATH_AUTHENTICATOR (
1176 ID INTEGER NOT NULL AUTO_INCREMENT,
1177 TENANT_ID INTEGER NOT NULL,
1178 AUTHENTICATOR_NAME VARCHAR (255) NOT NULL ,
1179 APP_ID INTEGER NOT NULL,
1180 PRIMARY KEY (ID)
1181 )ENGINE INNODB;
1182 ALTER TABLE SP_REQ_PATH_AUTHENTICATOR ADD CONSTRAINT REQ_AUTH_APPID_CONSTRAINT FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
1183 CREATE TABLE IF NOT EXISTS SP_PROVISIONING_CONNECTOR (
1184 ID INTEGER NOT NULL AUTO_INCREMENT,
1185 TENANT_ID INTEGER NOT NULL,
1186 IDP_NAME VARCHAR (255) NOT NULL ,
1187 CONNECTOR_NAME VARCHAR (255) NOT NULL ,
1188 APP_ID INTEGER NOT NULL,
1189 IS_JIT_ENABLED CHAR(1) NOT NULL DEFAULT '0',
1190 BLOCKING CHAR(1) NOT NULL DEFAULT '0',
1191 RULE_ENABLED CHAR(1) NOT NULL DEFAULT '0',
1192 PRIMARY KEY (ID)
1193 )ENGINE INNODB;
1194 ALTER TABLE SP_PROVISIONING_CONNECTOR ADD CONSTRAINT PRO_CONNECTOR_APPID_CONSTRAINT FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE;
1195 CREATE TABLE SP_AUTH_SCRIPT (
1196 ID INTEGER AUTO_INCREMENT NOT NULL,
1197 TENANT_ID INTEGER NOT NULL,
1198 APP_ID INTEGER NOT NULL,
1199 TYPE VARCHAR(255) NOT NULL,
1200 CONTENT BLOB DEFAULT NULL,
1201 IS_ENABLED CHAR(1) NOT NULL DEFAULT '0',
1202 PRIMARY KEY (ID));
1203 CREATE TABLE IF NOT EXISTS SP_TEMPLATE (
1204 ID INTEGER AUTO_INCREMENT NOT NULL,
1205 TENANT_ID INTEGER NOT NULL,
1206 NAME VARCHAR(255) NOT NULL,
1207 DESCRIPTION VARCHAR(1023),
1208 CONTENT BLOB DEFAULT NULL,
1209 PRIMARY KEY (ID),
1210 CONSTRAINT SP_TEMPLATE_CONSTRAINT UNIQUE (TENANT_ID, NAME));
1211 CREATE INDEX IDX_SP_TEMPLATE ON SP_TEMPLATE (TENANT_ID, NAME);
1212 CREATE TABLE IF NOT EXISTS IDN_AUTH_WAIT_STATUS (
1213 ID INTEGER AUTO_INCREMENT NOT NULL,
1214 TENANT_ID INTEGER NOT NULL,
1215 LONG_WAIT_KEY VARCHAR(255) NOT NULL,
1216 WAIT_STATUS CHAR(1) NOT NULL DEFAULT '1',
1217 TIME_CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1218 EXPIRE_TIME TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1219 PRIMARY KEY (ID),
1220 CONSTRAINT IDN_AUTH_WAIT_STATUS_KEY UNIQUE (LONG_WAIT_KEY));
1221 CREATE TABLE IF NOT EXISTS IDP (
1222 ID INTEGER AUTO_INCREMENT,
1223 TENANT_ID INTEGER,
1224 NAME VARCHAR(254) NOT NULL,
1225 IS_ENABLED CHAR(1) NOT NULL DEFAULT '1',
1226 IS_PRIMARY CHAR(1) NOT NULL DEFAULT '0',
1227 HOME_REALM_ID VARCHAR(254),
1228 IMAGE MEDIUMBLOB,
1229 CERTIFICATE BLOB,
1230 ALIAS VARCHAR(254),
1231 INBOUND_PROV_ENABLED CHAR (1) NOT NULL DEFAULT '0',
1232 INBOUND_PROV_USER_STORE_ID VARCHAR(254),
1233 USER_CLAIM_URI VARCHAR(254),
1234 ROLE_CLAIM_URI VARCHAR(254),
1235 DESCRIPTION VARCHAR (1024),
1236 DEFAULT_AUTHENTICATOR_NAME VARCHAR(254),
1237 DEFAULT_PRO_CONNECTOR_NAME VARCHAR(254),
1238 PROVISIONING_ROLE VARCHAR(128),
1239 IS_FEDERATION_HUB CHAR(1) NOT NULL DEFAULT '0',
1240 IS_LOCAL_CLAIM_DIALECT CHAR(1) NOT NULL DEFAULT '0',
1241 DISPLAY_NAME VARCHAR(255),
1242 PRIMARY KEY (ID),
1243 UNIQUE (TENANT_ID, NAME)
1244 )ENGINE INNODB;
1245 CREATE TABLE IF NOT EXISTS IDP_ROLE (
1246 ID INTEGER AUTO_INCREMENT,
1247 IDP_ID INTEGER,
1248 TENANT_ID INTEGER,
1249 ROLE VARCHAR(254),
1250 PRIMARY KEY (ID),
1251 UNIQUE (IDP_ID, ROLE),
1252 FOREIGN KEY (IDP_ID) REFERENCES IDP(ID) ON DELETE CASCADE
1253 )ENGINE INNODB;
1254 CREATE TABLE IF NOT EXISTS IDP_ROLE_MAPPING (
1255 ID INTEGER AUTO_INCREMENT,
1256 IDP_ROLE_ID INTEGER,
1257 TENANT_ID INTEGER,
1258 USER_STORE_ID VARCHAR (253),
1259 LOCAL_ROLE VARCHAR(253),
1260 PRIMARY KEY (ID),
1261 UNIQUE (IDP_ROLE_ID, TENANT_ID, USER_STORE_ID, LOCAL_ROLE),
1262 FOREIGN KEY (IDP_ROLE_ID) REFERENCES IDP_ROLE(ID) ON DELETE CASCADE
1263 )ENGINE INNODB;
1264 CREATE TABLE IF NOT EXISTS IDP_CLAIM (
1265 ID INTEGER AUTO_INCREMENT,
1266 IDP_ID INTEGER,
1267 TENANT_ID INTEGER,
1268 CLAIM VARCHAR(254),
1269 PRIMARY KEY (ID),
1270 UNIQUE (IDP_ID, CLAIM),
1271 FOREIGN KEY (IDP_ID) REFERENCES IDP(ID) ON DELETE CASCADE
1272 )ENGINE INNODB;
1273 CREATE TABLE IF NOT EXISTS IDP_CLAIM_MAPPING (
1274 ID INTEGER AUTO_INCREMENT,
1275 IDP_CLAIM_ID INTEGER,
1276 TENANT_ID INTEGER,
1277 LOCAL_CLAIM VARCHAR(253),
1278 DEFAULT_VALUE VARCHAR(255),
1279 IS_REQUESTED VARCHAR(128) DEFAULT '0',
1280 PRIMARY KEY (ID),
1281 UNIQUE (IDP_CLAIM_ID, TENANT_ID, LOCAL_CLAIM),
1282 FOREIGN KEY (IDP_CLAIM_ID) REFERENCES IDP_CLAIM(ID) ON DELETE CASCADE
1283 )ENGINE INNODB;
1284 CREATE TABLE IF NOT EXISTS IDP_AUTHENTICATOR (
1285 ID INTEGER AUTO_INCREMENT,
1286 TENANT_ID INTEGER,
1287 IDP_ID INTEGER,
1288 NAME VARCHAR(255) NOT NULL,
1289 IS_ENABLED CHAR (1) DEFAULT '1',
1290 DISPLAY_NAME VARCHAR(255),
1291 PRIMARY KEY (ID),
1292 UNIQUE (TENANT_ID, IDP_ID, NAME),
1293 FOREIGN KEY (IDP_ID) REFERENCES IDP(ID) ON DELETE CASCADE
1294 )ENGINE INNODB;
1295 CREATE TABLE IF NOT EXISTS IDP_METADATA (
1296 ID INTEGER AUTO_INCREMENT,
1297 IDP_ID INTEGER,
1298 NAME VARCHAR(255) NOT NULL,
1299 VALUE VARCHAR(255) NOT NULL,
1300 DISPLAY_NAME VARCHAR(255),
1301 TENANT_ID INTEGER DEFAULT -1,
1302 PRIMARY KEY (ID),
1303 CONSTRAINT IDP_METADATA_CONSTRAINT UNIQUE (IDP_ID, NAME),
1304 FOREIGN KEY (IDP_ID) REFERENCES IDP(ID) ON DELETE CASCADE
1305 )ENGINE INNODB;
1306 CREATE TABLE IF NOT EXISTS IDP_AUTHENTICATOR_PROPERTY (
1307 ID INTEGER AUTO_INCREMENT,
1308 TENANT_ID INTEGER,
1309 AUTHENTICATOR_ID INTEGER,
1310 PROPERTY_KEY VARCHAR(255) NOT NULL,
1311 PROPERTY_VALUE VARCHAR(2047),
1312 IS_SECRET CHAR (1) DEFAULT '0',
1313 PRIMARY KEY (ID),
1314 UNIQUE (TENANT_ID, AUTHENTICATOR_ID, PROPERTY_KEY),
1315 FOREIGN KEY (AUTHENTICATOR_ID) REFERENCES IDP_AUTHENTICATOR(ID) ON DELETE CASCADE
1316 )ENGINE INNODB;
1317 CREATE TABLE IF NOT EXISTS IDP_PROVISIONING_CONFIG (
1318 ID INTEGER AUTO_INCREMENT,
1319 TENANT_ID INTEGER,
1320 IDP_ID INTEGER,
1321 PROVISIONING_CONNECTOR_TYPE VARCHAR(255) NOT NULL,
1322 IS_ENABLED CHAR (1) DEFAULT '0',
1323 IS_BLOCKING CHAR (1) DEFAULT '0',
1324 IS_RULES_ENABLED CHAR (1) DEFAULT '0',
1325 PRIMARY KEY (ID),
1326 UNIQUE (TENANT_ID, IDP_ID, PROVISIONING_CONNECTOR_TYPE),
1327 FOREIGN KEY (IDP_ID) REFERENCES IDP(ID) ON DELETE CASCADE
1328 )ENGINE INNODB;
1329 CREATE TABLE IF NOT EXISTS IDP_PROV_CONFIG_PROPERTY (
1330 ID INTEGER AUTO_INCREMENT,
1331 TENANT_ID INTEGER,
1332 PROVISIONING_CONFIG_ID INTEGER,
1333 PROPERTY_KEY VARCHAR(255) NOT NULL,
1334 PROPERTY_VALUE VARCHAR(2048),
1335 PROPERTY_BLOB_VALUE BLOB,
1336 PROPERTY_TYPE CHAR(32) NOT NULL,
1337 IS_SECRET CHAR (1) DEFAULT '0',
1338 PRIMARY KEY (ID),
1339 UNIQUE (TENANT_ID, PROVISIONING_CONFIG_ID, PROPERTY_KEY),
1340 FOREIGN KEY (PROVISIONING_CONFIG_ID) REFERENCES IDP_PROVISIONING_CONFIG(ID) ON DELETE CASCADE
1341 )ENGINE INNODB;
1342 CREATE TABLE IF NOT EXISTS IDP_PROVISIONING_ENTITY (
1343 ID INTEGER AUTO_INCREMENT,
1344 PROVISIONING_CONFIG_ID INTEGER,
1345 ENTITY_TYPE VARCHAR(255) NOT NULL,
1346 ENTITY_LOCAL_USERSTORE VARCHAR(255) NOT NULL,
1347 ENTITY_NAME VARCHAR(255) NOT NULL,
1348 ENTITY_VALUE VARCHAR(255),
1349 TENANT_ID INTEGER,
1350 ENTITY_LOCAL_ID VARCHAR(255),
1351 PRIMARY KEY (ID),
1352 UNIQUE (ENTITY_TYPE, TENANT_ID, ENTITY_LOCAL_USERSTORE, ENTITY_NAME, PROVISIONING_CONFIG_ID),
1353 UNIQUE (PROVISIONING_CONFIG_ID, ENTITY_TYPE, ENTITY_VALUE),
1354 FOREIGN KEY (PROVISIONING_CONFIG_ID) REFERENCES IDP_PROVISIONING_CONFIG(ID) ON DELETE CASCADE
1355 )ENGINE INNODB;
1356 CREATE TABLE IF NOT EXISTS IDP_LOCAL_CLAIM (
1357 ID INTEGER AUTO_INCREMENT,
1358 TENANT_ID INTEGER,
1359 IDP_ID INTEGER,
1360 CLAIM_URI VARCHAR(255) NOT NULL,
1361 DEFAULT_VALUE VARCHAR(255),
1362 IS_REQUESTED VARCHAR(128) DEFAULT '0',
1363 PRIMARY KEY (ID),
1364 UNIQUE (TENANT_ID, IDP_ID, CLAIM_URI),
1365 FOREIGN KEY (IDP_ID) REFERENCES IDP(ID) ON DELETE CASCADE
1366 )ENGINE INNODB;
1367 CREATE TABLE IF NOT EXISTS IDN_ASSOCIATED_ID (
1368 ID INTEGER AUTO_INCREMENT,
1369 IDP_USER_ID VARCHAR(255) NOT NULL,
1370 TENANT_ID INTEGER DEFAULT -1234,
1371 IDP_ID INTEGER NOT NULL,
1372 DOMAIN_NAME VARCHAR(255) NOT NULL,
1373 USER_NAME VARCHAR(255) NOT NULL,
1374 PRIMARY KEY (ID),
1375 UNIQUE(IDP_USER_ID, TENANT_ID, IDP_ID),
1376 FOREIGN KEY (IDP_ID) REFERENCES IDP(ID) ON DELETE CASCADE
1377 )ENGINE INNODB;
1378 CREATE TABLE IF NOT EXISTS IDN_USER_ACCOUNT_ASSOCIATION (
1379 ASSOCIATION_KEY VARCHAR(255) NOT NULL,
1380 TENANT_ID INTEGER,
1381 DOMAIN_NAME VARCHAR(255) NOT NULL,
1382 USER_NAME VARCHAR(255) NOT NULL,
1383 PRIMARY KEY (TENANT_ID, DOMAIN_NAME, USER_NAME)
1384 )ENGINE INNODB;
1385 CREATE TABLE IF NOT EXISTS FIDO_DEVICE_STORE (
1386 TENANT_ID INTEGER,
1387 DOMAIN_NAME VARCHAR(255) NOT NULL,
1388 USER_NAME VARCHAR(45) NOT NULL,
1389 TIME_REGISTERED TIMESTAMP,
1390 KEY_HANDLE VARCHAR(200) NOT NULL,
1391 DEVICE_DATA VARCHAR(2048) NOT NULL,
1392 PRIMARY KEY (TENANT_ID, DOMAIN_NAME, USER_NAME, KEY_HANDLE)
1393 )ENGINE INNODB;
1394 CREATE TABLE IF NOT EXISTS WF_REQUEST (
1395 UUID VARCHAR (45),
1396 CREATED_BY VARCHAR (255),
1397 TENANT_ID INTEGER DEFAULT -1,
1398 OPERATION_TYPE VARCHAR (50),
1399 CREATED_AT TIMESTAMP,
1400 UPDATED_AT TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
1401 STATUS VARCHAR (30),
1402 REQUEST BLOB,
1403 PRIMARY KEY (UUID)
1404 )ENGINE INNODB;
1405 CREATE TABLE IF NOT EXISTS WF_BPS_PROFILE (
1406 PROFILE_NAME VARCHAR(45),
1407 HOST_URL_MANAGER VARCHAR(255),
1408 HOST_URL_WORKER VARCHAR(255),
1409 USERNAME VARCHAR(45),
1410 PASSWORD VARCHAR(1023),
1411 CALLBACK_HOST VARCHAR (45),
1412 CALLBACK_USERNAME VARCHAR (45),
1413 CALLBACK_PASSWORD VARCHAR (255),
1414 TENANT_ID INTEGER DEFAULT -1,
1415 PRIMARY KEY (PROFILE_NAME, TENANT_ID)
1416 )ENGINE INNODB;
1417 CREATE TABLE IF NOT EXISTS WF_WORKFLOW(
1418 ID VARCHAR (45),
1419 WF_NAME VARCHAR (45),
1420 DESCRIPTION VARCHAR (255),
1421 TEMPLATE_ID VARCHAR (45),
1422 IMPL_ID VARCHAR (45),
1423 TENANT_ID INTEGER DEFAULT -1,
1424 PRIMARY KEY (ID)
1425 )ENGINE INNODB;
1426 CREATE TABLE IF NOT EXISTS WF_WORKFLOW_ASSOCIATION(
1427 ID INTEGER NOT NULL AUTO_INCREMENT,
1428 ASSOC_NAME VARCHAR (45),
1429 EVENT_ID VARCHAR(45),
1430 ASSOC_CONDITION VARCHAR (2000),
1431 WORKFLOW_ID VARCHAR (45),
1432 IS_ENABLED CHAR (1) DEFAULT '1',
1433 TENANT_ID INTEGER DEFAULT -1,
1434 PRIMARY KEY(ID),
1435 FOREIGN KEY (WORKFLOW_ID) REFERENCES WF_WORKFLOW(ID)ON DELETE CASCADE
1436 )ENGINE INNODB;
1437 CREATE TABLE IF NOT EXISTS WF_WORKFLOW_CONFIG_PARAM(
1438 WORKFLOW_ID VARCHAR (45),
1439 PARAM_NAME VARCHAR (45),
1440 PARAM_VALUE VARCHAR (1000),
1441 PARAM_QNAME VARCHAR (45),
1442 PARAM_HOLDER VARCHAR (45),
1443 TENANT_ID INTEGER DEFAULT -1,
1444 PRIMARY KEY (WORKFLOW_ID, PARAM_NAME, PARAM_QNAME, PARAM_HOLDER),
1445 FOREIGN KEY (WORKFLOW_ID) REFERENCES WF_WORKFLOW(ID)ON DELETE CASCADE
1446 )ENGINE INNODB;
1447 CREATE TABLE IF NOT EXISTS WF_REQUEST_ENTITY_RELATIONSHIP(
1448 REQUEST_ID VARCHAR (45),
1449 ENTITY_NAME VARCHAR (255),
1450 ENTITY_TYPE VARCHAR (50),
1451 TENANT_ID INTEGER DEFAULT -1,
1452 PRIMARY KEY(REQUEST_ID, ENTITY_NAME, ENTITY_TYPE, TENANT_ID),
1453 FOREIGN KEY (REQUEST_ID) REFERENCES WF_REQUEST(UUID)ON DELETE CASCADE
1454 )ENGINE INNODB;
1455 CREATE TABLE IF NOT EXISTS WF_WORKFLOW_REQUEST_RELATION(
1456 RELATIONSHIP_ID VARCHAR (45),
1457 WORKFLOW_ID VARCHAR (45),
1458 REQUEST_ID VARCHAR (45),
1459 UPDATED_AT TIMESTAMP,
1460 STATUS VARCHAR (30),
1461 TENANT_ID INTEGER DEFAULT -1,
1462 PRIMARY KEY (RELATIONSHIP_ID),
1463 FOREIGN KEY (WORKFLOW_ID) REFERENCES WF_WORKFLOW(ID)ON DELETE CASCADE,
1464 FOREIGN KEY (REQUEST_ID) REFERENCES WF_REQUEST(UUID)ON DELETE CASCADE
1465 )ENGINE INNODB;
1466 CREATE TABLE IF NOT EXISTS IDN_RECOVERY_DATA (
1467 USER_NAME VARCHAR(255) NOT NULL,
1468 USER_DOMAIN VARCHAR(127) NOT NULL,
1469 TENANT_ID INTEGER DEFAULT -1,
1470 CODE VARCHAR(255) NOT NULL,
1471 SCENARIO VARCHAR(255) NOT NULL,
1472 STEP VARCHAR(127) NOT NULL,
1473 TIME_CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1474 REMAINING_SETS VARCHAR(2500) DEFAULT NULL,
1475 PRIMARY KEY(USER_NAME, USER_DOMAIN, TENANT_ID, SCENARIO,STEP),
1476 UNIQUE(CODE)
1477 )ENGINE INNODB;
1478 CREATE TABLE IF NOT EXISTS IDN_PASSWORD_HISTORY_DATA (
1479 ID INTEGER NOT NULL AUTO_INCREMENT,
1480 USER_NAME VARCHAR(255) NOT NULL,
1481 USER_DOMAIN VARCHAR(127) NOT NULL,
1482 TENANT_ID INTEGER DEFAULT -1,
1483 SALT_VALUE VARCHAR(255),
1484 HASH VARCHAR(255) NOT NULL,
1485 TIME_CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1486 PRIMARY KEY(ID),
1487 UNIQUE (USER_NAME,USER_DOMAIN,TENANT_ID,SALT_VALUE,HASH)
1488 )ENGINE INNODB;
1489 CREATE TABLE IF NOT EXISTS IDN_CLAIM_DIALECT (
1490 ID INTEGER NOT NULL AUTO_INCREMENT,
1491 DIALECT_URI VARCHAR (255) NOT NULL,
1492 TENANT_ID INTEGER NOT NULL,
1493 PRIMARY KEY (ID),
1494 CONSTRAINT DIALECT_URI_CONSTRAINT UNIQUE (DIALECT_URI, TENANT_ID)
1495 )ENGINE INNODB;
1496 CREATE TABLE IF NOT EXISTS IDN_CLAIM (
1497 ID INTEGER NOT NULL AUTO_INCREMENT,
1498 DIALECT_ID INTEGER,
1499 CLAIM_URI VARCHAR (255) NOT NULL,
1500 TENANT_ID INTEGER NOT NULL,
1501 PRIMARY KEY (ID),
1502 FOREIGN KEY (DIALECT_ID) REFERENCES IDN_CLAIM_DIALECT(ID) ON DELETE CASCADE,
1503 CONSTRAINT CLAIM_URI_CONSTRAINT UNIQUE (DIALECT_ID, CLAIM_URI, TENANT_ID)
1504 )ENGINE INNODB;
1505 CREATE TABLE IF NOT EXISTS IDN_CLAIM_MAPPED_ATTRIBUTE (
1506 ID INTEGER NOT NULL AUTO_INCREMENT,
1507 LOCAL_CLAIM_ID INTEGER,
1508 USER_STORE_DOMAIN_NAME VARCHAR (255) NOT NULL,
1509 ATTRIBUTE_NAME VARCHAR (255) NOT NULL,
1510 TENANT_ID INTEGER NOT NULL,
1511 PRIMARY KEY (ID),
1512 FOREIGN KEY (LOCAL_CLAIM_ID) REFERENCES IDN_CLAIM(ID) ON DELETE CASCADE,
1513 CONSTRAINT USER_STORE_DOMAIN_CONSTRAINT UNIQUE (LOCAL_CLAIM_ID, USER_STORE_DOMAIN_NAME, TENANT_ID)
1514 )ENGINE INNODB;
1515 CREATE TABLE IF NOT EXISTS IDN_CLAIM_PROPERTY (
1516 ID INTEGER NOT NULL AUTO_INCREMENT,
1517 LOCAL_CLAIM_ID INTEGER,
1518 PROPERTY_NAME VARCHAR (255) NOT NULL,
1519 PROPERTY_VALUE VARCHAR (255) NOT NULL,
1520 TENANT_ID INTEGER NOT NULL,
1521 PRIMARY KEY (ID),
1522 FOREIGN KEY (LOCAL_CLAIM_ID) REFERENCES IDN_CLAIM(ID) ON DELETE CASCADE,
1523 CONSTRAINT PROPERTY_NAME_CONSTRAINT UNIQUE (LOCAL_CLAIM_ID, PROPERTY_NAME, TENANT_ID)
1524 )ENGINE INNODB;
1525 CREATE TABLE IF NOT EXISTS IDN_CLAIM_MAPPING (
1526 ID INTEGER NOT NULL AUTO_INCREMENT,
1527 EXT_CLAIM_ID INTEGER NOT NULL,
1528 MAPPED_LOCAL_CLAIM_ID INTEGER NOT NULL,
1529 TENANT_ID INTEGER NOT NULL,
1530 PRIMARY KEY (ID),
1531 FOREIGN KEY (EXT_CLAIM_ID) REFERENCES IDN_CLAIM(ID) ON DELETE CASCADE,
1532 FOREIGN KEY (MAPPED_LOCAL_CLAIM_ID) REFERENCES IDN_CLAIM(ID) ON DELETE CASCADE,
1533 CONSTRAINT EXT_TO_LOC_MAPPING_CONSTRN UNIQUE (EXT_CLAIM_ID, TENANT_ID)
1534 )ENGINE INNODB;
1535 CREATE TABLE IF NOT EXISTS IDN_SAML2_ASSERTION_STORE (
1536 ID INTEGER NOT NULL AUTO_INCREMENT,
1537 SAML2_ID VARCHAR(255) ,
1538 SAML2_ISSUER VARCHAR(255) ,
1539 SAML2_SUBJECT VARCHAR(255) ,
1540 SAML2_SESSION_INDEX VARCHAR(255) ,
1541 SAML2_AUTHN_CONTEXT_CLASS_REF VARCHAR(255) ,
1542 SAML2_ASSERTION VARCHAR(4096) ,
1543 PRIMARY KEY (ID)
1544 )ENGINE INNODB;
1545 CREATE TABLE IDN_SAML2_ARTIFACT_STORE (
1546 ID INT(11) NOT NULL AUTO_INCREMENT,
1547 SOURCE_ID VARCHAR(255) NOT NULL,
1548 MESSAGE_HANDLER VARCHAR(255) NOT NULL,
1549 AUTHN_REQ_DTO BLOB NOT NULL,
1550 SESSION_ID VARCHAR(255) NOT NULL,
1551 EXP_TIMESTAMP TIMESTAMP NOT NULL,
1552 INIT_TIMESTAMP TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1553 ASSERTION_ID VARCHAR(255),
1554 PRIMARY KEY (`ID`)
1555 )ENGINE INNODB;
1556 CREATE TABLE IF NOT EXISTS IDN_OIDC_JTI (
1557 JWT_ID VARCHAR(255) NOT NULL,
1558 EXP_TIME TIMESTAMP NOT NULL ,
1559 TIME_CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
1560 PRIMARY KEY (JWT_ID)
1561 )ENGINE INNODB;
1562 CREATE TABLE IF NOT EXISTS IDN_OIDC_PROPERTY (
1563 ID INTEGER NOT NULL AUTO_INCREMENT,
1564 TENANT_ID INTEGER,
1565 CONSUMER_KEY VARCHAR(255) ,
1566 PROPERTY_KEY VARCHAR(255) NOT NULL,
1567 PROPERTY_VALUE VARCHAR(2047) ,
1568 PRIMARY KEY (ID),
1569 FOREIGN KEY (CONSUMER_KEY) REFERENCES IDN_OAUTH_CONSUMER_APPS(CONSUMER_KEY) ON DELETE CASCADE
1570 )ENGINE INNODB;
1571 CREATE TABLE IF NOT EXISTS IDN_OIDC_REQ_OBJECT_REFERENCE (
1572 ID INTEGER NOT NULL AUTO_INCREMENT,
1573 CONSUMER_KEY_ID INTEGER ,
1574 CODE_ID VARCHAR(255) ,
1575 TOKEN_ID VARCHAR(255) ,
1576 SESSION_DATA_KEY VARCHAR(255),
1577 PRIMARY KEY (ID),
1578 FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE,
1579 FOREIGN KEY (TOKEN_ID) REFERENCES IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) ON DELETE CASCADE,
1580 FOREIGN KEY (CODE_ID) REFERENCES IDN_OAUTH2_AUTHORIZATION_CODE(CODE_ID) ON DELETE CASCADE
1581 )ENGINE INNODB;
1582 CREATE TABLE IF NOT EXISTS IDN_OIDC_REQ_OBJECT_CLAIMS (
1583 ID INTEGER NOT NULL AUTO_INCREMENT,
1584 REQ_OBJECT_ID INTEGER,
1585 CLAIM_ATTRIBUTE VARCHAR(255) ,
1586 ESSENTIAL CHAR(1) NOT NULL DEFAULT '0' ,
1587 VALUE VARCHAR(255) ,
1588 IS_USERINFO CHAR(1) NOT NULL DEFAULT '0',
1589 PRIMARY KEY (ID),
1590 FOREIGN KEY (REQ_OBJECT_ID) REFERENCES IDN_OIDC_REQ_OBJECT_REFERENCE (ID) ON DELETE CASCADE
1591 )ENGINE INNODB;
1592 CREATE TABLE IF NOT EXISTS IDN_OIDC_REQ_OBJ_CLAIM_VALUES (
1593 ID INTEGER NOT NULL AUTO_INCREMENT,
1594 REQ_OBJECT_CLAIMS_ID INTEGER ,
1595 CLAIM_VALUES VARCHAR(255) ,
1596 PRIMARY KEY (ID),
1597 FOREIGN KEY (REQ_OBJECT_CLAIMS_ID) REFERENCES IDN_OIDC_REQ_OBJECT_CLAIMS(ID) ON DELETE CASCADE
1598 )ENGINE INNODB;
1599 CREATE TABLE IF NOT EXISTS IDN_CERTIFICATE (
1600 ID INTEGER NOT NULL AUTO_INCREMENT,
1601 NAME VARCHAR(100),
1602 CERTIFICATE_IN_PEM BLOB,
1603 TENANT_ID INTEGER DEFAULT 0,
1604 PRIMARY KEY(ID),
1605 CONSTRAINT CERTIFICATE_UNIQUE_KEY UNIQUE (NAME, TENANT_ID)
1606 )ENGINE INNODB;
1607 CREATE TABLE IF NOT EXISTS IDN_OIDC_SCOPE (
1608 ID INTEGER NOT NULL AUTO_INCREMENT,
1609 NAME VARCHAR(255) NOT NULL,
1610 TENANT_ID INTEGER DEFAULT -1,
1611 PRIMARY KEY (ID)
1612 )ENGINE INNODB;
1613 CREATE TABLE IF NOT EXISTS IDN_OIDC_SCOPE_CLAIM_MAPPING (
1614 ID INTEGER NOT NULL AUTO_INCREMENT,
1615 SCOPE_ID INTEGER,
1616 EXTERNAL_CLAIM_ID INTEGER,
1617 PRIMARY KEY (ID),
1618 FOREIGN KEY (SCOPE_ID) REFERENCES IDN_OIDC_SCOPE(ID) ON DELETE CASCADE,
1619 FOREIGN KEY (EXTERNAL_CLAIM_ID) REFERENCES IDN_CLAIM(ID) ON DELETE CASCADE
1620 )ENGINE INNODB;
1621 CREATE INDEX IDX_AT_SI_ECI ON IDN_OIDC_SCOPE_CLAIM_MAPPING(SCOPE_ID, EXTERNAL_CLAIM_ID);
1622kind: ConfigMap
1623metadata:
1624 name: mysql-dbscripts
1625 namespace: wso2
1626---
1627
1628apiVersion: v1
1629kind: Service
1630metadata:
1631 name: wso2is-rdbms-service
1632 namespace: wso2
1633spec:
1634 type: ClusterIP
1635 selector:
1636 deployment: wso2is-mysql
1637 ports:
1638 - name: mysql-port
1639 port: 3306
1640 targetPort: 3306
1641 protocol: TCP
1642---
1643
1644apiVersion: v1
1645kind: Service
1646metadata:
1647 name: wso2is-is-service
1648 namespace: wso2
1649 labels:
1650 deployment: wso2is-is
1651spec:
1652 selector:
1653 deployment: wso2is-is
1654 type: NodePort
1655 ports:
1656 - name: servlet-http
1657 port: 9763
1658 targetPort: 9763
1659 protocol: TCP
1660 - name: servlet-https
1661 port: 9443
1662 targetPort: 9443
1663 protocol: TCP
1664 nodePort: 30597
1665---
1666
1667apiVersion: apps/v1
1668kind: Deployment
1669metadata:
1670 name: wso2is-mysql-deployment
1671 namespace: wso2
1672spec:
1673 replicas: 1
1674 selector:
1675 matchLabels:
1676 deployment: wso2is-mysql
1677 template:
1678 metadata:
1679 labels:
1680 deployment: wso2is-mysql
1681 spec:
1682 containers:
1683 - name: wso2is-mysql
1684 image: mysql:5.7
1685 livenessProbe:
1686 exec:
1687 command:
1688 - sh
1689 - -c
1690 - "mysqladmin ping -u root -p${MYSQL_ROOT_PASSWORD}"
1691 initialDelaySeconds: 60
1692 periodSeconds: 10
1693 readinessProbe:
1694 exec:
1695 command:
1696 - sh
1697 - -c
1698 - "mysqladmin ping -u root -p${MYSQL_ROOT_PASSWORD}"
1699 initialDelaySeconds: 60
1700 periodSeconds: 10
1701 imagePullPolicy: IfNotPresent
1702 securityContext:
1703 runAsUser: 999
1704 env:
1705 - name: MYSQL_ROOT_PASSWORD
1706 value: root
1707 - name: MYSQL_USER
1708 value: wso2carbon
1709 - name: MYSQL_PASSWORD
1710 value: wso2carbon
1711 ports:
1712 - containerPort: 3306
1713 protocol: TCP
1714 volumeMounts:
1715 - name: mysql-dbscripts
1716 mountPath: /docker-entrypoint-initdb.d
1717 args: ["--max-connections", "10000"]
1718 volumes:
1719 - name: mysql-dbscripts
1720 configMap:
1721 name: mysql-dbscripts
1722 serviceAccountName: "wso2svc-account"
1723---
1724
1725apiVersion: apps/v1
1726kind: Deployment
1727metadata:
1728 name: wso2is-is-deployment
1729 namespace: wso2
1730spec:
1731 replicas: 1
1732 minReadySeconds: 30
1733 strategy:
1734 rollingUpdate:
1735 maxSurge: 1
1736 maxUnavailable: 0
1737 type: RollingUpdate
1738 selector:
1739 matchLabels:
1740 deployment: wso2is-is
1741 template:
1742 metadata:
1743 labels:
1744 deployment: wso2is-is
1745 spec:
1746 hostAliases:
1747 - ip: "127.0.0.1"
1748 hostnames:
1749 - "wso2is"
1750 containers:
1751 - name: wso2is-is
1752 image: docker.wso2.com/wso2is:5.7.0
1753 livenessProbe:
1754 exec:
1755 command:
1756 - /bin/sh
1757 - -c
1758 - nc -z localhost 9443
1759 initialDelaySeconds: 60
1760 periodSeconds: 10
1761 readinessProbe:
1762 exec:
1763 command:
1764 - /bin/sh
1765 - -c
1766 - nc -z localhost 9443
1767 initialDelaySeconds: 60
1768 periodSeconds: 10
1769 lifecycle:
1770 preStop:
1771 exec:
1772 command: ['sh', '-c', '${WSO2_SERVER_HOME}/bin/wso2server.sh stop']
1773 imagePullPolicy: Always
1774 securityContext:
1775 runAsUser: 802
1776 ports:
1777 - containerPort: 9763
1778 protocol: TCP
1779 - containerPort: 9443
1780 protocol: TCP
1781 volumeMounts:
1782 - name: identity-server-conf
1783 mountPath: /home/wso2carbon/wso2-config-volume/repository/conf
1784 - name: identity-server-conf-datasources
1785 mountPath: /home/wso2carbon/wso2-config-volume/repository/conf/datasources
1786 initContainers:
1787 - name: init-is
1788 image: busybox
1789 command: ['sh', '-c', 'echo -e "checking for the availability of MySQL"; while ! nc -z wso2is-rdbms-service 3306; do sleep 1; printf "-"; done; echo -e " >> MySQL started";']
1790 serviceAccountName: "wso2svc-account"
1791 imagePullSecrets:
1792 - name: wso2creds
1793 volumes:
1794 - name: identity-server-conf
1795 configMap:
1796 name: identity-server-conf
1797 - name: identity-server-conf-datasources
1798 configMap:
1799 name: identity-server-conf-datasources
1800---