From 5c0314a75d2722bb99918ef44473f4204462835a Mon Sep 17 00:00:00 2001
From: cflip <36554078+cflip@users.noreply.github.com>
Date: Wed, 14 Apr 2021 17:23:56 -0600
Subject: Add 'date edited' attribute to posts

---
 setup.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'setup.sql')

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)
-- 
cgit v1.2.3

