-- 页面模板

DELETE FROM T_BAS_METATPL WHERE FID IN (896296560785145856, 896300011271274496, 912049863745602560, 912050506254258176, 896300496803905536, 896354297661407232, 896427930253575168, 909393634292447232, 909393385033352192, 896113322657593344, 910660485102220288, 920066797187643392, 909402991365243904, 909393167181202432);


INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (896296560785145856, 'bos_doublepicrow_moblist', '带图双列列表模板', 'C', 13466739, 13466739, '1', {ts'2020-05-21 15:39:11'}, {ts'2020-08-28 15:15:34'}, 896296560785145856, 890408979845362688, '0T+WNB01F3X9', '/private/bos/metatemplate/Bos_dtsllb_160_260.png', '带图的复杂业务单据的关键信息展示', '["/private/bos/metatemppreview/Ilist/bos_dtslb_kccx_375_667.png", "/private/bos/metatemppreview/Ilist/bos_dtslb_scddcx_375_667.png", "/private/bos/metatemppreview/Ilist/bos_dtslb_yxsp_375_667.png"]', 5);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (896300011271274496, 'bos_singleopera_moblist', '单操作列表模板', 'C', 13466739, 13466739, '1', {ts'2020-05-21 15:47:20'}, {ts'2020-08-28 15:20:09'}, 896300011271274496, 890408979845362688, '0T1YMDS8OP2U', '/private/bos/metatemplate/Bos_dczlb_160_260.png', '对列表行数据进行单个快速操作', '["/private/bos/metatemppreview/Ilist/bos_dczlb_dskkhxx_375_667.png", "/private/bos/metatemppreview/Ilist/bos_dczlb_dspqjd_375_667.png", "/private/bos/metatemppreview/Ilist/bos_dczlb_mdsppd__375_667.png"]', 3);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (912049863745602560, 'bos_singlecol_moblisttpl', '单列列表模板', 'C', 13466739, 13466739, '1', {ts'2020-06-12 09:19:06'}, {ts'2020-08-28 15:19:01'}, 912049863745602560, 890408979845362688, '0SX4EBJTZILO', '/private/bos/metatemplate/Bos_dllb_160_260.png', '基础资料或简单单据的快速查看', '["/private/bos/metatemppreview/Ilist/bos_dllb_wdbl_375_667.png", "/private/bos/metatemppreview/Ilist/bos_dllb_ysxx_375_667.png", "/private/bos/metatemppreview/Ilist/bos_dllb_zjszmx_375_667.png"]', 1);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (912050506254258176, 'bos_doublerow_mobbilltpl', '双列列表模板', 'C', 13466739, 13466739, '1', {ts'2020-06-12 09:20:28'}, {ts'2020-08-28 15:16:57'}, 912050506254258176, 890408979845362688, '0T+JKAT2KGYG', '/private/bos/metatemplate/Bos_sllb_160_260.png', '复杂业务单据的关键信息展示', '["/private/bos/metatemppreview/Ilist/bos_sllb_cgdd_375_668.png", "/private/bos/metatemppreview/Ilist/bos_sllb_jylsxx_375_668.png", "/private/bos/metatemppreview/Ilist/bos_sllb_kccx_375_668.png", "/private/bos/metatemppreview/Ilist/bos_sllb_wdxsdd_375_668.png", "/private/bos/metatemppreview/Ilist/bos_sllb_zd_375_668.png"]', 4);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (896300496803905536, 'bos_multiopera_moblist', '多操作列表模板', 'C', 13466739, 13466739, '1', {ts'2020-05-21 15:48:22'}, {ts'2020-08-28 15:17:56'}, 896300496803905536, 890408979845362688, '0T2+N3Z246QT', '/private/bos/metatemplate/Bos_dczlb2_160_260.png', '对列表行数据进行多个快速操作', '["/private/bos/metatemppreview/Ilist/bos_dczlb_mdyh__375_667.png", "/private/bos/metatemppreview/Ilist/bos_dczlb_scrwd_375_667.png", "/private/bos/metatemppreview/Ilist/bos_dczlb_sjlb__375_667.png"]', 6);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (896354297661407232, 'bos_serviceporta_mobform', '服务门户类首页模板', 'C', 13466739, 13466739, '1', {ts'2020-05-21 17:35:27'}, {ts'2020-08-28 14:37:31'}, 896354297661407232, 890408595915551744, '0T221ILJI030', '/private/bos/metatemplate/Bos_sy_160_260.png', '主要作为业务办理的入口，包含运营banner、快速开始入口和待办数据等', '["/private/bos/metatemppreview/Home/bos_fwmhl_750_1334.png"]', 1);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (896427930253575168, 'bos_entry_mobform', '简单录入模板', 'C', 13466739, 13466739, '1', {ts'2020-05-21 20:01:47'}, {ts'2020-08-28 14:48:38'}, 896427930253575168, 890409900134381568, '0T228ZFJYZPI', '/private/bos/metatemplate/bos_jdlur_160_260.png', '适用于简单的单据录入场景，不带分录信息', '["/private/bos/metatemppreview/Input/Bos_cgsqd_375_667.png", "/private/bos/metatemppreview/Input/Bos_skd_375_667.png", "/private/bos/metatemppreview/Input/Bos_tjxcd_375_667.png"]', 1);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (909393385033352192, 'bos_businemanage_mobform', '业务管理类首页模板', 'C', 13466739, 13466739, '1', {ts'2020-06-08 17:21:56'}, {ts'2020-08-28 13:57:24'}, 909393385033352192, 890408595915551744, '0UOLLNE=HKL=', '/private/bos/metatemplate/Bos_ywgll_160_260.png', '主要作为业务管理的入口，主要包含关键统计数字和快速入口', '["/private/bos/metatemppreview/Home/bos_ywgll_750_1334.png", "/private/bos/metatemppreview/Home/bos_ywgll2__750_1334.png", "/private/bos/metatemppreview/Home/bos_ywgll3__750_1334.png"]', 2);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (896113322657593344, 'bos_singlepicrow_mobbill', '带图单列列表模板', 'C', 13466739, 13466739, '1', {ts'2020-05-21 09:36:23'}, {ts'2020-08-28 15:21:03'}, 896113322657593344, 890408979845362688, '0T+DQ/F/UOSP', '/private/bos/metatemplate/Bos_dtdllb_160_260.png', '带图的基础资料或简单单据的快速查看', '["/private/bos/metatemppreview/Ilist/bos_dtdlb_bgjlyqd_375_667.png", "/private/bos/metatemppreview/Ilist/bos_dtdlb_dshfybx__375_667.png", "/private/bos/metatemppreview/Ilist/bos_dtdlb_gyxx__375_667.png"]', 2);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (910660485102220288, 'bos_shopmallper_mobform', '商城类个人中心模板', 'C', 13466739, 13466739, '1', {ts'2020-06-10 11:18:08'}, {ts'2020-08-28 14:44:20'}, 910660485102220288, 890409113937261568, '0URZCFC3N206', '/private/bos/metatemplate/Bos_my2_160_260.png', '主要作为商城类产品的个人管理中心，包含了个人信息、统计数据和工具服务、管理、设置等入口', '["/private/bos/metatemppreview/PersonalCenter/bos_sclgrzx_750_1338.png", "/private/bos/metatemppreview/PersonalCenter/bos_sclgrzx2_750_1338.png"]', 2);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (920066797187643392, 'bos_entryinput_mobform', '平铺式分录录入模板', 'C', 13466739, 13466739, '1', {ts'2020-06-23 10:47:44'}, {ts'2020-08-28 15:13:49'}, 920066797187643392, 890409900134381568, '0VXFD1P1QVQD', '/private/bos/metatemplate/bos_ppfl_160_260.png', '适用于存在分录的单据录入场景，分录行的字段数不宜太多', '["/private/bos/metatemppreview/Input/Bos_lskds_375_667.png", "/private/bos/metatemppreview/Input/Bos_xjccbx_375_667.png"]', 2);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (909393634292447232, 'bos_datakanban_mobform', '数据看板类首页模板', 'C', 13466739, 13466739, '1', {ts'2020-06-08 17:22:21'}, {ts'2020-08-28 14:36:49'}, 909393634292447232, 890408595915551744, '0UOQTTWN=IKR', '/private/bos/metatemplate/Bos_sjkbl_160_260.png', '主要用于业务指标的监测，可由若干个数字统计面板构成', '["/private/bos/metatemppreview/Home/bos_sjkbl_750_1334.png"]', 3);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (909402991365243904, 'bos_univarsalper_mobform', '通用型个人中心模板', 'C', 13466739, 13466739, '1', {ts'2020-06-08 17:41:02'}, {ts'2020-08-28 14:45:23'}, 909402991365243904, 890409113937261568, '0UOTG3MRSNVP', '/private/bos/metatemplate/Bos_my1__160_260.png', '一种常见的个人管理中心，包含了个人信息和管理、设置等入口', '["/private/bos/metatemppreview/PersonalCenter/bos_tyxgrz2_750_1338.png", "/private/bos/metatemppreview/PersonalCenter/bos_tyxgrzx2_750_1338.png"]', 1);
INSERT INTO T_BAS_METATPL(FID, FNUMBER, FNAME, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FGROUPID, FPAGE, FSRC, FDESC, FPREVPATHS, FORDER) VALUES (909393167181202432, 'bos_market_mobform', '商城类首页模板', 'C', 13466739, 13466739, '1', {ts'2020-06-08 17:20:57'}, {ts'2020-08-28 14:36:32'}, 909393167181202432, 890408595915551744, '0USR7VX3VSA+', '/private/bos/metatemplate/Bos_scl_160_260.png', '主要用于B2B或B2C商城，包含运营banner和重点的商品/物料信息', ' ["/private/bos/metatemppreview/Home/bos_scl_75-_1334.png", "/private/bos/metatemppreview/Home/bos_scl2_75-_1334.png", "/private/bos/metatemppreview/Home/bos_scl3_75-_1334.png"]', 4);


