loginPost
Tables (4)
accountlikes
- post_id — int(10) — Foreign key → posts.id — NOT NULL
- name — varchar(20) — Foreign key → accounts.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
- post_id — int(10) — Foreign key → posts.id — NOT NULL
- author — varchar(20) — Foreign key → accounts.name — NOT NULL
- content — varchar(50) — NOT NULL
- wtime — datetime — NOT NULL
posts
- id — int(10) — Primary key — NOT NULL
- author — varchar(20) — Foreign key → accounts.name — 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