prompt PL/SQL Developer import file
prompt Created on 2010年8月28日 by Administrator
set feedback off
set define off
prompt Dropping T_APP...
drop table T_APP cascade constraints;
prompt Dropping T_CHANNEL...
drop table T_CHANNEL cascade constraints;
prompt Dropping T_CHARGE...
drop table T_CHARGE cascade constraints;
prompt Dropping T_STRATEGY...
drop table T_STRATEGY cascade constraints;
prompt Creating T_APP...
create table T_APP
(
APPID NUMBER(5) not null,
APPNAME VARCHAR2(40) not null,
APPCODE VARCHAR2(10),
SUBJECTID NUMBER(5) not null,
APPTYPE CHAR(1),
PRICE NUMBER(5) not null,
STATUSCHAR(1) default 1 not null,
ADDRESS VARCHAR2(50)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table T_APP
add constraint PK_APP4 primary key (APPID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table T_APP
add constraint TC_APP3 unique (APPCODE)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating T_CHANNEL...
create table T_CHANNEL
(
CHANNELID NUMBER(7) not null,
PASSWORDVARCHAR2(32) not null,
CHANNELNAME VARCHAR2(50) not null,
CHANNELCODE VARCHAR2(10),
CONTACTER VARCHAR2(50),
TEL VARCHAR2(20),
EMAIL VARCHAR2(30),
CHANNELTYPE CHAR(1),
WEBSITE VARCHAR2(100),
STATUSCHAR(1) default 0 not null,
REMARKVARCHAR2(100)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table T_CHANNEL
add constraint PK_CHANNEL7 primary key (CHANNELID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table T_CHANNEL
add constraint TC_CHANNEL5 unique (CHANNELCODE)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating T_CHARGE...
create table T_CHARGE
(
CIDNUMBER(5) not null,
CHARGENAME VARCHAR2(30) not null,
CHARGEMODE NUMBER(2) not null
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table T_CHARGE
add constraint PK_T_CHARGE36 primary key (CID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating T_STRATEGY...
create table T_STRATEGY
(
RIDNUMBER(12) not null,
CHANNELIDNUMBER(7) not null,
APPIDNUMBER(5) not null,
CIDNUMBER(5) not null,
MODIFYTIME DATE not null
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table T_STRATEGY
add constraint PK_T_STRATEGY37 primary key (RID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Disabling triggers for T_APP...
alter table T_APP disable all triggers;
prompt Disabling triggers for T_CHANNEL...
alter table T_CHANNEL disable all triggers;
prompt Disabling triggers for T_CHARGE...
alter table T_CHARGE disable all triggers;
prompt Disabling triggers for T_STRATEGY...
alter table T_STRATEGY disable all triggers;
prompt Loading T_APP...
insert into T_APP (APPID, APPNAME, APPCODE, SUBJECTID, APPTYPE, PRICE, STATUS, ADDRESS)
values (2, 'qwe', 'eqw', 1, '1', 1, '1', '1');
insert into T_APP (APPID, APPNAME, APPCODE, SUBJECTID, APPTYPE, PRICE, STATUS, ADDRESS)
values (1, 'av', '1v', 1, '1', 1, '1', '1');
commit;
prompt 2 records loaded
prompt Loading T_CHANNEL...
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (181, '123456', 'ab', '200000000', 'werfQQQQ', '13265985847', '[email protected]', '2', 'http://10.40.71.53', '1', 'ccadd');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (44, '123456', 'a', '3-24', 'bb', '132659858472', '[email protected]', '1', 'http://b.c', '0', null);
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (45, '123456', 'SS渠道', '3', 'fsdf', '13111111111', '[email protected]', '2', 'http://b.c', '1', null);
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (46, '123456', 'yy渠道', '1111111111', 'cf', '111111111111', '[email protected]', '2', 'http://10.40.71.53aA', '2', '而卧');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (240, '123456', '淡淡的的方式的法的淡淡的淡淡的的的淡淡的的淡师的法', null, '淡淡的淡淡的淡淡的淡淡的的淡淡的的淡淡的', '12565856987', '[email protected]', '2', 'http://sadf.c', '0', null);
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (187, '123456', '陶帅', '1', 'a', '13242324211', '[email protected]', '1', 'http://32.432.21.34', '0', ')(_ 98@!');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (188, '123456', 'abc', '11', 'as读法', '00000000000', '[email protected]', '1', 'http://sfsf.edu.ab3', '2', null);
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (222, '123456', '软通动力', '111', 'null', '15050555817', '[email protected]', '1', 'http://dd.dfd', '1', '很好很强？');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (190, '123456', 'erqwr', '1122222222', 'jlsfs', '12505563251', '[email protected]', '1', 'http://10.40.71.53', '0', '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || 'safasfsafsaf' || chr(13) || '' || chr(10) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '' || chr(9) || '');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (154, '123456', 'sss渠道', '000', 'sss', '11111111111', '[email protected]', '1', 'http://www.baidu.com', '0', null);
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (223, '123456', 'fsdfs', null, 'fsdf', '11111111111', '[email protected]', '1', 'http://b.c', '0', 'ab？￥');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (224, '123456', 'aa', null, 'fs', '11111111111', '[email protected]', '1', 'http://b.c', '0', 'aba!$%^&&*(*');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (225, '123456', 'aaa', null, 'aaaa', '11111111111', '[email protected]', '1', 'http://b.c', '0', 'aa&*()_');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (226, '123456', 'aaaaa', '234234', 'aa', '11111111111', '[email protected]', '1', 'http://b.cAba', '0', ')(*52!@^???_+~');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (227, '123456', '软通动力加强版', null, 'taoshuai', '15050555817', '[email protected]', '1', 'http://www.baidu', '0', 'dawfewfew');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (228, '123456', 'taosdfsafdsa', '256', 'sfsdfs', '15050555817', '[email protected]', '1', 'http://dfsa.cd', '1', 'afwefwe');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (229, '123456', 'qqdafdfas', null, 'hfdasljlf', '15050555817', '[email protected]', '1', 'http://fsafs.com', '0', '大幅的法师');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (230, '123456', 'rewrwe', null, 'erqre', '12351263547', '[email protected]', '1', 'http://erw.c', '0', 'dasfefw');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (231, '123456', 'wefwe', null, 'weqr', '12322133333', '[email protected]', '1', 'http://10.40', '0', '1');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (232, '123456', 'taoshuaihao', null, 'taoshuaiere', '152236541235', '[email protected]', '1', 'http://10.40.71.53', '0', '!@#$%^&^*(()_+}{|:>NMBDRGWE,.');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (238, '123456', 'bbb', null, 'bb', '11111125623', '[email protected]', '1', 'http://c.cc.com.', '0', null);
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (234, '123456', 'bb', null, 'fasdf', '111111111111', '[email protected]', '1', 'http://b.c', '0', '!@$$%$^%*&^*(&^()*&)_)+"><M:NCBXVZDSfgsd');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (235, '123456', '陶帅好', '121', 'null', '13252654845', '[email protected]', '2', 'http://fsad.dfsa.v.v.vv.v.v.', '1', 'cc欧科、【；、。');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (236, '123456', 'ewqwwwwwwwwwwwwwwwwwwwwww', null, 'wwwwwwwwwwwwwwwwwwww', '11111125623', '[email protected]', '1', 'http://d.o.mmmmmmmmmmmmmmmmmmm', '0', 'dfsafgaegewge');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (237, '123456', '的', null, '打法', '12536524512', '[email protected]', '1', 'http://dfafds.cdfd', '0', 'afsdfsdafds');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (194, '123456', 'erwqrq', '00', 'rqwerwqr', '12525863521', '[email protected]', '1', 'http://10.40.71.53dsfef e发沃尔沃', '0', null);
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (195, '123456', 'efw', null, 'rweqr', '25611111111', '[email protected]', '1', 'http://10.40.71.53凡违!@#$%^&*()', '0', 'rewqrq');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (196, '123456', 'ytryw', null, 'erwqrq', '05118736986', '[email protected]', '1', 'http://dssssssssssssssssaf.com', '0', null);
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (197, '123456', '顽强', '111111', 'ewqe', '12322133333', '[email protected]', '2', 'http://10.40.71.53凡违人青？?remark=日期我提？', '0', 'null');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (192, '123456', '而且我让二二', null, '污染', '051187369864', '[email protected]', '1', 'http://d.d', '0', 'sadfa');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (193, '123456', 'adgaweg', '12', 'e', '02587635264', '[email protected]', '1', 'http://10.40.71.53？？？？', '1', 'erq');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (198, '123456', '发的萨芬夫妇反反复反复反复反复反复反复反复反复反复', null, '鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅鹅', '11111111111', '[email protected]', '1', 'http://10.40.71.53凡违？而且', '0', '热情我人气');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (199, '123456', 'qweqweqewq', null, 'qqeqewqeq', '55555555555', '[email protected]', '1', 'http://10.40.71.53凡违!@#$%^&*()', '0', 'abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvw');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (200, '123456', 'taoshuai', null, 'taoshuai', '11111111111', '[email protected]', '2', 'http://afdsafa.com', '0', 'taoshuai');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (201, '123456', '的分萨芬', '100', '而服务', '15050555817', '[email protected]', '1', 'http://dfa.cn', '0', '爱上风格');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (203, '123456', 'ffff', null, 'ffff', '11111111111', '[email protected]', '1', 'http://b.c', '0', '#');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (239, '123456', 'aaaaaa', null, 'a', '11111111111', '[email protected]', '2', 'http://10.10.1.1', '0', null);
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (241, '123456', 't', null, 't', '11111111111', '[email protected]', '2', 'http://10.10.10.10', '0', null);
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (202, '123456', 'ff', null, 'fsadf', '111111111111', '[email protected]', '1', 'http://b.c', '0', '#');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (204, '123456', 'fff', null, 'fff', '11111111111', '[email protected]', '1', 'http://b.c', '0', ',');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (207, '123456', '而温柔', null, '而污染物', '12365487956', '[email protected]', '1', 'http://10.40.71.53凡违且dfedf!@#$', '0', 'fewrfewrw');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (208, '123456', 'eeeeeeeeeeeeeeeeeeeeeeeee', null, 'eeeeeeeeeeeeeeeeeeee', '11111111111', '[email protected]', '1', 'http://dsafsaf.c', '0', 'dddddddddddddddddddddddddddddddddddddddddddddddddd');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (209, '123456', 'erw', null, '而无人区', '12325632156', '[email protected]', '1', 'http://dfafd.c', '0', null);
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (210, '123456', '阿萨德丰富的淡淡的淡淡的淡淡的淡淡的的淡淡的的淡淡', null, '啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊', '154312151212', '[email protected]', '1', 'http://dfas.d', '0', '的分萨芬撒旦法vdf！@#￥%（）——+}{“：？');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (205, '123456', 'taoshuaiqq', null, 'trwt', '15000000000', '[email protected]', '1', 'http://dfs.v', '0', 'eee,3r3');
insert into T_CHANNEL (CHANNELID, PASSWORD, CHANNELNAME, CHANNELCODE, CONTACTER, TEL, EMAIL, CHANNELTYPE, WEBSITE, STATUS, REMARK)
values (206, '123456', 'dfasf', '55', 'fdfasdf', '12025254684', '[email protected]', '1', 'http://dfasf.c', '0', '111!@');
commit;
prompt 46 records loaded
prompt Loading T_CHARGE...
insert into T_CHARGE (CID, CHARGENAME, CHARGEMODE)
values (1, '按次', 1);
insert into T_CHARGE (CID, CHARGENAME, CHARGEMODE)
values (2, '免费', 2);
insert into T_CHARGE (CID, CHARGENAME, CHARGEMODE)
values (3, '限次', 3);
insert into T_CHARGE (CID, CHARGENAME, CHARGEMODE)
values (4, '包月', 4);
commit;
prompt 4 records loaded
prompt Loading T_STRATEGY...
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (13, 44, 2, 3, to_date('28-08-2010 09:32:49', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (1, 154, 1, 1, to_date('25-08-2010 11:35:36', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (2, 154, 1, 3, to_date('28-08-2010 13:44:12', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (5, 43, 2, 1, to_date('26-08-2010 09:09:37', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (3, 43, 1, 1, to_date('25-08-2010 17:29:37', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (4, 141, 2, 3, to_date('25-08-2010 18:05:43', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (6, 43, 2, 3, to_date('26-08-2010 09:10:08', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (7, 154, 2, 2, to_date('28-08-2010 14:08:53', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (8, 141, 2, 1, to_date('26-08-2010 09:23:11', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (9, 148, 2, 1, to_date('26-08-2010 11:36:37', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (10, 148, 1, 1, to_date('26-08-2010 11:36:58', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (11, 158, 1, 1, to_date('26-08-2010 11:40:27', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_STRATEGY (RID, CHANNELID, APPID, CID, MODIFYTIME)
values (12, 158, 2, 1, to_date('26-08-2010 11:40:34', 'dd-mm-yyyy hh24:mi:ss'));
commit;
prompt 13 records loaded
prompt Enabling triggers for T_APP...
alter table T_APP enable all triggers;
prompt Enabling triggers for T_CHANNEL...
alter table T_CHANNEL enable all triggers;
prompt Enabling triggers for T_CHARGE...
alter table T_CHARGE enable all triggers;
prompt Enabling triggers for T_STRATEGY...
alter table T_STRATEGY enable all triggers;
set feedback on
set define on
prompt Done.
|