-- 页面模板多语言


DELETE FROM T_BAS_METATPL_L WHERE FID IN (896296560785145856, 896300011271274496, 912049863745602560, 912050506254258176, 896300496803905536, 896354297661407232, 896427930253575168, 909393634292447232, 909393385033352192, 896113322657593344, 910660485102220288, 920066797187643392, 909402991365243904, 909393167181202432);


INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0T214P422RG+', 896296560785145856, 'zh_CN', '带图双列列表模板', '带图的复杂业务单据的关键信息展示');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0T21SUKW2XV5', 896300011271274496, 'zh_CN', '单操作列表模板', '对列表行数据进行单个快速操作');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0T21WCK640FP', 896300496803905536, 'zh_CN', '多操作列表模板', '对列表行数据进行多个快速操作');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0T2AYEK7OM1+', 896354297661407232, 'zh_CN', '服务门户类首页模板', '主要作为业务办理的入口，包含运营banner、快速开始入口和待办数据等');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0V/IKRC06J/3', 912049863745602560, 'zh_CN', '单列列表模板', '基础资料或简单单据的快速查看');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0V/IPEHT1ICD', 912050506254258176, 'zh_CN', '双列列表模板', '复杂业务单据的关键信息展示');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0T2OP+7MA6HT', 896427930253575168, 'zh_CN', '简单录入模板', '适用于简单的单据录入场景，不带分录信息');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0UOT9UVNGPSX', 909393634292447232, 'zh_CN', '数据看板类首页模板', '主要用于业务指标的监测，可由若干个数字统计面板构成');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0UOV001ZMNFT', 909402991365243904, 'zh_CN', '通用型个人中心模板', '一种常见的个人管理中心，包含了个人信息和管理、设置等入口');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0UOT6FAI1/RV', 909393167181202432, 'zh_CN', '商城类首页模板', '主要用于B2B或B2C商城，包含运营banner和重点的商品/物料信息');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0UOT800+LIS6', 909393385033352192, 'zh_CN', '业务管理类首页模板', '主要作为业务管理的入口，主要包含关键统计数字和快速入口');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0T15XF3BF6WP', 896113322657593344, 'zh_CN', '带图单列列表模板', '带图的基础资料或简单单据的快速查看');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0UUW+C4ZNHSY', 910660485102220288, 'zh_CN', '商城类个人中心模板', '主要作为商城类产品的个人管理中心，包含了个人信息、统计数据和工具服务、管理、设置等入口');
INSERT INTO T_BAS_METATPL_L(FPKID, FID, FLOCALEID, FNAME, FDESC) VALUES ('0W+YI//C3Z2O', 920066797187643392, 'zh_CN', '平铺式分录录入模板', '适用于存在分录的单据录入场景，分录行的字段数不宜太多');

