package {package}.provider;

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

import {package}.provider.{app_cap}Contract.*;

public class {app_cap}Database extends SQLiteOpenHelper {
	
	private static final String DATABASE_NAME = "{database}";
	
	private static final int DATABASE_VERSION = 1;
	
	{foreach table}
	private static final String {table_up}_CREATE = "CREATE TABLE "
		+ Tables.{table_up}
		+ "("
		+ BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
		{foreach column}
		+ {table_cap}Columns.{column_up} + " {column_type}{column_default}{column_primary_key}{column_autoincrement}{column_not_null}{column_comma}"
		{end column}
		{database_column_foreign_key}
		+ ");";
	{end table}
	
	interface Tables {
		{foreach table}
		String {table_up} = "{table}";
		{database_table_join}
		{end table}
	}
	
	public {app_cap}Database(Context context) {
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
	}
	
	@Override
	public void onCreate(SQLiteDatabase db) {
		{foreach table}
		db.execSQL({table_up}_CREATE);
		{end table}
	}
	
	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {}
	
}