apprentice workflow completed

[brisk.git] / sql / sql.d / 071-apprentice.sql

diff --git a/sql/sql.d/071-apprentice.sql b/sql/sql.d/071-apprentice.sql
new file mode 100644 (file)
index 0000000..c3a0193
--- /dev/null
+++ b/sql/sql.d/071-apprentice.sql
@@ -0,0 +1,8 @@
+--
+--  Table to manage mails sent to users
+--
+DROP TABLE #PFX#selfreg_chk;
+CREATE TABLE #PFX#selfreg_chk (
+       ip         integer,                           -- ip v4 address
+       atime      timestamp DEFAULT to_timestamp(0)  -- access time
+       );