aboutsummaryrefslogtreecommitdiff
path: root/database/contactform.sql
diff options
context:
space:
mode:
authorThedro Neely <thedroneely@gmail.com>2022-11-16 03:46:30 -0500
committerThedro Neely <thedroneely@gmail.com>2022-11-16 07:03:30 -0500
commita2f16246ec362f8a00ad4eedf2f7aea565e6d488 (patch)
tree25ba5fdc4bb291efe95022b8ac579d9b94d0a067 /database/contactform.sql
parentb2c05f03749d8e69f5909737b18425772bcb784b (diff)
downloadedwinmattiacci.com-a2f16246ec362f8a00ad4eedf2f7aea565e6d488.tar.gz
edwinmattiacci.com-a2f16246ec362f8a00ad4eedf2f7aea565e6d488.tar.bz2
edwinmattiacci.com-a2f16246ec362f8a00ad4eedf2f7aea565e6d488.zip
Makefile: Add deployment logic
Diffstat (limited to 'database/contactform.sql')
-rw-r--r--database/contactform.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/database/contactform.sql b/database/contactform.sql
new file mode 100644
index 0000000..196cd9b
--- /dev/null
+++ b/database/contactform.sql
@@ -0,0 +1,7 @@
+CREATE TABLE IF NOT EXISTS contactform (
+ id INTEGER PRIMARY KEY AUTOINCREMENT,
+ name TEXT,
+ email TEXT NOT NULL,
+ message TEXT NOT NULL,
+ date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
+);