[Helpmeict-cvs] Helpdesk/install DB-MySQL.sql, 1.3, 1.4 DB-PostgreSQL.sql, 1.2, 1.3

[Scott P. <wht...@us...>]

Update of /cvsroot/helpmeict/Helpdesk/install
In directory sc8-pr-cvs17:/tmp/cvs-serv4819/install

Modified Files:
	DB-MySQL.sql DB-PostgreSQL.sql 
Log Message:
LDAP authentication frontend/schema changes.


Index: DB-PostgreSQL.sql
===================================================================
RCS file: /cvsroot/helpmeict/Helpdesk/install/DB-PostgreSQL.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** DB-PostgreSQL.sql	7 Feb 2007 01:20:05 -0000	1.2
--- DB-PostgreSQL.sql	15 Sep 2007 08:41:32 -0000	1.3
***************
*** 710,714 ****
      active smallint DEFAULT (1)::smallint NOT NULL,
      root smallint DEFAULT (0)::smallint NOT NULL,
!     restricted smallint DEFAULT (0)::smallint NOT NULL
  );
  
--- 710,715 ----
      active smallint DEFAULT (1)::smallint NOT NULL,
      root smallint DEFAULT (0)::smallint NOT NULL,
!     restricted smallint DEFAULT (0)::smallint NOT NULL,
!     ldap smallint DEFAULT (0)::smallint NOT NULL
  );
  
***************
*** 891,894 ****
--- 892,899 ----
  INSERT INTO tbl_default_preferences VALUES ('newissue-email', '');
  INSERT INTO tbl_default_preferences VALUES ('wrk-timer', 'true');
+ INSERT INTO tbl_default_preferences VALUES ('ldap-ause', 'false');
+ INSERT INTO tbl_default_preferences VALUES ('ldap-basedn', '');
+ INSERT INTO tbl_default_preferences VALUES ('ldap-host', '');
+ INSERT INTO tbl_default_preferences VALUES ('ldap-v2', 'false');
  
  
***************
*** 1022,1025 ****
--- 1027,1034 ----
  INSERT INTO tbl_preference_descriptions VALUES ('newissue-email', 'text', 'Email address to receive new unassigned issues (or leave blank)', 0);
  INSERT INTO tbl_preference_descriptions VALUES ('wrk-timer', 'boolean', 'Turn on usage of Timer', 0);
+ INSERT INTO tbl_preference_descriptions VALUES ('ldap-ause', 'boolean', 'Use LDAP Authentication', 0);
+ INSERT INTO tbl_preference_descriptions VALUES ('ldap-basedn', 'text', 'LDAP BaseDN', 0);
+ INSERT INTO tbl_preference_descriptions VALUES ('ldap-host', 'text', 'LDAP Hostname', 0);
+ INSERT INTO tbl_preference_descriptions VALUES ('ldap-v2', 'boolean', 'Use LDAP Protocol Version 2', 0);
  
  

Index: DB-MySQL.sql
===================================================================
RCS file: /cvsroot/helpmeict/Helpdesk/install/DB-MySQL.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** DB-MySQL.sql	15 Sep 2007 03:50:31 -0000	1.3
--- DB-MySQL.sql	15 Sep 2007 08:41:32 -0000	1.4
***************
*** 34,38 ****
  ('email-resolve', 'false'),
  ('newissue-email', ''),
! ('wrk-timer', 'true');
  
  -- --------------------------------------------------------
--- 34,43 ----
  ('email-resolve', 'false'),
  ('newissue-email', ''),
! ('wrk-timer', 'true'),
! ('ldap-ause', 'false'),
! ('ldap-basedn', ''),
! ('ldap-host', ''),
! ('ldap-v2', 'false');
! 
  
  -- --------------------------------------------------------
***************
*** 285,289 ****
  ('email-resolve', 'boolean', 'Email notification of issue resolutions.', 1),
  ('newissue-email', 'text', 'Email address to receive new unassigned issues (or leave blank)', 0),
! ('wrk-timer', 'boolean', 'Turn on usage of Timer', 0);
  
  -- --------------------------------------------------------
--- 290,299 ----
  ('email-resolve', 'boolean', 'Email notification of issue resolutions.', 1),
  ('newissue-email', 'text', 'Email address to receive new unassigned issues (or leave blank)', 0),
! ('wrk-timer', 'boolean', 'Turn on usage of Timer', 0),
! ('ldap-ause', 'boolean', 'Use LDAP Authentication', 0),
! ('ldap-basedn', 'text', 'LDAP BaseDN', 0),
! ('ldap-host', 'text', 'LDAP Hostname', 0),
! ('ldap-v2', 'boolean', 'Use LDAP Protocol Version 2', 0);
! 
  
  -- --------------------------------------------------------
***************
*** 604,607 ****
--- 614,618 ----
    `root` int(2) NOT NULL default '0',
    `restricted` int(2) NOT NULL default '0',
+   `ldap` int(2) NOT NULL default '0',
    PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;