[2011-12-09 21:03:45.946] [000024] [MySQL Local] [MYSQL] SHOW VARIABLES LIKE 'lower_case_%' [2011-12-09 21:03:45.946] [000024] [MySQL Local] [MYSQL] SHOW VARIABLES LIKE 'profiling' [2011-12-09 21:03:45.946] [000024] [MySQL Local] [MYSQL] SHOW CHARACTER SET [2011-12-09 21:03:45.946] [000024] [MySQL Local] [MYSQL] SHOW COLLATION [2011-12-09 21:03:45.956] [000024] [MySQL Local] [MYSQL] SHOW DATABASES [2011-12-09 21:03:48.308] [000025] [MySQL Local] [MYSQL] SELECT @@character_set_database, @@collation_database [2011-12-09 21:03:48.308] [000025] [MySQL Local] [MYSQL] SHOW FULL TABLES WHERE Table_type != 'VIEW' [2011-12-09 21:05:50.025] [000024] [MySQL Local] [MYSQL] SHOW DATABASES [2011-12-09 21:06:08.392] [000026] [MySQL Local] [MYSQL] mysqladmin -u root -p create cvdb ; [2011-12-09 21:06:08.482] [000026] [MySQL Local] [MYSQL] 1064 - You have an error in your SQL syntax; check the manual that corresponds t o your MySQL server version for the right syntax to use near 'mysqladmin -u root -p create cvdb' at line 1 [2011-12-09 21:06:12.413] [000026] [MySQL Local] [MYSQL] mysqladmin -u root -p create cvdb; [2011-12-09 21:06:12.413] [000026] [MySQL Local] [MYSQL] 1064 - You have an error in your SQL syntax; check the manual that corresponds t o your MySQL server version for the right syntax to use near 'mysqladmin -u root -p create cvdb' at line 1 [2011-12-09 21:06:52.222] [000028] [MySQL Local] [MYSQL] SELECT @@character_set_database, @@collation_database [2011-12-09 21:06:52.222] [000028] [MySQL Local] [MYSQL] SHOW FULL TABLES WHERE Table_type != 'VIEW' [2011-12-09 21:06:54.334] [000029] [MySQL Local] [MYSQL] SELECT @@character_set_database, @@collation_database [2011-12-09 21:06:54.334] [000029] [MySQL Local] [MYSQL] SHOW FULL TABLES WHERE Table_type != 'VIEW' [2011-12-09 21:06:56.014] [000030] [MySQL Local] [MYSQL] SELECT @@character_set_database, @@collation_database [2011-12-09 21:06:56.024] [000030] [MySQL Local] [MYSQL] SHOW FULL TABLES WHERE Table_type != 'VIEW'

[2011-12-09 21:06:57.194] [000031] [MySQL Local] [MYSQL] SELECT @@character_set_database, @@collation_database [2011-12-09 21:06:57.204] [000031] [MySQL Local] [MYSQL] SHOW FULL TABLES WHERE Table_type != 'VIEW' [2011-12-09 21:06:58.614] [000032] [MySQL Local] [MYSQL] SELECT @@character_set_database, @@collation_database [2011-12-09 21:06:58.614] [000032] [MySQL Local] [MYSQL] SHOW FULL TABLES WHERE Table_type != 'VIEW' [2011-12-09 21:06:59.854] [000033] [MySQL Local] [MYSQL] SELECT @@character_set_database, @@collation_database [2011-12-09 21:06:59.854] [000033] [MySQL Local] [MYSQL] SHOW FULL TABLES WHERE Table_type != 'VIEW' [2011-12-09 21:07:01.065] [000034] [MySQL Local] [MYSQL] SELECT @@character_set_database, @@collation_database [2011-12-09 21:07:01.075] [000034] [MySQL Local] [MYSQL] SHOW FULL TABLES WHERE Table_type != 'VIEW' [2011-12-09 21:07:50.742] [000024] [MySQL Local] [MYSQL] SHOW DATABASES [2011-12-09 21:08:03.859] [000029] [MySQL Local] [MYSQL] SHOW TABLE STATUS LIKE 'cds' [2011-12-09 21:08:03.899] [000029] [MySQL Local] [MYSQL] SHOW CREATE TABLE `cds` [2011-12-09 21:08:03.899] [000029] [MySQL Local] [MYSQL] SELECT TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME, PARTITION_METHOD, SUBPARTI TION_METHOD, PARTITION_EXPRESSION, SUBPARTITION_EXPRESSION, PARTITION_DESCRIPTIO N, PARTITION_COMMENT, NODEGROUP, TABLESPACE_NAME FROM information_schema.PARTITI ONS WHERE TABLE_SCHEMA LIKE 'cdcol' AND NOT ISNULL(PARTITION_NAME) AND TABLE_NAM E LIKE 'cds' ORDER BY TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION, SU BPARTITION_ORDINAL_POSITION [2011-12-09 21:08:03.929] [000029] [MySQL Local] [MYSQL] SHOW CREATE TABLE `cds` [2011-12-09 21:08:03.959] [000035] [MySQL Local] [MYSQL] SELECT * FROM `cds` LIMIT 0, 1000 [2011-12-09 21:08:03.959] [000035] [MySQL Local] [MYSQL] SHOW COLUMNS FROM `cdcol`.`cds` [2011-12-09 21:08:08.601] [000000] [Extranet Tabox] [MYSQL] 2005 - Unknown MySQL server host 'dbmy0010.whservidor.com' (11004) [2011-12-09 21:09:32.695] [000024] [MySQL Local] [MYSQL] CREATE DATABASE `cvdb` [2011-12-09 21:09:32.715] [000024] [MySQL Local] [MYSQL] SHOW DATABASES [2011-12-09 21:09:34.606] [000036] [MySQL Local] [MYSQL]

SELECT @@character_set_database, @@collation_database [2011-12-09 21:09:34.606] [000036] [MySQL Local] [MYSQL] SHOW FULL TABLES WHERE Table_type != 'VIEW' [2011-12-09 21:10:40.087] [000037] [MySQL Local] [MYSQL] -- MySQL dump 9.10 --- Host: localhost Database: footest -- ------------------------------------------------------- Server version 4.0.18-standard-log SET FOREIGN_KEY_CHECKS = 0; [2011-12-09 21:10:40.387] [000037] [MySQL Local] [MYSQL] SET UNIQUE_CHECKS=0; [2011-12-09 21:10:40.427] [000037] [MySQL Local] [MYSQL] SET AUTOCOMMIT=0; [2011-12-09 21:10:40.447] [000037] [MySQL Local] [MYSQL] --- Table structure for table `accountingstatus` -DROP TABLE IF EXISTS `accountingstatus`; [2011-12-09 21:10:40.447] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.457] [000037] [MySQL Local] [MYSQL] CREATE TABLE `accountingstatus` ( `statusid` int(10) unsigned NOT NULL auto_increment, `title` varchar(25) NOT NULL default '', `description` text NOT NULL, PRIMARY KEY (`statusid`) ) TYPE=InnoDB; [2011-12-09 21:10:40.457] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.467] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `accountingstatus` -INSERT INTO `accountingstatus` (`statusid`, `title`, `description`) VALUES (1,'P ending','We are in process of deciding whether to accept or reject this order'), (2,'Accepted','We are going to supply material according to this order'),(3,'Rej ected','We are not going to fulfill this order'); [2011-12-09 21:10:40.467] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.487] [000037] [MySQL Local] [MYSQL] --- Table structure for table `accountingterms` -DROP TABLE IF EXISTS `accountingterms`;

[2011-12-09 21:10:40.487] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.497] [000037] [MySQL Local] [MYSQL] CREATE TABLE `accountingterms` ( `termsid` int(11) unsigned NOT NULL auto_increment, `title` varchar(25) default NULL, `description` text, PRIMARY KEY (`termsid`) ) TYPE=InnoDB; [2011-12-09 21:10:40.497] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.507] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `accountingterms` -INSERT INTO `accountingterms` (`termsid`, `title`, `description`) VALUES (1,'Acc ountTerms1',NULL),(2,'AccountTerms2',NULL),(3,'AccountTerms3',NULL),(4,'AccountT erms4',NULL); [2011-12-09 21:10:40.507] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.517] [000037] [MySQL Local] [MYSQL] --- Table structure for table `action` -DROP TABLE IF EXISTS `action`; [2011-12-09 21:10:40.517] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.527] [000037] [MySQL Local] [MYSQL] CREATE TABLE `action` ( `ActionID` int(11) unsigned NOT NULL auto_increment, `Type` enum('ALERT','EMAIL') NOT NULL default 'ALERT', `Message` text, `ActionTime` datetime default NULL, `Repeat` tinyint(4) default NULL, `ActionInterval` int(11) default NULL, PRIMARY KEY (`ActionID`), UNIQUE KEY `ActionID` (`ActionID`) ) TYPE=InnoDB; [2011-12-09 21:10:40.527] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.537] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `action` ---- Table structure for table `activity` --

DROP TABLE IF EXISTS `activity`; [2011-12-09 21:10:40.537] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.547] [000037] [MySQL Local] [MYSQL] CREATE TABLE `activity` ( `AllDay` enum('YES','NO') default 'NO', `ActivityID` int(11) unsigned NOT NULL auto_increment, `Type` int(11) NOT NULL default '0', `Priority` int(11) NOT NULL default '0', `Status` int(11) NOT NULL default '0', `Title` varchar(255) default NULL, `DueDate` datetime default NULL, `CompletedDate` datetime default NULL, `Details` text, `Creator` int(11) NOT NULL default '0', `Owner` int(11) default NULL, `ModifiedBy` int(11) default NULL, `Modified` timestamp(14) NOT NULL, `Created` datetime NOT NULL default '0000-00-00 00:00:00', `Start` datetime default NULL, `End` datetime default NULL, `AttachmentType` enum('NONE','FILE','LINK') NOT NULL default 'NONE', `Location` varchar(25) default NULL, `visibility` enum('PRIVATE','PUBLIC') NOT NULL default 'PRIVATE', `Notes` varchar(255) default NULL, PRIMARY KEY (`ActivityID`), UNIQUE KEY `ActivityID` (`ActivityID`), KEY `Type` (`Type`), KEY `Priority` (`Priority`), KEY `Status` (`Status`), KEY `Creator` (`Creator`), KEY `Owner` (`Owner`), KEY `ModifiedBy` (`ModifiedBy`), KEY `Location` (`Location`) ) TYPE=InnoDB; [2011-12-09 21:10:40.547] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.567] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `activity` ---- Table structure for table `activityaction` -DROP TABLE IF EXISTS `activityaction`; [2011-12-09 21:10:40.567] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.577] [000037] [MySQL Local] [MYSQL] CREATE TABLE `activityaction` ( `ActivityID` int(11) unsigned NOT NULL default '0',

`ActionID` int(11) unsigned NOT NULL default '0', `recipient` int(11) unsigned default NULL, KEY `ActivityID` (`ActivityID`), KEY `ActionID` (`ActionID`), KEY `recipient` (`recipient`) ) TYPE=InnoDB; [2011-12-09 21:10:40.577] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.587] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `activityaction` ---- Table structure for table `activitylink` -DROP TABLE IF EXISTS `activitylink`; [2011-12-09 21:10:40.587] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.597] [000037] [MySQL Local] [MYSQL] CREATE TABLE `activitylink` ( `ActivityID` int(11) unsigned NOT NULL default '0', `RecordTypeID` int(11) unsigned NOT NULL default '0', `RecordID` int(11) unsigned NOT NULL default '0', KEY `ActivityID` (`ActivityID`), KEY `RecordTypeID` (`RecordTypeID`), KEY `RecordID` (`RecordID`) ) TYPE=InnoDB; [2011-12-09 21:10:40.597] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.607] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `activitylink` ---- Table structure for table `activityportlet` -DROP TABLE IF EXISTS `activityportlet`; [2011-12-09 21:10:40.607] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.627] [000037] [MySQL Local] [MYSQL] CREATE TABLE `activityportlet` ( `individualid` int(11) unsigned default NULL, `activitytype` int(11) unsigned default NULL, KEY `individualid` (`individualid`), KEY `activitytype` (`activitytype`) ) TYPE=InnoDB;

