Kitty_Fall_Mytel/FIle/database_usesAndSub.sql

--------------------------------------------------------
--  File created - Tuesday-June-30-2026   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table CONFIG
--------------------------------------------------------

  CREATE TABLE "CONFIG" 
   (	"MODULE" NVARCHAR2(100), 
	"PARAM_NAME" NVARCHAR2(50), 
	"PARAM_VALUE" NVARCHAR2(1024), 
	"PARAM_VALUE_FR" NVARCHAR2(1024), 
	"NOTE" NVARCHAR2(1024), 
	"DEFAULT_VALUE" VARCHAR2(4000 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Table CHARGE_LOG
--------------------------------------------------------

  CREATE TABLE "CHARGE_LOG" 
   (	"ID" NUMBER, 
	"MSISDN" VARCHAR2(255 CHAR), 
	"ACCOUNT_ID" VARCHAR2(255 CHAR), 
	"FEE" NUMBER(12,2), 
	"DESCRIPTION" CLOB, 
	"CHARGE_TIME" DATE DEFAULT sysdate, 
	"INSERT_TIME" DATE DEFAULT sysdate, 
	"STATUS" NUMBER
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 LOB ("DESCRIPTION") STORE AS SECUREFILE (ENABLE STORAGE IN ROW CHUNK 8192
  NOCACHE LOGGING  NOCOMPRESS  KEEP_DUPLICATES 
  STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
--------------------------------------------------------
--  DDL for Table MPS_CONFIG
--------------------------------------------------------

  CREATE TABLE "MPS_CONFIG" 
   (	"ACTION_CODE" VARCHAR2(200 BYTE), 
	"SERVICE" VARCHAR2(100 BYTE), 
	"SUB_SERVICE" VARCHAR2(100 BYTE), 
	"CP_NAME" VARCHAR2(100 BYTE), 
	"COMMAND" VARCHAR2(100 BYTE), 
	"CATEGORY" VARCHAR2(100 BYTE), 
	"PRICE" VARCHAR2(100 BYTE), 
	"KEY_PATH" VARCHAR2(200 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Table MT_HIS
--------------------------------------------------------

  CREATE TABLE "MT_HIS" 
   (	"MT_HIS_ID" NUMBER(10,0), 
	"MO_HIS_ID" NUMBER(10,0), 
	"MSISDN" VARCHAR2(15 BYTE), 
	"RECEIVE_TIME" DATE, 
	"SENT_TIME" DATE, 
	"MESSAGE" NVARCHAR2(1024), 
	"STATUS" NUMBER(1,0), 
	"CHANNEL" VARCHAR2(20 BYTE), 
	"NODE_NAME" NVARCHAR2(80), 
	"CLUSTER_NAME" NVARCHAR2(80)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING;
--------------------------------------------------------
--  DDL for Table ACCOUNT_ADMIN
--------------------------------------------------------

  CREATE TABLE "ACCOUNT_ADMIN" 
   (	"ID" NUMBER, 
	"USER_ADMIN" VARCHAR2(255 CHAR), 
	"PASS_ADMIN" VARCHAR2(255 CHAR), 
	"CREATED_DATE" DATE DEFAULT sysdate, 
	"UPDATE_DATE" DATE DEFAULT sysdate, 
	"STATUS" VARCHAR2(20 BYTE) DEFAULT 'ACTIVE', 
	"SERVICE_ID" NUMBER(10,0) DEFAULT 1, 
	"ROLE" VARCHAR2(200 BYTE) DEFAULT 'USER'
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Table MT
--------------------------------------------------------

  CREATE TABLE "MT" 
   (	"MT_ID" NUMBER, 
	"MO_HIS_ID" NUMBER(10,0), 
	"MSISDN" VARCHAR2(20 BYTE), 
	"MESSAGE" NVARCHAR2(2000), 
	"RECEIVE_TIME" DATE, 
	"RETRY_NUM" NUMBER(2,0) DEFAULT 0, 
	"CHANNEL" VARCHAR2(10 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Table REG_INFO
--------------------------------------------------------

  CREATE TABLE "REG_INFO" 
   (	"REGISTER_ID" NUMBER, 
	"MSISDN" VARCHAR2(20 BYTE), 
	"PRODUCT_NAME" VARCHAR2(100 BYTE), 
	"REGISTER_TIME" DATE, 
	"NUMBER_SPIN" NUMBER(5,0), 
	"EXTEND_SPIN" NUMBER(5,0), 
	"EXTEND_STATUS" NUMBER(1,0), 
	"STATUS" NUMBER(1,0), 
	"EXPIRE_TIME" DATE, 
	"LAST_EXTEND" DATE, 
	"PLAYED_TIMES" NUMBER(5,0), 
	"END_TIME" DATE, 
	"ALREADY_CHARGED" NUMBER(10,2), 
	"RENEW" NUMBER(2,0) DEFAULT 0, 
	"SERVICE_ID" NUMBER(10,2), 
	"CHANNEL" VARCHAR2(20 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Table ACCOUNT_INFO
--------------------------------------------------------

  CREATE TABLE "ACCOUNT_INFO" 
   (	"ID" NUMBER, 
	"MSISDN" VARCHAR2(200 BYTE), 
	"REFRESH_TOKEN" VARCHAR2(2000 BYTE)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING;
--------------------------------------------------------
--  DDL for Table PERMISSION
--------------------------------------------------------

  CREATE TABLE "PERMISSION" 
   (	"ID" NUMBER, 
	"NAME" VARCHAR2(200 BYTE), 
	"STATUS" VARCHAR2(20 BYTE) DEFAULT 'ACTIVE', 
	"PATH" VARCHAR2(200 BYTE), 
	"ACTION" VARCHAR2(200 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Table LUCKY_SPIN
--------------------------------------------------------

  CREATE TABLE "LUCKY_SPIN" 
   (	"ID" NUMBER(12,0), 
	"MSISDN" VARCHAR2(15 BYTE), 
	"ADDED" NUMBER(10,0), 
	"USED" NUMBER(10,0), 
	"INSERT_TIME" DATE, 
	"EXPIRE_TIME" DATE, 
	"LAST_UPDATE" DATE, 
	"CHANNEL_ADD" VARCHAR2(15 BYTE)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING;
--------------------------------------------------------
--  DDL for Table ACCOUNT_USER
--------------------------------------------------------

  CREATE TABLE "ACCOUNT_USER" 
   (	"ID" NUMBER, 
	"MSISDN" VARCHAR2(20 CHAR), 
	"USERS" VARCHAR2(255 CHAR), 
	"PASS" VARCHAR2(255 CHAR), 
	"SERVICE_ID" VARCHAR2(255 CHAR), 
	"CREATED_DATE" DATE DEFAULT sysdate, 
	"UPDATE_DATE" DATE DEFAULT sysdate, 
	"IS_ACTIVE" NUMBER(2,0) DEFAULT 1, 
	"CHANNEL" VARCHAR2(1000 BYTE) DEFAULT 'USSD', 
	"FREE_SPIN" NUMBER(10,0) DEFAULT 0, 
	"TOTAL_SPIN" NUMBER(10,0) DEFAULT 0, 
	"ROLE" VARCHAR2(100 BYTE) DEFAULT 'USER', 
	"LANGUAGE" NUMBER(2,0) DEFAULT 1, 
	"IS_LOCK" NUMBER(2,0) DEFAULT 0, 
	"TOTAL_FALSE" NUMBER(5,0) DEFAULT 0, 
	"TIME_LOCK" DATE DEFAULT sysdate, 
	"LAST_UPDATE" DATE DEFAULT sysdate, 
	"LAST_LOGIN" DATE DEFAULT sysdate, 
	"POINT" NUMBER(10,0) DEFAULT 0, 
	"STATUS" NUMBER(2,0) DEFAULT 1, 
	"PICTURE" VARCHAR2(500 CHAR) DEFAULT 'default.png', 
	"FULLNAME" VARCHAR2(255 CHAR), 
	"EMAIL" VARCHAR2(255 CHAR), 
	"BIRTHDAY" DATE DEFAULT sysdate
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Table PACKG
--------------------------------------------------------

  CREATE TABLE "PACKG" 
   (	"PRODUCT_ID" NUMBER(10,0), 
	"FEE" NUMBER(12,2), 
	"NUMBER_SPIN" NUMBER(5,0), 
	"PRODUCT_NAME" VARCHAR2(100 BYTE), 
	"SMS_SYNTAX" VARCHAR2(100 BYTE), 
	"BIZ_ID" NUMBER(5,0), 
	"EXPIRE_DAYS" NUMBER(5,0), 
	"RENEW" NUMBER(2,0) DEFAULT 0
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Table ROLE
--------------------------------------------------------

  CREATE TABLE "ROLE" 
   (	"ID" NUMBER, 
	"NAME" VARCHAR2(200 BYTE), 
	"DESCRIPTION" VARCHAR2(2000 BYTE), 
	"CODE" VARCHAR2(20 BYTE), 
	"STATUS" VARCHAR2(20 BYTE) DEFAULT 'ACTIVE'
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Table ROLE_PERMISSION
--------------------------------------------------------

  CREATE TABLE "ROLE_PERMISSION" 
   (	"ID" NUMBER, 
	"ROLE_ID" NUMBER, 
	"PERMISSION_ID" NUMBER, 
	"STATUS" VARCHAR2(20 BYTE) DEFAULT 'ACTIVE'
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Table TRANSACTION_ACTION
--------------------------------------------------------

  CREATE TABLE "TRANSACTION_ACTION" 
   (	"ID" NUMBER, 
	"MSISDN" VARCHAR2(20 BYTE), 
	"TRANSACTION_ID" VARCHAR2(200 BYTE), 
	"OTP" VARCHAR2(20 BYTE), 
	"CREATED_TIME" DATE DEFAULT sysdate, 
	"VALID_TIME" DATE, 
	"TIME_LEFT" NUMBER DEFAULT 3
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Table TRANSACTION_LOG
--------------------------------------------------------

  CREATE TABLE "TRANSACTION_LOG" 
   (	"TRANSACTION_ID" VARCHAR2(100 BYTE), 
	"TYPE" NUMBER(5,0), 
	"MSISDN" VARCHAR2(15 BYTE), 
	"REQUEST" VARCHAR2(2000 BYTE), 
	"ERROR_CODE" VARCHAR2(50 BYTE), 
	"COMMAND" VARCHAR2(50 BYTE), 
	"REQUEST_TIME" DATE, 
	"RESPONSE_TIME" DATE, 
	"RESPONSE" VARCHAR2(4000 BYTE), 
	"CHANNEL" VARCHAR2(100 BYTE), 
	"RESULT_VALUE" VARCHAR2(200 BYTE)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING;
--------------------------------------------------------
--  DDL for Table WEBSERVICE
--------------------------------------------------------

  CREATE TABLE "WEBSERVICE" 
   (	"WS_ID" NUMBER(10,0), 
	"WS_NAME" VARCHAR2(1000 BYTE), 
	"WS_CODE" VARCHAR2(100 BYTE), 
	"WSDL" VARCHAR2(1000 BYTE), 
	"MSG_TEMPLATE" VARCHAR2(2000 BYTE), 
	"STATUS" NUMBER(1,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Table WS_USER
--------------------------------------------------------

  CREATE TABLE "WS_USER" 
   (	"WS_USER_ID" NUMBER(10,0), 
	"USERNAME" VARCHAR2(100 BYTE), 
	"PASSWORD" VARCHAR2(100 BYTE), 
	"IP_ADDRESS" VARCHAR2(2000 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
REM INSERTING into CONFIG
SET DEFINE OFF;
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','GIFT_FRIEND_SUCCESS','Ou voye %spin% Vire  pou %friend%.avek sikse.Ou peye%money% HTG. Zanmil lan ap kontan anpil! Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_MULTIPLE_SPIN','Ou genyen doub vire. Konnye a ou genyen %spin% vire.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_RESET_SPIN','Malerezman , Ou pedi vire yo.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','SCAN_MT_TIME','00:00:00-23:59:59',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('RECEIVER','RESPONSE_BUSY','5000',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('RECEIVER','MSG_OVER_LOAD','MSG_OVER_LOAD',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('RECEIVER','REQUEST_EXIST','REQUEST_EXIST',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('RECEIVER','SYSTEM_FAIL','SYSTEM_FAIL',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('RECEIVER','SYNTAXERROR','SYNTAXERROR',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('RECEIVER','EXPIRE','0',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('RECEIVER','PENDING','0',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','SQL_REPORT_HOURLY','select ''Report date: ''  || to_char(sysdate,''dd/mm/yyyy'') 
|| '' '' || to_char(sysdate,''HH24'') || ''h''
|| ''
Revenue: '' || revenue || ''
Register new: '' || count_reg || ''
Deactive: '' || count_deactive|| ''
Total active: '' || count_active|| ''
Winner money: '' || paid_money|| ''
Winner count: '' || winner
from 
(select * from 
(
(select nvl(sum(fee),0) revenue from charge_log where charge_time >= trunc(sysdate) and charge_time < sysdate)
left join
(select count(*) count_reg from reg_info where register_time >= trunc(sysdate) and register_time < sysdate) on 1=1
left join
(select nvl(sum(money),0) paid_money, count (distinct msisdn) winner from history_play where  play_day >= trunc(sysdate) and play_day < sysdate) on 1=1
left join 
(select count(*) count_active from reg_info where status = 1) on 1=1
left join 
(select count(*) count_deactive from reg_info where status = 0 and end_time >= trunc(sysdate) and end_time < sysdate) on 1=1
) ) a',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','REGISTER_SUCCESS_WEEKLY','Felisitasyon! Ou anrejistre Lucky Draw avek sikse. Pri a se 15 HTG/semen. Ou gen 5 woulet/jou, achte plis: 2HTG/3 woulet. Ale sou https://guesssong.tls.tl pou anrejistre sevis epi gen yon chans pou jwenn gwo pri. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','REGISTER_SUCCESS_MONTHLY','Felisitasyon! Ou anrejistre Lucky Draw avek sikse. Pri a se 45 HTG/Mwa. Ou gen 5 woulet/jou, achte plis: 2HTG/3 woulet. Ale sou https://guesssong.tls.tl pou anrejistre sevis epi gen yon chans pou jwenn gwo pri. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RECHARGE_GIFT','WAW! Konnye a ou ka jwe Lawoulet  epi genyen gwo prim p. Pou plis enfomasyon sou sevis la voye HELP nan 7878. Pouw komanse jwe avek kado a tape *7878*2# Mesi !',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','MONEY_LIMIT','25000',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','SQL_DISABLE_SERVICE','update REG_INFO set status=0 where MSISDN=? and status = 1',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_LOSE_SPIN','Ou jwe woulet nan BONCHANS. Tanpri kontinye jwe woulet pou gen yon chans jwenn gwo pri. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_REMAIN_SPIN_REG_GIFT','Kado vire ou rete a se %giftSpin%
Vire ou rete apre anrejistreman an se %regSpin%',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_REMAIN_SPIN_REG','Vire ou rete apre anrejistreman an se %regSpin% ',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_REMAIN_SPIN_GIFT','Kado vire ou rete a se %giftSpin%',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_REMAIN_NO_SPIN','Ou pa genyen vire .Tanpri achte pouw ka kontinye jwe. Mesi ',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','NOT_ENOUGH_POINT','Pwen ou piti',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WAIT_INVITE_FRIEND','Tanpri mete nimewo zanmi ou an. Ou pral resevwa 5 pwen pou envitasyon avek sikse.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','INVITE_POINT','5',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_INVITE_FRIEND','Felisitasyon! Ou envite %phone% avek sikse epi li resevwa 5 pwen. Zanmi ou an pral kontan! Mesi.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','CHANGE_POINT_SUCCESS','Ou konveti %point% pwen pou jwenn %money% HTG avek sikse. Bon chans!
Ale sou https://guesssong.tls.tl jwi jwet la epi jwenn chans pou genyen gwo prim. Bon Chans!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RECEIVED_INVITATION','%phone% envite w nan sevis WHEELING BINGO. Ale sou https://guesssong.tls.tl pou anrejistre sevis la epi gen yon chans pou jwenn gwo pri. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_MULTIPLE_POINT','Felisitasyon! Ou genyen X2.Ou ka konveti 10 pwen pouw resevwa 1 HTG Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','REGISTER_SUCCESS_USSD_WEEKLY','Felisitasyon! Ou anrejistre Lucky Draw avek sikse. Pri a se 15 HTG/semen. Ou gen 5 woulet/jou, achte plis: 2HTG/3 woulet. Ale sou https://guesssong.tls.tl pou anrejistre sevis epi gen yon chans pou jwenn gwo pri. Modpas ou se %password%. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','SQL_REPORT','select ''Report date: '' ||to_char(sysdate-1,''dd/mm/yyyy'') 
|| ''
Revenue: '' || revenue || ''
Register new: '' || count_reg || ''
Deactive: '' || count_deactive|| ''
Total active: '' || count_active|| ''
Winner money: '' || paid_money|| ''
Winner count: '' || winner
from 
(select * from 
(
(select nvl(sum(fee),0) revenue from charge_log where charge_time >= trunc(sysdate-1) and charge_time < trunc(sysdate))
left join
(select count(*) count_reg from reg_info where register_time >= trunc(sysdate-1) and register_time < trunc(sysdate)) on 1=1
left join
(select nvl(sum(money),0) paid_money, count (distinct msisdn) winner from history_play where  play_day >= trunc(sysdate-1) and play_day < trunc(sysdate)) on 1=1
left join 
(select count(*) count_active from reg_info where status = 1) on 1=1
left join 
(select count(*) count_deactive from reg_info where status = 0 and end_time >= trunc(sysdate-1) and end_time < trunc(sysdate)) on 1=1
) ) a',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','LIST_RECEIVE_REPORT','50933123456,50940240715',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','CHANNEL','1542',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','COUNTRY_CODE','95',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','SPIN_FEE','0.6667',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','WRONG_SYNTAX','Wrong syntax!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','ACCOUNT_BLOCKED_RES','55',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','LIST_SUCCESS_RES','0,100',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','NOT_ENOUGH_MONEY_RES','55',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','ERROR','Error!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','CHARGE_FEE_SUCCESS','Buying one more time to play successful. Fee is 1HTG.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','NOT_ENOUGH_BALANCE','You have not enough money to %action%.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','SYSTEM_FAIL','System fail. Try again later!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','LIST_CANCEL_SUCCESS_RES','0,411,511,414',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_LOSE_TURN_UNSUB','Ou jwe woulet nan BONCHANS. Tanpri kontinye jwe woulet pou gen yon chans jwenn gwo pri. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_ADD_POINT','Felisitasyon! Ou genyen %point%. Ou ka konveti 10 pwen pouw resevwa 1 HTG. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','ADD_SPIN_FEE','3',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','MIN_POINT_TO_ADD_WEEKLY_PRIZE','2',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','EXCHANGE_SUCCESS_DAILY','Exchange top %top%  to   %money% HTG  TYpe  %type%',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','EXCHANGE_SUCCESS_WEEKLY','Exchange top %top%  to   %money% HTG  TYpe  %type%',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','EXCHANGE_SUCCESS_MONTHLY','Exchange top %top%  to   %money% HTG  TYpe  %type%',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','REGISTER_SUCCESS_USSD_MONTHLY','Felisitasyon! Ou anrejistre Lucky Draw avek sikse. Pri a se 45 HTG/Mwa. Ou gen 5 woulet/jou, achte plis: 2HTG/3 woulet. Ale sou https://guesssong.tls.tl pou anrejistre sevis epi gen yon chans pou jwenn gwo pri. Modpas ou se %password%. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','REGISTER_SUCCESS_USSD_DAILY','Felisitasyon! Ou anrejistre Lucky Draw avek sikse. Pri a se 5 HTG/jou. Ou gen 5 woulet/jou, achte plis: 2HTG/3 woulet. Ale sou https://guesssong.tls.tl pou anrejistre sevis epi gen yon chans pou jwenn gwo pri. Modpas ou se %password%. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RECEIVER_GIFT','WAW! Zanmiw %msisdn% voye %spin% pou wou! Konnye a ou ka jwe Lawoulet  epi genyen gwo prim p. Pou plis enfomasyon sou sevis la voye  HELP nan 7878. Pouw komanse jwe avek kado a tape *7878*2# Mesi !',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RENEW_SPIN_SUCCESS','Ou gen 5 woulet pou jodi a. Ale sou https://guesssong.tls.tl jwi jwet la epi jwenn chans pou genyen gwo prim. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','EXTEND_PACKAGE_SUCCESS_WEEKLY','Ou renouvle sevis LUCKY DRAW avek sikse. Pri a se 15HTG/ 35woulet gratis/semen. Ale sou https://guesssong.tls.tl yo jwi jwet la epi yo gen yon chans jwenn pri gwo. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','EXTEND_PACKAGE_SUCCESS_MONTHLY','Ou renouvle sevis LUCKY DRAW avek sikse. Pri a se 45HTG/ 150woulet gratis/mwa. Ale sou https://guesssong.tls.tl yo jwi jwet la epi yo gen yon chans jwenn pri gwo. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','FTP_ADDRESS','127.0.0.1',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','FTP_ACCOUNT','test',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','FTP_PASS','123456a@',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','FTP_PATH','/cdr_test',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','FTP_DOWNLOADED_PATH','H:/ftp_client',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','FTP_RECHARGE_ADDRESS','127.0.0.1',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','FTP_RECHARGE_ACCOUNT','test',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','FTP_RECHARGE_PASS','123456a@',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','FTP_RECHARGE_PATH','/cdr_test/recharge',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','FTP_RECHARGE_DOWNLOADED_PATH','H:/ftp_client/recharge',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','ADD_SPIN_TIMES','3',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','BUY_SPIN_SUB_SUCCESS','Ou gen 3 vire an plis. Fre 2HTG. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_SCORE_WINNER','Kantite vire a se %spin%. Pi gwo kantite a se %spin%.Wap gen chans genyen prim Jodia!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','DISABLE_SUCCESS','Ou anile sevis Lawoullet la avek sikse. Pou anrejistre anko, rele *556*1#, *556*7#, *556*30#. Tounen vin jwenn nou pouw kapab genyen gwo prim. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','DISABLE_NOT_REGISTER','Ou poko anrejistre nan sevis Lawoullet la. Pou anrejistre sevis la rele *556*1#, *556*7#, *556*30#. Epi swiv enstriksyon yo .Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RANKING_PRIZE_SUCCESS','Felisitasyon! Ou genyen %money%HTG sou kont de baz ou ak %spin% vire e pozisyon %rank%. Pouw verifye, Tanpri , Tape *556# . Mesi',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_ADD_TIMES_UNSUB','Felisitasyon! Ou genyen 1 vire an plis. Kantite vire a se %spin%.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','MIN_POINT_TO_ADD_MONTHLY_PRIZE','2',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','ADD_MONEY_SUCCESS','Parabens, Ita simu ona %money%$ aumenta iha ita nia data hodi asesu ba internet husi servisu Sik Muzika. Obrigadu!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','ADD_DATA_SUCCESS','Parabens, Ita simu ona %data%MB aumenta iha ita nia data hodi asesu ba internet husi servisu Sik Muzika. Obrigadu!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','SEND_OTP_SUCCESS','Your new OTP is: %otp%',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RESEND_OTP_SUCCESS','Your new OTP is: %otp%',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','INVITED_MESSAGE','Zanmiw %msisdn% envitew itilize sevis LUCKY DRAW Natcom.Tape *556# pou plis enfomasyon.
Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','FRIEND_ALREADY_REGISTERED','Zanmiw %friend% ap itilize sevis la deja. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','ALREADY_REGISTERED','You have already registered %package%!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','REGISTER_SUCCESS','Register success!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','CREATE_ACCOUNT_SUCCESS','Your account is your number. Your password is %password%. 
	Go to https://guesssong.tls.tl to enjoy a fun time with hundreds of different quizzes and have a chance to get up to 500 HTG daily. Thank you.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','INVITE_SUCCESS','Invite %msisdn% successful. Please visit https://guesssong.tls.tl to check your reward.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','REGISTER_SUCCESS_USSD','Registered by USSD successful! Fee is %fee%. Your password is %password%. This package will be expired after %expire%. Please visit http://funquiz.natcom.com.ht to play your games.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RESET_PASSWORD_SUCCESS','Reset password successful. Your new password is %password%.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','EXTEND_PACKAGE_SUCCESS','Your account have been renewed successful.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RENEW_SUCCESS','Your account have been renewed successful.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','INVITE_FRIEND_SUCCESS','Invite %msisdn% successful. Please visit https://guesssong.tls.tl to check your reward.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','EXCHANGE_SUCCESS','Exchange %point% points to %money% HTG successful ',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_ADD_MONEY_UNSUB','Felisitasyon! Ou genyen %money% %unit%. Anrejistre nan sevis la pouw ka genyen 300HTG.
Bon Chans!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_ADD_TIMES','Felisitasyon! Ou genyen %added_spin% vire an plis. Kantite vire a se %spin%.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_LOSE_TURN','Ou jwe woulet nan BONCHANS. Tanpri kontinye jwe woulet pou gen yon chans jwenn gwo pri. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','INVITE_TO_SPIN','Ou genyen %number% Vire pou kounya. Eske ou vle Vire kounya?',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_ADD_SCORE','Congratulation! You got %description% score. Your total score is %score%. You still have a chance to win the prize today. Good luck to you!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_RESET_SCORE','Sorry! You have lost all your score. Your total score is  0. You still have a chance to win the prize today. Good luck to you!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_MULTIPLE_SCORE','Congratulation! You got double your scores. Your total score is %score%. You still have a chance to win the prize today. Good luck to you!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_WIN_ADD_SPIN','Felisitasyon! Ou gen %added_spin% woulet gratis. Tanpri kontinye jwe woulet pou gen yon chans jwenn gwo pri. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','INTRODUCE_MESSAGE','Lucky Draw se yon s vis kote itilizate an selman bezwen konekte ak nimewo Natcom nan epi peze Spin pou jwen yon woulet, kounya se kapab chans paw pou jwenn rekonpans lan. Pake jounalye: fe *556*1#, fre 5 HTG/jou ak 5 woulet gratis. Pake semen: fe *556*7 #, fr  15 HTG/sem n ak 5 woulet gratis/jou. Pake mwa: fe *556*30#, fr  45 HTG/mwa ak 5 woulet gratis/jou. Pou anile s vis lan , fe *556*0#. Ou ka konv ti 10 pwen pou ka resevwa 1 HTG. Ale sou http://luckydraw.natcom.com.ht pou anrejistre sevis la epi gen yon chans pou jwenn gwo pri. Mesi!',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','RETURN_CURRENT_RANKING','Konnye a ran ou se %rank%',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('PROCESS','CONFIRM_GIFT_FRIEND','Voye %spin% vire pou zanmi. Wap peye %money% HTG.',null,null,null);
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('FREE_LIMIT','APPLICATIONS_PER_DAY','3',null,'So lan ung tuyen toi da/ngay cho Free user','3');
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('FREE_LIMIT','CV_OPERATIONS_PER_DAY','2',null,'So lan tao/sua CV toi da/ngay cho Free user','2');
Insert into CONFIG (MODULE,PARAM_NAME,PARAM_VALUE,PARAM_VALUE_FR,NOTE,DEFAULT_VALUE) values ('FREE_LIMIT','APPLICATIONS_PER_DAY ','3',null,null,null);
REM INSERTING into CHARGE_LOG
SET DEFINE OFF;
Insert into CHARGE_LOG (ID,MSISDN,ACCOUNT_ID,FEE,CHARGE_TIME,INSERT_TIME,STATUS) values (1000,'9587200090',null,199,to_date('03-JUN-26','DD-MON-RR'),to_date('03-JUN-26','DD-MON-RR'),1);
Insert into CHARGE_LOG (ID,MSISDN,ACCOUNT_ID,FEE,CHARGE_TIME,INSERT_TIME,STATUS) values (1020,'9589898989',null,199,to_date('11-JUN-26','DD-MON-RR'),to_date('11-JUN-26','DD-MON-RR'),1);
REM INSERTING into MPS_CONFIG
SET DEFINE OFF;
Insert into MPS_CONFIG (ACTION_CODE,SERVICE,SUB_SERVICE,CP_NAME,COMMAND,CATEGORY,PRICE,KEY_PATH) values ('CHARGE_10','MINHA_VIBE','MINHA_VIBE_MINUS','VIETTECH','CHARGE','MINUS10','10','../etc/key/MINHA_VIBE_MINUS/');
Insert into MPS_CONFIG (ACTION_CODE,SERVICE,SUB_SERVICE,CP_NAME,COMMAND,CATEGORY,PRICE,KEY_PATH) values ('CHARGE_50','MINHA_VIBE','MINHA_VIBE_MINUS','VIETTECH','CHARGE','MINUS50','50','../etc/key/MINHA_VIBE_MINUS/');
Insert into MPS_CONFIG (ACTION_CODE,SERVICE,SUB_SERVICE,CP_NAME,COMMAND,CATEGORY,PRICE,KEY_PATH) values ('CANEL_MINHA_VIBE_DAY','MINHA_VIBE','MINHA_VIBE_DAY','VIETTECH','CANEL','BLANK','0','../etc/key/MINHA_VIBE_DAY/');
Insert into MPS_CONFIG (ACTION_CODE,SERVICE,SUB_SERVICE,CP_NAME,COMMAND,CATEGORY,PRICE,KEY_PATH) values ('REGISTER_MINHA_VIBE_MR_DAY','MINHA_VIBE','MINHA_VIBE_MR_DAY','VIETTECH','REGISTER','BLANK','3','../etc/key/MINHA_VIBE_MR_DAY/');
Insert into MPS_CONFIG (ACTION_CODE,SERVICE,SUB_SERVICE,CP_NAME,COMMAND,CATEGORY,PRICE,KEY_PATH) values ('CHARGE_2','MINHA_VIBE','MINHA_VIBE_MINUS','VIETTECH','CHARGE','MINUS2','2','../etc/key/MINHA_VIBE_MINUS/');
Insert into MPS_CONFIG (ACTION_CODE,SERVICE,SUB_SERVICE,CP_NAME,COMMAND,CATEGORY,PRICE,KEY_PATH) values ('REGISTER_MINHA_VIBE_DAY','MINHA_VIBE','MINHA_VIBE_DAY','VIETTECH','REGISTER','BLANK','3','../etc/key/MINHA_VIBE_DAY/');
Insert into MPS_CONFIG (ACTION_CODE,SERVICE,SUB_SERVICE,CP_NAME,COMMAND,CATEGORY,PRICE,KEY_PATH) values ('ADD_5','MINHA_VIBE','VOZ_DA_SORTE_WIN','VIETTECH','MODBALANCEM','ADD5','5','../etc/key/VOZ_DA_SORTE_WIN/');
Insert into MPS_CONFIG (ACTION_CODE,SERVICE,SUB_SERVICE,CP_NAME,COMMAND,CATEGORY,PRICE,KEY_PATH) values ('ADD_10','MINHA_VIBE','VOZ_DA_SORTE_WIN','VIETTECH','MODBALANCEM','ADD10','10','../etc/key/VOZ_DA_SORTE_WIN/');
Insert into MPS_CONFIG (ACTION_CODE,SERVICE,SUB_SERVICE,CP_NAME,COMMAND,CATEGORY,PRICE,KEY_PATH) values ('ADD_20','MINHA_VIBE','VOZ_DA_SORTE_WIN','VIETTECH','MODBALANCEM','ADD20','20','../etc/key/VOZ_DA_SORTE_WIN/');
Insert into MPS_CONFIG (ACTION_CODE,SERVICE,SUB_SERVICE,CP_NAME,COMMAND,CATEGORY,PRICE,KEY_PATH) values ('ADD_15','MINHA_VIBE','VOZ_DA_SORTE_WIN','VIETTECH','MODBALANCEM','ADD15','15','../etc/key/VOZ_DA_SORTE_WIN/');
Insert into MPS_CONFIG (ACTION_CODE,SERVICE,SUB_SERVICE,CP_NAME,COMMAND,CATEGORY,PRICE,KEY_PATH) values ('CHARGE_1','MINHA_VIBE','MINHA_VIBE_MINUS','VIETTECH','CHARGE','MINUS1','1','../etc/key/MINHA_VIBE_MINUS/');
REM INSERTING into MT_HIS
SET DEFINE OFF;
REM INSERTING into ACCOUNT_ADMIN
SET DEFINE OFF;
Insert into ACCOUNT_ADMIN (ID,USER_ADMIN,PASS_ADMIN,CREATED_DATE,UPDATE_DATE,STATUS,SERVICE_ID,ROLE) values (1020,'TEST','TEST',to_date('16-JUN-26','DD-MON-RR'),to_date('16-JUN-26','DD-MON-RR'),'ACTIVE',1,'TEST');
Insert into ACCOUNT_ADMIN (ID,USER_ADMIN,PASS_ADMIN,CREATED_DATE,UPDATE_DATE,STATUS,SERVICE_ID,ROLE) values (1,'admin','123456a@A',to_date('11-MAY-26','DD-MON-RR'),to_date('11-MAY-26','DD-MON-RR'),'ACTIVE',1,'ADMIN');
Insert into ACCOUNT_ADMIN (ID,USER_ADMIN,PASS_ADMIN,CREATED_DATE,UPDATE_DATE,STATUS,SERVICE_ID,ROLE) values (2,'report','Report@123',to_date('11-MAY-26','DD-MON-RR'),to_date('11-MAY-26','DD-MON-RR'),'ACTIVE',1,'REPORT');
Insert into ACCOUNT_ADMIN (ID,USER_ADMIN,PASS_ADMIN,CREATED_DATE,UPDATE_DATE,STATUS,SERVICE_ID,ROLE) values (1000,'user','123456',to_date('12-MAY-26','DD-MON-RR'),to_date('12-MAY-26','DD-MON-RR'),'ACTIVE',1,'USER');
REM INSERTING into MT
SET DEFINE OFF;
Insert into MT (MT_ID,MO_HIS_ID,MSISDN,MESSAGE,RECEIVE_TIME,RETRY_NUM,CHANNEL) values (1453,1453,'9587200093','Your Minha Vibe login code is: 962551',to_date('28-MAY-26','DD-MON-RR'),0,'1542');
REM INSERTING into REG_INFO
SET DEFINE OFF;
Insert into REG_INFO (REGISTER_ID,MSISDN,PRODUCT_NAME,REGISTER_TIME,NUMBER_SPIN,EXTEND_SPIN,EXTEND_STATUS,STATUS,EXPIRE_TIME,LAST_EXTEND,PLAYED_TIMES,END_TIME,ALREADY_CHARGED,RENEW,SERVICE_ID,CHANNEL) values (1000,'959833543354','MYJOB_DAYLY',to_date('18-MAY-26','DD-MON-RR'),3,null,0,1,to_date('18-MAY-26','DD-MON-RR'),null,0,null,null,1,1,'WEB');
Insert into REG_INFO (REGISTER_ID,MSISDN,PRODUCT_NAME,REGISTER_TIME,NUMBER_SPIN,EXTEND_SPIN,EXTEND_STATUS,STATUS,EXPIRE_TIME,LAST_EXTEND,PLAYED_TIMES,END_TIME,ALREADY_CHARGED,RENEW,SERVICE_ID,CHANNEL) values (1021,'9587200087','MYJOB_MONTHLY',to_date('20-MAY-26','DD-MON-RR'),3,null,0,1,to_date('18-JUN-26','DD-MON-RR'),null,0,null,null,1,1,'WEB');
Insert into REG_INFO (REGISTER_ID,MSISDN,PRODUCT_NAME,REGISTER_TIME,NUMBER_SPIN,EXTEND_SPIN,EXTEND_STATUS,STATUS,EXPIRE_TIME,LAST_EXTEND,PLAYED_TIMES,END_TIME,ALREADY_CHARGED,RENEW,SERVICE_ID,CHANNEL) values (1122,'959681464634','MYJOB_MONTHLY',to_date('29-MAY-26','DD-MON-RR'),3,null,0,1,to_date('27-JUN-26','DD-MON-RR'),null,0,null,null,1,2,'WEB');
Insert into REG_INFO (REGISTER_ID,MSISDN,PRODUCT_NAME,REGISTER_TIME,NUMBER_SPIN,EXTEND_SPIN,EXTEND_STATUS,STATUS,EXPIRE_TIME,LAST_EXTEND,PLAYED_TIMES,END_TIME,ALREADY_CHARGED,RENEW,SERVICE_ID,CHANNEL) values (1160,'9589898989','MYJOB_DAYLY',to_date('11-JUN-26','DD-MON-RR'),3,null,0,1,to_date('11-JUN-26','DD-MON-RR'),null,0,null,null,1,1,'WEB');
REM INSERTING into ACCOUNT_INFO
SET DEFINE OFF;
REM INSERTING into PERMISSION
SET DEFINE OFF;
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2029,'SubscriptionChargeReport','ACTIVE','/SubscriptionChargeReport','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2030,'subscriptionchargereport index','ACTIVE','/subscriptionchargereport/index','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2031,'subscriptionchargereport','ACTIVE','/admin/subscriptionchargereport','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2038,'SubscriptionChargeReportNoDate','ACTIVE','/SubscriptionChargeReportNoDate','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2039,'subscriptionchargereportnodate index','ACTIVE','/subscriptionchargereportnodate/index','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2040,'subscriptionchargereportnodate admin','ACTIVE','/admin/subscriptionchargereportnodate','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2041,'Monthly Reward Payout','ACTIVE','/MonthlyRewardPayoutReport','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2042,'monthly reward payout index','ACTIVE','/monthlyrewardpayoutreport/index','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2043,'monthly reward payout admin','ACTIVE','/admin/monthlyrewardpayoutreport','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2032,'cmsjobposting','ACTIVE','/cmsjobposting','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2033,'cmsjobposting index','ACTIVE','/cmsjobposting/index','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2034,'cmsjobposting create','ACTIVE','/cmsjobposting/create','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2035,'cmsjobposting edit','ACTIVE','/cmsjobposting/edit','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2036,'cmsjobposting save','ACTIVE','/cmsjobposting/save','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2037,'cmsjobposting updatestatus','ACTIVE','/cmsjobposting/updatestatus','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1033,'CMS Dashboard Legacy','ACTIVE','/Home/Index','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1,'Get User Register','ACTIVE','/portal/user-register','/');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1034,'CMS Categories Legacy','ACTIVE','/Admin/Categories','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1035,'CMS Save Category Legacy','ACTIVE','/Admin/SaveCategory','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1036,'CMS Delete Category Legacy','ACTIVE','/Admin/DeleteCategory','DELETE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1037,'CMS Load Category Legacy','ACTIVE','/portal/load-category','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1038,'CMS Locations Legacy','ACTIVE','/Admin/Locations','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1039,'CMS Save Location Legacy','ACTIVE','/Admin/SaveLocation','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1040,'CMS Delete Location Legacy','ACTIVE','/Admin/DeleteLocation','DELETE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1041,'CMS Job Moderation Index','ACTIVE','/JobModeration/Index','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1042,'CMS Job Moderation Legacy','ACTIVE','/Admin/Jobs','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1043,'CMS Review Job Legacy','ACTIVE','/Admin/ReviewJob','APPROVE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1044,'CMS Employers','ACTIVE','/Admin/Employers','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1005,'Revenue Reports','ACTIVE','/RevenueReport','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1006,'Revenue Reports','ACTIVE','/RevenueReport/Index','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1007,'Revenue Reports','ACTIVE','/Admin/RevenueReport','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1008,'Users','ACTIVE','/CmsAccount/Users','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1009,'Save user','ACTIVE','/cmsaccount/saveuser','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1010,'Delete user','ACTIVE','/cmsaccount/deleteuser','DELETE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1011,'Roles','ACTIVE','/CmsAccount/Roles','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1012,'Save role','ACTIVE','/cmsaccount/saverole','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1001,'CMS Dashboard','ACTIVE','/Dashboard','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1002,'CMS Categories','ACTIVE','/MasterData/Categories','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1003,'CMS Locations','ACTIVE','/MasterData/Locations','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1004,'CMS Job Moderation','ACTIVE','/JobModeration','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1019,'CMS Save Category','ACTIVE','/MasterData/SaveCategory','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1020,'CMS Delete Category','ACTIVE','/MasterData/DeleteCategory','DELETE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1021,'CMS Save Location','ACTIVE','/MasterData/SaveLocation','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1022,'CMS Delete Location','ACTIVE','/MasterData/DeleteLocation','DELETE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1031,'CMS Review Job','ACTIVE','/JobModeration/ReviewJob','APPROVE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1032,'CMS Dashboard Index','ACTIVE','/Dashboard/Index','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1013,'Delete role','ACTIVE','/cmsaccount/deleterole','DELETE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1014,'Role details','ACTIVE','/cmsaccount/roledetails','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1015,'Save role permissions','ACTIVE','/cmsaccount/saverolepermissions','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1016,'Permissions','ACTIVE','/CmsAccount/Permissions','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1017,'Save permission','ACTIVE','/cmsaccount/savepermission','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1018,'Delete permission','ACTIVE','/cmsaccount/deletepermission','DELETE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (1045,'CMS Companies','ACTIVE','/Admin/Companies','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2004,'Banners: View list','ACTIVE','/masterdata/banners','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2005,'Banners: Create/Update','ACTIVE','/masterdata/savebanner','WRITE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2006,'Banners: Delete','ACTIVE','/masterdata/deletebanner','WRITE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2016,'InterviewManagement Categories','ACTIVE','/InterviewManagement/Categories','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2017,'interviewmanagement','ACTIVE','/interviewmanagement','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2018,'interviewmanagement index','ACTIVE','/interviewmanagement/index','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2019,'interviewmanagement savecategory','ACTIVE','/interviewmanagement/savecategory','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2020,'interviewmanagement deletecategory','ACTIVE','/interviewmanagement/deletecategory','DELETE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2021,'interviewmanagement questions','ACTIVE','/interviewmanagement/questions','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2022,'interviewmanagement savequestion','ACTIVE','/interviewmanagement/savequestion','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2023,'interviewmanagement deletequestion','ACTIVE','/interviewmanagement/deletequestion','DELETE');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2024,'interviewmanagement answers','ACTIVE','/interviewmanagement/answers','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2025,'interviewmanagement saveanswer','ACTIVE','/interviewmanagement/saveanswer','VIEW');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2026,'interviewmanagement import','ACTIVE','/interviewmanagement/import','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2027,'interviewmanagement importexcel','ACTIVE','/interviewmanagement/importexcel','EDIT');
Insert into PERMISSION (ID,NAME,STATUS,PATH,ACTION) values (2028,'interviewmanagement downloadtemplate','ACTIVE','/interviewmanagement/downloadtemplate','EDIT');
REM INSERTING into LUCKY_SPIN
SET DEFINE OFF;
REM INSERTING into ACCOUNT_USER
SET DEFINE OFF;
Insert into ACCOUNT_USER (ID,MSISDN,USERS,PASS,SERVICE_ID,CREATED_DATE,UPDATE_DATE,IS_ACTIVE,CHANNEL,FREE_SPIN,TOTAL_SPIN,ROLE,LANGUAGE,IS_LOCK,TOTAL_FALSE,TIME_LOCK,LAST_UPDATE,LAST_LOGIN,POINT,STATUS,PICTURE,FULLNAME,EMAIL,BIRTHDAY) values (1280,'959681464622','959681464622','307677',null,to_date('29-MAY-26','DD-MON-RR'),to_date('29-MAY-26','DD-MON-RR'),1,'USSD',0,0,'USER',1,0,0,to_date('29-MAY-26','DD-MON-RR'),to_date('29-MAY-26','DD-MON-RR'),to_date('29-MAY-26','DD-MON-RR'),0,1,'default.png',null,null,to_date('29-MAY-26','DD-MON-RR'));
Insert into ACCOUNT_USER (ID,MSISDN,USERS,PASS,SERVICE_ID,CREATED_DATE,UPDATE_DATE,IS_ACTIVE,CHANNEL,FREE_SPIN,TOTAL_SPIN,ROLE,LANGUAGE,IS_LOCK,TOTAL_FALSE,TIME_LOCK,LAST_UPDATE,LAST_LOGIN,POINT,STATUS,PICTURE,FULLNAME,EMAIL,BIRTHDAY) values (1281,'959681464611','959681464611','845460',null,to_date('29-MAY-26','DD-MON-RR'),to_date('29-MAY-26','DD-MON-RR'),1,'USSD',0,0,'EMPLOYER',1,0,0,to_date('29-MAY-26','DD-MON-RR'),to_date('29-MAY-26','DD-MON-RR'),to_date('29-MAY-26','DD-MON-RR'),0,1,'default.png',null,null,to_date('29-MAY-26','DD-MON-RR'));
REM INSERTING into PACKG
SET DEFINE OFF;
Insert into PACKG (PRODUCT_ID,FEE,NUMBER_SPIN,PRODUCT_NAME,SMS_SYNTAX,BIZ_ID,EXPIRE_DAYS,RENEW) values (2,1999,3,'MYJOB_MONTHLY',null,2,30,1);
Insert into PACKG (PRODUCT_ID,FEE,NUMBER_SPIN,PRODUCT_NAME,SMS_SYNTAX,BIZ_ID,EXPIRE_DAYS,RENEW) values (1,199,3,'MYJOB_DAYLY',null,1,1,1);
Insert into PACKG (PRODUCT_ID,FEE,NUMBER_SPIN,PRODUCT_NAME,SMS_SYNTAX,BIZ_ID,EXPIRE_DAYS,RENEW) values (4,2,4,'CHARGE2',null,null,1,0);
Insert into PACKG (PRODUCT_ID,FEE,NUMBER_SPIN,PRODUCT_NAME,SMS_SYNTAX,BIZ_ID,EXPIRE_DAYS,RENEW) values (6,10,12,'CHARGE10',null,null,1,0);
Insert into PACKG (PRODUCT_ID,FEE,NUMBER_SPIN,PRODUCT_NAME,SMS_SYNTAX,BIZ_ID,EXPIRE_DAYS,RENEW) values (7,50,60,'CHARGE50',null,null,1,0);
Insert into PACKG (PRODUCT_ID,FEE,NUMBER_SPIN,PRODUCT_NAME,SMS_SYNTAX,BIZ_ID,EXPIRE_DAYS,RENEW) values (3,1,2,'CHARGE1',null,null,1,0);
Insert into PACKG (PRODUCT_ID,FEE,NUMBER_SPIN,PRODUCT_NAME,SMS_SYNTAX,BIZ_ID,EXPIRE_DAYS,RENEW) values (18,0,0,'ADD5',null,null,1,0);
Insert into PACKG (PRODUCT_ID,FEE,NUMBER_SPIN,PRODUCT_NAME,SMS_SYNTAX,BIZ_ID,EXPIRE_DAYS,RENEW) values (19,0,0,'ADD10',null,null,1,0);
Insert into PACKG (PRODUCT_ID,FEE,NUMBER_SPIN,PRODUCT_NAME,SMS_SYNTAX,BIZ_ID,EXPIRE_DAYS,RENEW) values (20,0,0,'ADD15',null,null,1,0);
Insert into PACKG (PRODUCT_ID,FEE,NUMBER_SPIN,PRODUCT_NAME,SMS_SYNTAX,BIZ_ID,EXPIRE_DAYS,RENEW) values (21,0,0,'ADD20',null,null,1,0);
REM INSERTING into ROLE
SET DEFINE OFF;
Insert into ROLE (ID,NAME,DESCRIPTION,CODE,STATUS) values (2004,'TEST',null,'TEST','ACTIVE');
Insert into ROLE (ID,NAME,DESCRIPTION,CODE,STATUS) values (1,'ADMIN',null,'ADMIN','ACTIVE');
Insert into ROLE (ID,NAME,DESCRIPTION,CODE,STATUS) values (2,'REPORT',null,'REPORT','ACTIVE');
Insert into ROLE (ID,NAME,DESCRIPTION,CODE,STATUS) values (2003,'USER','USER','USER','ACTIVE');
REM INSERTING into ROLE_PERMISSION
SET DEFINE OFF;
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2251,1,2006,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2252,1,2004,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2253,1,1002,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2254,1,1034,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2255,1,1045,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2256,1,1001,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2257,1,1032,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2258,1,1033,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2259,1,1036,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2260,1,1022,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2261,1,1040,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2262,1,1044,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2263,1,1004,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2264,1,1041,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2265,1,1042,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2266,1,1037,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2267,1,1003,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2268,1,1038,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2269,1,1031,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2270,1,1043,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2271,1,1019,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2272,1,1035,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2273,1,1021,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2274,1,1039,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2275,1,1013,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2276,1,1010,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2277,1,1,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2278,1,1016,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2279,1,1006,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2280,1,1007,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2281,1,1005,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2282,1,1014,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2283,1,1011,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2284,1,1017,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2285,1,1012,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2286,1,1015,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2287,1,1009,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2288,1,2029,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2289,1,1008,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2290,1,2032,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2291,1,2034,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2292,1,2035,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2250,1,2005,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2293,1,2033,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2294,1,2036,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2295,1,2037,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2296,1,2017,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2297,1,2024,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2298,1,2020,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2299,1,2023,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2300,1,2028,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2301,1,2026,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2302,1,2027,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2303,1,2018,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2304,1,2021,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2305,1,2025,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2306,1,2019,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2307,1,2022,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2308,1,2031,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2309,1,2030,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2313,1,2038,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2314,1,2039,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2315,1,2040,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2316,1,2041,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2317,1,2042,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2318,1,2043,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2310,2004,2029,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2311,2004,2031,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2312,2004,2030,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2000,2003,1031,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2125,2,1001,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2126,2,1032,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2127,2,1005,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2128,2,1006,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2129,2,1007,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2130,2003,1004,'ACTIVE');
Insert into ROLE_PERMISSION (ID,ROLE_ID,PERMISSION_ID,STATUS) values (2131,2003,1041,'ACTIVE');
REM INSERTING into TRANSACTION_ACTION
SET DEFINE OFF;
Insert into TRANSACTION_ACTION (ID,MSISDN,TRANSACTION_ID,OTP,CREATED_TIME,VALID_TIME,TIME_LEFT) values (1161,'9587200087','ewvlswpq-28261216','111111',to_date('20-MAY-26','DD-MON-RR'),to_date('20-MAY-26','DD-MON-RR'),5);
Insert into TRANSACTION_ACTION (ID,MSISDN,TRANSACTION_ID,OTP,CREATED_TIME,VALID_TIME,TIME_LEFT) values (1162,'9587200088','hotowyej-73959258','111111',to_date('27-MAY-26','DD-MON-RR'),to_date('20-MAY-26','DD-MON-RR'),3);
Insert into TRANSACTION_ACTION (ID,MSISDN,TRANSACTION_ID,OTP,CREATED_TIME,VALID_TIME,TIME_LEFT) values (1241,'9512345678','jtvirdvi-11631927','111111',to_date('22-JUN-26','DD-MON-RR'),to_date('27-MAY-26','DD-MON-RR'),4);
Insert into TRANSACTION_ACTION (ID,MSISDN,TRANSACTION_ID,OTP,CREATED_TIME,VALID_TIME,TIME_LEFT) values (1242,'959681464633','hxkdygma-95923963','111111',to_date('02-JUN-26','DD-MON-RR'),to_date('27-MAY-26','DD-MON-RR'),2);
Insert into TRANSACTION_ACTION (ID,MSISDN,TRANSACTION_ID,OTP,CREATED_TIME,VALID_TIME,TIME_LEFT) values (1260,'9596781464632','erxkjcbc-29263155','111111',to_date('29-MAY-26','DD-MON-RR'),to_date('28-MAY-26','DD-MON-RR'),3);
Insert into TRANSACTION_ACTION (ID,MSISDN,TRANSACTION_ID,OTP,CREATED_TIME,VALID_TIME,TIME_LEFT) values (1265,'95968146434','onherywn-98553212','111111',to_date('28-MAY-26','DD-MON-RR'),to_date('28-MAY-26','DD-MON-RR'),5);
Insert into TRANSACTION_ACTION (ID,MSISDN,TRANSACTION_ID,OTP,CREATED_TIME,VALID_TIME,TIME_LEFT) values (1281,'959681464611','bvzpeqpk-96222884','111111',to_date('29-MAY-26','DD-MON-RR'),to_date('29-MAY-26','DD-MON-RR'),5);
REM INSERTING into TRANSACTION_LOG
SET DEFINE OFF;
REM INSERTING into WEBSERVICE
SET DEFINE OFF;
Insert into WEBSERVICE (WS_ID,WS_NAME,WS_CODE,WSDL,MSG_TEMPLATE,STATUS) values (7,'add_data','add_data','http://10.226.232.65:9186/MPI/Payment?wsdl','<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ws="http://ws.payment.mps.viettel.com/">
<soapenv:Header/>
<soapenv:Body>
<ws:doCharge>
<msisdn>#MSISDN</msisdn>
<amount>#AMOUNT</amount>
<serviceName>#SERVICE_NAME</serviceName>
<providerName>#PROVIDER_NAME</providerName>
<channel>EBP</channel>
<subCpName></subCpName>
<category></category>
<item></item>
<command>#CMD</command>
<subService>#SUB_SERVICE_NAME</subService>
<transId>#TRANS_ID</transId>
<charge_type>1</charge_type>
</ws:doCharge>
</soapenv:Body>
</soapenv:Envelope>',0);
Insert into WEBSERVICE (WS_ID,WS_NAME,WS_CODE,WSDL,MSG_TEMPLATE,STATUS) values (1,'register_otp','register_otp','http://10.226.234.201:9181/MPS/otp.html?',null,1);
Insert into WEBSERVICE (WS_ID,WS_NAME,WS_CODE,WSDL,MSG_TEMPLATE,STATUS) values (2,'charge_fee','charge_fee','http://10.226.234.201:9181/MPS/otp.html?',null,1);
Insert into WEBSERVICE (WS_ID,WS_NAME,WS_CODE,WSDL,MSG_TEMPLATE,STATUS) values (3,'add_money','add_money','http://10.226.234.201:9181/MPS/charge.html?',null,1);
Insert into WEBSERVICE (WS_ID,WS_NAME,WS_CODE,WSDL,MSG_TEMPLATE,STATUS) values (4,'sendmt','sendmt184','http://10.226.232.201:9201/smsws?wsdl','<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://smsws/xsd">
   <soapenv:Header/>
   <soapenv:Body>
      <xsd:smsRequest>
         <!--Optional:-->
         <xsd:username>184u</xsd:username>
         <!--Optional:-->
         <xsd:password>184p</xsd:password>
         <!--Optional:-->
         <xsd:msisdn>#MSISDN#</xsd:msisdn>
         <!--Optional:-->
         <xsd:content>#CONTENT#</xsd:content>
         <!--Optional:-->
         <xsd:shortcode>184</xsd:shortcode>
         <!--Optional:-->
         <xsd:alias></xsd:alias>
         <!--Optional:-->
         <xsd:params>#PARAM#</xsd:params>
      </xsd:smsRequest>
   </soapenv:Body>
</soapenv:Envelope>',1);
Insert into WEBSERVICE (WS_ID,WS_NAME,WS_CODE,WSDL,MSG_TEMPLATE,STATUS) values (5,'register','register','http://10.226.234.201:9181/MPS/OTP.html?',null,null);
Insert into WEBSERVICE (WS_ID,WS_NAME,WS_CODE,WSDL,MSG_TEMPLATE,STATUS) values (6,'disable','disable','http://10.226.234.201:9181/MPS/charge.html?',null,null);
REM INSERTING into WS_USER
SET DEFINE OFF;
Insert into WS_USER (WS_USER_ID,USERNAME,PASSWORD,IP_ADDRESS) values (1,'ws_myjob','Myjob@123A','127.0.0.1,10.226.234.75,10.226.40.30,10.226.234.240,10.226.234.239,10.226.232.65,10.226.232.66,10.226.234.92,x.x.x.x');
--------------------------------------------------------
--  DDL for Index CFG_UNK
--------------------------------------------------------

  CREATE UNIQUE INDEX "CFG_UNK" ON "CONFIG" ("MODULE", "PARAM_NAME") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index SYS_C0012861
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0012861" ON "ACCOUNT_ADMIN" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index SYS_C0012856
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0012856" ON "MT" ("MT_ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index SYS_C0012857
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0012857" ON "REG_INFO" ("REGISTER_ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index REG_INFO_MSISDN_IDX
--------------------------------------------------------

  CREATE INDEX "REG_INFO_MSISDN_IDX" ON "REG_INFO" ("MSISDN") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index ACCOUNT_INFO_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "ACCOUNT_INFO_PK" ON "ACCOUNT_INFO" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index LS_MSISDN_IDX
--------------------------------------------------------

  CREATE INDEX "LS_MSISDN_IDX" ON "LUCKY_SPIN" ("MSISDN") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index LS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LS_PK" ON "LUCKY_SPIN" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index SYS_C0012750
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0012750" ON "ACCOUNT_USER" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index ROLE_PERMISSION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "ROLE_PERMISSION_PK" ON "ROLE_PERMISSION" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index TRANSACTION_ACTION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "TRANSACTION_ACTION_PK" ON "TRANSACTION_ACTION" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index TLOG_ISDN_IDX
--------------------------------------------------------

  CREATE INDEX "TLOG_ISDN_IDX" ON "TRANSACTION_LOG" ("MSISDN") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index TLOG_RT_IDX
--------------------------------------------------------

  CREATE INDEX "TLOG_RT_IDX" ON "TRANSACTION_LOG" ("REQUEST_TIME") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  DDL for Index WS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "WS_PK" ON "WEBSERVICE" ("WS_ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT);
--------------------------------------------------------
--  Constraints for Table CONFIG
--------------------------------------------------------

  ALTER TABLE "CONFIG" ADD CONSTRAINT "CFG_UNK" UNIQUE ("MODULE", "PARAM_NAME")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE;
--------------------------------------------------------
--  Constraints for Table MT
--------------------------------------------------------

  ALTER TABLE "MT" MODIFY ("MT_ID" NOT NULL ENABLE);
  ALTER TABLE "MT" ADD CONSTRAINT "SYS_C0012856" PRIMARY KEY ("MT_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE;
  ALTER TABLE "MT" ADD CONSTRAINT "SYS_C00135700" CHECK ("MT_ID" IS NOT NULL) ENABLE;
--------------------------------------------------------
--  Constraints for Table REG_INFO
--------------------------------------------------------

  ALTER TABLE "REG_INFO" MODIFY ("REGISTER_ID" NOT NULL ENABLE);
  ALTER TABLE "REG_INFO" ADD CONSTRAINT "SYS_C0012857" PRIMARY KEY ("REGISTER_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE;
  ALTER TABLE "REG_INFO" ADD CONSTRAINT "SYS_C00135726" CHECK ("REGISTER_ID" IS NOT NULL) ENABLE;
--------------------------------------------------------
--  Constraints for Table ACCOUNT_INFO
--------------------------------------------------------

  ALTER TABLE "ACCOUNT_INFO" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("MSISDN" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" ADD CONSTRAINT "ACCOUNT_INFO_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE;
  ALTER TABLE "ACCOUNT_INFO" ADD CONSTRAINT "SYS_C0012879" CHECK ("ID" IS NOT NULL) ENABLE;
  ALTER TABLE "ACCOUNT_INFO" ADD CONSTRAINT "SYS_C0012880" CHECK ("MSISDN" IS NOT NULL) ENABLE;
  ALTER TABLE "ACCOUNT_INFO" ADD CONSTRAINT "SYS_C00135668" CHECK ("ID" IS NOT NULL) ENABLE;
  ALTER TABLE "ACCOUNT_INFO" ADD CONSTRAINT "SYS_C00135669" CHECK ("MSISDN" IS NOT NULL) ENABLE;
--------------------------------------------------------
--  Constraints for Table LUCKY_SPIN
--------------------------------------------------------

  ALTER TABLE "LUCKY_SPIN" ADD CONSTRAINT "LS_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE;
--------------------------------------------------------
--  Constraints for Table ACCOUNT_USER
--------------------------------------------------------

  ALTER TABLE "ACCOUNT_USER" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_USER" ADD CONSTRAINT "SYS_C0012750" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE;
  ALTER TABLE "ACCOUNT_USER" ADD CONSTRAINT "SYS_C00135670" CHECK ("ID" IS NOT NULL) ENABLE;
--------------------------------------------------------
--  Constraints for Table PERMISSION
--------------------------------------------------------

  ALTER TABLE "PERMISSION" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "PERMISSION" ADD CONSTRAINT "PERMISSION_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table ROLE
--------------------------------------------------------

  ALTER TABLE "ROLE" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "ROLE" ADD CONSTRAINT "ROLE_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table ROLE_PERMISSION
--------------------------------------------------------

  ALTER TABLE "ROLE_PERMISSION" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "ROLE_PERMISSION" MODIFY ("ROLE_ID" NOT NULL ENABLE);
  ALTER TABLE "ROLE_PERMISSION" MODIFY ("PERMISSION_ID" NOT NULL ENABLE);
  ALTER TABLE "ROLE_PERMISSION" MODIFY ("STATUS" NOT NULL ENABLE);
  ALTER TABLE "ROLE_PERMISSION" ADD CONSTRAINT "ROLE_PERMISSION_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE;
--------------------------------------------------------
--  Constraints for Table TRANSACTION_ACTION
--------------------------------------------------------

  ALTER TABLE "TRANSACTION_ACTION" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "TRANSACTION_ACTION" MODIFY ("MSISDN" NOT NULL ENABLE);
  ALTER TABLE "TRANSACTION_ACTION" MODIFY ("TRANSACTION_ID" NOT NULL ENABLE);
  ALTER TABLE "TRANSACTION_ACTION" MODIFY ("OTP" NOT NULL ENABLE);
  ALTER TABLE "TRANSACTION_ACTION" MODIFY ("CREATED_TIME" NOT NULL ENABLE);
  ALTER TABLE "TRANSACTION_ACTION" MODIFY ("VALID_TIME" NOT NULL ENABLE);
  ALTER TABLE "TRANSACTION_ACTION" MODIFY ("TIME_LEFT" NOT NULL ENABLE);
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "TRANSACTION_ACTION_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C0012741" CHECK ("ID" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C0012742" CHECK ("MSISDN" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C0012743" CHECK ("TRANSACTION_ID" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C0012744" CHECK ("OTP" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C0012745" CHECK ("CREATED_TIME" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C0012746" CHECK ("VALID_TIME" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C0012747" CHECK ("TIME_LEFT" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C00135757" CHECK ("ID" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C00135758" CHECK ("MSISDN" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C00135759" CHECK ("TRANSACTION_ID" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C00135760" CHECK ("OTP" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C00135761" CHECK ("CREATED_TIME" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C00135762" CHECK ("VALID_TIME" IS NOT NULL) ENABLE;
  ALTER TABLE "TRANSACTION_ACTION" ADD CONSTRAINT "SYS_C00135763" CHECK ("TIME_LEFT" IS NOT NULL) ENABLE;



create or replace NONEDITIONABLE PROCEDURE "ADD_TURN" 
(
  MSISDN_ IN VARCHAR2 
, TURN_ IN NUMBER 
) IS
    v_count     NUMBER;
    v_lucky_id  NUMBER; 
BEGIN
 -- Ki?m tra xem ?ã t?n t?i b?n ghi cho msisdn ch?a
    SELECT COUNT(*) INTO v_count
    FROM lucky_spin
    WHERE msisdn = MSISDN_ ;

    IF v_count > 0 THEN
        -- L?y ID b?n ghi ?? c?p nh?t
        SELECT id INTO v_lucky_id
        FROM lucky_spin
        WHERE msisdn = MSISDN_ AND ROWNUM = 1;

        -- C?p nh?t l??t quay
        UPDATE lucky_spin
        SET added = NVL(added, 0) + TURN_,
            last_update = SYSDATE
        WHERE id = v_lucky_id;

    ELSE
        -- N?u ch?a có b?n ghi ? insert m?i
        INSERT INTO lucky_spin (
            id,
            msisdn,
            added,
            used,
            INSERT_TIME,
            expire_time,
            last_update,
            channel_add
        ) VALUES (
            lucky_spin_seq.NEXTVAL,
            MSISDN_,
            TURN_,
            0,
            SYSDATE,
            SYSDATE + 7,
            SYSDATE,
            1
        );

    END IF;

    COMMIT;
END ADD_TURN;