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

[tony at geeklog.net]

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

Added Files:
	mysql.sql 
Log Message:
Initial load into Geeklog


--- 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'
--