summaryrefslogtreecommitdiff
path: root/setup.sql
diff options
context:
space:
mode:
authorcflip <36554078+cflip@users.noreply.github.com>2021-04-14 17:23:56 -0600
committercflip <36554078+cflip@users.noreply.github.com>2021-04-14 17:23:56 -0600
commit5c0314a75d2722bb99918ef44473f4204462835a (patch)
tree7f930fd12305baad4e8944ed95f0136e749d3741 /setup.sql
parent424622fbdbe7065cb5b93b39d6cfc5ba0a31775e (diff)
Add 'date edited' attribute to posts
Diffstat (limited to 'setup.sql')
-rw-r--r--setup.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/setup.sql b/setup.sql
index b362798..6a96b8a 100644
--- a/setup.sql
+++ b/setup.sql
@@ -31,7 +31,8 @@ CREATE TABLE threads (
CREATE TABLE posts (
post_id INT(8) NOT NULL AUTO_INCREMENT,
post_content TEXT NOT NULL,
- post_date DATETIME NOT NULL,
+ post_date_created DATETIME NOT NULL,
+ post_date_edited DATETIME,
post_thread INT(8) NOT NULL,
post_author INT(8) NOT NULL,
PRIMARY KEY (post_id)