SHOW:
|
|
- or go back to the newest paste.
| 1 | package com.conceptualsystems.database; | |
| 2 | ||
| 3 | import android.provider.BaseColumns; | |
| 4 | ||
| 5 | import java.util.HashMap; | |
| 6 | import java.util.Map; | |
| 7 | ||
| 8 | /////////////////////////////////// | |
| 9 | // CHANGELOG | |
| 10 | // ============================= | |
| 11 | // 6/24/11 - v2 | |
| 12 | ||
| 13 | public final class DatabaseSchema {
| |
| 14 | public static final String DATABASE_NAME = "smskitting"; | |
| 15 | public static final int DATABASE_VERSION = 5; | |
| 16 | public static final String SORT_ASC = " ASC"; | |
| 17 | public static final String SORT_DESC = " DESC"; | |
| 18 | public static final String[] ORDERS = {SORT_ASC,SORT_DESC};
| |
| 19 | public static final int OFF = 0; | |
| 20 | public static final int ON = 1; | |
| 21 | public static final Map<String, Class<? implements BaseColumns>> DatabaseTables = new HashMap<String, Class<? implements BaseColumns>>(); | |
| 22 | public static final DatabaseSchema instance = new DatabaseSchema(); | |
| 23 | ||
| 24 | public static final DatabaseSchema getSchema() {
| |
| 25 | return instance; | |
| 26 | } | |
| 27 | ||
| 28 | public static final class KitSchema implements BaseColumns {
| |
| 29 | public static final String TABLE_NAME = "kit"; | |
| 30 | public static final String COLUMN_ID = "kit_id"; | |
| 31 | public static final String COLUMN_RAW_ID = "raw_id"; | |
| 32 | public static final String COLUMN_FIN_ID = "fin_id"; | |
| 33 | public static final String COLUMN_DATE = "date"; | |
| 34 | public static final String COLUMN_GROSS = "gross"; | |
| 35 | public static final String COLUMN_NET = "net"; | |
| 36 | public static final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
| |
| 37 | _ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + | |
| 38 | COLUMN_ID + " TEXT NOT NULL," + | |
| 39 | COLUMN_RAW_ID + " TEXT," + | |
| 40 | COLUMN_FIN_ID + " TEXT NOT NULL," + | |
| 41 | COLUMN_DATE + " LONG NOT NULL," + | |
| 42 | COLUMN_GROSS + " LONG NOT NULL," + | |
| 43 | COLUMN_NET + " LONG NOT NULL);"; | |
| 44 | public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME; | |
| 45 | } | |
| 46 | ||
| 47 | public static final class ShipmentSchema implements BaseColumns {
| |
| 48 | public static final String TABLE_NAME = "shipment"; | |
| 49 | public static final String COLUMN_ID = "kit_id"; | |
| 50 | public static final String COLUMN_SHIP_ID = "ship_id"; | |
| 51 | public static final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
| |
| 52 | _ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + | |
| 53 | COLUMN_SHIP_ID + " TEXT NOT NULL," + | |
| 54 | COLUMN_ID + " TEXT NOT NULL);"; | |
| 55 | public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME; | |
| 56 | } | |
| 57 | ||
| 58 | public static final class TargetSchema implements BaseColumns {
| |
| 59 | public static final String TABLE_NAME = "target"; | |
| 60 | public static final String COLUMN_TARGET = "target_weight"; | |
| 61 | public static final String COLUMN_SHIP_ID = "ship_id"; | |
| 62 | public static final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
| |
| 63 | _ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + | |
| 64 | COLUMN_SHIP_ID + " TEXT NOT NULL," + | |
| 65 | COLUMN_TARGET + " TEXT NOT NULL);"; | |
| 66 | public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME; | |
| 67 | } | |
| 68 | ||
| 69 | public static final class SiteSchema implements BaseColumns {
| |
| 70 | public static final String TABLE_NAME = "site"; | |
| 71 | public static final String COLUMN_LABEL = "label"; | |
| 72 | public static final String COLUMN_IP = "ip"; | |
| 73 | public static final String COLUMN_PORT = "port"; | |
| 74 | public static final String COLUMN_ACTIVATION_CODE = "code"; | |
| 75 | public static final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
| |
| 76 | _ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + | |
| 77 | COLUMN_LABEL + " TEXT NOT NULL," + | |
| 78 | COLUMN_IP + " TEXT NOT NULL," + | |
| 79 | COLUMN_ACTIVATION_CODE + " TEXT," + | |
| 80 | COLUMN_PORT + " TEXT NOT NULL);"; | |
| 81 | public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME; | |
| 82 | } | |
| 83 | ||
| 84 | public static final class CustomerSchema implements BaseColumns {
| |
| 85 | public static final String TABLE_NAME = "customers"; | |
| 86 | public static final String COLUMN_NAME = "name"; | |
| 87 | public static final String COLUMN_ID = "cust_id"; | |
| 88 | public static final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
| |
| 89 | _ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + | |
| 90 | COLUMN_ID + " TEXT NOT NULL," + | |
| 91 | COLUMN_NAME + " TEXT NOT NULL);"; | |
| 92 | public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME; | |
| 93 | } | |
| 94 | ||
| 95 | public static final class ProductSchema implements BaseColumns {
| |
| 96 | public static final String TABLE_NAME = "products"; | |
| 97 | public static final String COLUMN_NAME = "name"; | |
| 98 | public static final String COLUMN_ID = "prod_id"; | |
| 99 | public static final String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
| |
| 100 | _ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + | |
| 101 | COLUMN_ID + " TEXT NOT NULL," + | |
| 102 | COLUMN_NAME + " TEXT NOT NULL);"; | |
| 103 | public static final String DROP_TABLE = "DROP TABLE IF EXISTS " + TABLE_NAME; | |
| 104 | } | |
| 105 | } |
