db.execSQL("CREATE TABLE " + DATABASE_TABLE + " (" + KEY_ROWID
    + " INTEGER PRIMARY KEY AUTOINCREMENT, " + KEY_NAME
    + " TEXT NOT NULL, " + KEY_WORKED + " INTEGER, "
    + KEY_NOTE + " INTEGER);");

db.execSQL("CREATE TABLE " + DATABASE_TABLE + " ("
    + KEY_ROWID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
    + KEY_NAME + " TEXT NOT NULL, "
    + KEY_WORKED + " INTEGER, "
    + KEY_NOTE + " INTEGER DEFAULT 0);");

CREATE TABLE <TableName>(
...
<ColumnName> <Type> DEFAULT <DefaultValue>
...
)

Count INTEGER DEFAULT 0,
LastSeen TEXT DEFAULT (datetime('now'))

CREATE TABLE <MY_TABLE> (
<MY_TABLE_KEY>       INTEGER    UNIQUE
                                PRIMARY KEY,
<MY_TABLE_SERIAL>    TEXT       DEFAULT (<MY_VALUE>)
                                NOT NULL
<THE_REST_COLUMNS>
);