package ro.ieval.unical;
-import java.sql.SQLClientInfoException;
-
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
-import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
public static final String Name="Events";
public static final String ID = "_id";
- public static final String name = "Name";
+ public static final String title = "Title";
public static final String description = "Description";
public static final String date = "Date";
- public static final String time = "Time";
+ public static final String duration = "Duration";
public static final String repeat = "repeat";
public static final String repeatIn = "repeatInterval";
public static final String location = "Location";
private static final int dbversion=1;
private static final String Database_create = "create table " + Name + "(" +
- ID + " integer primary key autoincrement, " +
- name + " text not null, " +
+ //ID + " integer primary key autoincrement, " +
+ ID + " text primary key, " +
+ title + " text not null, " +
description + " text, " +
date + " integer, " +
- time + " integer, " +
+ duration + " integer, " +
repeat + " integer, "+
repeatIn + " integer, " +
location + " text);"
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
Log.w(MySQLiteHelper.class.getName(),
- "Upgrading database from version " + oldVersion + " to "
- + newVersion + ", which will destroy all old data");
- db.execSQL("DROP TABLE IF EXISTS " + Name);
- onCreate(db);
+ "Upgrading database from version " + oldVersion + " to "
+ + newVersion + ", which will destroy all old data");
+ db.execSQL("DROP TABLE IF EXISTS " + Name);
+ onCreate(db);
}
}
\ No newline at end of file