android/caddipictureupload/DatabaseHelper.java

package com.caddi.android.caddipictureupload;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 *
 */
public class DatabaseHelper extends SQLiteOpenHelper {
    public static final String DB_NAME = "CaddiPicture";
    public static final int DB_VERSION = 1;

    public DatabaseHelper(Context context) {
        super(context, DB_NAME, null, DB_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(
                "CREATE TABLE pictures ( " +
                        "id INTEGER PRIMARY KEY, " +
                        "filename TEXT, " +
                        "owner TEXT, " +
                        "status INTEGER" +
                        ") "

        );
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }


}
1	package com.caddi.android.caddipictureupload;
2
3	import android.content.Context;
4	import android.database.sqlite.SQLiteDatabase;
5	import android.database.sqlite.SQLiteOpenHelper;
6
7	/**
8	*
9	*/
10	public class DatabaseHelper extends SQLiteOpenHelper {
11	public static final String DB_NAME = "CaddiPicture";
12	public static final int DB_VERSION = 1;
13
14	public DatabaseHelper(Context context) {
15	super(context, DB_NAME, null, DB_VERSION);
16	}
17
18	@Override
19	public void onCreate(SQLiteDatabase db) {
20	db.execSQL(
21	"CREATE TABLE pictures ( " +
22	"id INTEGER PRIMARY KEY, " +
23	"filename TEXT, " +
24	"owner TEXT, " +
25	"status INTEGER" +
26	") "
27
28	);
29	}
30
31	@Override
32	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
33
34	}
35
36
37	}