dbschemaex

package com.conceptualsystems.kitmobile;

import android.provider.BaseColumns;

///////////////////////////////////
//  CHANGELOG
//  =============================
//  6/24/11 - v2
//  - added SiteSchema Table
//  - added CustomerSchema Table
//  - added ProductSchema Table

public final class DbSchema {
    public static final String DATABASE_NAME = "smskitting";
    public static final int DATABASE_VERSION = 2;
    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 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 + " INTEGER," +
                COLUMN_FIN_ID + " INTEGER NOT NULL," +
                COLUMN_DATE + " LONG NOT NULL," +
                COLUMN_GROSS + " INTEGER NOT NULL," +
                COLUMN_NET + " INTEGER 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 CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
                _ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
                COLUMN_ID + " 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 NOT NULL," +
                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 NOT NULL," +
                COLUMN_ID + " TEXT NOT NULL," +
                COLUMN_NAME + " TEXT NOT NULL);";
        public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME;
    }
}