无线站坪：创建人车关联假数据的sql脚本
2017-11-09 16:25:03 访问(2054) 赞(0) 踩(0)
prompt Importing table car_driver...
set feedback off
set define off
insert into car_driver (ID, PLATE_NUMBER, NFC_GUID, ACCOUNT, BEGIN_TIME, END_TIME, CARINFO_ID, EMCARDRIVERFROMV, EMCARDRIVERSTATUSV)
values (car_driver_id.nextval, '民航C70611', '04:5d:58:82:00:3e:80', 'zhang.wei3', to_date('09-11-2017 22:19:11', 'dd-mm-yyyy hh24:mi:ss'), null, 0, 1, 1);
insert into car_driver (ID, PLATE_NUMBER, NFC_GUID, ACCOUNT, BEGIN_TIME, END_TIME, CARINFO_ID, EMCARDRIVERFROMV, EMCARDRIVERSTATUSV)
values (car_driver_id.nextval, '民航C70596', '04:c6:33:4a:eb:3e:80', 'haich.luo', to_date('09-11-2017 10:09:06', 'dd-mm-yyyy hh24:mi:ss'), null, 0, 1, 1);
insert into car_driver (ID, PLATE_NUMBER, NFC_GUID, ACCOUNT, BEGIN_TIME, END_TIME, CARINFO_ID, EMCARDRIVERFROMV, EMCARDRIVERSTATUSV)
values (car_driver_id.nextval, '民航C70562', '04:5c:e0:82:00:3e:80', 'wangqiang5', to_date('09-11-2017 10:10:56', 'dd-mm-yyyy hh24:mi:ss'), null, 0, 1, 1);
insert into car_driver (ID, PLATE_NUMBER, NFC_GUID, ACCOUNT, BEGIN_TIME, END_TIME, CARINFO_ID, EMCARDRIVERFROMV, EMCARDRIVERSTATUSV)
values (car_driver_id.nextval, '民航C70626', '04:5c:e0:82:00:3e:80', 'panhao', to_date('09-11-2017 10:14:35', 'dd-mm-yyyy hh24:mi:ss'), null, 0, 1, 1);
insert into car_driver (ID, PLATE_NUMBER, NFC_GUID, ACCOUNT, BEGIN_TIME, END_TIME, CARINFO_ID, EMCARDRIVERFROMV, EMCARDRIVERSTATUSV)
values (car_driver_id.nextval, '民航C70201', '04:4e:9f:82:00:3e:80', 'huij.xu', to_date('09-11-2017 11:13:36', 'dd-mm-yyyy hh24:mi:ss'), null, 0, 1, 1);
insert into car_driver (ID, PLATE_NUMBER, NFC_GUID, ACCOUNT, BEGIN_TIME, END_TIME, CARINFO_ID, EMCARDRIVERFROMV, EMCARDRIVERSTATUSV)
values (car_driver_id.nextval, '民航C70524', '04:8f:20:32:f1:4a:80', 'ps.li', to_date('09-11-2017 21:08:03', 'dd-mm-yyyy hh24:mi:ss'), null, 3234, 2, 5);
insert into car_driver (ID, PLATE_NUMBER, NFC_GUID, ACCOUNT, BEGIN_TIME, END_TIME, CARINFO_ID, EMCARDRIVERFROMV, EMCARDRIVERSTATUSV)
values (car_driver_id.nextval, '民航C70628', '04:5d:58:82:00:3e:90', 'shiz.lin', to_date('09-11-2017 08:31:38', 'dd-mm-yyyy hh24:mi:ss'), null, 0, 1, 1);
insert into car_driver (ID, PLATE_NUMBER, NFC_GUID, ACCOUNT, BEGIN_TIME, END_TIME, CARINFO_ID, EMCARDRIVERFROMV, EMCARDRIVERSTATUSV)
values (car_driver_id.nextval, '民航C70755', '04:68:40:82:00:3e:80', 'shiz.lin', to_date('09-11-2017 14:47:08', 'dd-mm-yyyy hh24:mi:ss'), null, 0, 1, 1);
insert into car_driver (ID, PLATE_NUMBER, NFC_GUID, ACCOUNT, BEGIN_TIME, END_TIME, CARINFO_ID, EMCARDRIVERFROMV, EMCARDRIVERSTATUSV)
values (car_driver_id.nextval, '民航C70762', '04:3f:35:82:00:3e:80', 'zhong_lin', to_date('09-11-2017 09:42:37', 'dd-mm-yyyy hh24:mi:ss'), null, 0, 1, 1);
insert into car_driver (ID, PLATE_NUMBER, NFC_GUID, ACCOUNT, BEGIN_TIME, END_TIME, CARINFO_ID, EMCARDRIVERFROMV, EMCARDRIVERSTATUSV)
values (car_driver_id.nextval, '民航C70230', '04:2f:a4:82:00:3e:80', 'hz.deng', to_date('09-11-2017 11:44:07', 'dd-mm-yyyy hh24:mi:ss'), null, 0, 1, 1);
prompt Done.
上一条：
下一条：
相关评论
发表评论