[2011-12-09 21:10:40.627] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.637] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `activityportlet` ---- Table structure for table `activitypriority` -DROP TABLE IF EXISTS `activitypriority`; [2011-12-09 21:10:40.637] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.647] [000037] [MySQL Local] [MYSQL] CREATE TABLE `activitypriority` ( `PriorityID` int(11) NOT NULL auto_increment, `Name` varchar(25) NOT NULL default '', `PriorityOrder` int(11) NOT NULL default '0', PRIMARY KEY (`PriorityID`), UNIQUE KEY `PriorityID` (`PriorityID`) ) TYPE=InnoDB; [2011-12-09 21:10:40.647] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.657] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `activitypriority` -INSERT INTO `activitypriority` (`PriorityID`, `Name`, `PriorityOrder`) VALUES (1 ,'High',1),(2,'Medium',2),(3,'Low',3); [2011-12-09 21:10:40.657] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.667] [000037] [MySQL Local] [MYSQL] --- Table structure for table `activityresources` -DROP TABLE IF EXISTS `activityresources`; [2011-12-09 21:10:40.667] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.677] [000037] [MySQL Local] [MYSQL] CREATE TABLE `activityresources` ( `ActivityResourceID` int(11) unsigned NOT NULL auto_increment, `Name` varchar(25) NOT NULL default '', `Detail` text, PRIMARY KEY (`ActivityResourceID`), UNIQUE KEY `ActivityResourceID` (`ActivityResourceID`) ) TYPE=InnoDB;

[2011-12-09 21:10:40.677] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.697] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `activityresources` ---- Table structure for table `activitystatus` -DROP TABLE IF EXISTS `activitystatus`; [2011-12-09 21:10:40.697] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.707] [000037] [MySQL Local] [MYSQL] CREATE TABLE `activitystatus` ( `StatusID` int(11) NOT NULL auto_increment, `Name` varchar(25) NOT NULL default '', PRIMARY KEY (`StatusID`), UNIQUE KEY `StatusID` (`StatusID`), UNIQUE KEY `Name` (`Name`) ) TYPE=InnoDB; [2011-12-09 21:10:40.707] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.717] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `activitystatus` -INSERT INTO `activitystatus` (`StatusID`, `Name`) VALUES (3,'Assigned'),(2,'Comp leted'),(1,'Pending'); [2011-12-09 21:10:40.717] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.727] [000037] [MySQL Local] [MYSQL] --- Table structure for table `activitytype` -DROP TABLE IF EXISTS `activitytype`; [2011-12-09 21:10:40.727] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.737] [000037] [MySQL Local] [MYSQL] CREATE TABLE `activitytype` ( `TypeID` int(11) NOT NULL auto_increment, `Name` varchar(25) NOT NULL default '', PRIMARY KEY (`TypeID`), UNIQUE KEY `TypeID` (`TypeID`) ) TYPE=InnoDB;

[2011-12-09 21:10:40.737] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.747] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `activitytype` -INSERT INTO `activitytype` (`TypeID`, `Name`) VALUES (1,'Appointment'),(2,'Call' ),(3,'Forecast Sale'),(4,'Literature Request'),(5,'Meeting'),(6,'To Do'),(7,'Nex t Action'),(8,'Task'); [2011-12-09 21:10:40.747] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.757] [000037] [MySQL Local] [MYSQL] --- Table structure for table `additionalmenu` -DROP TABLE IF EXISTS `additionalmenu`; [2011-12-09 21:10:40.757] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.767] [000037] [MySQL Local] [MYSQL] CREATE TABLE `additionalmenu` ( `menuitem_id` int(11) unsigned NOT NULL auto_increment, `menuitem_name` varchar(25) NOT NULL default '', `moduleid` int(11) unsigned NOT NULL default '0', `forward_res` varchar(25) NOT NULL default '', `new_win` int(1) unsigned default '0', `win_property` varchar(50) default NULL, `params` varchar(50) default NULL, `menuitem_order` int(2) unsigned NOT NULL default '0', PRIMARY KEY (`menuitem_id`), KEY `menuitem_id` (`menuitem_id`) ) TYPE=InnoDB; [2011-12-09 21:10:40.767] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.777] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `additionalmenu` -INSERT INTO `additionalmenu` (`menuitem_id`, `menuitem_name`, `moduleid`, `forwa rd_res`, `new_win`, `win_property`, `params`, `menuitem_order`) VALUES (1,'Help' ,60,'help',1,' width=500,height=500,status=no','',1),(3,'Preferences',62,'prefer ences',0,'','',3),(4,'Reports',63,'reports',0,'','',4),(5,'Administrator',64,'ad ministrator',0,'','',6); [2011-12-09 21:10:40.777] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.787] [000037] [MySQL Local] [MYSQL] --- Table structure for table `address` --

DROP TABLE IF EXISTS `address`; [2011-12-09 21:10:40.787] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.797] [000037] [MySQL Local] [MYSQL] CREATE TABLE `address` ( `AddressID` int(10) unsigned NOT NULL auto_increment, `AddressType` int(11) unsigned default NULL, `Street1` varchar(225) default NULL, `Street2` varchar(255) default NULL, `City` varchar(255) default NULL, `state` varchar(255) default '', `Zip` varchar(25) default NULL, `country` varchar(255) default '', `Website` varchar(255) default NULL, `jurisdictionID` int(11) unsigned default '0', PRIMARY KEY (`AddressID`), KEY `AddressType` (`AddressType`) ) TYPE=InnoDB; [2011-12-09 21:10:40.797] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.807] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `address` -INSERT INTO `address` (`AddressID`, `AddressType`, `Street1`, `Street2`, `City`, `state`, `Zip`, `country`, `Website`, `jurisdictionID`) VALUES (1,1,'650 Sentry Park Suite One','','Blue Bell','PA','19422','USA','http://www.centraview.com',0 ); [2011-12-09 21:10:40.817] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.827] [000037] [MySQL Local] [MYSQL] --- Table structure for table `addressrelate` -DROP TABLE IF EXISTS `addressrelate`; [2011-12-09 21:10:40.827] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.837] [000037] [MySQL Local] [MYSQL] CREATE TABLE `addressrelate` ( `Address` int(11) unsigned NOT NULL default '0', `ContactType` int(11) unsigned NOT NULL default '0', `Contact` int(11) unsigned NOT NULL default '0', `AddressType` int(11) unsigned default NULL, `IsPrimary` enum('YES','NO') default NULL, PRIMARY KEY (`Address`,`ContactType`,`Contact`), KEY `Address` (`Address`), KEY `ContactType` (`ContactType`), KEY `Contact` (`Contact`), KEY `AddressType` (`AddressType`)

) TYPE=InnoDB; [2011-12-09 21:10:40.837] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.847] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `addressrelate` -INSERT INTO `addressrelate` (`Address`, `ContactType`, `Contact`, `AddressType`, `IsPrimary`) VALUES (1,1,2,1,'YES'); [2011-12-09 21:10:40.847] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.857] [000037] [MySQL Local] [MYSQL] --- Table structure for table `addresstype` -DROP TABLE IF EXISTS `addresstype`; [2011-12-09 21:10:40.857] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.867] [000037] [MySQL Local] [MYSQL] CREATE TABLE `addresstype` ( `TypeID` int(11) unsigned NOT NULL auto_increment, `Name` varchar(25) default NULL, PRIMARY KEY (`TypeID`) ) TYPE=InnoDB; [2011-12-09 21:10:40.867] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.877] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `addresstype` -INSERT INTO `addresstype` (`TypeID`, `Name`) VALUES (1,'Billing'),(2,'Shipping') ; [2011-12-09 21:10:40.877] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.887] [000037] [MySQL Local] [MYSQL] --- Table structure for table `alert` -DROP TABLE IF EXISTS `alert`; [2011-12-09 21:10:40.887] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.897] [000037] [MySQL Local] [MYSQL] CREATE TABLE `alert` ( `alertid` int(11) unsigned NOT NULL auto_increment,

`message` text, `owner` int(11) unsigned default NULL, `ack` enum('YES','NO') default NULL, `displayedtime` datetime default NULL, PRIMARY KEY (`alertid`), KEY `owner` (`owner`) ) TYPE=InnoDB; [2011-12-09 21:10:40.897] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.907] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `alert` ---- Table structure for table `alertpreference` -DROP TABLE IF EXISTS `alertpreference`; [2011-12-09 21:10:40.907] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.917] [000037] [MySQL Local] [MYSQL] CREATE TABLE `alertpreference` ( `individualid` int(11) unsigned default NULL, `acknowledgedvisability` enum('BOTH','HOME','NONE') default NULL, `emailvisability` enum('BOTH','HOME','NONE') default NULL, `acknowledgeddays` int(11) default NULL, KEY `individualid` (`individualid`) ) TYPE=InnoDB; [2011-12-09 21:10:40.917] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.927] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `alertpreference` ---- Table structure for table `applicationsetting` -DROP TABLE IF EXISTS `applicationsetting`; [2011-12-09 21:10:40.927] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.937] [000037] [MySQL Local] [MYSQL] CREATE TABLE `applicationsetting` ( `modulesettingid` int(11) unsigned NOT NULL auto_increment, `msname` varchar(100) NOT NULL default '', `msvalue` varchar(250) NOT NULL default '', `starttime` time default NULL, `endtime` time default NULL,

`workingdays` varchar(50) NOT NULL default '', PRIMARY KEY (`modulesettingid`), UNIQUE KEY `msname` (`msname`) ) TYPE=InnoDB COMMENT='InnoDB free: 68608 kB; InnoDB free: 75776 kB'; [2011-12-09 21:10:40.937] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.947] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `applicationsetting` -INSERT INTO `applicationsetting` (`modulesettingid`, `msname`, `msvalue`, `start time`, `endtime`, `workingdays`) VALUES (1,'CUSTOMERLOGO','logo_customer.gif',NU LL,NULL,''),(2,'DEFAULTOWNER','646',NULL,NULL,''),(3,'','','10:00:00','07:00:00' ,'mon,tues,wed,thurs,fri,sat'); [2011-12-09 21:10:40.947] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.957] [000037] [MySQL Local] [MYSQL] --- Table structure for table `applypayment` -DROP TABLE IF EXISTS `applypayment`; [2011-12-09 21:10:40.957] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.967] [000037] [MySQL Local] [MYSQL] CREATE TABLE `applypayment` ( `LineID` int(10) unsigned NOT NULL auto_increment, `LineStatus` enum('New','Active','Deleted') NOT NULL default 'Active', `PaymentID` int(10) unsigned NOT NULL default '0', `InvoiceID` int(10) unsigned NOT NULL default '0', `Amount` float NOT NULL default '0', PRIMARY KEY (`LineID`), KEY `PaymentID` (`PaymentID`), KEY `InvoiceID` (`InvoiceID`) ) TYPE=InnoDB; [2011-12-09 21:10:40.967] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.977] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `applypayment` ---- Table structure for table `attachment` -DROP TABLE IF EXISTS `attachment`; [2011-12-09 21:10:40.977] [000037] [MySQL Local] [MYSQL] 1046 - No database selected

