package com.sandy.mylittleprincess2;
import java.io.File;

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

public class CreatDB extends SQLiteOpenHelper{
	private static final String DICTIONARY_TABLE_NAME = "Place";
	private static final String DICTIONARY_TABLE_CREATE =
            "CREATE TABLE " + DICTIONARY_TABLE_NAME + " (" +
            "_id" + "  INTEGER PRIMARY KEY AUTOINCREMENT, " +
            "Finish_date" + " TEXT , "+
            "HyperLink" + " TEXT, " +
            "Main" + " TEXT, " +
            "Context"+" TEXT, "+
            "Address"+" TEXT "+
            " );";

	private static final int VERSION=3;
	public CreatDB(Context context) {
		super(context, "Princess", null, VERSION);
		// TODO 自動產生的建構子 Stub
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO 自動產生的方法 Stub
		db.execSQL(DICTIONARY_TABLE_CREATE);
		
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO 自動產生的方法 Stub
		System.out.println("old"+oldVersion+"new"+newVersion);
		if(oldVersion<2){
		String sql=" ALTER TABLE "+DICTIONARY_TABLE_NAME+" ADD COLUMN Address TEXT";
        db.execSQL(sql);
        oldVersion++;
		}else{
        //onCreate(db);
		}
		}
	
	@Override
	public synchronized void close() {
		// TODO 自動產生的方法 Stub
		super.close();
	}
	 
}