X-Git-Url: https://defaria.com/gitweb/?a=blobdiff_plain;f=maps%2Fbin%2FMAPSDB.sql;h=1af464b29a0904018e706c2e845298f6a4288338;hb=ae9e57b169de143d2b8a7c761c3bf7394385e0d0;hp=dfe0a4ff8d7fd037264aac4c4236d23b22799a45;hpb=48784bba5d049ef84fa03f63ed581508d6c5cbf0;p=clearscm.git

diff --git a/maps/bin/MAPSDB.sql b/maps/bin/MAPSDB.sql
index dfe0a4f..1af464b 100644
--- a/maps/bin/MAPSDB.sql
+++ b/maps/bin/MAPSDB.sql
@@ -50,7 +50,7 @@ create table email (
   key sender_index (sender)
 ); -- email
 
--- whitelist: Table holds the users' whitelists
+-- list: Table holds the users' various lists
 create table list (
   userid            varchar (128)                   not null,
   type              enum ("white", "black", "null") not null,
@@ -60,6 +60,18 @@ create table list (
   sequence          smallint,
   hit_count         integer,
   last_hit          datetime,
+
+-- Retention: This field indicates how much time must pass before an inactive
+--            list entry should be scrubbed. Null indicates retain forever.
+--            other values include "x day(s)", "x month(s)", "x year(s)". So,
+--            for example, a user on the white list may have its retention set
+--            to say 1 year and when mapsscrub runs, if last_hit is older than
+--            a year the whitelist entry would be removed. If, however, 
+--            retention is null then the record is kept forever. This is useful
+--            for the null and black lists where one might want to insure that
+--            a particular domain (e.g. @talentburst.com) will never come off
+--            of the nulllist.
+--  retention         varchar (40),
   key user_index    (userid),
   key user_listtype (userid, type),
   unique            (userid, type, sequence),
@@ -88,9 +100,6 @@ create table log (
 ); -- log
 
 -- Create users
-grant all privileges 
-  on MAPS.* to mapsadmin@"localhost"  identified by "mapsadmin";
-grant select
-  on MAPS.* to mapsreader@"localhost" identified by "reader";
-grant insert, select, update, delete
-  on MAPS.* to mapswriter@"localhost" identified by "writer";
+-- New 8.0 syntax...
+--create user 'maps'@'localhost' identified by 'spam';
+grant all privileges on MAPS.* to 'maps'@'localhost';