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