[Idrs-commit] CVS: Idrs/sql_scripts mysql_auth.sql,NONE,1.1 mysql_docs.sql,NONE,1.1

[Marc B. <big...@us...>]

Update of /cvsroot/idrs/Idrs/sql_scripts
In directory usw-pr-cvs1:/tmp/cvs-serv8412/sql_scripts

Added Files:
	mysql_auth.sql mysql_docs.sql 
Log Message:
Synched Development

--- NEW FILE: mysql_auth.sql ---

CREATE TABLE `tblUser` (
  `UserID` int(11) NOT NULL default '0',
  `Username` varchar(100) default NULL,
  `Password` varchar(100) default NULL,
  `GroupID` varchar(50) default NULL,
  PRIMARY KEY  (`UserID`)
) ;

CREATE TABLE `tblGroups` (
 `GroupID` int(11) NOT NULL auto_increment,
 `GroupName` varchar(20) default NULL,
  PRIMARY KEY  (`GroupID`)
);


--- NEW FILE: mysql_docs.sql ---
CREATE TABLE `tblDoc` (
  `DocID` int(11) NOT NULL auto_increment,
  `DocName` varchar(20) default NULL,
  `DocSrc` blob,
  `DocGroups` varchar(50) default NULL,
  `DocParams` text,
  `DocConns` varchar(70) default NULL,
  `DocMin` int(11) default NULL,
  `DocMax` int(11) default NULL,
  PRIMARY KEY  (`DocID`)
);