package com.ectrip.cyt.db;

/**
 * @author dengchen
 *         Created by  2016/9/14.
 */
public interface OrderDbString {


    String NAME    = "order.db";
    int    VERSION = 1;

    /**
     * 浏览历史表
     */
    public interface TableHistroy {

        String TABLE_NAME = "order";// 表名
        String INVITASION_ID         = "_id";//id自增
        String INVITASION_ORDER        = "orderid";//订单号
        String INVITASION_PID        = "pid";//流水号

        /**
         * 建表的sql
         */
        String CREATE_TABLE_SQL = "create table " + TABLE_NAME + "("
                + INVITASION_ID + " integer primary key autoincrement,"
                + INVITASION_ORDER + " text,"
                + INVITASION_PID + " text,"
                + ")";

        /**
         * 根据传入的参数查询数据
         */
        String QUERY_ALL_SQL = "select "
                + INVITASION_PID + ","
                 + " from "
                + TABLE_NAME + " where "
                + INVITASION_ORDER + "=?";


        /**
         * 根据tid查询数据，判断是否执行插入操作
         */
        String QUERY_IS_EXIST_SQL = "select "
                + INVITASION_ORDER + " from "
                + TABLE_NAME + " where "
                + INVITASION_ORDER + "=?";

    }

}