PDF《运营中心使用指南-MarketingMgmt 1 套件基础》

9000000001101'

, 1, '

抽奖活动模板'

, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000110101'

, '

9000000001101'

, 2, '

isSendNotice'

, '

是否发送通知'

, '

1000000000005'

, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000110102'

, '

9000000001101'

, 1, '

notice'

, '

通知内容'

, null, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000110103'

, '

9000000001101'

, 1, '

errorTip'

, '

错误提示'

, null, sysdate, sysdate);

5.3 动作模板 由于存在赠送抽奖次数和即时抽奖两个动作,因此需要预置两个动作模板. 5.3.1 赠送抽奖次数动作模板 具体SQL如下: insert into MKM_T_TEMPLATE (TEMPLATEID, TEMPLATETYPE, TEMPLATENAME, CREATETIME, LASTUPDATETIME) values ('

9000000001201'

, 2, '

赠送抽奖次数动作模板'

, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000120101'

, '

9000000001201'

, 1, '

gainAmount'

, '

赠送次数'

, null, sysdate, sysdate);

5.3.2 即时抽奖动作模板 具体SQL如下: insert into MKM_T_TEMPLATE (TEMPLATEID, TEMPLATETYPE, TEMPLATENAME, CREATETIME, LASTUPDATETIME) values ('

9000000001202'

, 2, '

即时抽奖动作模板'

, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000120201'

, '

9000000001202'

, 1, '

gainMaxAmount'

, '

获得的免费抽奖次数'

, null, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000120202'

, '

9000000001202'

, 2, '

gainUnit'

, '

获得免费抽奖次数的时间周期'

, '

1000000000006'

, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000120203'

, '

9000000001202'

, 2, '

isConsume'

, '

抽奖是否消耗点数'

, '

1000000000005'

, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000120204'

, '

9000000001202'

, 1, '

consumeAmount'

, '

消耗点数'

, null, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('

9000000120205'

, '

9000000001202'

, 1, '

dayLimit'

, '

单日抽奖上限'

, null, sysdate, sysdate);

insert into MKM_T_EXTENSION (EXTENSIONID, TEMPLATEID, EXTENSIONTYPE, FIELDKEY, FIELDNAME, DICTID, CREATETIME, LASTUPDATETIME) values ('