package com.ectrip.cyt.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DbHelper extends SQLiteOpenHelper {

	private static String Db_Name = "ectrip.db";
	private static int Db_Version = 7;

	public  DbHelper(Context context) {
		super(context, Db_Name, null, Db_Version);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {

		db.execSQL("CREATE TABLE IF NOT EXISTS ec_configs"
				+ "(ec_cid  NVARCHAR,ec_ip NVARCHAR,ec_passwd NVARCHAR,ec_mac NVARCHAR,ec_key NVARCHAR,ec_name NVARCHAR,ec_isPrint INT)");

		//数据表名为ec_save_print，字段为ec_id，ec_time，ec_content,
		db.execSQL("CREATE TABLE IF NOT EXISTS ec_save_print"
				+ "(ec_id INTEGER PRIMARY KEY AUTOINCREMENT,ec_time NVARCHAR,ec_content NVARCHAR,ec_order_id NVARCHAR)");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		db.execSQL("DROP TABLE IF EXISTS ec_configs");
		db.execSQL("DROP TABLE IF EXISTS ec_save_print");
		onCreate(db);
	}

}