X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F071-apprentice.sql;fp=sql%2Fsql.d%2F071-apprentice.sql;h=c3a0193bfcbe4b609a1a1cd7e7d7ce5f979d94f8;hb=66f94441ec85a5555c7280aff03ba7e5d661c364;hp=0000000000000000000000000000000000000000;hpb=634d45b289a7c58aff3a0a4d3a16907a22216d20;p=brisk.git

diff --git a/sql/sql.d/071-apprentice.sql b/sql/sql.d/071-apprentice.sql
new file mode 100644
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
+       );