[2011-12-09 21:10:40.987] [000037] [MySQL Local] [MYSQL] CREATE TABLE `attachment` ( `AttachmentID` int(4) unsigned NOT NULL auto_increment, `MessageID` int(11) unsigned default NULL, `FileName` varchar(100) NOT NULL default '', `FileID` int(11) unsigned default NULL, PRIMARY KEY (`AttachmentID`), KEY `MessageID` (`MessageID`), KEY `FileID` (`FileID`) ) TYPE=InnoDB; [2011-12-09 21:10:40.987] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:40.997] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `attachment` ---- Table structure for table `attendee` -DROP TABLE IF EXISTS `attendee`; [2011-12-09 21:10:40.997] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.007] [000037] [MySQL Local] [MYSQL] CREATE TABLE `attendee` ( `ActivityID` int(11) unsigned NOT NULL default '0', `IndividualID` int(11) unsigned NOT NULL default '0', `Type` enum('REQUIRED','OPTIONAL') NOT NULL default 'REQUIRED', `Status` int(11) unsigned default NULL, KEY `ActivityID` (`ActivityID`), KEY `IndividualID` (`IndividualID`), KEY `Status` (`Status`) ) TYPE=InnoDB; [2011-12-09 21:10:41.007] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.017] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `attendee` ---- Table structure for table `attendeestatus` -DROP TABLE IF EXISTS `attendeestatus`; [2011-12-09 21:10:41.017] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.027] [000037] [MySQL Local] [MYSQL]

CREATE TABLE `attendeestatus` ( `StatusID` int(11) NOT NULL auto_increment, `Name` varchar(25) NOT NULL default '', PRIMARY KEY (`StatusID`), UNIQUE KEY `StatusID` (`StatusID`), UNIQUE KEY `Name` (`Name`) ) TYPE=InnoDB; [2011-12-09 21:10:41.027] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.037] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `attendeestatus` -INSERT INTO `attendeestatus` (`StatusID`, `Name`) VALUES (1,'Accepted'),(2,'Decl ined'),(3,'Tentatively Accepted'); [2011-12-09 21:10:41.037] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.047] [000037] [MySQL Local] [MYSQL] --- Table structure for table `attic` -DROP TABLE IF EXISTS `attic`; [2011-12-09 21:10:41.047] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.057] [000037] [MySQL Local] [MYSQL] CREATE TABLE `attic` ( `atticid` int(10) unsigned NOT NULL auto_increment, `deletedby` int(10) unsigned NOT NULL default '0', `deleted` timestamp(14) NOT NULL, `dumptype` enum('CV_ATTIC','CV_GARBAGE') NOT NULL default 'CV_ATTIC', `recordtitle` varchar(250) default NULL, `owner` int(11) unsigned NOT NULL default '0', `moduleid` int(10) unsigned NOT NULL default '0', `record` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`atticid`), KEY `deletedby` (`deletedby`), KEY `owner` (`owner`), KEY `moduleid` (`moduleid`), KEY `record` (`record`) ) TYPE=InnoDB; [2011-12-09 21:10:41.057] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.067] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `attic` ---- Table structure for table `atticdata`

-DROP TABLE IF EXISTS `atticdata`; [2011-12-09 21:10:41.067] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.077] [000037] [MySQL Local] [MYSQL] CREATE TABLE `atticdata` ( `atticid` int(10) unsigned NOT NULL default '0', `fieldid` int(10) unsigned NOT NULL default '0', `value` varchar(250) default NULL, `recordtypeid` int(10) unsigned NOT NULL default '0', KEY `atticid` (`atticid`), KEY `fieldid` (`fieldid`), KEY `recordtypeid` (`recordtypeid`) ) TYPE=InnoDB; [2011-12-09 21:10:41.077] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.087] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `atticdata` ---- Table structure for table `authorizationsettings` -DROP TABLE IF EXISTS `authorizationsettings`; [2011-12-09 21:10:41.087] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.097] [000037] [MySQL Local] [MYSQL] CREATE TABLE `authorizationsettings` ( `userAuthType` varchar(100) NOT NULL default '', `server` varchar(100) NOT NULL default '', `port` varchar(100) NOT NULL default '', `username` varchar(100) NOT NULL default '', `password` varchar(100) NOT NULL default '', `usernameField` varchar(100) NOT NULL default '', `passwordField` varchar(100) NOT NULL default '', `authField` varchar(100) NOT NULL default '' ) TYPE=InnoDB; [2011-12-09 21:10:41.097] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.107] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `authorizationsettings` ---- Table structure for table `calendarportlet` --

DROP TABLE IF EXISTS `calendarportlet`; [2011-12-09 21:10:41.107] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.127] [000037] [MySQL Local] [MYSQL] CREATE TABLE `calendarportlet` ( `individualid` int(11) unsigned default NULL, `activitytype` int(11) unsigned default NULL, KEY `individualid` (`individualid`), KEY `activitytype` (`activitytype`) ) TYPE=InnoDB; [2011-12-09 21:10:41.127] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.137] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `calendarportlet` ---- Table structure for table `call` -DROP TABLE IF EXISTS `call`; [2011-12-09 21:10:41.137] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.147] [000037] [MySQL Local] [MYSQL] CREATE TABLE `call` ( `ActivityID` int(11) unsigned NOT NULL default '0', `CallType` int(11) unsigned default NULL, KEY `ActivityID` (`ActivityID`), KEY `CallType` (`CallType`) ) TYPE=InnoDB; [2011-12-09 21:10:41.147] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.157] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `call` ---- Table structure for table `calltype` -DROP TABLE IF EXISTS `calltype`; [2011-12-09 21:10:41.157] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.167] [000037] [MySQL Local] [MYSQL] CREATE TABLE `calltype` (

`CallTypeID` int(10) unsigned NOT NULL auto_increment, `Name` varchar(25) NOT NULL default '', PRIMARY KEY (`CallTypeID`), UNIQUE KEY `CallTypeID` (`CallTypeID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.167] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.177] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `calltype` -INSERT INTO `calltype` (`CallTypeID`, `Name`) VALUES (1,'Incoming'),(2,'Outgoing '); [2011-12-09 21:10:41.177] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.187] [000037] [MySQL Local] [MYSQL] --- Table structure for table `category` -DROP TABLE IF EXISTS `category`; [2011-12-09 21:10:41.187] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.197] [000037] [MySQL Local] [MYSQL] CREATE TABLE `category` ( `catid` int(10) unsigned NOT NULL auto_increment, `title` varchar(100) NOT NULL default '', `description` text, `parent` int(11) unsigned NOT NULL default '0', `createdby` int(10) unsigned NOT NULL default '0', `modifiedby` int(10) unsigned NOT NULL default '0', `created` datetime NOT NULL default '0000-00-00 00:00:00', `modified` timestamp(14) NOT NULL, `owner` int(10) unsigned NOT NULL default '0', `status` enum('DRAFT','PUBLISH') NOT NULL default 'DRAFT', `publishToCustomerView` enum('YES','NO') NOT NULL default 'NO', PRIMARY KEY (`catid`), KEY `parent` (`parent`), KEY `createdby` (`createdby`), KEY `modifiedby` (`modifiedby`), KEY `owner` (`owner`) ) TYPE=InnoDB; [2011-12-09 21:10:41.197] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.207] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `category` -INSERT INTO `category` (`catid`, `title`, `description`, `parent`, `createdby`, `modifiedby`, `created`, `modified`, `owner`, `status`, `publishToCustomerView`)

VALUES (1,'KnowledgeBase','Root Category',0,1,1,'2003-12-14 23:50:16',200409271 55044,1,'DRAFT','YES'); [2011-12-09 21:10:41.207] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.217] [000037] [MySQL Local] [MYSQL] --- Table structure for table `companynews` -DROP TABLE IF EXISTS `companynews`; [2011-12-09 21:10:41.217] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.227] [000037] [MySQL Local] [MYSQL] CREATE TABLE `companynews` ( `FileID` int(11) NOT NULL auto_increment, `DateFrom` datetime NOT NULL default '0000-00-00 00:00:00', `DateTo` datetime NOT NULL default '0000-00-00 00:00:00', KEY `FileID` (`FileID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.227] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.237] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `companynews` ---- Table structure for table `competition` -DROP TABLE IF EXISTS `competition`; [2011-12-09 21:10:41.237] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.247] [000037] [MySQL Local] [MYSQL] CREATE TABLE `competition` ( `CompetitionID` int(11) NOT NULL default '0', `EntityID` int(11) NOT NULL default '0', `Strengths` varchar(250) NOT NULL default '', `Weaknesses` varchar(250) NOT NULL default '', `Notes` text, PRIMARY KEY (`CompetitionID`), KEY `EntityID` (`EntityID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.247] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.267] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `competition` --

--- Table structure for table `contacttype` -DROP TABLE IF EXISTS `contacttype`; [2011-12-09 21:10:41.267] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.267] [000037] [MySQL Local] [MYSQL] CREATE TABLE `contacttype` ( `ContactTypeID` int(11) unsigned NOT NULL auto_increment, `Name` varchar(25) default NULL, PRIMARY KEY (`ContactTypeID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.267] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.287] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `contacttype` -INSERT INTO `contacttype` (`ContactTypeID`, `Name`) VALUES (1,'Entity'),(2,'Indi vidual'); [2011-12-09 21:10:41.287] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.297] [000037] [MySQL Local] [MYSQL] --- Table structure for table `contentstatus` -DROP TABLE IF EXISTS `contentstatus`; [2011-12-09 21:10:41.297] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.307] [000037] [MySQL Local] [MYSQL] CREATE TABLE `contentstatus` ( `statusid` int(10) unsigned NOT NULL default '0', `name` varchar(25) NOT NULL default '', PRIMARY KEY (`statusid`) ) TYPE=InnoDB; [2011-12-09 21:10:41.307] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.317] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `contentstatus` ---- Table structure for table `country`

