|
From: Scott P. <wht...@us...> - 2007-10-01 03:34:58
|
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;
--
|