[geeklog-cvs] geeklog-2/lib/A_and_A/server/sql mysql.sql,NONE,1.1

[geeklog-cvs-admin at lists.geeklog.net]

Update of /usr/cvs/geeklog/geeklog-2/lib/A_and_A/server/sql
In directory internal.geeklog.net:/tmp/cvs-serv29048/sql

Added Files:
	mysql.sql 
Log Message:
These directories/files have been moved here from the gl2 public_html directory in order to make it obvious where the A&A framework is so that individual classes can find other required classes for inclusion.  I've moved index.php to sample.index.php because that page will need to be moved to the gl2 webtree and not access from this directory.


--- NEW FILE: mysql.sql ---
-- MySQL dump 8.22
--
-- Host: localhost    Database: geeklog2
---------------------------------------------------------
-- Server version	3.23.53-max-nt

--
-- Table structure for table 'app_privileges'
--

CREATE TABLE app_privileges (
  app_id varchar(30) NOT NULL default '',
  privilege_cd varchar(20) NOT NULL default '',
  privilege_desc varchar(128) NOT NULL default '',
  PRIMARY KEY  (app_id,privilege_cd)
) TYPE=MyISAM;

--
-- Dumping data for table 'app_privileges'
--


INSERT INTO app_privileges VALUES ('A_AND_A','AA_ADMIN_PRIV','A&A Administrator');

--
-- Table structure for table 'application'
--

CREATE TABLE application (
  app_id varchar(30) NOT NULL default '',
  app_name varchar(50) NOT NULL default '',
  app_contact_email varchar(50) default NULL,
  PRIMARY KEY  (app_id,app_name)
) TYPE=MyISAM;

--
-- Dumping data for table 'application'
--


INSERT INTO application VALUES ('A_AND_A','Enterprise Authentication and Authorization Servic','tony at geeklog.net');

--
-- Table structure for table 'group_assignment'
--

CREATE TABLE group_assignment (
  main_group_id mediumint(10) NOT NULL default '0',
  assigned_user_id mediumint(10) default NULL,
  assigned_group_id mediumint(10) default NULL,
  privilege_cache varchar(255) default NULL,
  KEY assigned_group_id (assigned_group_id),
  KEY main_group_id (main_group_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'group_assignment'
--


INSERT INTO group_assignment VALUES (1,1,NULL,NULL);

--
-- Table structure for table 'groups'
--

CREATE TABLE groups (
  group_id mediumint(10) NOT NULL auto_increment,
  app_id varchar(30) NOT NULL default '',
  group_logical_name varchar(50) NOT NULL default '',
  group_display_name varchar(50) NOT NULL default '',
  group_descr varchar(255) NOT NULL default '',
  creation_date int(10) unsigned NOT NULL default '0',
  change_date int(10) unsigned default NULL,
  change_user_id mediumint(10) default NULL,
  PRIMARY KEY  (group_id),
  KEY app_id (app_id),
  KEY group_logical_name (group_logical_name)
) TYPE=MyISAM;

--
-- Dumping data for table 'groups'
--


INSERT INTO groups VALUES (1,'A_AND_A','AA_ADMIN','Enterprise A&A Administrator','This user can modify anything within the A&A application',1037738177,NULL,NULL);

--
-- Table structure for table 'privilege_access'
--

CREATE TABLE privilege_access (
  privilege_cd varchar(20) NOT NULL default '',
  app_id varchar(30) NOT NULL default '',
  user_id mediumint(10) default NULL,
  group_id mediumint(10) default NULL,
  KEY app_id (app_id,user_id,group_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'privilege_access'
--


INSERT INTO privilege_access VALUES ('AA_ADMIN_PRIV','A_AND_A',NULL,1);

--
-- Table structure for table 'user'
--

CREATE TABLE user (
  user_id mediumint(10) NOT NULL auto_increment,
  username varchar(75) NOT NULL default '',
  password varchar(20) NOT NULL default '',
  employee_id varchar(20) NOT NULL default '',
  account_locked tinyint(1) NOT NULL default '0',
  failed_attempts tinyint(1) unsigned NOT NULL default '0',
  pwd_last_set int(10) unsigned NOT NULL default '0',
  creation_date int(10) unsigned NOT NULL default '0',
  change_date int(10) unsigned NOT NULL default '0',
  change_user_id mediumint(10) default NULL,
  PRIMARY KEY  (user_id),
  KEY username (username)
) TYPE=MyISAM;

--
-- Dumping data for table 'user'
--


INSERT INTO user VALUES (1,'ROOT at LOCALHOST','foo','1',0,0,1038344984,1037738177,1037738177,NULL);
INSERT INTO user VALUES (2,'WEBMASTER at LOCALHOST','1038344984','2',0,0,1038344985,1037738177,1037738177,NULL);

--
-- Table structure for table 'user_passwords'
--

CREATE TABLE user_passwords (
  user_id varchar(75) NOT NULL default '',
  password varchar(20) NOT NULL default '',
  insert_date varchar(20) NOT NULL default '',
  PRIMARY KEY  (user_id,password,insert_date)
) TYPE=MyISAM;

--
-- Dumping data for table 'user_passwords'
--