-DROP TABLE IF EXISTS `country`; [2011-12-09 21:10:41.317] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.327] [000037] [MySQL Local] [MYSQL] CREATE TABLE `country` ( `CountryID` int(11) unsigned NOT NULL auto_increment, `Name` varchar(50) default NULL, PRIMARY KEY (`CountryID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.327] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.337] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `country` -INSERT INTO `country` (`CountryID`, `Name`) VALUES (1,'United States'),(2,'Canad a'),(3,'United Kingdom'),(4,'Afghanistan'),(5,'Albania'),(6,'Algeria'),(7,'Ameri can Samoa'),(8,'Andorra'),(9,'Angola'),(10,'Anguilla'),(11,'Antigua and Barbuda' ),(12,'Argentina'),(13,'Armenia'),(14,'Aruba'),(15,'Australia'),(16,'Austria'),( 17,'Azerbaijan Republic'),(18,'Bahamas'),(19,'Bahrain'),(20,'Bangladesh'),(21,'B arbados'),(22,'Belarus'),(23,'Belgium'),(24,'Belize'),(25,'Benin'),(26,'Bermuda' ),(27,'Bhutan'),(28,'Bolivia'),(29,'Bosnia and Herzegovina'),(30,'Botswana'),(31 ,'Brazil'),(32,'British Virgin Islands'),(33,'Brunei Darussalam'),(34,'Bulgaria' ),(35,'Burkina Faso'),(36,'Burma'),(37,'Burundi'),(38,'Cambodia'),(39,'Cameroon' ),(40,'Canada'),(41,'Cape Verde Islands'),(42,'Cayman Islands'),(43,'Central Afr ican Republic'),(44,'Chad'),(45,'Chile'),(46,'China'),(47,'Colombia'),(48,'Comor os'),(49,'Congo, Democratic Republic of the'),(50,'Congo, Republic of the'),(51, 'Cook Islands'),(52,'Costa Rica'),(53,'Cote d Ivoire (Ivory Coast)'),(54,'Croati a, Republic of'),(55,'Cyprus'),(56,'Czech Republic'),(57,'Denmark'),(58,'Djibout i'),(59,'Dominica'),(60,'Dominican Republic'),(61,'Ecuador'),(62,'Egypt'),(63,'E l Salvador'),(64,'Equatorial Guinea'),(65,'Eritrea'),(66,'Estonia'),(67,'Ethiopi a'),(68,'Falkland Islands (Islas Malvinas)'),(69,'Fiji'),(70,'Finland'),(71,'Fra nce'),(72,'French Guiana'),(73,'French Polynesia'),(74,'Gabon Republic'),(75,'Ga mbia'),(76,'Georgia'),(77,'Germany'),(78,'Ghana'),(79,'Gibraltar'),(80,'Greece') ,(81,'Greenland'),(82,'Grenada'),(83,'Guadeloupe'),(84,'Guam'),(85,'Guatemala'), (86,'Guernsey'),(87,'Guinea'),(88,'Guinea-Bissau'),(89,'Guyana'),(90,'Haiti'),(9 1,'Honduras'),(92,'Hong Kong'),(93,'Hungary'),(94,'Iceland'),(95,'India'),(96,'I ndonesia'),(97,'Ireland'),(98,'Israel'),(99,'Italy'),(100,'Jamaica'),(101,'Jan M ayen'),(102,'Japan'),(103,'Jersey'),(104,'Jordan'),(105,'Kazakhstan'),(106,'Keny a Coast Republic'),(107,'Kiribati'),(108,'Korea, South'),(109,'Kuwait'),(110,'Ky rgyzstan'),(111,'Laos'),(112,'Latvia'),(113,'Lebanon'),(114,'Liechtenstein'),(11 5,'Lithuania'),(116,'Luxembourg'),(117,'Macau'),(118,'Macedonia'),(119,'Madagasc ar'),(120,'Malawi'),(121,'Malaysia'),(122,'Maldives'),(123,'Mali'),(124,'Malta') ,(125,'Marshall Islands'),(126,'Martinique'),(127,'Mauritania'),(128,'Mauritius' ),(129,'Mayotte'),(130,'Mexico'),(131,'Micronesia'),(132,'Moldova'),(133,'Monaco '),(134,'Mongolia'),(135,'Montserrat'),(136,'Morocco'),(137,'Mozambique'),(138,' Namibia'),(139,'Nauru'),(140,'Nepal'),(141,'Netherlands'),(142,'Netherlands Anti lles'),(143,'New Caledonia'),(144,'New Zealand'),(145,'Nicaragua'),(146,'Niger') ,(147,'Nigeria'),(148,'Niue'),(149,'Norway'),(150,'Oman'),(151,'Pakistan'),(152, 'Palau'),(153,'Panama'),(154,'Papua New Guinea'),(155,'Paraguay'),(156,'Peru'),( 157,'Philippines'),(158,'Poland'),(159,'Portugal'),(160,'Puerto Rico'),(161,'Qat ar'),(162,'Romania'),(163,'Russian Federation'),(164,'Rwanda'),(165,'Saint Helen a'),(166,'Saint Kitts-Nevis'),(167,'Saint Lucia'),(168,'Saint Pierre and Miquelo

n'),(169,'Saint Vincent and the Grenadines'),(170,'San Marino'),(171,'Saudi Arab ia'),(172,'Senegal'),(173,'Seychelles'),(174,'Sierra Leone'),(175,'Singapore'),( 176,'Slovakia'),(177,'Slovenia'),(178,'Solomon Islands'),(179,'Somalia'),(180,'S outh Africa'),(181,'Spain'),(182,'Sri Lanka'),(183,'Suriname'),(184,'Svalbard'), (185,'Swaziland'),(186,'Sweden'),(187,'Switzerland'),(188,'Syria'),(189,'Tahiti' ),(190,'Taiwan'),(191,'Tajikistan'),(192,'Tanzania'),(193,'Thailand'),(194,'Togo '),(195,'Tonga'),(196,'Trinidad and Tobago'),(197,'Tunisia'),(198,'Turkey'),(199 ,'Turkmenistan'),(200,'Turks and Caicos Islands'),(201,'Tuvalu'),(202,'Uganda'), (203,'Ukraine'),(204,'United Arab Emirates'),(205,'United Kingdom'),(206,'United States'),(207,'Uruguay'),(208,'Uzbekistan'),(209,'Vanuatu'),(210,'Vatican City State'),(211,'Venezuela'),(212,'Vietnam'),(213,'Virgin Islands (U.S.)'),(214,'Wa llis and Futuna'),(215,'Western Sahara'),(216,'Western Samoa'),(217,'Yemen'),(21 8,'Yugoslavia'),(219,'Zambia'),(220,'Zimbabwe'); [2011-12-09 21:10:41.337] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.347] [000037] [MySQL Local] [MYSQL] --- Table structure for table `createfieldauthorisation` -DROP TABLE IF EXISTS `createfieldauthorisation`; [2011-12-09 21:10:41.347] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.357] [000037] [MySQL Local] [MYSQL] CREATE TABLE `createfieldauthorisation` ( `individualid` int(11) unsigned default NULL, `groupid` int(11) unsigned default NULL, `fieldid` int(11) unsigned default NULL, `privilegelevel` char(1) default NULL, `owner` int(11) unsigned default NULL, KEY `individualid` (`individualid`), KEY `groupid` (`groupid`), KEY `fieldid` (`fieldid`), KEY `owner` (`owner`) ) TYPE=InnoDB; [2011-12-09 21:10:41.357] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.367] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `createfieldauthorisation` ---- Table structure for table `createrecordauthorisation` -DROP TABLE IF EXISTS `createrecordauthorisation`; [2011-12-09 21:10:41.367] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.377] [000037] [MySQL Local] [MYSQL] CREATE TABLE `createrecordauthorisation` (

`individualid` int(11) unsigned default NULL, `groupid` int(11) unsigned default NULL, `recordid` int(11) unsigned default NULL, `privilegelevel` char(1) default NULL, `owner` int(11) unsigned default NULL, KEY `individualid` (`individualid`), KEY `groupid` (`groupid`), KEY `recordid` (`recordid`), KEY `owner` (`owner`) ) TYPE=InnoDB; [2011-12-09 21:10:41.377] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.387] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `createrecordauthorisation` ---- Table structure for table `customfield` -DROP TABLE IF EXISTS `customfield`; [2011-12-09 21:10:41.387] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.397] [000037] [MySQL Local] [MYSQL] CREATE TABLE `customfield` ( `CustomFieldID` int(10) unsigned NOT NULL auto_increment, `Name` varchar(25) default NULL, `CustomFieldTypeID` tinyint(4) unsigned default NULL, `FieldType` enum('SCALAR','MULTIPLE') default NULL, `RecordType` int(11) unsigned default NULL, UNIQUE KEY `CustomFieldID` (`CustomFieldID`), KEY `CustomFieldTypeID` (`CustomFieldTypeID`), KEY `RecordType` (`RecordType`) ) TYPE=InnoDB; [2011-12-09 21:10:41.397] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.407] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `customfield` -INSERT INTO `customfield` (`CustomFieldID`, `Name`, `CustomFieldTypeID`, `FieldT ype`, `RecordType`) VALUES (1,'Type',NULL,'MULTIPLE',1),(2,'Industry',NULL,'SCAL AR',1),(3,'Status',NULL,'MULTIPLE',1),(4,'Assistant\'s Name',NULL,'SCALAR',2),(5 ,'Department',NULL,'MULTIPLE',2); [2011-12-09 21:10:41.407] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.417] [000037] [MySQL Local] [MYSQL] --- Table structure for table `customfieldmultiple`

-DROP TABLE IF EXISTS `customfieldmultiple`; [2011-12-09 21:10:41.417] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.427] [000037] [MySQL Local] [MYSQL] CREATE TABLE `customfieldmultiple` ( `CustomFieldID` int(4) unsigned default NULL, `ValueID` int(11) unsigned default NULL, `RecordID` int(11) unsigned default NULL, KEY `CustomFieldID` (`CustomFieldID`), KEY `ValueID` (`ValueID`), KEY `RecordID` (`RecordID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.427] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.437] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `customfieldmultiple` -INSERT INTO `customfieldmultiple` (`CustomFieldID`, `ValueID`, `RecordID`) VALUE S (1,0,1),(3,0,1),(5,0,1),(1,0,2),(3,0,2); [2011-12-09 21:10:41.437] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.447] [000037] [MySQL Local] [MYSQL] --- Table structure for table `customfieldscalar` -DROP TABLE IF EXISTS `customfieldscalar`; [2011-12-09 21:10:41.447] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.457] [000037] [MySQL Local] [MYSQL] CREATE TABLE `customfieldscalar` ( `CustomFieldID` int(11) unsigned default NULL, `RecordID` int(11) unsigned default NULL, `Value` varchar(25) default NULL, KEY `CustomFieldID` (`CustomFieldID`), KEY `RecordID` (`RecordID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.457] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.467] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `customfieldscalar` -INSERT INTO `customfieldscalar` (`CustomFieldID`, `RecordID`, `Value`) VALUES (2 ,1,''),(4,1,''),(2,2,'');

[2011-12-09 21:10:41.467] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.477] [000037] [MySQL Local] [MYSQL] --- Table structure for table `customfieldvalue` -DROP TABLE IF EXISTS `customfieldvalue`; [2011-12-09 21:10:41.477] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.487] [000037] [MySQL Local] [MYSQL] CREATE TABLE `customfieldvalue` ( `ValueID` int(10) unsigned NOT NULL auto_increment, `CustomFieldID` int(11) unsigned default NULL, `Value` varchar(25) default NULL, PRIMARY KEY (`ValueID`), UNIQUE KEY `ValueID` (`ValueID`), KEY `CustomFieldID` (`CustomFieldID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.487] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.497] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `customfieldvalue` -INSERT INTO `customfieldvalue` (`ValueID`, `CustomFieldID`, `Value`) VALUES (1,1 ,'Customer'),(2,1,'Vendor'),(3,1,'Reseller'),(4,3,'Active'),(5,3,'Inactive'),(6, 5,'Information Technology'),(7,5,'Project Management'),(8,5,'Support'),(9,5,'Sal es'),(10,5,'Accounting'); [2011-12-09 21:10:41.497] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.507] [000037] [MySQL Local] [MYSQL] --- Table structure for table `cvfile` -DROP TABLE IF EXISTS `cvfile`; [2011-12-09 21:10:41.507] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.527] [000037] [MySQL Local] [MYSQL] CREATE TABLE `cvfile` ( `FileID` int(11) unsigned NOT NULL auto_increment, `Title` varchar(250) default NULL, `Description` text, `Name` varchar(250) default NULL, `Owner` int(11) unsigned default NULL, `Creator` int(10) unsigned default NULL, `UpdatedBy` int(11) unsigned default NULL, `Created` datetime default NULL,

`Updated` timestamp(14) NOT NULL, `FileSize` float(10,4) default NULL, `Version` varchar(15) default NULL, `Status` enum('DRAFT','PUBLISHED') default NULL, `visibility` enum('PUBLIC','PRIVATE') default NULL, `Author` int(11) unsigned default NULL, `CustomerView` enum('YES','NO') NOT NULL default 'NO', `RelateEntity` int(11) unsigned default NULL, `RelateIndividual` int(11) unsigned default NULL, `IsTemporary` enum('YES','NO') NOT NULL default 'NO', PRIMARY KEY (`FileID`), KEY `Owner` (`Owner`), KEY `Creator` (`Creator`), KEY `UpdatedBy` (`UpdatedBy`), KEY `Author` (`Author`), KEY `RelateEntity` (`RelateEntity`), KEY `RelateIndividual` (`RelateIndividual`) ) TYPE=InnoDB; [2011-12-09 21:10:41.527] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.537] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `cvfile` ---- Table structure for table `cvfilefolder` -DROP TABLE IF EXISTS `cvfilefolder`; [2011-12-09 21:10:41.537] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.547] [000037] [MySQL Local] [MYSQL] CREATE TABLE `cvfilefolder` ( `fileid` int(11) unsigned default NULL, `folderid` int(11) unsigned default NULL, `referencetype` enum('PHYSICAL','VIRTUAL') default NULL, KEY `fileid` (`fileid`), KEY `folderid` (`folderid`) ) TYPE=InnoDB; [2011-12-09 21:10:41.547] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.557] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `cvfilefolder` ---- Table structure for table `cvfilelink` -DROP TABLE IF EXISTS `cvfilelink`;