-- 页面模板分类

DELETE FROM T_BAS_METATPLCAT WHERE FID IN (890408595915551744, 890408779835783168, 890408979845362688, 890409113937261568, 890409900134381568, 890410178854270976);


INSERT INTO T_BAS_METATPLCAT(FID, FNUMBER, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FLONGNUMBER, FLEVEL, FISLEAF, FPARENTID, FORDER) VALUES (890408595915551744, 'homepage', 'C', 347167982184592393, 13466739, '1', {ts'2020-05-13 12:42:20'}, {ts'2020-08-28 15:27:15'}, 890408595915551744, 'MobMeta.homepage', 2, '1', 890408779835783168, 3);
INSERT INTO T_BAS_METATPLCAT(FID, FNUMBER, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FLONGNUMBER, FLEVEL, FISLEAF, FPARENTID, FORDER) VALUES (890408779835783168, 'MobMeta', 'C', 347167982184592393, 13466739, '1', {ts'2020-05-13 12:42:59'}, {ts'2020-08-28 15:26:01'}, 890408779835783168, 'MobMeta', 1, '0', 0, 1);
INSERT INTO T_BAS_METATPLCAT(FID, FNUMBER, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FLONGNUMBER, FLEVEL, FISLEAF, FPARENTID, FORDER) VALUES (890408979845362688, 'MobListMeta', 'C', 347167982184592393, 13466739, '1', {ts'2020-05-13 12:43:24'}, {ts'2020-08-13 14:06:58'}, 890408979845362688, 'MobListMeta', 1, '1', 0, 2);
INSERT INTO T_BAS_METATPLCAT(FID, FNUMBER, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FLONGNUMBER, FLEVEL, FISLEAF, FPARENTID, FORDER) VALUES (890409113937261568, 'other', 'C', 347167982184592393, 13466739, '1', {ts'2020-05-13 12:43:46'}, {ts'2020-08-28 15:27:23'}, 890409113937261568, 'MobMeta.other', 2, '1', 890408779835783168, 4);
INSERT INTO T_BAS_METATPLCAT(FID, FNUMBER, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FLONGNUMBER, FLEVEL, FISLEAF, FPARENTID, FORDER) VALUES (890409900134381568, 'input', 'C', 347167982184592393, 13466739, '1', {ts'2020-05-13 12:44:50'}, {ts'2020-08-28 15:27:05'}, 890409900134381568, 'MobMeta.input', 2, '1', 890408779835783168, 1);
INSERT INTO T_BAS_METATPLCAT(FID, FNUMBER, FSTATUS, FCREATORID, FMODIFIERID, FENABLE, FCREATETIME, FMODIFYTIME, FMASTERID, FLONGNUMBER, FLEVEL, FISLEAF, FPARENTID, FORDER) VALUES (890410178854270976, 'detail', 'C', 347167982184592393, 13466739, '1', {ts'2020-05-13 12:45:41'}, {ts'2020-08-28 15:26:41'}, 890410178854270976, 'MobMeta.detail', 2, '1', 890408779835783168, 2);


