Android Open Source - hpush Messages Tbl

• Back to News/client  ↑

From Project

Back to project page hpush.

License

The source code is released under:

MIT License

Java Source Code

package com.hpush.db;
/*w  ww. jav a  2 s  .  c om*/
/**
 * Messages table.
 *
 * @author Xinyue Zhao
 */
public interface MessagesTbl {
  static final String DB_ID = "_db_id";
  static final String BY = "_by";
  static final String ID = "_id";
  public static final String SCORE = "_score";
  public static final String COMMENTS_COUNT  = "_comments_count";
  static final String TEXT = "_text";
  public static final String TIME = "_time";
  static final String TITLE = "_title";
  static final String URL = "_url";
  public static final String PUSHED_TIME = "_pushed_time";
  static final String TABLE_NAME = "messages";



  //We use rowId as key for each row.
  //See. http://www.sqlite.org/autoinc.html
  /**
   * Init new table since {@link com.hpush.db.DatabaseHelper#DATABASE_VERSION} = {@code 1}.
   */
  static final String SQL_CREATE = "CREATE TABLE " + TABLE_NAME + " (" +
      DB_ID + " INTEGER PRIMARY KEY, " +
      BY + " TEXT  DEFAULT \"\", " +
      ID + " INTEGER  DEFAULT -1, " +
      SCORE + " INTEGER  DEFAULT -1, " +
      COMMENTS_COUNT + " INTEGER  DEFAULT -1, " +
      TEXT + " TEXT  DEFAULT \"\", " +
      TIME + " INTEGER   DEFAULT -1, " +
      TITLE + " TEXT  DEFAULT \"\", " +
      MessagesTbl.URL + " TEXT  DEFAULT \"\", " +
      PUSHED_TIME + " INTEGER   DEFAULT -1" +
      ");";
}

Java Source Code List

• Back to News/client  ↑