[2011-12-09 21:10:41.557] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.567] [000037] [MySQL Local] [MYSQL] CREATE TABLE `cvfilelink` ( `FileID` int(11) unsigned NOT NULL default '0', `RecordTypeID` int(11) unsigned NOT NULL default '0', `RecordID` int(11) unsigned NOT NULL default '0', KEY `FileID` (`FileID`), KEY `RecordTypeID` (`RecordTypeID`), KEY `RecordID` (`RecordID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.567] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.577] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `cvfilelink` ---- Table structure for table `cvfolder` -DROP TABLE IF EXISTS `cvfolder`; [2011-12-09 21:10:41.577] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.587] [000037] [MySQL Local] [MYSQL] CREATE TABLE `cvfolder` ( `FolderID` int(11) unsigned NOT NULL auto_increment, `Name` varchar(250) default NULL, `Parent` int(11) unsigned default NULL, `CreatedBy` int(11) unsigned default NULL, `ModifiedBy` int(11) unsigned default NULL, `CreatedOn` datetime default NULL, `ModifiedOn` timestamp(14) NOT NULL, `Description` text, `FullPath` tinytext, `LocationID` int(11) unsigned NOT NULL default '0', `owner` int(11) unsigned default NULL, `visibility` enum('PRIVATE','PUBLIC') default 'PRIVATE', `IsSystem` enum('TRUE','FALSE') default 'FALSE', `leftNav` tinyint(1) NOT NULL default '0', PRIMARY KEY (`FolderID`), KEY `Parent` (`Parent`), KEY `CreatedBy` (`CreatedBy`), KEY `ModifiedBy` (`ModifiedBy`), KEY `LocationID` (`LocationID`), KEY `owner` (`owner`) ) TYPE=InnoDB; [2011-12-09 21:10:41.587] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.597] [000037] [MySQL Local] [MYSQL]

--- Dumping data for table `cvfolder` -INSERT INTO `cvfolder` (`FolderID`, `Name`, `Parent`, `CreatedBy`, `ModifiedBy`, `CreatedOn`, `ModifiedOn`, `Description`, `FullPath`, `LocationID`, `owner`, `v isibility`, `IsSystem`, `leftNav`) VALUES (1,'CV_ROOT',0,2,2,'2003-12-14 23:51:2 5',20031214235125,'',NULL,1,1,'PUBLIC','TRUE',0),(2,'CVFS_ROOT',1,2,2,'2003-12-1 4 23:51:25',20031214235125,'',NULL,1,1,'PUBLIC','TRUE',0),(3,'CVFS_SYSTEM',1,2,2 ,'2003-12-14 23:51:25',20031214235125,'',NULL,1,1,'PUBLIC','TRUE',0),(4,'CVFS_US ER',2,2,2,'2003-12-14 23:51:26',20031214235126,'',NULL,1,1,'PUBLIC','FALSE',0),( 5,'ATTIC',3,2,2,'2003-12-14 23:51:26',20031214235126,'',NULL,1,1,'PUBLIC','TRUE' ,0),(6,'CV_EMAIL_DEFAULT_FOLDER',2,2,2,'2003-12-14 23:51:26',20031214235126,'',N ULL,1,1,'PUBLIC','TRUE',0),(7,'CV_EMPLOYEEHANDBOOK_DEFAULT_FOLDER',2,2,2,'2003-1 2-14 23:51:26',20031214235126,'',NULL,1,1,'PUBLIC','TRUE',0),(8,'admin',4,2,2,'2 003-12-14 23:51:27',20031214235127,'',NULL,1,1,'PUBLIC','FALSE',0),(9,'CV_FILE_D EFAULT_FOLDER',3,2,2,'2003-12-14 23:51:26',20031214235126,'',NULL,1,1,'PUBLIC',' TRUE',0),(10,'Public Folders',2,1,1,NULL,20050713001306,NULL,NULL,1,1,'PUBLIC',' FALSE',1); [2011-12-09 21:10:41.597] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.607] [000037] [MySQL Local] [MYSQL] --- Table structure for table `cvfolderlocation` -DROP TABLE IF EXISTS `cvfolderlocation`; [2011-12-09 21:10:41.607] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.617] [000037] [MySQL Local] [MYSQL] CREATE TABLE `cvfolderlocation` ( `LocationID` int(11) unsigned NOT NULL auto_increment, `Detail` varchar(250) default NULL, PRIMARY KEY (`LocationID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.617] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.627] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `cvfolderlocation` -INSERT INTO `cvfolderlocation` (`LocationID`, `Detail`) VALUES (1,'/var/centravi ew/fs'); [2011-12-09 21:10:41.627] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.637] [000037] [MySQL Local] [MYSQL] --- Table structure for table `cvjoin` -DROP TABLE IF EXISTS `cvjoin`;

