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
);
posted @ 2021-12-08 20:27  wtlafoxmail  阅读(82)  评论(0)    收藏  举报