package com.conceptualsystems.database;

import android.provider.BaseColumns;

import java.util.HashMap;
import java.util.Map;

///////////////////////////////////
//  CHANGELOG
//  =============================
//  6/24/11 - v2

public final class DatabaseSchema {
	public static final String DATABASE_NAME = "smskitting";
	public static final int DATABASE_VERSION = 5;
	public static final String SORT_ASC = " ASC";
	public static final String SORT_DESC = " DESC";
	public static final String[] ORDERS = {SORT_ASC,SORT_DESC};
	public static final int OFF = 0;
	public static final int ON = 1;
	public static final Map<String, Class<? implements BaseColumns>> DatabaseTables = new HashMap<String, Class<? implements BaseColumns>>();
	public static final DatabaseSchema instance = new DatabaseSchema();

	public static final DatabaseSchema getSchema() {
		return instance;
	}

	public static final class KitSchema implements BaseColumns {
		public static final String TABLE_NAME = "kit";
		public static final String COLUMN_ID = "kit_id";
		public static final String COLUMN_RAW_ID = "raw_id";
		public static final String COLUMN_FIN_ID = "fin_id";
		public static final String COLUMN_DATE = "date";
		public static final String COLUMN_GROSS = "gross";
		public static final String COLUMN_NET = "net";
		public static final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
				_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
				COLUMN_ID + " TEXT NOT NULL," +
				COLUMN_RAW_ID + " TEXT," +
				COLUMN_FIN_ID + " TEXT NOT NULL," +
				COLUMN_DATE + " LONG NOT NULL," +
				COLUMN_GROSS + " LONG NOT NULL," +
				COLUMN_NET + " LONG NOT NULL);";
		public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME;
	}

	public static final class ShipmentSchema implements BaseColumns {
		public static final String TABLE_NAME = "shipment";
		public static final String COLUMN_ID = "kit_id";
		public static final String COLUMN_SHIP_ID = "ship_id";
		public static final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
				_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
				COLUMN_SHIP_ID + " TEXT NOT NULL," +
				COLUMN_ID + " TEXT NOT NULL);";
		public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME;
	}

	public static final class TargetSchema implements BaseColumns {
		public static final String TABLE_NAME = "target";
		public static final String COLUMN_TARGET = "target_weight";
		public static final String COLUMN_SHIP_ID = "ship_id";
		public static final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
				_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
				COLUMN_SHIP_ID + " TEXT NOT NULL," +
				COLUMN_TARGET + " TEXT NOT NULL);";
		public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME;
	}

	public static final class SiteSchema implements BaseColumns {
		public static final String TABLE_NAME = "site";
		public static final String COLUMN_LABEL = "label";
		public static final String COLUMN_IP = "ip";
		public static final String COLUMN_PORT = "port";
		public static final String COLUMN_ACTIVATION_CODE = "code";
		public static final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
				_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
				COLUMN_LABEL + " TEXT NOT NULL," +
				COLUMN_IP + " TEXT NOT NULL," +
				COLUMN_ACTIVATION_CODE + " TEXT," +
				COLUMN_PORT + " TEXT NOT NULL);";
		public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME;
	}

	public static final class CustomerSchema implements BaseColumns {
		public static final String TABLE_NAME = "customers";
		public static final String COLUMN_NAME = "name";
		public static final String COLUMN_ID = "cust_id";
		public static final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
				_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
				COLUMN_ID + " TEXT NOT NULL," +
				COLUMN_NAME + " TEXT NOT NULL);";
		public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME;
	}

	public static final class ProductSchema implements BaseColumns {
		public static final String TABLE_NAME = "products";
		public static final String COLUMN_NAME = "name";
		public static final String COLUMN_ID = "prod_id";
		public static final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
				_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
				COLUMN_ID + " TEXT NOT NULL," +
				COLUMN_NAME + " TEXT NOT NULL);";
		public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME;
	}
}