[2011-12-09 21:10:41.637] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.647] [000037] [MySQL Local] [MYSQL] CREATE TABLE `cvjoin` ( `tableid1` int(10) unsigned NOT NULL default '0', `tableid2` int(10) unsigned NOT NULL default '0', `fieldid1` int(10) unsigned NOT NULL default '0', `fieldid2` int(10) unsigned NOT NULL default '0', `cvjoin` enum('INNER','LEFT','RIGHT') default NULL, `othertablename` varchar(100) NOT NULL default '', `clause` varchar(150) NOT NULL default '', KEY `tableid1` (`tableid1`), KEY `tableid2` (`tableid2`), KEY `fieldid1` (`fieldid1`), KEY `fieldid2` (`fieldid2`) ) TYPE=InnoDB; [2011-12-09 21:10:41.647] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.657] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `cvjoin` -INSERT INTO `cvjoin` (`tableid1`, `tableid2`, `fieldid1`, `fieldid2`, `cvjoin`, `othertablename`, `clause`) VALUES (1,2,1,13,'LEFT','','AND entity.EntityID = in dividual.Entity'),(1,2,61,12,'INNER','','AND entity.AccountManagerID = individua l.IndividualID'),(1,3,62,3,'INNER','','AND entity.AccountTeamID = GroupTBL.Group ID'),(1,11,1,51,'LEFT','contacttype','AND entity.EntityID = MOCRelate.ContactID AND MOCRelate.ContactType = ContactType.ContactTypeID AND ContactType.Name = \'E ntity\''),(1,12,1,55,'LEFT','contacttype','AND entity.EntityID = addressrelate.C ontact AND addressrelate.ContactType = contacttype.ContactTypeID AND contacttype .Name = \'Entity\''),(1,14,9,59,'INNER','','AND entity.DBase = dbase.DBaseID'),( 2,1,13,1,'RIGHT','','AND entity.EntityID = individual.Entity'),(2,11,12,51,'LEFT ','contacttype','AND individual.IndividualID = mocrelate.ContactID AND mocrelate .ContactType = contacttype.ContactTypeID AND contacttype.Name = \'Individual\'') ,(2,12,12,55,'LEFT','contacttype','AND individual.IndividualID = addressrelate.C ontact AND addressrelate.ContactType = contacttype.ContactTypeID AND contacttype .Name = \'Individual\''),(2,13,12,58,'INNER','','AND individual.IndividualID = m ember.ChildID'),(4,5,32,35,'INNER','','AND address.State = state.StateID'),(4,6, 34,37,'INNER','','And address.Country = country.CountryID'),(12,4,12,27,'INNER', '','AND addressrelate.Address = address.AddressID'),(13,3,57,24,'INNER','','AND member.GroupID = groupTbl.GroupID'),(15,20,71,106,'LEFT','','AND emailmessage.me ssageid = attachment.messageid'),(15,18,63,85,'INNER','','AND emailmessage.accou ntid = emailaccount.accountid'),(15,17,71,82,'INNER','','AND emailmessage.messag eid = emailstore.messageid'),(15,19,71,99,'INNER','','AND emailmessage.messageid = emailrecipient.messageid'),(15,2,66,12,'INNER','','AND emailmessage.fromindiv idual = emailrecipient.individualid'),(15,2,72,19,'LEFT','','AND emailmessage.ow ner = individual.owner'),(15,2,65,20,'INNER','','AND emailmessage.createdby = in dividual.createdby'),(15,16,63,79,'INNER','','AND emailmessage.accountid = email folder.accountid'),(17,16,83,78,'INNER','','AND emailstore.folderid = emailfolde r.folderid'),(2,19,12,100,'INNER','','AND individual.individualid = emailrecipie nt.recipientid AND emailrecipient.recipientlsgroup = \'NO\''),(19,3,100,24,'LEFT ','','AND emailrecipient.recipientid = group.groupid AND emailrecipient.recipien tlsgroup = \'YES\''),(20,33,104,162,'INNER','','AND attachment.fileid = file.fil eid'),(2,18,19,92,'LEFT','','AND emailaccount.owner = individual.owner'),(23,107 ,129,480,'INNER','','AND calltype.calltypeid = call.calltype'),(2,22,12,126,'LEF

T','','AND individual.individualid = attendee.individualid AND attendee.type=\'R EQUIRED\''),(2,21,12,118,'LEFT','','AND individual.individualid = activity.owner '),(40,21,523,107,'LEFT','','AND literaturerequest.activityid = activity.activit yid'),(96,21,426,107,'LEFT','','AND opportunity.activityid = activity.activityid '),(49,21,465,107,'LEFT','','AND task.activityid = activity.activityid'),(22,21, 125,107,'LEFT','','AND attendee.activityid = activity.activityid'),(69,28,244,13 7,'LEFT','','AND record.recordid = activitylink.recordid'),(29,21,139,125,'LEFT' ,'','AND recurrence.activityid = activity.activityid'),(31,21,149,139,'INNER','' ,'AND activityaction.activityid = activity.activityid'),(106,21,477,123,'INNER', '','AND activitytype.typeid = activity.type'),(110,21,486,121,'INNER','','AND ac tivitystatus.statusid = status.status'),(109,21,483,119,'INNER','','AND activity prority.priorityid = activity.priority'),(108,22,481,127,'INNER','','AND attende estatus.statusid = attendee.status'),(107,21,479,107,'LEFT','','AND call.activit yid = activity.activityid'),(24,21,577,107,'LEFT','','AND appointment.activityid = activity.activityid'),(25,21,579,107,'LEFT','','AND meeting.activityid = acti vity.activityid'),(25,26,581,131,'LEFT','','AND meeting.resourceid = activityres ources.activityresourceid'),(24,26,578,131,'LEFT','','AND appointment.resourceid = activityresources.activityresourceid'),(31,32,148,151,'INNER','','AND activit yaction.actionid = action.actionid'),(29,30,141,147,'LEFT','','AND recurrence.re currenceid = recurexcept.recurrenceid'),(111,2,492,19,'LEFT','','AND note.owner= individual.individualid'),(111,2,491,12,'LEFT','','AND note.creator= individual .individualid'),(111,2,495,12,'LEFT','','AND note.updatedby = individual.individ ualid'),(111,112,488,496,'LEFT','','AND note.noteid = notelink.noteid'),(112,69, 498,244,'LEFT','','AND notelink.recordid = record.recordid'),(33,2,166,19,'LEFT' ,'','AND file.owner = individual.owner'),(33,2,172,12,'LEFT','','AND file.update dby = individual.individualid'),(33,2,159,12,'LEFT','','AND file.creator = indiv idual.individualid'),(33,34,162,175,'LEFT','','AND file.fileid = filefolder.file id'),(34,42,176,181,'INNER','','AND filefolder.folderid = folder.folderid'),(96, 1,429,1,'LEFT','','AND opportunity.entityid = entity.entityid'),(96,2,430,12,'LE FT','','AND opportunity.individualid = individual.individualid'),(96,21,426,107, 'LEFT','','AND opportunity.activityid = activity.activityid'),(96,100,425,446,'L EFT','','AND opportunity.opportunityid = opportunitylink.opportunityid'),(96,100 ,436,449,'INNER','','AND opportunity.probablity = salesprobablity.probablityid') ,(96,97,431,440,'INNER','','AND opportunity.typeid = salestype.salestypeid'),(96 ,98,433,442,'INNER','','AND opportunity.stage = salesstage.salesstageid'),(96,99 ,432,444,'INNER','','AND opportunity.status = salesstatus.salesstatusid'),(69,10 0,242,448,'INNER','','AND opportunitylink.recordid = record.recordid'),(48,49,45 3,466,'LEFT','','AND project.projectid = task.projectid'),(48,105,453,474,'LEFT' ,'','AND project.projectid = projectlink.projectid'),(48,2,460,19,'LEFT','','AND project.owner = individual.individualid'),(48,2,461,12,'LEFT','','AND project.c reatedby = individual.individualid'),(48,2,462,12,'LEFT','','AND project.modifie dby = individual.individualid'),(49,50,465,472,'INNER','','AND task.taskid = tas kassigned.taskid'),(2,50,12,473,'INNER','','AND individual.individualid = taskas signed.individualid'),(69,105,244,476,'LEFT','','AND record.recordid = projectli nk.recordid'),(37,1,564,10,'LEFT','','AND marketinglist.listid = entity.list'),( 37,2,572,19,'LEFT','','AND marketinglist.owner = individual.owner'),(37,2,573,12 ,'LEFT','','AND marketinglist.creator = individual.individualid'),(37,2,574,12,' LEFT','','AND marketinglist.modifiedby = individual.individualid'),(2,43,19,541, 'LEFT','','AND individual.owner = event.owner'),(2,43,12,542,'LEFT','','AND indi vidual.individualid = event.creator'),(2,43,12,544,'LEFT','','AND individual.ind ividualid = event.modifiedby'),(2,40,12,527,'LEFT','','AND individual.individual id = literaturerequest.requestedby'),(40,41,524,529,'LEFT','','AND literaturereq uest.literatureid = literature.literatureid'),(40,42,528,533,'LEFT','','AND lite raturerequest.deliverymethod = deliverymethod.deliveryid'),(43,44,535,546,'INNER ','','AND event.eventid = eventregister.eventid'),(44,2,547,12,'INNER','','AND e ventregister.individualid = individual.individualid'),(2,45,554,19,'LEFT','','AN D individual.owner = promotion.owner'),(2,45,12,555,'LEFT','','AND individual.in dividualid = promotion.creator'),(2,45,12,556,'LEFT','','AND individual.individu alid = promotion.modifiedby'),(45,46,548,559,'LEFT','','AND promotion.promotioni d = promoitem.promotionid'),(46,78,560,297,'INNER','','AND promoitem.itemid = it

em.itemid'),(52,1,585,1,'LEFT','','AND ticket.entityid = entity.entityid'),(52,5 4,588,595,'LEFT','','AND ticket.status = supportstatus.statusid'),(52,56,589,607 ,'LEFT','','AND ticket.priority = supportpriority.priorityid'),(52,53,582,595,'L EFT','','AND ticket.ticketid = thread.ticketid'),(52,2,590,19,'LEFT','','AND tic ket.owner = individual.owner'),(52,2,592,12,'LEFT','','AND ticket.createdby = in dividual.individualid'),(52,2,593,12,'LEFT','','AND ticket.modifiedby = individu al.individualid'),(52,55,582,604,'LEFT','','AND ticket.ticketid = ticketlink.tic ketid'),(53,2,602,12,'LEFT','','AND thread.creator = individual.individualid'),( 55,69,606,244,'LEFT','','AND ticketlink.recordid = record.recordid'),(69,58,244, 620,'LEFT','','AND record.recordid = knowledgebaselink.recordid'),(57,2,617,19,' LEFT','','AND FAQ.owner = individual.owner'),(57,2,612,12,'LEFT','','AND FAQ.cre atedby = individual.individualid'),(57,2,614,12,'LEFT','','AND FAQ.updatedby = i ndividual.individualid'),(57,59,616,612,'LEFT','','AND FAQ.status = contentstatu s.statusid'),(60,2,631,19,'LEFT','','AND knowledgebase.owner = individual.owner' ),(60,2,626,12,'LEFT','','AND knowledgebase.createdby = individual.individualid' ),(60,2,628,12,'LEFT','','AND knowledgebase.updatedby = individual.individualid' ),(60,59,630,612,'LEFT','','AND knowledgebase.status = contentstatus.statusid'), (60,61,632,633,'LEFT','','AND knowledgebase.category = category.catid'),(93,94,4 03,415,'LEFT','','AND timeslip.timeslipid = timeentry.timeslipid'),(93,2,406,19, 'LEFT','','AND timeslip.owner = individual.owner'),(93,2,407,12,'LEFT','','AND t imeslip.creator = individual.individualid'),(93,2,408,12,'LEFT','','AND timeslip .modifiedby = individual.individualid'),(93,95,413,423,'LEFT','','AND timeslip.t imestatus = status.statusid'),(94,52,417,582,'LEFT','','AND timeentry.ticketid = ticket.ticketid'),(94,48,416,453,'LEFT','','AND timeentry.projectid = project.p rojectid'),(73,74,258,280,'LEFT','','AND order.orderid = orderitem.orderid'),(73 ,77,264,294,'LEFT','','AND order.status = accountingstatus.statusid'),(73,79,265 ,309,'LEFT','','AND order.terms = accountingterms.termsid'),(73,84,258,324,'LEFT ','','AND order.orderid = invoice.order'),(73,113,268,499,'LEFT','','AND order.p roposal = proposal.proposalid'),(74,78,281,297,'LEFT','','AND orderitem.itemid = item.itemid'),(77,88,294,369,'LEFT','','AND accountingstatus.statusid = purchas eorder.status'),(77,84,294,327,'LEFT','','AND accountingstatus.statusid = invoic e.status'),(79,84,309,328,'LEFT','','AND accountingterms.termsid = invoice.terms '),(75,76,290,291,'LEFT','','AND inventory.locationid = location.locationid'),(7 5,78,289,297,'LEFT','','AND inventory.item = item.itemid'),(78,81,302,318,'LEFT' ,'','AND item.taxclass = taxclass.taxclassid'),(78,80,303,312,'LEFT','','AND ite m.type = itemtype.itemtypeid'),(78,90,297,388,'LEFT','','AND item.itemid = purch aseorderitem.itemid'),(81,82,315,318,'LEFT','','AND taxclass.taxclassid = taxmat rix.taxclassid'),(82,83,319,321,'LEFT','','AND taxmatrix.taxjurisdictionid = tax jurisdiction.taxjurisdictionid'),(88,90,354,387,'LEFT','','AND purchaseorder.pur chaseorderid = purchaseorderitem.orderid'),(89,92,374,398,'LEFT','','AND expense .expenseid = expenseitem.expenseid'),(84,85,324,336,'LEFT','','AND invoice.invoi ceid = applypayment.invoiceid'),(86,85,338,335,'LEFT','','AND payment.paymentid = applypayment.paymentid'),(86,87,342,352,'LEFT','','AND payment.paymentmethod = paymentmethod.methodid'),(48,116,645,643,'LEFT','','AND project.statusid=projec tstatus.statusid'),(48,1,453,1,'LEFT','projectlink','AND project.projectid=proje ctlink.projectid and projectlink.recordid=entity.entityid'); [2011-12-09 21:10:41.657] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.667] [000037] [MySQL Local] [MYSQL] --- Table structure for table `cvorder` -DROP TABLE IF EXISTS `cvorder`; [2011-12-09 21:10:41.667] [000037] [MySQL Local] [MYSQL] 1046 - No database selected

[2011-12-09 21:10:41.677] [000037] [MySQL Local] [MYSQL] CREATE TABLE `cvorder` ( `orderid` int(11) unsigned NOT NULL auto_increment, `title` varchar(25) default NULL, `description` text, `entityid` int(11) unsigned default NULL, `billindividual` int(11) unsigned default NULL, `shipindividual` int(11) unsigned default NULL, `billaddress` int(11) unsigned default NULL, `shipaddress` int(11) unsigned default NULL, `status` int(11) unsigned default NULL, `terms` int(11) unsigned default NULL, `accountmgr` int(11) unsigned default NULL, `project` int(11) unsigned default NULL, `proposal` int(11) unsigned default NULL, `subtotal` float default NULL, `tax` float default NULL, `shipping` float default NULL, `discount` float default NULL, `total` float default NULL, `creator` int(11) unsigned default NULL, `owner` int(11) unsigned default NULL, `modifiedby` int(11) unsigned default NULL, `created` datetime default NULL, `modified` timestamp(14) NOT NULL, `orderdate` date default '0000-00-00', `orderstatus` enum('Active','Deleted') NOT NULL default 'Active', `invoiceIsGenerated` enum('YES','NO') NOT NULL default 'NO', `ponumber` varchar(25) default NULL, PRIMARY KEY (`orderid`), KEY `entityid` (`entityid`), KEY `billindividual` (`billindividual`), KEY `shipindividual` (`shipindividual`), KEY `billaddress` (`billaddress`), KEY `shipaddress` (`shipaddress`), KEY `status` (`status`), KEY `terms` (`terms`), KEY `accountmgr` (`accountmgr`), KEY `project` (`project`), KEY `proposal` (`proposal`), KEY `creator` (`creator`), KEY `owner` (`owner`), KEY `modifiedby` (`modifiedby`) ) TYPE=InnoDB; [2011-12-09 21:10:41.677] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.697] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `cvorder` ---- Table structure for table `cvtable` -DROP TABLE IF EXISTS `cvtable`;

[2011-12-09 21:10:41.697] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.707] [000037] [MySQL Local] [MYSQL] CREATE TABLE `cvtable` ( `tableid` int(10) unsigned NOT NULL auto_increment, `moduleid` int(10) unsigned default NULL, `name` varchar(25) NOT NULL default '', PRIMARY KEY (`tableid`), KEY `moduleid` (`moduleid`) ) TYPE=InnoDB; [2011-12-09 21:10:41.707] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.717] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `cvtable` -INSERT INTO `cvtable` (`tableid`, `moduleid`, `name`) VALUES (1,14,'entity'),(2, 15,'individual'),(3,16,'grouptbl'),(4,1,'address'),(5,1,'state'),(6,1,'country') ,(7,1,'contacttype'),(8,1,'addresstype'),(9,1,'moctype'),(10,1,'methodofcontact' ),(11,1,'mocrelate'),(12,1,'addressrelate'),(13,1,'member'),(14,1,'dbase'),(15,2 ,'emailmessage'),(16,2,'emailfolder'),(17,2,'emailstore'),(18,2,'emailaccount'), (19,2,'emailrecipient'),(20,2,'attachment'),(21,3,'activity'),(22,3,'attendee'), (23,3,'calltype'),(24,3,'appointment'),(25,3,'meeting'),(26,3,'activityresources '),(27,3,'resourcerelate'),(28,3,'activitylink'),(29,3,'recurrence'),(30,3,'recu rexcept'),(31,3,'activityaction'),(32,3,'action'),(33,6,'cvfile'),(34,6,'cvfilef older'),(35,6,'cvfolderlocation'),(36,6,'cvfolder'),(37,8,'marketinglist'),(40,8 ,'literaturerequest'),(41,8,'literature'),(42,8,'deliverymethod'),(43,8,'event') ,(44,8,'eventregister'),(45,8,'promotion'),(46,8,'promoitem'),(48,9,'project'),( 49,9,'task'),(50,9,'taskassigned'),(51,9,'projectlink'),(52,39,'ticket'),(53,10, 'thread'),(54,10,'supportstatus'),(55,10,'ticketlink'),(56,10,'supportpriority') ,(57,10,'faq'),(58,10,'knoledgebaselink'),(59,10,'contentstatus'),(60,10,'knowle dgebase'),(61,10,'category'),(62,11,'role'),(63,11,'user'),(64,11,'alert'),(65,1 1,'moduleauthorization'),(66,11,'recordauthorization'),(67,11,'fieldauthorizatio n'),(68,11,'module'),(69,11,'record'),(70,11,'field'),(71,11,'createrecordauthor ization'),(72,11,'createfieldauthorization'),(73,12,'order'),(74,12,'orderitem') ,(75,12,'p'),(76,12,'location'),(77,12,'accountingstatus'),(78,12,'item'),(79,12 ,'accountingterms'),(80,12,'itemtype'),(81,12,'taxclass'),(82,12,'taxmatrix'),(8 3,12,'taxjurisdiction'),(84,12,'invoice'),(85,12,'applypayment'),(86,12,'payment '),(87,12,'paymentmethod'),(88,12,'purchaseorder'),(89,12,'expense'),(90,12,'pur chaseorderitem'),(91,12,'glaccount'),(92,12,'expenseitem'),(93,13,'timeslip'),(9 4,13,'timeentry'),(95,13,'timestatus'),(96,7,'opportunity'),(97,7,'salestype'),( 98,7,'salesstage'),(99,7,'salesstatus'),(100,7,'opportunitylink'),(101,7,'salesp robablity'),(106,3,'activitytype'),(107,3,'call'),(108,3,'attendeestatus'),(109, 3,'activitypriority'),(110,3,'activitystatus'),(111,5,'note'),(112,5,'notelink') ,(113,7,'proposal'),(114,7,'proposallink'),(115,7,'proposalitem'),(116,9,'projec tstatus'); [2011-12-09 21:10:41.717] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.727] [000037] [MySQL Local] [MYSQL] --- Table structure for table `cvtableextra` -DROP TABLE IF EXISTS `cvtableextra`;

