create tabletask_test

(

idint primary keyauto_increment,user_name varchar(50) not null,

ac_namevarchar(50) not null,

task_typetinyint not null,

statustinyint not null,

isdeletetinyint not null,

start_timedatetime not null,

add_timedatetime not null,

update_timedatetime not null);insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,3,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,4,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,3,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,4,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name3',1,3,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name4',1,4,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,2,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name2',1,0,0,now(),now(),now());insert into task_test(user_name,ac_name, task_type, status, isdelete, start_time, add_time, update_time) values ('test2','name1',1,0,0,now(),now(),now());