CREATE TABLE gym_chatuser(
id Integer NOT NULL,
uid text ,
name text ,
img text ,
account text ,
pinyin text ,
loginId text,
CONSTRAINT PK_userList PRIMARY KEY (id)
);SQLite中Integer字段才支持自动增加,设置为主键可自增
原文:http://blog.csdn.net/icqapp/article/details/39548397