[2011-12-09 21:10:41.727] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.737] [000037] [MySQL Local] [MYSQL] CREATE TABLE `cvtableextra` ( `TableId` int(10) unsigned default NULL, `FullName` varchar(55) default NULL, `Appearance` enum('TOP','BOTTOM','BOTH') default 'BOTH', UNIQUE KEY `TableId` (`TableId`), CONSTRAINT `0_21439` FOREIGN KEY (`TableId`) REFERENCES `cvtable` (`tableid`) ) TYPE=InnoDB; [2011-12-09 21:10:41.737] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.747] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `cvtableextra` -INSERT INTO `cvtableextra` (`TableId`, `FullName`, `Appearance`) VALUES (1,'enti ty','BOTH'),(2,'individual','BOTH'),(3,'grouptbl','BOTH'),(4,'address','BOTH'),( 5,'state','BOTH'),(6,'country','BOTH'),(7,'contacttype','BOTH'),(8,'addresstype' ,'BOTH'),(9,'moctype','BOTH'),(10,'methodofcontact','BOTH'),(11,'mocrelate','BOT H'),(12,'addressrelate','BOTH'),(13,'member','BOTH'),(14,'dbase','BOTH'),(15,'em ailmessage','BOTH'),(16,'emailfolder','BOTH'),(17,'emailstore','BOTH'),(18,'emai laccount','BOTH'),(19,'emailrecipient','BOTH'),(20,'attachment','BOTH'),(21,'act ivity','BOTH'),(22,'attendee','BOTH'),(23,'calltype','BOTH'),(24,'appointment',' BOTH'),(25,'meeting','BOTH'),(26,'activityresources','BOTH'),(27,'resourcerelate ','BOTH'),(28,'activitylink','BOTH'),(29,'recurrence','BOTH'),(30,'recurexcept', 'BOTH'),(31,'activityaction','BOTH'),(32,'action','BOTH'),(33,'cvfile','BOTH'),( 34,'cvfilefolder','BOTH'),(35,'cvfolderlocation','BOTH'),(36,'cvfolder','BOTH'), (37,'marketinglist','BOTH'),(40,'literaturerequest','BOTH'),(41,'literature','BO TH'),(42,'deliverymethod','BOTH'),(43,'event','BOTH'),(44,'eventregister','BOTH' ),(45,'promotion','BOTH'),(46,'promoitem','BOTH'),(48,'project','BOTH'),(49,'tas k','BOTH'),(50,'taskassigned','BOTH'),(51,'projectlink','BOTH'),(52,'ticket','BO TH'),(53,'thread','BOTH'),(54,'supportstatus','BOTH'),(55,'ticketlink','BOTH'),( 56,'supportpriority','BOTH'),(57,'faq','BOTH'),(58,'knoledgebaselink','BOTH'),(5 9,'contentstatus','BOTH'),(60,'knowledgebase','BOTH'),(61,'category','BOTH'),(62 ,'role','BOTH'),(63,'user','BOTH'),(64,'alert','BOTH'),(65,'moduleauthorization' ,'BOTH'),(66,'recordauthorization','BOTH'),(67,'fieldauthorization','BOTH'),(68, 'module','BOTH'),(69,'record','BOTH'),(70,'field','BOTH'),(71,'createrecordautho rization','BOTH'),(72,'createfieldauthorization','BOTH'),(73,'order','BOTH'),(74 ,'orderitem','BOTH'),(75,'p','BOTH'),(76,'location','BOTH'),(77,'accountingstatu s','BOTH'),(78,'item','BOTH'),(79,'accountingterms','BOTH'),(80,'itemtype','BOTH '),(81,'taxclass','BOTH'),(82,'taxmatrix','BOTH'),(83,'taxjurisdiction','BOTH'), (84,'invoice','BOTH'),(85,'applypayment','BOTH'),(86,'payment','BOTH'),(87,'paym entmethod','BOTH'),(88,'purchaseorder','BOTH'),(89,'expense','BOTH'),(90,'purcha seorderitem','BOTH'),(91,'glaccount','BOTH'),(92,'expenseitem','BOTH'),(93,'time slip','BOTH'),(94,'timeentry','BOTH'),(95,'timestatus','BOTH'),(96,'opportunity' ,'BOTH'),(97,'salestype','BOTH'),(98,'salesstage','BOTH'),(99,'salesstatus','BOT H'),(100,'opportunitylink','BOTH'),(101,'salesprobablity','BOTH'),(106,'activity type','BOTH'),(107,'call','BOTH'),(108,'attendeestatus','BOTH'),(109,'activitypr iority','BOTH'),(110,'activitystatus','BOTH'),(111,'note','BOTH'),(112,'notelink ','BOTH'),(113,'proposal','BOTH'),(114,'proposallink','BOTH'),(115,'proposalitem ','BOTH'),(116,'projectstatus','BOTH'); [2011-12-09 21:10:41.747] [000037] [MySQL Local] [MYSQL] 1046 - No database selected

[2011-12-09 21:10:41.757] [000037] [MySQL Local] [MYSQL] --- Table structure for table `defaultprivilege` -DROP TABLE IF EXISTS `defaultprivilege`; [2011-12-09 21:10:41.757] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.767] [000037] [MySQL Local] [MYSQL] CREATE TABLE `defaultprivilege` ( `DefaultPrivilegeId` int(10) unsigned NOT NULL auto_increment, `OwnerId` int(10) unsigned NOT NULL default '0', `IndividualId` int(10) unsigned NOT NULL default '0', `PrivilegeLevel` tinyint(4) NOT NULL default '0', PRIMARY KEY (`DefaultPrivilegeId`), KEY `OwnerId` (`OwnerId`), KEY `IndividualId` (`IndividualId`), CONSTRAINT `0_21441` FOREIGN KEY (`OwnerId`) REFERENCES `individual` (`Individ ualID`) ON DELETE CASCADE, CONSTRAINT `0_21442` FOREIGN KEY (`IndividualId`) REFERENCES `individual` (`In dividualID`) ON DELETE CASCADE ) TYPE=InnoDB; [2011-12-09 21:10:41.767] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.777] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `defaultprivilege` ---- Table structure for table `defaultrecordauthorisation` -DROP TABLE IF EXISTS `defaultrecordauthorisation`; [2011-12-09 21:10:41.777] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.797] [000037] [MySQL Local] [MYSQL] CREATE TABLE `defaultrecordauthorisation` ( `recordid` int(11) unsigned default NULL, `recordtypeid` int(11) unsigned default NULL, `privilegelevel` tinyint(4) NOT NULL default '0', KEY `recordid` (`recordid`), KEY `recordtypeid` (`recordtypeid`) ) TYPE=InnoDB; [2011-12-09 21:10:41.797] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.807] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `defaultrecordauthorisation` --

INSERT INTO `defaultrecordauthorisation` (`recordid`, `recordtypeid`, `privilege level`) VALUES (1,76,30),(2,76,30),(3,76,30),(4,76,30),(5,76,10),(6,76,10),(7,76 ,30),(1,32,30),(9,76,20); [2011-12-09 21:10:41.807] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.817] [000037] [MySQL Local] [MYSQL] --- Table structure for table `defaultviews` -DROP TABLE IF EXISTS `defaultviews`; [2011-12-09 21:10:41.817] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.827] [000037] [MySQL Local] [MYSQL] CREATE TABLE `defaultviews` ( `listtype` varchar(30) NOT NULL default '', `viewid` int(10) unsigned default NULL, PRIMARY KEY (`listtype`), KEY `viewid` (`viewid`) ) TYPE=InnoDB; [2011-12-09 21:10:41.827] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.837] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `defaultviews` -INSERT INTO `defaultviews` (`listtype`, `viewid`) VALUES ('Entity',1),('Individu al',3),('Group',4),('GroupMember',5),('AllActivity',6),('Address',7),('Appointme nt',8),('BottomIndividual',9),('Call',10),('CustomField',11),('Email',12),('File ',13),('ForecastSales',14),('LiteratureRequests',17),('Meeting',18),('MOC',19),( 'MultiActivity',20),('NextAction',21),('Note',22),('Rule',23),('Tasks',24),('ToD o',25),('EmailLookup',30),('Ticket',66),('FAQ',70),('KnowledgeBase',71),('Litera tureFulfillment',72),('Event',73),('GLAccount',74),('Marketing',75),('Promotion' ,76),('Item',77),('Inventory',79),('Order',81),('Payment',82),('Expense',83),('P urchaseOrder',84),('VolumeDiscount',85),('Vendor',86),('InvoiceHistory',87),('Bo ttomTask',88),('BottomTimeslip',89),('Task',90),('Project',91),('Timeslip',92),( 'Opportunity',93),('Proposal',94),('ActivityTask',100),('BottomMultiActivity',10 1),('BottomContacts',104),('BottomFiles',105),('BottomNotes',106),('CustomFields ',110),('Employee',170),('TimeSheet',171),('Expenses',172),('EmployeeHandbook',1 73),('USER',174),('SavedSearch',175),('CustomView',177),('SecurityProfile',179), ('CVAttic',180),('CVGarbage',181),('History',182),('EventAtendees',183),('Standa rdReport',185),('AdHocReport',186),('CustomReport',187),('ReportResult',188),('M arketingListMembers',189),('Literature',190),('EntityMerge',191),('BottomProposa l',192),('Template',193),('IndividualMerge',194); [2011-12-09 21:10:41.837] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.847] [000037] [MySQL Local] [MYSQL] --- Table structure for table `delegation` --

