• Home
• io.mosip.registration
• registration-services
• 1.2.0
• source code
• rollback_scripts.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.0.10.0.rollback_scripts.sql Maven / Gradle / Ivy

truncate table reg.global_param;

insert into reg.global_param values ('mosip.kernel.applicant.type.age.limit','mosip.kernel.applicant.type.age.limit','5','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.jsonvalidator.file-storage-uri','mosip.kernel.jsonvalidator.file-storage-uri','LOCAL','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.crypto.symmetric-algorithm-name','mosip.kernel.crypto.symmetric-algorithm-name','AES','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.keygenerator.symmetric-algorithm-length','mosip.kernel.keygenerator.symmetric-algorithm-length','256','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.keygenerator.asymmetric-algorithm-length','mosip.kernel.keygenerator.asymmetric-algorithm-length','2048','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.prid.restricted-numbers','mosip.kernel.prid.restricted-numbers','786,666','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.prid.length','mosip.kernel.prid.length','14','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.prid.sequence-limit','mosip.kernel.prid.sequence-limit','3','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.prid.repeating-block-limit','mosip.kernel.prid.repeating-block-limit','3','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.prid.repeating-limit','mosip.kernel.prid.repeating-limit','2','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.prid.not-start-with','mosip.kernel.prid.not-start-with','0,1','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.uin.restricted-numbers','mosip.kernel.uin.restricted-numbers','786,666','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.uin.length.repeating-block-limit','mosip.kernel.uin.length.repeating-block-limit','2','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.uin.length.sequence-limit','mosip.kernel.uin.length.sequence-limit','3','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.uin.length.repeating-limit','mosip.kernel.uin.length.repeating-limit','2','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.uin.length.conjugative-even-digits-limit','mosip.kernel.uin.length.conjugative-even-digits-limit','3','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.transliteration.arabic-language-code','mosip.kernel.transliteration.arabic-language-code','ara','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.transliteration.franch-language-code','mosip.kernel.transliteration.franch-language-code','fra','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.virus-scanner.host','mosip.kernel.virus-scanner.host','104.211.209.102','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.virus-scanner.port','mosip.kernel.virus-scanner.port','3310','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.jsonvalidator.property-source','mosip.kernel.jsonvalidator.property-source','LOCAL','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.xsdstorage-uri','mosip.kernel.xsdstorage-uri','LOCAL','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.xsdfile','mosip.kernel.xsdfile','LOCAL','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.jsonvalidator.schema-name','mosip.kernel.jsonvalidator.schema-name','mosip-identity-json-schema.json','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.registration.machinecenterchanged','mosip.registration.machinecenterchanged','false','CONFIGURATION','eng',true,'System',current timestamp,'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.registration.initial_setup','mosip.registration.initial_setup','Y','CONFIGURATION','eng',true,'System',current timestamp,'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.registration.is_software_update_available','mosip.registration.is_software_update_available','N','CONFIGURATION','eng',true,'System',current timestamp,'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.reg.services.current.version','mosip.reg.services.current.version','0','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.keygenerator.asymmetric-algorithm-name','mosip.kernel.keygenerator.asymmetric-algorithm-name','RSA','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.kernel.keygenerator.symmetric-algorithm-name','mosip.kernel.keygenerator.symmetric-algorithm-name','RSA','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.kernel.crypto.asymmetric-algorithm-name','mosip.kernel.crypto.asymmetric-algorithm-name','RSA','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.signature.signature-request-id','mosip.kernel.signature.signature-request-id','SIGNATURE.REQUEST','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.kernel.signature.signature-version-id','mosip.kernel.signature.signature-version-id','v1.0','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.signed.header','mosip.signed.header','response-signature','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('auth.role.prefix','auth.role.prefix','ROLE_','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('auth.header.name','auth.header.name','Authorization','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.kernel.idobjectvalidator.schema-name','mosip.kernel.idobjectvalidator.schema-name','mosip-identity-json-schema.json','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.idobjectvalidator.file-storage-uri','mosip.kernel.idobjectvalidator.file-storage-uri','LOCAL','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.idobjectvalidator.property-source','mosip.kernel.idobjectvalidator.property-source','LOCAL','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.idobjectvalidator.mandatory-attributes.reg-client.new-registration','mosip.kernel.idobjectvalidator.mandatory-attributes.reg-client.new-registration','fullName,dateOfBirth|age,gender,addressLine1,region,province,city,localAdministrativeAuthority,postalCode,residenceStatus','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.kernel.idobjectvalidator.mandatory-attributes.reg-client.child-registration','mosip.kernel.idobjectvalidator.mandatory-attributes.reg-client.child-registration','fullName,dateOfBirth|age,gender,addressLine1,region,province,city,localAdministrativeAuthority,postalCode,residenceStatus,parentOrGuardianName,parentOrGuardianRID|parentOrGuardianUIN,parentOrGuardianBiometrics','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.kernel.idobjectvalidator.mandatory-attributes.reg-client.lost-uin','mosip.kernel.idobjectvalidator.mandatory-attributes.reg-client.lost-uin','','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.kernel.idobjectvalidator.mandatory-attributes.reg-client.update-uin','mosip.kernel.idobjectvalidator.mandatory-attributes.reg-client.update-uin','','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.id.validation.identity.dateOfBirth','mosip.id.validation.identity.dateOfBirth','^\\d{4}/([0]\\d|1[0-2])/([0-2]\\d|3[01])$','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.id.validation.identity.phone','mosip.id.validation.identity.phone','^([6-9]{1})([0-9]{9})$','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.id.validation.identity.email','mosip.id.validation.identity.email','^[\\w-\\+]+(\\.[\\w]+)*@[\\w-]+(\\.[\\w]+)*(\\.[a-z]{2,})$','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.id.validation.identity.postalCode','mosip.id.validation.identity.postalCode','^[(?i)A-Z0-9]{5}$','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.id.validation.identity.CNIENumber','mosip.id.validation.identity.CNIENumber','^([0-9]{10,30})$','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.id.validation.identity.age','mosip.id.validation.identity.age','^(150|1[0-4][0-9]|[1-9]?[0-9])$','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp); 

insert into reg.global_param values ('mosip.id.validation.identity.fullName.[*].value','mosip.id.validation.identity.fullName.[*].value','^(?=.{0,50}$).*','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.id.validation.identity.addressLine1.[*].value','mosip.id.validation.identity.addressLine1.[*].value','^(?=.{0,50}$).*','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.id.validation.identity.addressLine2.[*].value','mosip.id.validation.identity.addressLine2.[*].value','^(?=.{0,50}$).*','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.id.validation.identity.addressLine3.[*].value','mosip.id.validation.identity.addressLine3.[*].value','^(?=.{0,50}$).*','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.id.validation.identity.region.[*].value','mosip.id.validation.identity.region.[*].value','^(?=.{0,50}$).*','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.id.validation.identity.province.[*].value','mosip.id.validation.identity.province.[*].value','^(?=.{0,50}$).*','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.id.validation.identity.city.[*].value','mosip.id.validation.identity.city.[*].value','^(?=.{0,50}$).*','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.country.code','mosip.country.code','MOR','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);	

insert into reg.global_param values ('mosip.registration.app.id','mosip.registration.app.id','REGISTRATIONCLIENT','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('mosip.kernel.otp.expiry-time','mosip.kernel.otp.expiry-time','180','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('auth.jwt.secret','auth.jwt.secret','authjwtsecret','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);

insert into reg.global_param values ('auth.jwt.base','auth.jwt.base','Mosip-Token','CONFIGURATION','eng',true,'SYSTEM',current timestamp, 'SYSTEM',current timestamp, false, current timestamp);