<?php

namespace YHMSupport\SqlMap\Notice;

class Notice {

    const SELECT_NOTICE_BY_UID = 'select * from user_notice_setting where uid = :uid';
    const SET_NOTICE_BY_UID = 'insert into `user_notice_setting`(`uid`,`message_notice`,`order_notice`,`system_notice`,`notice_begin_time`,`notice_end_time`)
        values(:uid, :message_notice, :order_notice, :system_notice, :start_time, :end_time) ON DUPLICATE KEY UPDATE message_notice= :message_notice,order_notice=:order_notice, system_notice=:system_notice,notice_begin_time=:start_time,notice_end_time=:end_time';

}