N5qRJYjM

1public void onCreate(SQLiteDatabase db) {
2        // TODO Auto-generated method stub      
3
4        String sqlDataStore = "create table if not exists " +
5        TABLE_NAME_CREDENTIALS + " ("+ BaseColumns._ID + " integer primary key " + " ON CONFLICT FAIL ,"
6
7                    + COLUMN_NAME_USERNAME + " TEXT NOT NULL " + " UNIQUE,"
8                    + COLUMN_NAME_PASSWORD + " TEXT NOT NULL " + " UNIQUE);";
9
10        db.execSQL(CREATE TRIGGER  " row_limiter " +  " BEFORE INSERT "
11               + " ON "
12               + " TABLE_NAME_CREDENTIALS " 
13               + " FOR EACH ROW WHEN " 
14               + ( SELECT  + "_id" + FROM + " TABLE_NAME_CREDENTIALS ") > "1"
15               +    BEGIN
16                    DELETE  FROM + "TABLE_NAME_CREDENTIALS"  +  WHERE  + "_id " > "1";
17                     END
18
19
20
21        db.execSQL(sqlDataStore);
22    }
23	
24String sqlDataStore = "create table if not exists " +
25                    TABLE_NAME_CREDENTIALS + " ("+ BaseColumns._ID + " NOT NULL,"
26
27                                + COLUMN_NAME_USERNAME + " TEXT NOT NULL, "
28                                + COLUMN_NAME_PASSWORD + " TEXT NOT NULL, "
29                                + " PRIMARY KEY (username, passcode))";
30	
31contentValues.put(LoginDB.COLUMN_NAME_USERNAME, rUsername);
32contentValues.put(LoginDB.COLUMN_NAME_PASSWORD, rPasscode);
33	
34CREATE TABLE `limited_table` (
35  `id` int(11) NOT NULL,
36  `value` text ,
37  PRIMARY KEY (`id`)
38)
39	
40ContentValues args = new ContentValues();
41args.put(KEY_ID, LIMITED_ID_CONST);
42args.put(KEY_VALUE, value );
43//Replace
44db.replace(DATABASE_TABLE, null, args);