Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.v3.messaging;
- import android.content.Context;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteOpenHelper;
- import android.database.sqlite.SQLiteDatabase.CursorFactory;
- public class DatabaseHelper extends SQLiteOpenHelper{
- private static final String DB_NAME = "messaging";
- private static final String TITLE = "title";
- private static final String VALUE = "value";
- public DatabaseHelper(Context context) {
- super(context, DB_NAME, null, 1);
- }
- @Override
- public void onCreate(SQLiteDatabase db) {
- db.execSQL("CREATE TABLE users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, username TEXT, password TEXT);");
- db.execSQL("CREATE TABLE mails (id INTEGER PRIMARY KEY AUTOINCREMENT, pid INTEGER DEFAULT '0', from_id INTEGER, to_id INTEGER, subject TEXT, body TEXT, datetime TEXT, read INTEGER);");
- db.execSQL("CREATE TABLE drafts (id INTEGER PRIMARY KEY AUTOINCREMENT, from_id INTEGER, to_id INTEGER, subject TEXT, body TEXT, datetime TEXT);");
- db.execSQL("CREATE TABLE sent (id INTEGER PRIMARY KEY AUTOINCREMENT, from_id INTEGER, to_id INTEGER, subject TEXT, body TEXT, datetime TEXT);");
- }
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement