android sqlite 自增数据类型

demo:

CREATE TABLE [push_widget] (
  [_id] INTEGER PRIMARY KEY AUTOINCREMENT,
  [push_id] VARCHAR(50) NOT NULL,
  [type] INT(10) NOT NULL DEFAULT (0),
  [url] VARCHAR,
  [pic_url] VARCHAR,
  [short] VARCHAR,
  [author] CHAR,
  [push_type] INT NOT NULL DEFAULT (0),
  [time] TIMESTAMP,
  [score] FLOAT DEFAULT (0));

posted @ 2011-07-26 14:57  健康小树  阅读(1608)  评论(0)    收藏  举报