package models

var Insert_sys_attachment = "insert into sys_attachment(`id`,`name`,`size`,`ext`,`hash`,`url`,`create_by`,`create_time`,`del_flag`) values (?id,?name,?size,?ext,?hash,?url,?create_by,?create_time,?del_flag)"

var Update_sys_attachment = "update sys_attachment set `name` = ?name,`size` = ?size,`ext` = ?ext,`hash` = ?hash,`url` = ?url,`create_by` = ?create_by,`create_time` = ?create_time,`del_flag` = ?del_flag where id = ?id"

var Deleteone_sys_attachment = "delete from sys_attachmentwhere id =?id"

var Selectone_sys_attachment = "select `id`,`name`,`size`,`ext`,`hash`,`url`,`create_by`,`create_time`,`del_flag` from sys_attachment where id = ?"

var Selectall_sys_attachment = "select `id`,`name`,`size`,`ext`,`hash`,`url`,`create_by`,`create_time`,`del_flag` from sys_attachment"