DROP TABLE IF EXISTS `delegation`; [2011-12-09 21:10:41.847] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.857] [000037] [MySQL Local] [MYSQL] CREATE TABLE `delegation` ( `delegationid` int(10) unsigned NOT NULL auto_increment, `fromuser` int(10) unsigned NOT NULL default '0', `touser` int(10) unsigned NOT NULL default '0', `moduleid` int(10) unsigned NOT NULL default '0', `righttype` enum('VIEW','SEND','SCHEDULE') NOT NULL default 'VIEW', PRIMARY KEY (`delegationid`), KEY `fromuser` (`fromuser`), KEY `touser` (`touser`), KEY `moduleid` (`moduleid`) ) TYPE=InnoDB; [2011-12-09 21:10:41.857] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.867] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `delegation` ---- Table structure for table `deliverymethod` -DROP TABLE IF EXISTS `deliverymethod`; [2011-12-09 21:10:41.867] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.877] [000037] [MySQL Local] [MYSQL] CREATE TABLE `deliverymethod` ( `DeliveryID` int(10) unsigned NOT NULL auto_increment, `Name` varchar(25) NOT NULL default '', PRIMARY KEY (`DeliveryID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.877] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.887] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `deliverymethod` -INSERT INTO `deliverymethod` (`DeliveryID`, `Name`) VALUES (1,'Email'),(2,'Fax') ,(3,'Mail'),(4,'Postal'); [2011-12-09 21:10:41.887] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.907] [000037] [MySQL Local] [MYSQL] --

-- Table structure for table `emailaccount` -DROP TABLE IF EXISTS `emailaccount`; [2011-12-09 21:10:41.907] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.917] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailaccount` ( `AccountID` int(11) unsigned NOT NULL auto_increment, `Owner` int(11) unsigned default NULL, `Name` varchar(50) default NULL, `Login` varchar(50) default NULL, `Password` varchar(25) default NULL, `SMTPServer` varchar(50) default NULL, `ServerType` enum('imap','pop3') default NULL, `LeaveOnServer` enum('YES','NO') default NULL, `Address` varchar(100) default NULL, `ReplyTo` varchar(100) default NULL, `Signature` text, `Default` enum('YES','NO') default 'NO', `mailserver` varchar(50) default NULL, `lastfetchedcount` int(11) default NULL, `lastfetcheddate` datetime default NULL, `lastuid` varchar(20) default NULL, `Port` int(4) unsigned NOT NULL default '125', `SecureConnectionIfPossible` enum('NO','YES') NOT NULL default 'NO', `ForceSecureConnection` enum('NO','YES') NOT NULL default 'NO', `SMTPRequiresAuthentication` enum('NO','YES') NOT NULL default 'NO', `POPBeforeSMTP` enum('NO','YES') NOT NULL default 'NO', PRIMARY KEY (`AccountID`), KEY `Owner` (`Owner`) ) TYPE=InnoDB; [2011-12-09 21:10:41.917] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.927] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emailaccount` ---- Table structure for table `emailaction` -DROP TABLE IF EXISTS `emailaction`; [2011-12-09 21:10:41.927] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.937] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailaction` ( `RuleID` int(11) default NULL, `ActionName` enum('MOVE','DELETE','MARK_AS_READ') default NULL, `TargetID` int(11) default NULL, KEY `RuleID` (`RuleID`), KEY `TargetID` (`TargetID`)

) TYPE=InnoDB; [2011-12-09 21:10:41.937] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.947] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emailaction` ---- Table structure for table `emailcomposition` -DROP TABLE IF EXISTS `emailcomposition`; [2011-12-09 21:10:41.947] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.957] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailcomposition` ( `individualid` int(10) unsigned default NULL, `composestyle` enum('TEXT','HTML') default NULL, KEY `individualid` (`individualid`) ) TYPE=InnoDB ROW_FORMAT=DYNAMIC; [2011-12-09 21:10:41.957] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.967] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emailcomposition` ---- Table structure for table `emaildelegation` -DROP TABLE IF EXISTS `emaildelegation`; [2011-12-09 21:10:41.967] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.977] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emaildelegation` ( `individualID` int(11) unsigned NOT NULL default '0', `delegatorID` int(11) unsigned NOT NULL default '0', UNIQUE KEY `delegationID` (`individualID`,`delegatorID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.977] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.987] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emaildelegation` --

--- Table structure for table `emailfolder` -DROP TABLE IF EXISTS `emailfolder`; [2011-12-09 21:10:41.987] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:41.997] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailfolder` ( `Parent` int(11) unsigned default NULL, `FolderID` int(11) unsigned NOT NULL auto_increment, `AccountID` int(11) unsigned default NULL, `Name` varchar(25) default NULL, `Ftype` enum('SYSTEM','USER') default NULL, `FullName` varchar(255) default NULL, PRIMARY KEY (`FolderID`), KEY `Parent` (`Parent`), KEY `AccountID` (`AccountID`) ) TYPE=InnoDB; [2011-12-09 21:10:41.997] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.007] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emailfolder` -INSERT INTO `emailfolder` (`Parent`, `FolderID`, `AccountID`, `Name`, `Ftype`, ` FullName`) VALUES (0,1,1,'root','SYSTEM',NULL); [2011-12-09 21:10:42.007] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.017] [000037] [MySQL Local] [MYSQL] --- Table structure for table `emailmessage` -DROP TABLE IF EXISTS `emailmessage`; [2011-12-09 21:10:42.017] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.027] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailmessage` ( `MessageID` int(11) unsigned NOT NULL auto_increment, `MessageDate` datetime default NULL, `MailFrom` varchar(255) default NULL, `FromIndividual` int(11) unsigned default NULL, `ReplyTo` varchar(255) default NULL, `Subject` text, `Headers` text, `Owner` int(11) unsigned default NULL, `CreatedBy` int(11) unsigned default NULL, `size` int(11) default NULL, `Priority` enum('HIGH','MEDIUM','LOW') default NULL,

`Importance` enum('YES','NO') default NULL, `Body` text, `AccountID` int(11) unsigned default NULL, `UID` varchar(22) default NULL, `LocallyDeleted` enum('NO','YES') NOT NULL default 'NO', `LocallyModified` enum('NO','YES') NOT NULL default 'NO', `MessageRead` enum('NO','YES') NOT NULL default 'NO', `MovedToFolder` int(11) unsigned default '0', `CopiedToFolder` int(11) unsigned default '0', `contentType` enum('text/plain','text/html') NOT NULL default 'text/plain', `private` enum('YES','NO') default 'NO', `ToList` varchar(255) default NULL, PRIMARY KEY (`MessageID`), KEY `FromIndividual` (`FromIndividual`), KEY `Owner` (`Owner`), KEY `CreatedBy` (`CreatedBy`), KEY `AccountID` (`AccountID`) ) TYPE=InnoDB; [2011-12-09 21:10:42.027] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.037] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emailmessage` ---- Table structure for table `emailmessagefolder` -DROP TABLE IF EXISTS `emailmessagefolder`; [2011-12-09 21:10:42.037] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.047] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailmessagefolder` ( `MessageID` int(11) unsigned default NULL, `FolderID` int(11) unsigned default NULL, UNIQUE KEY `SearchModuleID` (`MessageID`,`FolderID`), KEY `MessageID` (`MessageID`), KEY `FolderID` (`FolderID`), CONSTRAINT `0_21617` FOREIGN KEY (`MessageID`) REFERENCES `emailmessage` (`Mes sageID`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `0_21618` FOREIGN KEY (`FolderID`) REFERENCES `emailfolder` (`Folde rID`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; [2011-12-09 21:10:42.047] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.057] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emailmessagefolder` ---

-- Table structure for table `emailpreference` -DROP TABLE IF EXISTS `emailpreference`; [2011-12-09 21:10:42.057] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.067] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailpreference` ( `individualid` int(11) default NULL, `composestyle` enum('TEXT','HTML') default NULL, KEY `individualid` (`individualid`) ) TYPE=InnoDB; [2011-12-09 21:10:42.067] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.077] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emailpreference` ---- Table structure for table `emailrecipient` -DROP TABLE IF EXISTS `emailrecipient`; [2011-12-09 21:10:42.077] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.087] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailrecipient` ( `MessageID` int(11) unsigned default NULL, `RecipientID` int(11) unsigned default NULL, `Address` varchar(255) default NULL, `RecipientType` enum('TO','CC','BCC','FROM') default NULL, `RecipientIsGroup` enum('YES','NO') default NULL, KEY `MessageID` (`MessageID`), KEY `RecipientID` (`RecipientID`) ) TYPE=InnoDB; [2011-12-09 21:10:42.087] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.097] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emailrecipient` ---- Table structure for table `emailrule` -DROP TABLE IF EXISTS `emailrule`; [2011-12-09 21:10:42.097] [000037] [MySQL Local] [MYSQL]

1046 - No database selected [2011-12-09 21:10:42.107] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailrule` ( `ruleID` int(11) unsigned NOT NULL auto_increment, `accountID` int(11) default NULL, `name` varchar(50) default NULL, `description` varchar(200) default NULL, `enabled` enum('YES','NO') default NULL, PRIMARY KEY (`ruleID`), KEY `accountID` (`accountID`) ) TYPE=InnoDB; [2011-12-09 21:10:42.107] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.117] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emailrule` ---- Table structure for table `emailruleaction` -DROP TABLE IF EXISTS `emailruleaction`; [2011-12-09 21:10:42.117] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.127] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailruleaction` ( `ruleID` int(11) unsigned NOT NULL default '0', `actionType` enum('MOVE','MARK','DEL') NOT NULL default 'MOVE', `folderID` int(11) unsigned NOT NULL default '0', KEY `ruleID` (`ruleID`), KEY `folderID` (`folderID`), CONSTRAINT `0_21655` FOREIGN KEY (`ruleID`) REFERENCES `emailrule` (`ruleID`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; [2011-12-09 21:10:42.127] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.147] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emailruleaction` ---- Table structure for table `emailrulecriteria` -DROP TABLE IF EXISTS `emailrulecriteria`; [2011-12-09 21:10:42.147] [000037] [MySQL Local] [MYSQL] 1046 - No database selected

[2011-12-09 21:10:42.157] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailrulecriteria` ( `ruleID` int(11) unsigned NOT NULL default '0', `orderID` int(11) unsigned NOT NULL default '0', `expressionType` enum('AND','OR') NOT NULL default 'OR', `fieldID` int(11) unsigned NOT NULL default '0', `conditionID` int(11) unsigned NOT NULL default '0', `value` varchar(255) NOT NULL default '', KEY `ruleID` (`ruleID`), KEY `fieldID` (`fieldID`), KEY `conditionID` (`conditionID`), CONSTRAINT `0_21653` FOREIGN KEY (`ruleID`) REFERENCES `emailrule` (`ruleID`) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE=InnoDB; [2011-12-09 21:10:42.157] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.167] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emailrulecriteria` ---- Table structure for table `emailsettings` -DROP TABLE IF EXISTS `emailsettings`; [2011-12-09 21:10:42.167] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.177] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailsettings` ( `username` varchar(50) default NULL, `password` varchar(25) default NULL, `authentication` enum('YES','NO') default 'NO', `smtpport` int(4) unsigned NOT NULL default '25', `smtpserver` varchar(255) default NULL ) TYPE=InnoDB; [2011-12-09 21:10:42.177] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.187] [000037] [MySQL Local] [MYSQL] --- Dumping data for table `emailsettings` -INSERT INTO `emailsettings` (`username`, `password`, `authentication`, `smtpport `, `smtpserver`) VALUES (NULL,NULL,'NO',25,NULL); [2011-12-09 21:10:42.187] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.197] [000037] [MySQL Local] [MYSQL] --- Table structure for table `emailtemplate` --

DROP TABLE IF EXISTS `emailtemplate`; [2011-12-09 21:10:42.197] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-09 21:10:42.217] [000037] [MySQL Local] [MYSQL] CREATE TABLE `emailtemplate` ( `templateID` int(11) unsigned NOT NULL auto_increment, `name` varchar(255) default NULL, `description` varchar(255) default NULL, `toAddress` varchar(50) default NULL, `fromAddress` varchar(50) default NULL, `replyTo` varchar(50) default NULL, `subject` text, `body` text, `requiredToAddress` enum('YES','NO') default 'NO', `requiredFromAddress` enum('YES','NO') default 'NO', `requiredReplyTo` enum('YES','NO') default 'NO', `requiredSubject` enum('YES','NO') default 'NO', `requiredBody` enum('YES','NO') default 'NO', PRIMARY KEY (`templateID`) ) TYPE=InnoDB; [2011-12-09 21:10:42.217] [000037] [MySQL Local] [MYSQL] 1046 - No database selected [2011-12-0