[Helpmeict-cvs] Helpdesk/install DB-MySQL.sql,1.7,1.8

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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

Modified Files:
	DB-MySQL.sql 
Log Message:
Fix MySQL script missing auto_increments


Index: DB-MySQL.sql
===================================================================
RCS file: /cvsroot/helpmeict/Helpdesk/install/DB-MySQL.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** DB-MySQL.sql	30 Sep 2007 21:24:40 -0000	1.7
--- DB-MySQL.sql	1 Oct 2007 03:34:51 -0000	1.8
***************
*** 12,16 ****
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
! /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
  
  
--- 12,16 ----
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
! /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  
  
***************
*** 29,33 ****
    `value` varchar(100) NOT NULL default '',
    PRIMARY KEY  (`identifier`)
! ) TYPE=MyISAM;
  
  --
--- 29,33 ----
    `value` varchar(100) NOT NULL default '',
    PRIMARY KEY  (`identifier`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 60,64 ****
    `value` varchar(100) NOT NULL default '',
    PRIMARY KEY  (`identifier`,`domain`)
! ) TYPE=MyISAM;
  
  --
--- 60,64 ----
    `value` varchar(100) NOT NULL default '',
    PRIMARY KEY  (`identifier`,`domain`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 77,81 ****
  --
  CREATE TABLE `tbl_Domains` (
!   `id` int(4) unsigned NOT NULL,
    `domain` varchar(200) NOT NULL default '',
    `active` int(4) NOT NULL default '1',
--- 77,81 ----
  --
  CREATE TABLE `tbl_Domains` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `domain` varchar(200) NOT NULL default '',
    `active` int(4) NOT NULL default '1',
***************
*** 85,89 ****
    `defaultpriority` int(4) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 85,89 ----
    `defaultpriority` int(4) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 107,111 ****
    `date` int(11) NOT NULL default '0',
    PRIMARY KEY  (`hash`)
! ) TYPE=MyISAM;
  
  --
--- 107,111 ----
    `date` int(11) NOT NULL default '0',
    PRIMARY KEY  (`hash`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 121,125 ****
  --
  CREATE TABLE `tbl_Issues` (
!   `id` int(4) unsigned NOT NULL,
    `reportedby` int(4) NOT NULL default '0',
    `createdby` int(4) NOT NULL default '0',
--- 121,125 ----
  --
  CREATE TABLE `tbl_Issues` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `reportedby` int(4) NOT NULL default '0',
    `createdby` int(4) NOT NULL default '0',
***************
*** 145,149 ****
    `recalled` int(2) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 145,149 ----
    `recalled` int(2) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 159,163 ****
  --
  CREATE TABLE `tbl_Levels` (
!   `id` int(4) unsigned NOT NULL,
    `level` varchar(100) NOT NULL default '',
    `sortorder` int(4) NOT NULL default '0',
--- 159,163 ----
  --
  CREATE TABLE `tbl_Levels` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `level` varchar(100) NOT NULL default '',
    `sortorder` int(4) NOT NULL default '0',
***************
*** 165,169 ****
    `active` int(4) NOT NULL default '1',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 165,169 ----
    `active` int(4) NOT NULL default '1',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 183,192 ****
  --
  CREATE TABLE `tbl_Link_Categories` (
!   `id` int(4) unsigned NOT NULL,
    `name` varchar(100) NOT NULL default '',
    `sortorder` int(4) NOT NULL default '0',
    `lang` varchar(5) NOT NULL default 'en_UK',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 183,192 ----
  --
  CREATE TABLE `tbl_Link_Categories` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `name` varchar(100) NOT NULL default '',
    `sortorder` int(4) NOT NULL default '0',
    `lang` varchar(5) NOT NULL default 'en_UK',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 205,209 ****
  --
  CREATE TABLE `tbl_Links` (
!   `id` int(4) unsigned NOT NULL,
    `text` varchar(100) NOT NULL default '',
    `link` varchar(200) NOT NULL default '',
--- 205,209 ----
  --
  CREATE TABLE `tbl_Links` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `text` varchar(100) NOT NULL default '',
    `link` varchar(200) NOT NULL default '',
***************
*** 211,215 ****
    `sortorder` int(4) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 211,215 ----
    `sortorder` int(4) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 237,241 ****
  --
  CREATE TABLE `tbl_Logs` (
!   `id` int(4) unsigned NOT NULL,
    `userid` int(4) NOT NULL default '0',
    `domain` int(4) NOT NULL default '0',
--- 237,241 ----
  --
  CREATE TABLE `tbl_Logs` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `userid` int(4) NOT NULL default '0',
    `domain` int(4) NOT NULL default '0',
***************
*** 244,248 ****
    `log` text NOT NULL,
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 244,248 ----
    `log` text NOT NULL,
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 251,256 ****
  
  /*!40000 ALTER TABLE `tbl_Logs` DISABLE KEYS */;
- INSERT INTO `tbl_Logs` (`id`,`userid`,`domain`,`timestamp`,`code`,`log`) VALUES 
-  (1,2,2,1138757551,'LOGIN','Project Admin has successfully logged in.');
  /*!40000 ALTER TABLE `tbl_Logs` ENABLE KEYS */;
  
--- 251,254 ----
***************
*** 260,264 ****
  --
  CREATE TABLE `tbl_News` (
!   `id` int(4) unsigned NOT NULL,
    `date` date NOT NULL default '0000-00-00',
    `content` text NOT NULL,
--- 258,262 ----
  --
  CREATE TABLE `tbl_News` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `date` date NOT NULL default '0000-00-00',
    `content` text NOT NULL,
***************
*** 267,271 ****
    `domain_id` int(4) default NULL,
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 265,269 ----
    `domain_id` int(4) default NULL,
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 292,296 ****
    `overridable` int(2) NOT NULL default '0',
    PRIMARY KEY  (`identifier`)
! ) TYPE=MyISAM;
  
  --
--- 290,294 ----
    `overridable` int(2) NOT NULL default '0',
    PRIMARY KEY  (`identifier`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 319,323 ****
  --
  CREATE TABLE `tbl_Priorities` (
!   `id` int(4) unsigned NOT NULL,
    `priority` varchar(100) NOT NULL default '',
    `class` int(4) NOT NULL default '0',
--- 317,321 ----
  --
  CREATE TABLE `tbl_Priorities` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `priority` varchar(100) NOT NULL default '',
    `class` int(4) NOT NULL default '0',
***************
*** 327,331 ****
    `notify` int(2) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 325,329 ----
    `notify` int(2) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 345,354 ****
  --
  CREATE TABLE `tbl_ProblemCategories` (
!   `id` int(4) unsigned NOT NULL,
    `description` varchar(100) NOT NULL default '',
    `active` int(2) NOT NULL default '1',
    `domain` int(4) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 343,352 ----
  --
  CREATE TABLE `tbl_ProblemCategories` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `description` varchar(100) NOT NULL default '',
    `active` int(2) NOT NULL default '1',
    `domain` int(4) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 368,372 ****
  --
  CREATE TABLE `tbl_ProblemDetails` (
!   `id` int(4) unsigned NOT NULL,
    `category` int(4) NOT NULL default '0',
    `description` varchar(100) NOT NULL default '',
--- 366,370 ----
  --
  CREATE TABLE `tbl_ProblemDetails` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `category` int(4) NOT NULL default '0',
    `description` varchar(100) NOT NULL default '',
***************
*** 374,378 ****
    `domain` int(4) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 372,376 ----
    `domain` int(4) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 399,403 ****
  --
  CREATE TABLE `tbl_Remarks` (
!   `id` int(4) unsigned NOT NULL,
    `issue` int(4) NOT NULL default '0',
    `reportedby` int(4) default '0',
--- 397,401 ----
  --
  CREATE TABLE `tbl_Remarks` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `issue` int(4) NOT NULL default '0',
    `reportedby` int(4) default '0',
***************
*** 407,411 ****
    `time` time default '00:00:00',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 405,409 ----
    `time` time default '00:00:00',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 421,430 ****
  --
  CREATE TABLE `tbl_Sites` (
!   `id` int(4) unsigned NOT NULL,
    `site` varchar(100) NOT NULL default '',
    `domain` int(4) NOT NULL default '0',
    `active` int(4) NOT NULL default '1',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 419,428 ----
  --
  CREATE TABLE `tbl_Sites` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `site` varchar(100) NOT NULL default '',
    `domain` int(4) NOT NULL default '0',
    `active` int(4) NOT NULL default '1',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 442,446 ****
  --
  CREATE TABLE `tbl_Statuses` (
!   `id` int(4) unsigned NOT NULL,
    `status` varchar(100) NOT NULL default '',
    `sortorder` int(4) NOT NULL default '0',
--- 440,444 ----
  --
  CREATE TABLE `tbl_Statuses` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `status` varchar(100) NOT NULL default '',
    `sortorder` int(4) NOT NULL default '0',
***************
*** 448,452 ****
    `active` int(4) NOT NULL default '1',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 446,450 ----
    `active` int(4) NOT NULL default '1',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 466,470 ****
  --
  CREATE TABLE `tbl_System_Preferences` (
!   `id` int(4) unsigned NOT NULL,
    `identifier` varchar(20) NOT NULL default '',
    `value` varchar(100) NOT NULL default '',
--- 464,468 ----
  --
  CREATE TABLE `tbl_System_Preferences` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `identifier` varchar(20) NOT NULL default '',
    `value` varchar(100) NOT NULL default '',
***************
*** 472,476 ****
    `system` int(2) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 470,474 ----
    `system` int(2) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 492,499 ****
  --
  CREATE TABLE `tbl_Thesaurus` (
!   `id` int(4) unsigned NOT NULL,
    `term` varchar(40) NOT NULL default '',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 490,497 ----
  --
  CREATE TABLE `tbl_Thesaurus` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `term` varchar(40) NOT NULL default '',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 512,516 ****
    `issue` int(4) NOT NULL default '0',
    PRIMARY KEY  (`term`,`issue`)
! ) TYPE=MyISAM;
  
  --
--- 510,514 ----
    `issue` int(4) NOT NULL default '0',
    PRIMARY KEY  (`term`,`issue`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 530,534 ****
    `time` int(14) NOT NULL default '0',
    PRIMARY KEY  (`issue`,`userid`)
! ) TYPE=MyISAM;
  
  --
--- 528,532 ----
    `time` int(14) NOT NULL default '0',
    PRIMARY KEY  (`issue`,`userid`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 544,553 ****
  --
  CREATE TABLE `tbl_UserDomains` (
!   `id` int(4) unsigned NOT NULL,
    `userid` int(4) NOT NULL default '0',
    `domain` int(4) NOT NULL default '0',
    `defaultflag` int(2) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 542,551 ----
  --
  CREATE TABLE `tbl_UserDomains` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `userid` int(4) NOT NULL default '0',
    `domain` int(4) NOT NULL default '0',
    `defaultflag` int(2) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 570,574 ****
    `defaultflag` int(2) NOT NULL default '1',
    PRIMARY KEY  (`userid`,`site`,`usertype`)
! ) TYPE=MyISAM;
  
  --
--- 568,572 ----
    `defaultflag` int(2) NOT NULL default '1',
    PRIMARY KEY  (`userid`,`site`,`usertype`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 584,592 ****
  --
  CREATE TABLE `tbl_UserTypes` (
!   `id` int(4) unsigned NOT NULL,
    `type` varchar(100) NOT NULL default '',
    `sortorder` int(4) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 582,590 ----
  --
  CREATE TABLE `tbl_UserTypes` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `type` varchar(100) NOT NULL default '',
    `sortorder` int(4) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 614,618 ****
    `value` varchar(100) NOT NULL default '',
    PRIMARY KEY  (`identifier`,`userid`,`domain`)
! ) TYPE=MyISAM;
  
  --
--- 612,616 ----
    `value` varchar(100) NOT NULL default '',
    PRIMARY KEY  (`identifier`,`userid`,`domain`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 628,632 ****
  --
  CREATE TABLE `tbl_Users` (
!   `id` int(4) unsigned NOT NULL,
    `username` varchar(20) NOT NULL default '',
    `pass` varchar(50) NOT NULL default '',
--- 626,630 ----
  --
  CREATE TABLE `tbl_Users` (
!   `id` int(4) unsigned NOT NULL auto_increment,
    `username` varchar(20) NOT NULL default '',
    `pass` varchar(50) NOT NULL default '',
***************
*** 639,643 ****
    `ldap` smallint(6) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) TYPE=MyISAM;
  
  --
--- 637,641 ----
    `ldap` smallint(6) NOT NULL default '0',
    PRIMARY KEY  (`id`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
***************
*** 662,666 ****
    `end` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY  (`issue`,`userid`)
! ) TYPE=MyISAM;
  
  --
--- 660,664 ----
    `end` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY  (`issue`,`userid`)
! ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --