scorecard-war/populate.sql

Insert into USERS (ID,USER_NAME,PASSWORD,USER_TYPE,EMAIL,STATUS,ENABLED,FIRST_NAME,LAST_NAME) values (1,'admin','5f4dcc3b5aa765d61d8327deb882cf99','super','admin@admin.com','1','1','tigo','admin');
INSERT INTO NOTIFICATION_TEMPLATE (ID,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON,VERSION,BODY,NAME,"SCOPE",STATUS,SUBJECT,"TYPE") VALUES
(1,'admin',NULL,'admin',NULL,0,'<h3>Bienvenido a tigo!</h3><p style="font-size: 12.8px;"><strong>Hola ${(user.firstName)!} ${(user.lastName)!}</strong></p><p style="font-size: 12.8px;">Te damos la mas cordial bienvenido, tu usuario fue creado exitosamente.</p><p style="font-size: 12.8px;">Datos de ingreso:</p><ul style="font-size: 12.8px;"><li>User: ${(user.userName)!}</li><li>Email: ${(user.email)!}</li><li>Password: ${(user.password)!}</li></ul>','ususario.nuevo',0,1,'Credenciales Acceso TIGO','javamail');
INSERT INTO NOTIFICATION_TEMPLATE (ID,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON,VERSION,BODY,NAME,"SCOPE",STATUS,SUBJECT,"TYPE") VALUES
(2,'admin',NULL,'admin',NULL,0,'<h3>Bienvenido a tigo!</h3><p style="font-size: 12.8px;"><strong>Hola ${(provider.name)!} </strong></p><p style="font-size: 12.8px;">Te damos la mas cordial bienvenido a la familia de proveedores tigo.</p><p style="font-size: 12.8px;"><strong>Contacto ${(provider.contacto)!} </strong></p><p></p><p style="font-size: 12.8px;"> Se Adjunta bienvenida:</p>','provider.new',0,1,'Bienvenido a proveedores TIGO','javamail');
INSERT INTO NOTIFICATION_TEMPLATE (ID,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON,VERSION,BODY,NAME,"SCOPE",STATUS,SUBJECT,"TYPE") VALUES
(5,'admin',NULL,'admin',NULL,0,'<h1>Nueva Evalucion para revision y aprobacion</h1>','gere.new',0,1,'Nueva Evalucion ingresada para gerencia','javamail');
INSERT INTO NOTIFICATION_TEMPLATE (ID,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON,VERSION,BODY,NAME,"SCOPE",STATUS,SUBJECT,"TYPE") VALUES
(3,'admin',NULL,'admin',NULL,0,'<h1>Nueva Evalucion para revision y aprobacion</h1>','new.new',0,1,'Cambio de estado evalucion','javamail');
INSERT INTO NOTIFICATION_TEMPLATE (ID,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON,VERSION,BODY,NAME,"SCOPE",STATUS,SUBJECT,"TYPE") VALUES
(4,'admin',NULL,'admin',NULL,0,'<h1>Nueva Evalucion para revision y aprobacion, en direccion</h1>','gere.new',0,1,'Nueva evaluacion para direccion','javamail');
INSERT INTO NOTIFICATION_TEMPLATE (ID,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON,VERSION,BODY,NAME,"SCOPE",STATUS,SUBJECT,"TYPE") VALUES
(6,'admin',NULL,'admin',NULL,0,'<h1>Nueva Evalucion Rechazada para revision contract management</h1>','contract_rej.new',0,1,'Nueva evaluacion rechazada para revision','javamail');
INSERT INTO NOTIFICATION_TEMPLATE (ID,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON,VERSION,BODY,NAME,"SCOPE",STATUS,SUBJECT,"TYPE") VALUES
(7,'admin',NULL,'admin',NULL,0,'<h1>Nueva Evalucion APROBADA</h1>','contract_rej.new',0,1,'Nueva Evaluacion APROBADA','javamail');
INSERT INTO NOTIFICATION_TEMPLATE (ID,CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON,VERSION,BODY,NAME,"SCOPE",STATUS,SUBJECT,"TYPE") VALUES
(8,'admin',NULL,'admin',NULL,0,'<h1>Evaluacion se ha hecho publica para su visualizacion</h1>','contract_rej.new',0,1,'Evalucion lista para visualizar','javamail');
;