表数据_脚本

GY_TASK 任务表

-- Create table
create table GY_TASK
(
  UPDATE_TIME DATETIME,
  TASKID      int(4),
  TASKNAME    VARCHAR(100),
  CREATETIME  DATETIME,
  DEMO_URL    VARCHAR(50),
  EXEC_DATE   DATE
);
-- Add comments to the columns 
comment on column GY_TASK.UPDATE_TIME
  is '更新时间';
comment on column GY_TASK.TASKID
  is '任务ID';
comment on column GY_TASK.TASKNAME
  is '任务名称';
comment on column GY_TASK.CREATETIME
  is '创建时间';
comment on column GY_TASK.DEMO_URL
  is '样例地址';
comment on column GY_TASK.EXEC_DATE
  is '任务执行日期';

INSERT INTO gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
VALUES (STR_TO_DATE('19-03-2018 15:16:45', '%d-%m-%Y %H:%i:%s'), 7, '动态生成状态图片，点击改变状态', STR_TO_DATE('19-03-2018 15:16:45', '%d-%m-%Y %H:%i:%s'), '', STR_TO_DATE('19-03-2018', '%d-%m-%Y'));

INSERT INTO gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
VALUES (STR_TO_DATE('20-03-2018 08:53:58', '%d-%m-%Y %H:%i:%s'), 8, '开发者模式修改浏览器本地界面', STR_TO_DATE('20-03-2018 08:53:58', '%d-%m-%Y %H:%i:%s'), '', STR_TO_DATE('20-03-2018', '%d-%m-%Y'));

INSERT INTO gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
VALUES (STR_TO_DATE('19-03-2018 13:21:14', '%d-%m-%Y %H:%i:%s'), 6, 'JavaScript根据json数据生成“单个”动态界面', STR_TO_DATE('19-03-2018 13:21:14', '%d-%m-%Y %H:%i:%s'), '', STR_TO_DATE('19-03-2018', '%d-%m-%Y'));

INSERT INTO gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
VALUES (STR_TO_DATE('19-03-2018 07:50:22', '%d-%m-%Y %H:%i:%s'), 4, '前端基础串讲', STR_TO_DATE('19-03-2018 07:50:22', '%d-%m-%Y %H:%i:%s'), '', STR_TO_DATE('19-03-2018', '%d-%m-%Y'));

INSERT INTO gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
VALUES (STR_TO_DATE('19-03-2018 13:12:54', '%d-%m-%Y %H:%i:%s'), 5, '点击按钮，触发JavaScript方法动态生成固定界面', STR_TO_DATE('19-03-2018 13:12:54', '%d-%m-%Y %H:%i:%s'), '', STR_TO_DATE('19-03-2018', '%d-%m-%Y'));

INSERT INTO gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
VALUES (STR_TO_DATE('20-03-2018 09:35:11', '%d-%m-%Y %H:%i:%s'), 9, '前后端初次整合', STR_TO_DATE('20-03-2018 09:35:11', '%d-%m-%Y %H:%i:%s'), '', STR_TO_DATE('20-03-2018', '%d-%m-%Y'));

INSERT INTO gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
VALUES (STR_TO_DATE('21-03-2018 08:37:04', '%d-%m-%Y %H:%i:%s'), 10, '初次使用数据库', STR_TO_DATE('21-03-2018 08:37:04', '%d-%m-%Y %H:%i:%s'), '', STR_TO_DATE('21-03-2018', '%d-%m-%Y'));

INSERT INTO gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
VALUES (NULL, 1, '自动生成一批相同的学生信息', STR_TO_DATE('13-03-2018', '%d-%m-%Y'), '', STR_TO_DATE('13-03-2018', '%d-%m-%Y'));

INSERT INTO gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
VALUES (NULL, 2, '自动生成不同姓名的学生信息', STR_TO_DATE('14-03-2018', '%d-%m-%Y'), '', STR_TO_DATE('14-03-2018', '%d-%m-%Y'));

INSERT INTO gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
VALUES (NULL, 3, '使用一个字符串描述一个班的学生信息', STR_TO_DATE('15-03-2018', '%d-%m-%Y'), '', STR_TO_DATE('15-03-2018', '%d-%m-%Y'));

