(php) sentinel - sqlite version schema

sentinel-sqlite.sql

# @see https://github.com/cartalyst/sentinel/blob/2.0/schema/mysql.sql
# Dump of table activations
# ------------------------------------------------------------

CREATE TABLE activations (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  user_id INTEGER NOT NULL,
  code TEXT NOT NULL,
  completed INTEGER DEFAULT '0',
  completed_at TEXT NULL DEFAULT NULL,
  created_at TEXT NOT NULL DEFAULT '0000-00-00 00:00:00',
  updated_at TEXT NOT NULL DEFAULT '0000-00-00 00:00:00'
);

# Dump of table persistences
# ------------------------------------------------------------

CREATE TABLE persistences (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  user_id INTEGER NOT NULL,
  code TEXT NOT NULL,
  created_at TEXT NOT NULL DEFAULT '0000-00-00 00:00:00',
  updated_at TEXT NOT NULL DEFAULT '0000-00-00 00:00:00'
);
CREATE UNIQUE INDEX IF NOT EXISTS persistences_code_unique ON persistences (code);

# Dump of table reminders
# ------------------------------------------------------------

CREATE TABLE reminders (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  user_id INTEGER NOT NULL,
  code TEXT NOT NULL,
  completed INTEGER DEFAULT '0',
  completed_at TEXT NULL DEFAULT NULL,
  created_at TEXT NOT NULL DEFAULT '0000-00-00 00:00:00',
  updated_at TEXT NOT NULL DEFAULT '0000-00-00 00:00:00'
);

# Dump of table roles
# ------------------------------------------------------------

CREATE TABLE roles (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  slug TEXT NOT NULL,
  name TEXT NOT NULL,
  permissions TEXT,
  created_at TEXT NOT NULL DEFAULT '0000-00-00 00:00:00',
  updated_at TEXT NOT NULL DEFAULT '0000-00-00 00:00:00'
);
CREATE UNIQUE INDEX IF NOT EXISTS roles_slug_unique ON roles (slug);

# Dump of table role_users
# ------------------------------------------------------------

CREATE TABLE role_users (
  user_id INTEGER NOT NULL,
  role_id INTEGER NOT NULL,
  created_at TEXT NULL DEFAULT NULL,
  updated_at TEXT NULL DEFAULT NULL,
  PRIMARY KEY (user_id,role_id)
);

# Dump of table throttle
# ------------------------------------------------------------

CREATE TABLE throttle (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  user_id INTEGER DEFAULT NULL,
  type TEXT NOT NULL,
  ip TEXT DEFAULT NULL,
  created_at TEXT NOT NULL DEFAULT '0000-00-00 00:00:00',
  updated_at TEXT NOT NULL DEFAULT '0000-00-00 00:00:00'
);
CREATE INDEX throttle_user_id_index ON throttle (user_id);

# Dump of table users
# ------------------------------------------------------------

CREATE TABLE users (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  email TEXT NOT NULL,
  password TEXT NOT NULL,
  permissions TEXT,
  last_login TEXT NULL DEFAULT NULL,
  first_name varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  last_name varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  created_at TEXT NOT NULL DEFAULT '0000-00-00 00:00:00',
  updated_at TEXT NOT NULL DEFAULT '0000-00-00 00:00:00'
);
CREATE UNIQUE INDEX IF NOT EXISTS users_email_unique ON users (email);

http://www.hakopako.net/entry/2017/09/18/180643