sqlite创建表模板


DROP TABLE IF EXISTS "login";
CREATE TABLE "login" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT,
  "token" text(255),
  "create_time" TimeStamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
  "update_time"  TimeStamp,
  "username" text(50),
  "password" text(50),
  "valid" INTEGER
);

相关