gy_task_item 任务详情表

-- Create table
create table GY_TASK_ITEM
(
  ITEMID     int(4),
  ITEMNAME   VARCHAR(50),
  TASKID     int(4),
  ITEMDESC   VARCHAR(200),
  ITEMSTATUS VARCHAR(1),
  PRIORITY   VARCHAR(6)
);
-- Add comments to the columns 
comment on column GY_TASK_ITEM.ITEMID
  is '任务检查点ID';
comment on column GY_TASK_ITEM.ITEMNAME
  is '任务检查点名称';
comment on column GY_TASK_ITEM.TASKID
  is '任务ID';
comment on column GY_TASK_ITEM.ITEMDESC
  is '任务检查点描述';
comment on column GY_TASK_ITEM.ITEMSTATUS
  is '状态';
comment on column GY_TASK_ITEM.PRIORITY
  is '每个任务检查点的优先级，从1开始';

insert into gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
values (str_to_date('19-03-2018 15:16:45', '%d-%m-%Y hh24:mi:ss'), 7, '动态生成状态图片，点击改变状态', str_to_date('19-03-2018 15:16:45', '%d-%m-%Y hh24:mi:ss'), '', str_to_date('19-03-2018', '%d-%m-%Y'));

insert into gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
values (str_to_date('20-03-2018 08:53:58', '%d-%m-%Y hh24:mi:ss'), 8, '开发者模式修改浏览器本地界面', str_to_date('20-03-2018 08:53:58', '%d-%m-%Y hh24:mi:ss'), '', str_to_date('20-03-2018', '%d-%m-%Y'));

insert into gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
values (str_to_date('19-03-2018 13:21:14', '%d-%m-%Y hh24:mi:ss'), 6, 'JavaScript根据json数据生成“单个”动态界面', str_to_date('19-03-2018 13:21:14', '%d-%m-%Y hh24:mi:ss'), '', str_to_date('19-03-2018', '%d-%m-%Y'));

insert into gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
values (str_to_date('19-03-2018 07:50:22', '%d-%m-%Y hh24:mi:ss'), 4, '前端基础串讲', str_to_date('19-03-2018 07:50:22', '%d-%m-%Y hh24:mi:ss'), '', str_to_date('19-03-2018', '%d-%m-%Y'));

insert into gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
values (str_to_date('19-03-2018 13:12:54', '%d-%m-%Y hh24:mi:ss'), 5, '点击按钮，触发JavaScript方法动态生成固定界面', str_to_date('19-03-2018 13:12:54', '%d-%m-%Y hh24:mi:ss'), '', str_to_date('19-03-2018', '%d-%m-%Y'));

insert into gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
values (str_to_date('20-03-2018 09:35:11', '%d-%m-%Y hh24:mi:ss'), 9, '前后端初次整合', str_to_date('20-03-2018 09:35:11', '%d-%m-%Y hh24:mi:ss'), '', str_to_date('20-03-2018', '%d-%m-%Y'));

insert into gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
values (str_to_date('21-03-2018 08:37:04', '%d-%m-%Y hh24:mi:ss'), 10, '初次使用数据库', str_to_date('21-03-2018 08:37:04', '%d-%m-%Y hh24:mi:ss'), '', str_to_date('21-03-2018', '%d-%m-%Y'));

insert into gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
values (null, 1, '自动生成一批相同的学生信息', str_to_date('13-03-2018', '%d-%m-%Y'), '', str_to_date('13-03-2018', '%d-%m-%Y'));

insert into gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
values (null, 2, '自动生成不同姓名的学生信息', str_to_date('14-03-2018', '%d-%m-%Y'), '', str_to_date('14-03-2018', '%d-%m-%Y'));

insert into gy_task (UPDATE_TIME, TASKID, TASKNAME, CREATETIME, DEMO_URL, EXEC_DATE)
values (null, 3, '使用一个字符串描述一个班的学生信息', str_to_date('15-03-2018', '%d-%m-%Y'), '', str_to_date('15-03-2018', '%d-%m-%Y'));