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;
    }
}