@@ -0,0 +1,1863 @@
+package com.gmail.emerssso.srbase.database;%0A%0Aimport android.database.sqlite.SQLiteDatabase;%0Aimport android.util.Log;%0A%0A// TODO: Auto-generated Javadoc%0A/**%0A * The Class PartTable.%0A */%0Apublic class PartTable %7B%0A%09%0A%09/** The Constant TABLE_PART. */%0A%09public static final String TABLE_PART = %22part%22;%0A%09%0A%09/** The Constant COLUMN_ID. */%0A%09public static final String COLUMN_ID = %22_id%22;%0A%09%0A%09/** The Constant COLUMN_SR_ID. */%0A%09public static final String COLUMN_SR_ID = %22sr_id%22;%0A%09%0A%09/** The Constant COLUMN_QUANTITY. */%0A%09public static final String COLUMN_QUANTITY = %22quantity%22;%0A%09%0A%09/** The Constant COLUMN_USED. */%0A%09public static final String COLUMN_USED = %22used%22;%0A%09%0A%09/** The Constant COLUMN_SOURCE. */%0A%09public static final String COLUMN_SOURCE = %22source%22;%0A%09%0A%09/** The Constant COLUMN_DESCRIPTION. */%0A%09public static final String COLUMN_DESCRIPTION = %22description%22;%0A%09%0A%09/** The Constant DATABASE_CREATE. */%0A%09private static final String DATABASE_CREATE = %22create table %22%0A%09%09%09+ TABLE_PART + %22(%22 + COLUMN_ID%0A%09%09%09+ %22 integer primary key autoincrement, %22%0A%09%09%09+ COLUMN_SR_ID + %22 text not null, %22%0A%09%09%09+ COLUMN_QUANTITY + %22 text not null, %22%0A%09%09%09+ COLUMN_USED + %22 text not null, %22%0A%09%09%09+ COLUMN_SOURCE + %22 text not null, %22%0A%09%09%09+ COLUMN_DESCRIPTION + %22 text not null);%22;%0A%09%0A%09/**%0A%09 * On create.%0A%09 *%0A%09 * @param database the database%0A%09 */%0A%09public static void onCreate(SQLiteDatabase database) %7B%0A%09    database.execSQL(DATABASE_CREATE);%0A%09%7D%0A%09%0A%09/**%0A%09 * On upgrade.%0A%09 *%0A%09 * @param database the database%0A%09 * @param oldVersion the old version%0A%09 * @param newVersion the new version%0A%09 */%0A%09public static void onUpgrade(SQLiteDatabase database, int oldVersion,%0A%09%09%09int newVersion) %7B%0A%09%09Log.w(SRTable.class.getName(), %22Upgrading database from version %22%0A%09%09%09%09+ oldVersion + %22 to %22 + newVersion%0A%09%09%09%09+ %22, which will destroy all old data%22);%0A%09%09database.execSQL(%22DROP TABLE IF EXISTS %22 + TABLE_PART);%0A%09%09onCreate(database);%0A%09%7D%0A%0A%7D%0A

Add PartTable class