-------------------------------------------------------- -- 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 (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 (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',' #MSISDN #AMOUNT #SERVICE_NAME #PROVIDER_NAME EBP #CMD #SUB_SERVICE_NAME #TRANS_ID 1 ',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',' 184u 184p #MSISDN# #CONTENT# 184 #PARAM# ',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;