X-Git-Url: https://defaria.com/gitweb/?a=blobdiff_plain;f=maps%2Fbin%2FMAPSDB.sql;h=1d258108d0d674cbf5d069fcce8f6188fdf60807;hb=2b6de455b7bdd4f817f9fc850d900401eab29e57;hp=0a2a3fcec4a90b9e0b0e02ab020d59c1ef2b140c;hpb=020a4a5ea2be725b155cae3a2cadc9aba3911b9b;p=clearscm.git

diff --git a/maps/bin/MAPSDB.sql b/maps/bin/MAPSDB.sql
index 0a2a3fc..1d25810 100644
--- a/maps/bin/MAPSDB.sql
+++ b/maps/bin/MAPSDB.sql
@@ -1,12 +1,12 @@
 -------------------------------------------------------------------------------
 --
--- File:	$RCSFile$
--- Revision:	$Revision: 1.1 $
--- Description:	This file creates the MAPS database.
--- Author:	Andrew@DeFaria.com
--- Created:	Tue May 13 13:28:18 PDT 2003
--- Modified:	$Date: 2013/06/12 14:05:47 $
--- Language:	SQL
+-- File:        $RCSFile$
+-- Revision:    $Revision: 1.1 $
+-- Description: This file creates the MAPS database.
+-- Author:      Andrew@DeFaria.com
+-- Created:     Tue May 13 13:28:18 PDT 2003
+-- Modified:    $Date: 2013/06/12 14:05:47 $
+-- Language:    SQL
 --
 -- Copyright (c) 2000-2006, Andrew@DeFaria.com, all rights reserved
 --
@@ -22,56 +22,56 @@ use MAPS;
 
 -- user: Valid users and their passwords are contained here
 create table user (
-  userid			varchar (128)	not null,
-  name				tinytext	not null,
-  email				varchar (128)	not null,
-  password			tinytext	not null,
+  userid      varchar (128) not null,
+  name        tinytext      not null,
+  email       varchar (128) not null,
+  password    tinytext      not null,
   primary key (userid)
-) type=innodb; -- user
+); -- user
 
 -- useropts: User's options are stored here
 create table useropts (
-  userid			varchar (128)	not null,
-  name				tinytext,
-  value				varchar (128),
+  userid         varchar (128) not null,
+  name           tinytext,
+  value          varchar (128),
   key user_index (userid),
   foreign key (userid) references user (userid) on delete cascade
-) type=innodb; -- useropts
+); -- useropts
 
 -- email: Table that holds the email
 create table email (
-  userid			varchar (128)	not null,
-  sender			varchar (128)	not null,
-  subject			varchar (255),
-  timestamp			datetime,
-  data				longblob,
-  key user_index (userid),
-  foreign key (userid) references user (userid) on delete cascade,
+  userid           varchar (128) not null,
+  sender           varchar (128) not null,
+  subject          varchar (255),
+  timestamp        datetime,
+  data             longblob,
+  key user_index   (userid),
+  foreign key      (userid) references user (userid) on delete cascade,
   key sender_index (sender)
-) type=innodb; -- email
+); -- email
 
 -- whitelist: Table holds the users' whitelists
 create table list (
-  userid			varchar (128)	not null,
-  type				enum ("white", "black", "null") not null,
-  pattern			varchar (128),
-  domain			varchar (128),
-  comment			varchar (128),
-  sequence			smallint,
-  hit_count			integer,
-  last_hit			datetime,
-  key user_index (userid),
+  userid            varchar (128)                   not null,
+  type              enum ("white", "black", "null") not null,
+  pattern           varchar (128),
+  domain            varchar (128),
+  comment           varchar (128),
+  sequence          smallint,
+  hit_count         integer,
+  last_hit          datetime,
+  key user_index    (userid),
   key user_listtype (userid, type),
-  unique (userid, type, sequence),
-  foreign key (userid) references user (userid) on delete cascade
-) type=innodb; -- list
+  unique            (userid, type, sequence),
+  foreign key       (userid) references user (userid) on delete cascade
+); -- list
 
 -- log: Table to hold log information
 create table log (
-  userid			varchar (128)	not null,
-  timestamp			datetime,
-  sender			varchar (128),
-  type				enum (
+  userid    varchar (128) not null,
+  timestamp datetime,
+  sender    varchar (128),
+  type      enum (
     "blacklist",
     "debug",
     "error",
@@ -82,15 +82,11 @@ create table log (
     "returned",
     "whitelist"
   ) not null,
-  message			varchar (255)	not null,
+  message        varchar (255) not null,
   key user_index (userid),
-  foreign key (userid) references user (userid) on delete cascade
-) type=innodb; -- log
+  foreign key     (userid) references user (userid) on delete cascade
+); -- log
 
 -- Create users
---grant all privileges 
---  on MAPS.* to mapsadmin@"%"  identified by "mapsadmin";
---grant select
---  on MAPS.* to mapsreader@"%" identified by "reader";
---grant insert, select, update, delete
---  on MAPS.* to mapswriter@"%" identified by "writer";
+grant all privileges 
+  on MAPS.* to maps@"localhost"  identified by "spam";