From 878327ccd0de1794ca5d19f82ef53687b7e19160 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Sat, 5 Oct 2024 09:24:51 +0300
Subject: db: Add `created_at` field to `emails` table

---
 src/main/resources/schema-sqlserver.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'src/main/resources/schema-sqlserver.sql')

diff --git a/src/main/resources/schema-sqlserver.sql b/src/main/resources/schema-sqlserver.sql
index 947e5403..9ff21ed2 100644
--- a/src/main/resources/schema-sqlserver.sql
+++ b/src/main/resources/schema-sqlserver.sql
@@ -56,6 +56,7 @@ CREATE TABLE emails (
     user_id bigint NOT NULL,
     email character varying(128) NOT NULL,
     subscr_hour smallint,
+    created_at datetimeoffset DEFAULT CURRENT_TIMESTAMP NOT NULL,
     FOREIGN KEY (user_id) REFERENCES users(id)
 );
 CREATE TABLE facebook (
-- 
cgit v1.2.3

