1

Tables (4)

accountlikes

  • post_id — int(10) — Foreign key → posts.id — NOT NULL
  • name — varchar(20) — Foreign key → accounts.name — NOT NULL
  • name (name2) — varchar(20) — Foreign key → posts.name — NOT NULL

accounts

  • name — varchar(20) — Primary key — NOT NULL
  • password — varchar(128) — NOT NULL
  • isAdmin — tinyint(4) — NOT NULL
  • isIgnore — tinyint(4) — NOT NULL

comments

  • id — int(10) — Primary key — NOT NULL
  • name — varchar(20) — Foreign key → accounts.name — NOT NULL
  • id (id2) — int(10) — Foreign key → posts.id — NOT NULL
  • name (name2) — varchar(20) — Foreign key → posts.name — NOT NULL
  • post_id — int(10) — NOT NULL
  • author — varchar(20) — NOT NULL
  • content — varchar(50) — NOT NULL
  • wtime — datetime — NOT NULL

posts

  • id — int(10) — Primary key — NOT NULL
  • name — varchar(20) — Foreign key → accounts.name — NOT NULL
  • author — varchar(20) — NOT NULL
  • title — varchar(20) — NOT NULL
  • content — text — NOT NULL
  • wtime — datetime — NOT NULL
  • isNotice — tinyint(4) — NOT NULL
  • isAdminAuthor — tinyint(4) — NOT NULL