Commits

jvaz...@debserverp4.com.ar  committed fc46ac2 Merge
  • Participants
  • Parent commits bc3bee5, 1a33925

Comments (0)

Files changed (6)

File application/modules/applicant/controllers/WaitlistController.php

 			try {
 				$applied=$userWaitList->save();
 				$workflowHelper->terminateSession();
-				$this->view->msg = $applied!=false ? $this->getMessage('userAppliedToWaitlist') : $this->getMessage('errorSaving');
+				//$this->view->msg = $applied!=false ? $this->getMessage('userAppliedToWaitlist') : $this->getMessage('errorSaving');				
+				if( $applied!=false ) {
+				    $this->view->msg = 'userAppliedToWaitlist';
+				    $this->view->type = 'success';
+				}
+				else{
+				    $this->view->msg = 'errorSaving';
+				    $this->view->type = 'error';
+				}				
 			} catch (Exception $e) {
 				$helper = new Applicant_Library_Helper_Apply();
 				$helper->logFails($this, $e, __FUNCTION__);
-				$this->view->msg = $this->getMessage('errorSaving');
+				//$this->view->msg = $this->getMessage('errorSaving');
+				$this->view->msg = 'errorSaving';
+				$this->view->type = 'error';
 			}
 		}
 	}

File application/modules/applicant/views/scripts/waitlist/apply.phtml

  * @since 2010/05/30
  */
 $this->headScript()->appendFile('/javascript/jquery-ui_1.8/jquery-1.4.2.min.js','text/javascript')
-->headScript()->appendFile('/javascript/jquery-ui_1.8/jquery-ui-1.8.custom.min.js','text/javascript');
- 
-echo $this->headLink()->appendStylesheet('/css/roundError.css')
-->headLink()->appendStylesheet('/css/roundSuccess.css')
-->headLink()->appendStylesheet('/css/roundWarning.css');
+->headScript()->appendFile('/javascript/jquery-ui_1.8/jquery-ui-1.8.custom.min.js','text/javascript'); 
 
 echo $this->headLink();
 echo $this->headScript();
 ?>
 <h1><i18n>waitlistresult</i18n></h1>
 <?php
-echo $this->message($this->msg);
+//echo $this->message($this->msg);
+echo $this->internazionalization($this->msg,$this->type);
 ?>

File application/modules/modules/models/Controllers.php

 				->from( array('P' => 'permission'), array('PermissionId'=>'P.id') )
 				->join( array('M'=>'modules'), 'M.id = P.moduleId', array('moduleId'=>'M.id','moduleName'=>'LOWER(M.name)') )
 				->join( array('C'=>'controllers'), 'C.id = P.controllerId', array('controllerId'=>'C.id','controllerName'=>'LOWER(C.name)','display'=>'C.display','icon'=>'C.icon') )
-				->join( array('RP'=>'rolePermission'),'RP.permissionId=P.id',array())
+				->join( array('RP'=>'rolePermission'),'RP.permissionId=P.id',array())				
 				->where($db->quoteInto('M.name=?',$module,'string'))
 				->where($db->quoteInto('RP.roleId = ?',$roles,'int'))
-				->group('controllerId');			
+				->where( 'C.display=1' )
+				->where( "P.actionId IN(SELECT id FROM actions WHERE name='Index')")
+				->group('controllerId');			 
 			$resultset = $db->query($select);
 			$log = new ZFObserver_Forensic();
 			$log->setStatus(ZFObserver_ILogeable::DEBUG);
 				return $controllers;
 			}
 			foreach($resultset as $id=>$value)
-			{
+			{			
 				$controllers[]= array('moduleId'=>$value['moduleId'],'moduleName'=>$value['moduleName'],'controllerId'=>$value['controllerId'],'controllerName'=>$value['controllerName'],'display'=>$value['display'],'icon'=>$value['icon']);
 			}
 		}

File application/modules/user/forms/Join.php

 	 */
 	private function addCaptcha() {
 		$element ='captcha';
+		//var_dump( APPLICATION_PATH ); die;
+		//var_dump( APPLICATION_PATH.'/../../public_html/fonts/VeraMoBI.ttf' ); die;
 		$captchaImageOptions = array(
 						'captcha' => 'Image',
                         			'font'	  => realpath(APPLICATION_PATH.'/../../public_html/fonts/VeraMoBI.ttf'),
 									'class'=>'captchaelement'
 			
 		);
+		
 		$captchaOptions = array('label' => 'captchainstruction',
                 				'required'   => true,
                 				'captcha'    => $captchaImageOptions,

File lang/translations.tmx

 			<seg>Mascotas</seg>
 		</tuv>
     </tu>
-    
+    <tu tuid="userAppliedToWaitlist">
+		<tuv xml:lang="en_US">
+			<seg>You have been successfully applied to the waitlist</seg>
+		</tuv>		
+    </tu>        
     </body>
 </tmx>

File migrations/storage/268/aclDown.sql

+ALTER TABLE permission DROP FOREIGN KEY permission_ibfk_1;
+ALTER TABLE rolePermission DROP FOREIGN KEY rolePermission_ibfk_1;
+ALTER TABLE rolePermission DROP FOREIGN KEY rolePermission_ibfk_2;
+ALTER TABLE reports DROP FOREIGN KEY reports_ibfk_1;
+
+DROP TABLE IF EXISTS `actions`;
+
+CREATE TABLE `actions` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(50) NOT NULL,
+  `icon` varchar(90) DEFAULT NULL,
+  `display` tinyint(4) NOT NULL DEFAULT '1',
+  `dateCreated` datetime NOT NULL,
+  `dateUpdated` datetime DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `name` (`name`(2)),
+  KEY `icon` (`icon`(6))
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `controllers`;
+
+CREATE TABLE `controllers` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(90) NOT NULL,
+  `icon` varchar(250) DEFAULT NULL,
+  `display` tinyint(4) NOT NULL DEFAULT '0',
+  `dateCreated` datetime NOT NULL,
+  `dateUpdated` datetime DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `name` (`name`(5))
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='All the controllers that we have';
+
+DROP TABLE IF EXISTS `modules`;
+
+CREATE TABLE `modules` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(50) NOT NULL,
+  `icon` varchar(250) DEFAULT NULL,
+  `display` tinyint(4) NOT NULL DEFAULT '0',
+  `dateCreated` datetime NOT NULL,
+  `dateUpdated` datetime DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `name` (`name`(5))
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='The content of the modules folder, ie all the modules';
+
+
+
+DROP TABLE IF EXISTS `permission`;
+
+CREATE TABLE `permission` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `moduleId` int(11) NOT NULL,
+  `controllerId` int(11) NOT NULL,
+  `actionId` int(11) NOT NULL,
+  `alias` varchar(90) NOT NULL,
+  `dateCreated` datetime NOT NULL,
+  `dateUpdated` datetime DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `moduleId` (`moduleId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `rolePermission`;
+
+CREATE TABLE `rolePermission` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `roleId` int(11) NOT NULL,
+  `permissionId` int(11) NOT NULL,
+  `dateCreated` datetime NOT NULL,
+  `dateUpdated` datetime DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `tuple` (`roleId`,`permissionId`),
+  KEY `roleId` (`roleId`),
+  KEY `permissionId` (`permissionId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Relation between roles and permissions';
+
+DROP TABLE IF EXISTS `reports`;
+CREATE TABLE IF NOT EXISTS `reports` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(30) NOT NULL,
+  `cacheIdentifier` varchar(50) NOT NULL,
+  `moduleId` int(11) NOT NULL,
+  `cacheTtl` int(11) DEFAULT '60',
+  `urlPath` varchar(50) NOT NULL COMMENT 'The partial url for this report',
+  `dateCreated` datetime NOT NULL,
+  `dateUpdated` datetime DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `name` (`name`(5)),
+  KEY `moduleId` (`moduleId`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Report interface' AUTO_INCREMENT=16 ;
+
+
+
+INSERT INTO `actions` VALUES (1,'Index','/images/dashboard/actionBar/user/edit.png',1,'2010-08-20 17:05:42','2010-09-05 00:35:12');
+INSERT INTO `actions` VALUES (2,'Fee','/images/dashboard/087011-sky-blue-white-pearl-icon-business-dollar.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (3,'Fees','/images/dashboard/actionBar/applicant/fees.gif',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (4,'Viewfeesdue',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (5,'Viewfeespaid',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (6,'Viewmyleasedocuments',NULL,1,'2011-01-25 14:00:39',NULL);
+INSERT INTO `actions` VALUES (7,'Viewmyleasedocument',NULL,1,'2011-01-25 14:00:39',NULL);
+INSERT INTO `actions` VALUES (8,'Applyuser',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (9,'Rentalcriminalhistory',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (10,'Aboutyou',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (11,'Currentaddress',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (12,'Previousaddress',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (13,'Currentworkhistory',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (14,'Previousworkhistory',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (15,'Credithistory',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (16,'Spouse',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (17,'Occupants',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (18,'Vehicles',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (19,'Emergencycontact',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (20,'Whyyourented',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (21,'Authorization',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (22,'Payment',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (23,'End',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (24,'Removeinfo',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (25,'Deleteevent',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (26,'Deleteguest',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (27,'Deleteallguests',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (28,'Deleteeventtime',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (29,'Updateevent',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (30,'Dailyview',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (31,'Weekview',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (32,'Viewevent',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (33,'Search',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (34,'Error',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (35,'Createaccount','/images/dashboard/actionBar/account/createaccount.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (36,'Createaccounttransaction','/images/dashboard/actionBar/account/createtrans.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (37,'Createdeposit',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (38,'Createfee','/images/dashboard/actionBar/fee/createfee.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (39,'Createaccountlink',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (40,'Searchunit',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (41,'Selectbill',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (42,'Createbill',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (43,'Noaccess',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (44,'Updateaccount',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (45,'Updateaccountlink',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (46,'Updatedepositaccountlink',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (47,'Updatefeeaccountlink',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (48,'Updatedeposit',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (49,'Updatefee',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (50,'Updatefinancialaccountsetting',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (51,'Viewaccounttransactions','/images/dashboard/actionBar/account/viewaccounttransactions.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (52,'Viewallaccounts','/images/dashboard/actionBar/account/viewallaccounts.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (53,'Viewalldeposits',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (54,'Viewallfees','/images/dashboard/actionBar/fee/viewallfees.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (55,'Viewaccount',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (56,'Viewbill',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (57,'Viewpaymentdetail',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (58,'Viewallaccountlinks','/images/dashboard/actionBar/accountlink/viewallaccountlinks.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (59,'Viewtransaction',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (60,'Viewallfinancialaccountsettings','/images/dashboard/actionBar/financialaccountsetting/viewallsettings.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (61,'Viewfinancialaccountsetting',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (62,'Db',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (63,'Text',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (64,'Read',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (65,'Createmaintenancerequestadmin','/images/dashboard/actionBar/maintenance/createrequestadmin.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (66,'Createmaintenancerequest','/images/dashboard/actionBar/maintenance/createrequest.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (67,'Configure',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (68,'Populatedefaultassignedto',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (69,'Viewallmaintenancerequests','/images/dashboard/actionBar/maintenance/allrequests.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (70,'Viewmaintenancerequest',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (71,'Viewmaintenancerequestadmin',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (72,'Viewmymaintenancerequests','/images/dashboard/actionBar/maintenance/myrequests.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (73,'Viewassignedrequests','/images/dashboard/actionBar/maintenance/assignedrequests.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (74,'Help',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (75,'Update','/images/dashboard/onebit_20.gif',1,'2010-08-20 17:05:42','2010-08-20 18:14:37');
+INSERT INTO `actions` VALUES (76,'Viewallmodules','/images/dashboard/onebit_02.gif',1,'2010-08-20 17:05:42','2010-08-20 18:15:33');
+INSERT INTO `actions` VALUES (77,'View','/images/dashboard/onebit_02.gif',1,'2010-08-20 17:05:42','2010-08-20 18:16:17');
+INSERT INTO `actions` VALUES (78,'Roleaccess',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (79,'Delete','/images/dashboard/onebit_32.gif',1,'2010-08-20 17:05:42','2010-08-20 18:17:34');
+INSERT INTO `actions` VALUES (80,'Createamenity','/images/dashboard/actionBar/amenity/createamenity.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (81,'Createapartment',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (82,'Createleasefee','/images/dashboard/actionBar/lease/createleasefee.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (84,'Createunitsingle','/images/dashboard/actionBar/unit/createunitsingle.png',1,'2010-08-20 17:05:42','2010-08-20 18:19:31');
+INSERT INTO `actions` VALUES (85,'Createunitbulk','/images/dashboard/actionBar/unit/createunitbulk.png',1,'2010-08-20 17:05:42','2010-08-20 18:20:11');
+INSERT INTO `actions` VALUES (86,'Createunitmodel','/images/dashboard/actionBar/unitmodel/createunitmodel.png',1,'2010-08-20 17:05:42','2010-08-20 18:21:23');
+INSERT INTO `actions` VALUES (87,'Createmodelrentschedule','/images/dashboard/actionBar/modelrentschedule/createmodelrentschedule.png',1,'2010-08-20 17:05:42','2010-08-20 18:22:29');
+INSERT INTO `actions` VALUES (88,'Unitmodelindex','/images/dashboard/onebit_01.gif',1,'2010-08-20 17:05:42','2010-08-20 18:25:32');
+INSERT INTO `actions` VALUES (89,'Amenityindex','/images/dashboard/onebit_01.gif',1,'2010-08-20 17:05:42','2010-08-20 18:26:25');
+INSERT INTO `actions` VALUES (90,'Addusertolist',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (91,'Removeuserfromlist',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (92,'Confirmation',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (93,'Enterdiscounts',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (94,'Entermoveindate',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (95,'Searchaddtenant',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (96,'Selectfeedeposit',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (97,'Selectrentschedule',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (98,'Startleasewizard','/images/dashboard/actionBar/lease/startleasewizard.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (99,'Deleteapartment',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (100,'Deleteunitmetadata',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (101,'Viewunittenant','/images/dashboard/onebit_02.gif',1,'2010-08-20 17:05:42','2010-08-20 18:31:14');
+INSERT INTO `actions` VALUES (102,'Addtounit',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (103,'Cancellease',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (104,'Updateamenity',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (105,'Updateapartment',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (106,'Updateunit',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (107,'Updateunitmodel',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (108,'Getregions',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (109,'Viewallamenities','/images/dashboard/actionBar/amenity/viewallamenities.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (110,'Viewallapartments','/images/dashboard/actionBar/apartment/viewallapartments.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (111,'Viewallunitmodels','/images/dashboard/actionBar/unitmodel/viewallunitmodels.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (112,'Viewallmodelrentschedule','/images/dashboard/onebit_02.gif',1,'2010-08-20 17:05:42','2010-08-20 18:32:25');
+INSERT INTO `actions` VALUES (113,'Viewallunits','/images/dashboard/actionBar/unit/viewallunits.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (114,'Viewapartment',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (115,'Viewlease','/images/dashboard/actionBar/lease/viewlease.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (116,'Viewleaselist','/images/dashboard/actionBar/lease/viewleaselist.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (117,'Viewmodelrentschedule',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (118,'Viewunit',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (119,'Viewunitmodel',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (120,'Unitsforrent',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (121,'Viewunitgraphics',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (122,'Show',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (123,'Addpicture',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (126,'Logout',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `actions` VALUES (127,'Paymentconfirmation',NULL,1,'2010-08-22 20:08:34',NULL);
+INSERT INTO `actions` VALUES (128,'Updaterentprorationsettings',NULL,1,'2010-08-22 20:08:34',NULL);
+INSERT INTO `actions` VALUES (129,'Updatepermission',NULL,1,'2010-08-28 14:02:44',NULL);
+INSERT INTO `actions` VALUES (130,'Viewmodules','/images/dashboard/actionBar/role/viewmodules.png',1,'2010-08-28 14:02:44',NULL);
+INSERT INTO `actions` VALUES (131,'Viewcontrollers',NULL,1,'2010-08-28 14:02:44',NULL);
+INSERT INTO `actions` VALUES (132,'Viewactions',NULL,1,'2010-08-28 14:02:44',NULL);
+INSERT INTO `actions` VALUES (133,'Apply',NULL,1,'2010-08-29 19:07:06',NULL);
+INSERT INTO `actions` VALUES (134,'Waitlist','/images/dashboard/actionBar/applicant/waitlist.gif',1,'2010-09-01 10:10:16','2010-09-05 00:30:38');
+INSERT INTO `actions` VALUES (135,'Application','/images/dashboard/actionBar/applicant/application.gif',1,'2010-09-04 23:11:37','2010-09-05 00:24:40');
+INSERT INTO `actions` VALUES (136,'Viewfee',NULL,1,'2010-09-06 13:01:00',NULL);
+INSERT INTO `actions` VALUES (137,'Message',NULL,1,'2010-09-06 20:08:30',NULL);
+INSERT INTO `actions` VALUES (138,'Viewallapplicants','/images/dashboard/actionBar/applicant/viewallapplicants.png',1,'2010-09-12 23:11:00',NULL);
+INSERT INTO `actions` VALUES (139,'Updateapplicantstatus',NULL,1,'2010-09-14 22:10:45',NULL);
+INSERT INTO `actions` VALUES (140,'Createstatus',NULL,1,'2010-09-14 22:10:45',NULL);
+INSERT INTO `actions` VALUES (141,'Updatestatus',NULL,1,'2010-09-14 22:10:45',NULL);
+INSERT INTO `actions` VALUES (142,'Viewallstatuses',NULL,1,'2010-09-14 22:10:45',NULL);
+INSERT INTO `actions` VALUES (143,'Completedapps',NULL,1,'2010-09-20 23:11:58',NULL);
+INSERT INTO `actions` VALUES (144,'Statuschange',NULL,1,'2010-09-20 23:11:58',NULL);
+INSERT INTO `actions` VALUES (145,'Addpreleasefee',NULL,1,'2010-10-12 21:09:40',NULL);
+INSERT INTO `actions` VALUES (146,'Applicantemail',NULL,1,'2010-10-12 21:09:40',NULL);
+INSERT INTO `actions` VALUES (147,'Waitlistemail',NULL,1,'2010-10-12 21:09:40',NULL);
+INSERT INTO `actions` VALUES (148,'Viewpreleaseapplicantfees',NULL,1,'2010-10-12 21:09:40',NULL);
+INSERT INTO `actions` VALUES (149,'Refund',NULL,1,'2010-10-12 21:09:41',NULL);
+INSERT INTO `actions` VALUES (150,'Forfeit',NULL,1,'2010-10-12 21:09:41',NULL);
+INSERT INTO `actions` VALUES (151,'Payapplicantbills',NULL,1,'2010-10-17 13:01:53',NULL);
+INSERT INTO `actions` VALUES (152,'Bgcheck',NULL,1,'2010-10-17 13:01:53',NULL);
+INSERT INTO `actions` VALUES (153,'Bgcheckdetails',NULL,1,'2010-10-17 13:01:53',NULL);
+INSERT INTO `actions` VALUES (154,'Selectapplicantbills',NULL,1,'2010-10-28 23:11:43',NULL);
+INSERT INTO `actions` VALUES (155,'Payapplicantbillconfirmation',NULL,1,'2010-10-28 23:11:43',NULL);
+INSERT INTO `actions` VALUES (156,'Rentroll',NULL,1,'2010-10-28 23:11:43',NULL);
+INSERT INTO `actions` VALUES (159,'Payleasebills',NULL,1,'2010-11-03 21:09:25',NULL);
+INSERT INTO `actions` VALUES (160,'Payleasebillconfirmation',NULL,1,'2010-11-03 21:09:25',NULL);
+INSERT INTO `actions` VALUES (161,'Remove',NULL,1,'2010-11-03 21:09:25',NULL);
+INSERT INTO `actions` VALUES (162,'Viewsettings',NULL,1,'2010-11-14 00:12:29',NULL);
+INSERT INTO `actions` VALUES (163,'Applicant',NULL,1,'2010-11-26 21:09:40',NULL);
+INSERT INTO `actions` VALUES (164,'Recurringfees',NULL,1,'2010-11-26 21:09:40',NULL);
+INSERT INTO `actions` VALUES (165,'Cancelledlease',NULL,1,'2010-11-26 21:09:40',NULL);
+INSERT INTO `actions` VALUES (166,'Incomingtenants',NULL,1,'2010-11-26 21:09:40',NULL);
+INSERT INTO `actions` VALUES (167,'Paidfees',NULL,1,'2010-11-29 20:08:48',NULL);
+INSERT INTO `actions` VALUES (168,'Servicerequests',NULL,1,'2010-11-29 20:08:48',NULL);
+INSERT INTO `actions` VALUES (169,'Outgoingtenants',NULL,1,'2010-11-29 20:08:48',NULL);
+INSERT INTO `actions` VALUES (170,'Nonpaidfees',NULL,1,'2010-12-05 16:04:00',NULL);
+INSERT INTO `actions` VALUES (171,'Duefee',NULL,1,'2010-12-05 16:04:00',NULL);
+INSERT INTO `actions` VALUES (172,'Duerent',NULL,1,'2010-12-05 16:04:00',NULL);
+INSERT INTO `actions` VALUES (173,'Duerefunds',NULL,1,'2010-12-05 16:04:00',NULL);
+INSERT INTO `actions` VALUES (174,'Lateduerent',NULL,1,'2010-12-05 16:04:00',NULL);
+INSERT INTO `actions` VALUES (175,'Lateduefee',NULL,1,'2010-12-05 16:04:00',NULL);
+INSERT INTO `actions` VALUES (176,'Incomestatement',NULL,1,'2010-12-24 11:11:29',NULL);
+INSERT INTO `actions` VALUES (177,'Unoccupiedunits',NULL,1,'2010-12-24 11:11:29',NULL);
+INSERT INTO `actions` VALUES (178,'Balancesheet',NULL,1,'2010-12-25 22:10:49',NULL);
+INSERT INTO `actions` VALUES (179,'Clonelease',NULL,1,'2010-12-25 22:10:49',NULL);
+INSERT INTO `actions` VALUES (180,'Selectpreleasefees',NULL,1,'2010-12-25 22:10:49',NULL);
+INSERT INTO `actions` VALUES (182,'Forgotpassword',NULL,1,'2010-12-25 22:10:49',NULL);
+INSERT INTO `actions` VALUES (183,'Info','/images/dashboard/actionBar/user/info.png',1,'2010-12-25 22:10:49','2010-12-31 14:46:41');
+INSERT INTO `actions` VALUES (184,'Selectleasefees',NULL,1,'2010-12-31 12:12:11',NULL);
+INSERT INTO `actions` VALUES (186,'Viewdocument',NULL,1,'2011-01-06 00:12:25',NULL);
+INSERT INTO `actions` VALUES (187,'Deletedocument',NULL,1,'2011-01-06 00:12:25',NULL);
+INSERT INTO `actions` VALUES (189,'Myleaselist','/images/dashboard/actionBar/lease/myleaselist.png',1,'2011-01-08 23:11:43',NULL);
+INSERT INTO `actions` VALUES (191,'Myunit',NULL,1,'2011-01-09 18:06:53',NULL);
+INSERT INTO `actions` VALUES (192,'Forgotusername',NULL,1,'2011-01-09 18:06:54',NULL);
+INSERT INTO `actions` VALUES (193,'Forgotinfo',NULL,1,'2011-01-09 18:06:54',NULL);
+INSERT INTO `actions` VALUES (194,'Mylease','/images/dashboard/actionBar/lease/viewlease.png',1,'2011-01-13 21:09:38',NULL);
+INSERT INTO `actions` VALUES (195,'Viewmyleasebill','/images/dashboard/actionBar/lease/viewmyleasebill.png',1,'2011-01-13 21:09:38',NULL);
+INSERT INTO `actions` VALUES (196,'Viewmypayments',NULL,1,'2011-01-13 21:09:38',NULL);
+INSERT INTO `actions` VALUES (197,'Resetpassword',NULL,1,'2011-01-13 21:09:38',NULL);
+INSERT INTO `actions` VALUES (198,'Viewevictions','/images/dashboard/actionBar/lease/viewallevictions.png',1,'2011-01-19 14:00:39',NULL);
+INSERT INTO `actions` VALUES (199,'Vieweviction',NULL,1,'2011-01-19 14:00:39',NULL);
+INSERT INTO `actions` VALUES (200,'Createeviction','/images/dashboard/actionBar/lease/createeviction.png',1,'2011-01-19 14:00:39',NULL);
+INSERT INTO `actions` VALUES (201,'Viewallevictiondocuments','/images/dashboard/actionBar/lease/viewallevictiondocuments.png',1,'2011-01-19 14:00:39',NULL);
+INSERT INTO `actions` VALUES (202,'Addevictiondocument','/images/dashboard/actionBar/lease/addevictiondocument.png',1,'2011-01-19 14:00:39',NULL);
+INSERT INTO `actions` VALUES (203,'Viewevictiondocument',NULL,1,'2011-01-19 14:00:39',NULL);
+INSERT INTO `actions` VALUES (204,'Deleteevictiondocument',NULL,1,'2011-01-19 14:00:39',NULL);
+INSERT INTO `actions` VALUES (205,'Adddocument','/images/dashboard/actionBar/lease/adddocument.png',1,'2011-01-19 14:00:39',NULL);
+INSERT INTO `actions` VALUES (206,'Viewalldocuments','/images/dashboard/actionBar/lease/viewallleasedocuments.png',1,'2011-01-19 14:00:39',NULL);
+INSERT INTO `actions` VALUES (210,'Myrentbill',NULL,1,'2011-01-19 14:00:39',NULL);
+INSERT INTO `actions` VALUES (213,'Selectleasebills','/images/dashboard/actionBar/lease/dollar.png',1,'2011-01-19 14:00:39',NULL);
+INSERT INTO `actions` VALUES (214,'Detail',NULL,1,'2011-02-13 15:03:36',NULL);
+
+INSERT INTO `controllers` VALUES (1,'Create','/images/dashboard/onebit_48.gif',1,'2010-08-20 17:05:42','2010-08-20 17:43:20');
+INSERT INTO `controllers` VALUES (2,'Index','/images/dashboard/onebit_01.gif',1,'2010-08-20 17:05:42','2010-08-20 17:43:59');
+INSERT INTO `controllers` VALUES (3,'Delete','/images/dashboard/onebit_32.gif',1,'2010-08-20 17:05:42','2010-08-20 17:44:17');
+INSERT INTO `controllers` VALUES (4,'Backend',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `controllers` VALUES (5,'Update','/images/dashboard/onebit_20.gif',1,'2010-08-20 17:05:42','2010-08-20 17:45:59');
+INSERT INTO `controllers` VALUES (6,'View','/images/dashboard/controllerBar/userModule/viewallusers.png',1,'2010-08-20 17:05:42','2010-12-11 17:36:26');
+INSERT INTO `controllers` VALUES (7,'Dashboard','/images/dashboard/controllerBar/applicantModule/dashboard.png',1,'2010-08-20 17:05:42','2010-10-06 22:49:01');
+INSERT INTO `controllers` VALUES (8,'Apply',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `controllers` VALUES (9,'Error',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `controllers` VALUES (10,'Bulk','/images/dashboard/controllerBar/financialModule/bulkuploadrent.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `controllers` VALUES (11,'Setting','/images/dashboard/controllerBar/maintenanceModule/maintsetting.png',1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `controllers` VALUES (12,'Search','/images/dashboard/navigate_48.gif',1,'2010-08-20 17:05:42','2010-08-23 20:07:56');
+INSERT INTO `controllers` VALUES (13,'Leasewizard',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `controllers` VALUES (14,'Tenant',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `controllers` VALUES (15,'Add',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `controllers` VALUES (16,'Join',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `controllers` VALUES (17,'Login',NULL,1,'2010-08-20 17:05:42',NULL);
+INSERT INTO `controllers` VALUES (18,'Waitlist',NULL,1,'2010-08-29 19:07:06',NULL);
+INSERT INTO `controllers` VALUES (19,'Amenity','/images/dashboard/controllerBar/unitModule/amenity.png',1,'2010-09-04 17:56:24','2010-09-04 17:56:28');
+INSERT INTO `controllers` VALUES (20,'Apartment','/images/dashboard/controllerBar/unitModule/apartment.gif',1,'2010-09-04 17:56:43','2010-09-04 17:57:00');
+INSERT INTO `controllers` VALUES (21,'Lease',NULL,1,'2010-09-04 17:57:39','2010-09-04 17:57:44');
+INSERT INTO `controllers` VALUES (22,'Modelrentschedule',NULL,1,'2010-09-04 17:57:53','2010-09-04 17:57:56');
+INSERT INTO `controllers` VALUES (23,'Unitmodel','/images/dashboard/controllerBar/unitModule/unitmodel.png',1,'2010-09-04 17:58:30','2010-09-04 17:58:33');
+INSERT INTO `controllers` VALUES (24,'Unit','/images/dashboard/controllerBar/unitModule/unit.png',1,'2010-09-04 17:59:22','2010-09-04 17:59:46');
+INSERT INTO `controllers` VALUES (25,'Accounttransaction',NULL,1,'2010-09-06 09:09:11',NULL);
+INSERT INTO `controllers` VALUES (26,'Account','/images/dashboard/controllerBar/financialModule/account.png',1,'2010-09-06 09:31:48',NULL);
+INSERT INTO `controllers` VALUES (27,'Fee','/images/dashboard/controllerBar/financialModule/fee.png',1,'2010-09-06 10:17:37',NULL);
+INSERT INTO `controllers` VALUES (28,'Accountlink','/images/dashboard/controllerBar/financialModule/accountlink.png',1,'2010-09-06 11:00:02',NULL);
+INSERT INTO `controllers` VALUES (29,'Bill',NULL,1,'2010-09-06 11:10:58',NULL);
+INSERT INTO `controllers` VALUES (30,'Financialaccountsetting','/images/dashboard/controllerBar/financialModule/finacctsetting.png',1,'2010-09-06 11:22:12',NULL);
+INSERT INTO `controllers` VALUES (31,'Payment',NULL,1,'2010-09-06 11:29:40',NULL);
+INSERT INTO `controllers` VALUES (32,'Applicantstatus',NULL,1,'2010-09-14 22:10:45',NULL);
+INSERT INTO `controllers` VALUES (33,'Refundforfeit',NULL,0,'2010-10-12 21:09:41',NULL);
+INSERT INTO `controllers` VALUES (34,'Report','/images/dashboard/reports.png',1,'2010-10-28 23:11:43','2010-11-14 16:53:17');
+INSERT INTO `controllers` VALUES (35,'Maintenance','/images/dashboard/controllerBar/maintenanceModule/maintenance.png',1,'2010-11-14 00:30:04',NULL);
+
+INSERT INTO `modules` VALUES (1,'applicant','/images/dashboard/magic-applicant.png',1,'2010-08-20 17:05:42','2010-09-05 01:19:46');
+INSERT INTO `modules` VALUES (2,'calendar','/images/dashboard/magic-calendar.png',0,'2010-08-20 17:05:42','2010-09-05 01:11:40');
+INSERT INTO `modules` VALUES (3,'default','/images/dashboard/006334-sky-blue-white-pearl-icon-arrows-arrow-check.png',1,'2010-08-20 17:05:42','2010-09-05 01:04:28');
+INSERT INTO `modules` VALUES (4,'financial','/images/dashboard/magic-financial.png',1,'2010-08-20 17:05:42','2010-09-05 01:03:29');
+INSERT INTO `modules` VALUES (5,'logs',NULL,0,'2010-08-20 17:05:42',NULL);
+INSERT INTO `modules` VALUES (6,'maintenance','/images/dashboard/magic-maintenance.png',1,'2010-08-20 17:05:42','2010-09-05 01:09:50');
+INSERT INTO `modules` VALUES (7,'messages','/images/dashboard/magic-messages.png',0,'2010-08-20 17:05:42','2010-09-05 01:07:40');
+INSERT INTO `modules` VALUES (8,'modules',NULL,0,'2010-08-20 17:05:42',NULL);
+INSERT INTO `modules` VALUES (9,'permission','/images/dashboard/onebit_04.gif',0,'2010-08-20 17:05:42','2010-09-05 01:20:14');
+INSERT INTO `modules` VALUES (10,'role','/images/dashboard/magic-role.png',1,'2010-08-20 17:05:42','2010-09-05 01:16:29');
+INSERT INTO `modules` VALUES (11,'settings','/images/dashboard/magic-settings.png',0,'2010-08-20 17:05:42','2010-09-05 01:13:01');
+INSERT INTO `modules` VALUES (12,'unit','/images/dashboard/magic-unit.png',1,'2010-08-20 17:05:42','2010-09-05 01:18:09');
+INSERT INTO `modules` VALUES (13,'user','/images/dashboard/onebit_18.gif',1,'2010-08-20 17:05:42','2010-12-25 21:00:25');
+INSERT INTO `modules` VALUES (14,'email',NULL,0,'2010-10-17 13:01:53',NULL);
+INSERT INTO `modules` VALUES (15,'prospects',NULL,0,'2011-02-13 15:03:36',NULL);
+
+INSERT INTO `permission` VALUES (1,1,1,1,'Applicant Create Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (2,1,1,2,'Applicant Create Fee','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (3,1,3,2,'Applicant Delete Fee','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (4,1,4,1,'Applicant Backend Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (5,1,6,1,'Applicant View Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (6,1,6,3,'Applicant View Fees','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (7,1,7,1,'Applicant Dashboard Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (8,1,7,4,'Applicant Dashboard Viewfeesdue','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (9,1,7,5,'Applicant Dashboard Viewfeespaid','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (10,1,8,1,'Applicant Apply Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (11,12,21,6,'Unit Lease Viewmyleasedocuments ','2011-01-25 14:08:49',NULL);
+INSERT INTO `permission` VALUES (12,12,21,7,'Unit Lease Viewmyleasedocument','2011-01-25 14:08:49',NULL);
+INSERT INTO `permission` VALUES (13,1,8,8,'Applicant Apply Applyuser','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (14,1,8,9,'Applicant Apply Rentalcriminalhistory','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (15,1,8,10,'Applicant Apply Aboutyou','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (16,1,8,11,'Applicant Apply Currentaddress','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (17,1,8,12,'Applicant Apply Previousaddress','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (18,1,8,13,'Applicant Apply Currentworkhistory','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (19,1,8,14,'Applicant Apply Previousworkhistory','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (20,1,8,15,'Applicant Apply Credithistory','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (21,1,8,16,'Applicant Apply Spouse','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (22,1,8,17,'Applicant Apply Occupants','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (23,1,8,18,'Applicant Apply Vehicles','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (24,1,8,19,'Applicant Apply Emergencycontact','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (25,1,8,20,'Applicant Apply Whyyourented','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (26,1,8,21,'Applicant Apply Authorization','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (28,1,8,23,'Applicant Apply End','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (29,1,8,24,'Applicant Apply Removeinfo','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (30,2,1,1,'Calendar Create Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (31,2,2,1,'Calendar Index Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (32,2,3,25,'Calendar Delete Deleteevent','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (33,2,3,26,'Calendar Delete Deleteguest','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (34,2,3,27,'Calendar Delete Deleteallguests','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (35,2,3,28,'Calendar Delete Deleteeventtime','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (36,2,5,29,'Calendar Update Updateevent','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (37,2,6,1,'Calendar View Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (38,2,6,30,'Calendar View Dailyview','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (39,2,6,31,'Calendar View Weekview','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (40,2,6,32,'Calendar View Viewevent','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (41,3,2,1,'Default Index Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (42,3,2,33,'Default Index Search','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (43,3,9,34,'Default Error Error','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (52,4,2,1,'Financial Index Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (53,4,9,34,'Financial Error Error','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (54,4,9,43,'Financial Error Noaccess','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (73,4,10,1,'Financial Bulk Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (74,5,2,1,'Logs Index Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (75,5,2,62,'Logs Index Db','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (76,5,2,63,'Logs Index Text','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (77,5,2,64,'Logs Index Read','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (78,5,9,34,'Logs Error Error','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (81,6,2,1,'Maintenance Index Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (82,6,11,67,'Maintenance Setting Configure','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (83,6,11,68,'Maintenance Setting Populatedefaultassignedto','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (89,7,1,1,'Messages Create Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (90,7,2,1,'Messages Index Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (91,7,3,74,'Messages Delete Help','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (92,7,3,1,'Messages Delete Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (93,7,5,1,'Messages Update Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (94,7,6,1,'Messages View Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (95,8,2,1,'Modules Index Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (96,8,9,34,'Modules Error Error','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (97,8,5,1,'Modules Update Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (98,8,5,75,'Modules Update Update','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (99,8,6,1,'Modules View Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (100,8,6,76,'Modules View Viewallmodules','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (101,9,2,1,'Permission Index Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (102,9,9,34,'Permission Error Error','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (103,9,5,1,'Permission Update Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (104,9,6,1,'Permission View Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (105,9,6,77,'Permission View View','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (106,10,1,1,'Role Create Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (107,10,1,78,'Role Create Roleaccess','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (108,10,2,1,'Role Index Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (109,10,9,34,'Role Error Error','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (110,10,9,43,'Role Error Noaccess','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (111,10,3,1,'Role Delete Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (112,10,3,79,'Role Delete Delete','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (113,10,12,1,'Role Search Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (114,10,5,1,'Role Update Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (115,10,5,75,'Role Update Update','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (116,10,6,1,'Role View Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (117,10,6,77,'Role View View','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (119,11,1,1,'Settings Create Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (120,11,2,1,'Settings Index Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (121,11,5,1,'Settings Update Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (122,11,6,1,'Settings View Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (123,11,6,77,'Settings View View','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (133,12,2,1,'Unit Index Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (136,12,9,34,'Unit Error Error','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (137,12,13,90,'Unit Leasewizard Addusertolist','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (138,12,13,91,'Unit Leasewizard Removeuserfromlist','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (139,12,13,92,'Unit Leasewizard Confirmation','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (140,12,13,93,'Unit Leasewizard Enterdiscounts','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (141,12,13,94,'Unit Leasewizard Entermoveindate','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (142,12,13,95,'Unit Leasewizard Searchaddtenet','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (143,12,13,96,'Unit Leasewizard Selectfeedeposit','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (144,12,13,97,'Unit Leasewizard Selectrentschedule','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (145,12,13,98,'Unit Leasewizard Startleasewizard','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (146,12,3,1,'Unit Delete Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (147,12,3,79,'Unit Delete Delete','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (148,12,3,99,'Unit Delete Deleteapartment','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (149,12,3,100,'Unit Delete Deleteunitmetadata','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (150,12,12,1,'Unit Search Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (151,12,14,101,'Unit Tenet Viewunittenet','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (152,12,14,95,'Unit Tenet Searchaddtenet','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (153,12,14,102,'Unit Tenet Addtounit','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (154,12,5,1,'Unit Update Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (160,12,5,108,'Unit Update Getregions','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (175,12,15,123,'Unit Add Addpicture','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (176,13,16,1,'User Join Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (177,13,1,1,'User Create Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (178,13,2,1,'User Index Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (179,13,9,34,'User Error Error','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (180,13,9,43,'User Error Noaccess','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (181,13,5,1,'User Update Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (184,13,6,1,'User View Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (185,13,17,1,'User Login Index','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (186,13,17,126,'User Login Logout','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (187,13,17,34,'User Login Error','2010-08-20 17:05:42',NULL);
+INSERT INTO `permission` VALUES (188,1,7,22,'Applicant Dashboard Payment','2010-08-22 20:08:34',NULL);
+INSERT INTO `permission` VALUES (189,1,7,127,'Applicant Dashboard Paymentconfirmation','2010-08-22 20:08:34',NULL);
+INSERT INTO `permission` VALUES (190,12,5,128,'Unit Update Updaterentprorationsettings','2010-08-22 20:08:34',NULL);
+INSERT INTO `permission` VALUES (191,10,5,129,'Role Update Updatepermission','2010-08-28 14:02:44',NULL);
+INSERT INTO `permission` VALUES (192,10,6,130,'Role View Viewmodules','2010-08-28 14:02:44',NULL);
+INSERT INTO `permission` VALUES (193,10,6,131,'Role View Viewcontrollers','2010-08-28 14:02:44',NULL);
+INSERT INTO `permission` VALUES (194,10,6,132,'Role View Viewactions','2010-08-28 14:02:44',NULL);
+INSERT INTO `permission` VALUES (195,1,2,1,'Applicant Index Index','2010-08-28 14:02:54',NULL);
+INSERT INTO `permission` VALUES (196,1,18,1,'Applicant Waitlist Index','2010-08-29 19:07:06',NULL);
+INSERT INTO `permission` VALUES (197,1,18,133,'Applicant Waitlist Apply','2010-08-29 19:07:06',NULL);
+INSERT INTO `permission` VALUES (198,1,7,134,'Applicant Dashboard Waitlist','2010-09-01 10:10:16',NULL);
+INSERT INTO `permission` VALUES (199,12,23,1,'Unit Unitmodel Index','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (200,12,23,86,'Unit Unitmodel Createunitmodel','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (201,12,23,107,'Unit Unitmodel Updateunitmodel','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (202,12,23,111,'Unit Unitmodel Viewallunitmodels','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (203,12,23,119,'Unit Unitmodel Viewunitmodel','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (204,12,20,1,'Unit Apartment Index','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (205,12,20,81,'Unit Apartment Createapartment','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (206,12,20,99,'Unit Apartment Deleteapartment','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (207,12,20,105,'Unit Apartment Updateapartment','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (208,12,20,110,'Unit Apartment Viewallapartments','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (209,12,20,114,'Unit Apartment Viewapartment','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (210,12,22,1,'Unit Modelrentschedule Index','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (211,12,22,87,'Unit Modelrentschedule Createmodelrentschedule','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (212,12,22,112,'Unit Modelrentschedule Viewallmodelrentschedule','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (213,12,22,117,'Unit Modelrentschedule Viewmodelrentschedule','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (214,12,2,88,'Unit Index Unitmodelindex','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (215,12,2,89,'Unit Index Amenityindex','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (216,12,19,1,'Unit Amenity Index','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (217,12,19,80,'Unit Amenity Createamenity','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (218,12,19,104,'Unit Amenity Updateamenity','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (219,12,19,109,'Unit Amenity Viewallamenities','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (220,12,24,1,'Unit Unit Index','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (221,12,24,84,'Unit Unit Createunitsingle','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (222,12,24,85,'Unit Unit Createunitbulk','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (223,12,24,106,'Unit Unit Updateunit','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (224,12,24,113,'Unit Unit Viewallunits','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (225,12,24,118,'Unit Unit Viewunit','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (226,12,24,120,'Unit Unit Unitsforrent','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (227,12,24,121,'Unit Unit Viewunitgraphics','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (228,12,24,122,'Unit Unit Show','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (229,12,21,1,'Unit Lease Index','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (230,12,21,82,'Unit Lease Createleasefee','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (232,12,21,103,'Unit Lease Cancellease','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (233,12,21,115,'Unit Lease Viewlease','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (234,12,21,116,'Unit Lease Viewleaselist','2010-09-04 18:06:05',NULL);
+INSERT INTO `permission` VALUES (235,1,7,135,'Applicant Dashboard Application','2010-09-04 23:11:37',NULL);
+INSERT INTO `permission` VALUES (259,4,30,50,'Financial Financialaccountsetting Updatefinancialaccountsetting','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (260,4,30,60,'Financial Financialaccountsetting Viewallfinancialaccountsettings','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (261,4,30,61,'Financial Financialaccountsetting Viewfinancialaccountsetting','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (262,4,31,57,'Financial Payment Viewpaymentdetail','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (263,4,25,36,'Financial Accounttransaction Createaccounttransaction','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (264,4,25,51,'Financial Accounttransaction Viewaccounttransactions','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (265,4,25,59,'Financial Accounttransaction Viewtransaction','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (266,4,29,41,'Financial Bill Selectbill','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (267,4,29,42,'Financial Bill Createbill','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (268,4,29,40,'Financial Bill Searchunit','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (269,4,29,56,'Financial Bill Viewbill','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (270,4,28,39,'Financial Accountlink Createaccountlink','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (271,4,28,45,'Financial Accountlink Updateaccountlink','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (272,4,28,47,'Financial Accountlink Updatefeeaccountlink','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (273,4,28,58,'Financial Accountlink Viewallaccountlinks','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (274,4,27,38,'Financial Fee Createfee','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (275,4,27,49,'Financial Fee Updatefee','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (276,4,27,54,'Financial Fee Viewallfees','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (277,4,27,136,'Financial Fee Viewfee','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (278,4,26,35,'Financial Account Createaccount','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (279,4,26,44,'Financial Account Updateaccount','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (280,4,26,55,'Financial Account Viewaccount','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (281,4,26,52,'Financial Account Viewallaccounts','2010-09-06 13:01:39',NULL);
+INSERT INTO `permission` VALUES (282,1,8,137,'Applicant Apply Message','2010-09-06 20:08:30',NULL);
+INSERT INTO `permission` VALUES (283,1,6,138,'Applicant View Viewallapplicants','2010-09-12 23:11:00',NULL);
+INSERT INTO `permission` VALUES (284,1,5,139,'Applicant Update Updateapplicantstatus','2010-09-14 22:10:45',NULL);
+INSERT INTO `permission` VALUES (285,1,32,1,'Applicant Applicantstatus Index','2010-09-14 22:10:45',NULL);
+INSERT INTO `permission` VALUES (286,1,32,140,'Applicant Applicantstatus Createstatus','2010-09-14 22:10:45',NULL);
+INSERT INTO `permission` VALUES (287,1,32,141,'Applicant Applicantstatus Updatestatus','2010-09-14 22:10:45',NULL);
+INSERT INTO `permission` VALUES (288,1,32,142,'Applicant Applicantstatus Viewallstatuses','2010-09-14 22:10:45',NULL);
+INSERT INTO `permission` VALUES (289,3,9,43,'Default Error Noaccess','2010-09-14 22:10:45',NULL);
+INSERT INTO `permission` VALUES (290,1,6,143,'Applicant View Completedapps','2010-09-20 23:11:58',NULL);
+INSERT INTO `permission` VALUES (291,1,6,144,'Applicant View Statuschange','2010-09-20 23:11:58',NULL);
+INSERT INTO `permission` VALUES (292,1,6,134,'Applicant View Waitlist','2010-09-30 22:10:52',NULL);
+INSERT INTO `permission` VALUES (293,1,1,145,'Applicant Create Addpreleasefee','2010-10-12 21:09:40',NULL);
+INSERT INTO `permission` VALUES (294,1,1,146,'Applicant Create Applicantemail','2010-10-12 21:09:40',NULL);
+INSERT INTO `permission` VALUES (295,1,1,147,'Applicant Create Waitlistemail','2010-10-12 21:09:40',NULL);
+INSERT INTO `permission` VALUES (296,1,6,148,'Applicant View Viewpreleaseapplicantfees','2010-10-12 21:09:41',NULL);
+INSERT INTO `permission` VALUES (297,4,33,149,'Financial Refundforfeit Refund','2010-10-12 21:09:41',NULL);
+INSERT INTO `permission` VALUES (298,4,33,150,'Financial Refundforfeit Forfeit','2010-10-12 21:09:41',NULL);
+INSERT INTO `permission` VALUES (299,1,1,151,'Applicant Create Payapplicantbills','2010-10-17 13:01:53',NULL);
+INSERT INTO `permission` VALUES (300,1,5,152,'Applicant Update Bgcheck','2010-10-17 13:01:53',NULL);
+INSERT INTO `permission` VALUES (301,1,6,153,'Applicant View Bgcheckdetails','2010-10-17 13:01:53',NULL);
+INSERT INTO `permission` VALUES (302,1,1,154,'Applicant Create Selectapplicantbills','2010-10-28 23:11:43',NULL);
+INSERT INTO `permission` VALUES (303,1,1,155,'Applicant Create Payapplicantbillconfirmation','2010-10-28 23:11:43',NULL);
+INSERT INTO `permission` VALUES (304,4,34,1,'Financial Report Index','2010-10-28 23:11:43',NULL);
+INSERT INTO `permission` VALUES (305,4,34,156,'Financial Report Rentroll','2010-10-28 23:11:43',NULL);
+INSERT INTO `permission` VALUES (306,12,1,1,'Unit Create Index','2010-10-28 23:11:43',NULL);
+INSERT INTO `permission` VALUES (308,12,1,151,'Unit Create Payapplicantbills','2010-10-28 23:11:43',NULL);
+INSERT INTO `permission` VALUES (309,12,1,155,'Unit Create Payapplicantbillconfirmation','2010-10-28 23:11:43',NULL);
+INSERT INTO `permission` VALUES (312,12,21,159,'Unit Lease Payleasebills','2010-11-03 21:09:25',NULL);
+INSERT INTO `permission` VALUES (313,12,21,160,'Unit Lease Payleasebillconfirmation','2010-11-03 21:09:25',NULL);
+INSERT INTO `permission` VALUES (314,12,19,161,'Unit Amenity Remove','2010-11-03 21:09:25',NULL);
+INSERT INTO `permission` VALUES (315,12,24,161,'Unit Unit Remove','2010-11-03 21:09:25',NULL);
+INSERT INTO `permission` VALUES (316,12,23,161,'Unit Unitmodel Remove','2010-11-03 21:09:25',NULL);
+INSERT INTO `permission` VALUES (317,4,30,1,'Financial Financialaccountsetting Index','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (318,4,28,1,'Financial Accountlink Index','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (319,4,27,1,'Financial Fee Index','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (320,4,27,161,'Financial Fee Remove','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (321,4,26,1,'Financial Account Index','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (322,4,26,161,'Financial Account Remove','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (323,4,26,36,'Financial Account Createaccounttransaction','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (324,4,26,51,'Financial Account Viewaccounttransactions','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (325,4,26,59,'Financial Account Viewtransaction','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (326,6,35,65,'Maintenance Maintenance Createmaintenancerequestadmin','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (327,6,35,66,'Maintenance Maintenance Createmaintenancerequest','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (328,6,35,69,'Maintenance Maintenance Viewallmaintenancerequests','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (329,6,35,70,'Maintenance Maintenance Viewmaintenancerequest','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (330,6,35,71,'Maintenance Maintenance Viewmaintenancerequestadmin','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (331,6,35,72,'Maintenance Maintenance Viewmymaintenancerequests','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (332,6,35,73,'Maintenance Maintenance Viewassignedrequests','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (333,6,1,65,'Maintenance Create Createmaintenancerequestadmin','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (334,6,1,66,'Maintenance Create Createmaintenancerequest','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (335,6,11,1,'Maintenance Setting Index','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (336,6,11,162,'Maintenance Setting Viewsettings','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (337,12,22,161,'Unit Modelrentschedule Remove','2010-11-14 00:12:29',NULL);
+INSERT INTO `permission` VALUES (338,1,34,1,'Applicant Report Index','2010-11-26 21:09:40',NULL);
+INSERT INTO `permission` VALUES (339,1,34,163,'Applicant Report Applicant','2010-11-26 21:09:40',NULL);
+INSERT INTO `permission` VALUES (340,6,35,1,'Maintenance Maintenance Index','2010-11-26 21:09:40',NULL);
+INSERT INTO `permission` VALUES (341,12,13,164,'Unit Leasewizard Recurringfees','2010-11-26 21:09:40',NULL);
+INSERT INTO `permission` VALUES (342,12,34,1,'Unit Report Index','2010-11-26 21:09:40',NULL);
+INSERT INTO `permission` VALUES (343,12,34,165,'Unit Report Cancelledlease','2010-11-26 21:09:40',NULL);
+INSERT INTO `permission` VALUES (344,12,34,166,'Unit Report Incomingtenets','2010-11-26 21:09:40',NULL);
+INSERT INTO `permission` VALUES (345,1,34,167,'Applicant Report Paidfees','2010-11-29 20:08:48',NULL);
+INSERT INTO `permission` VALUES (346,6,34,1,'Maintenance Report Index','2010-11-29 20:08:48',NULL);
+INSERT INTO `permission` VALUES (347,6,34,168,'Maintenance Report Servicerequests','2010-11-29 20:08:48',NULL);
+INSERT INTO `permission` VALUES (348,12,34,169,'Unit Report Outgoingtenets','2010-11-29 20:08:48',NULL);
+INSERT INTO `permission` VALUES (349,1,34,170,'Applicant Report Nonpaidfees','2010-12-05 16:04:00',NULL);
+INSERT INTO `permission` VALUES (350,4,34,171,'Financial Report Duefee','2010-12-05 16:04:00',NULL);
+INSERT INTO `permission` VALUES (351,4,34,172,'Financial Report Duerent','2010-12-05 16:04:00',NULL);
+INSERT INTO `permission` VALUES (352,4,34,173,'Financial Report Duerefunds','2010-12-05 16:04:00',NULL);
+INSERT INTO `permission` VALUES (353,4,34,174,'Financial Report Lateduerent','2010-12-05 16:04:00',NULL);
+INSERT INTO `permission` VALUES (354,4,34,175,'Financial Report Lateduefee','2010-12-05 16:04:00',NULL);
+INSERT INTO `permission` VALUES (355,1,9,34,'Applicant Error Error','2010-12-24 11:11:29',NULL);
+INSERT INTO `permission` VALUES (356,1,9,43,'Applicant Error Noaccess','2010-12-24 11:11:29',NULL);
+INSERT INTO `permission` VALUES (357,4,34,176,'Financial Report Incomestatement','2010-12-24 11:11:29',NULL);
+INSERT INTO `permission` VALUES (358,12,34,177,'Unit Report Unoccupiedunits','2010-12-24 11:11:29',NULL);
+INSERT INTO `permission` VALUES (359,4,34,178,'Financial Report Balancesheet','2010-12-25 22:10:49',NULL);
+INSERT INTO `permission` VALUES (360,12,13,179,'Unit Leasewizard Clonelease','2010-12-25 22:10:49',NULL);
+INSERT INTO `permission` VALUES (361,12,13,180,'Unit Leasewizard Selectpreleasefees','2010-12-25 22:10:49',NULL);
+INSERT INTO `permission` VALUES (363,13,2,182,'User Index Forgotpassword','2010-12-25 22:10:49',NULL);
+INSERT INTO `permission` VALUES (364,13,6,183,'User View Info','2010-12-25 22:10:49','2010-12-31 13:03:56');
+INSERT INTO `permission` VALUES (365,12,13,184,'Unit Leasewizard Selectleasefees','2010-12-31 12:12:11',NULL);
+INSERT INTO `permission` VALUES (367,12,21,186,'Unit Lease Viewdocument','2011-01-06 00:12:25',NULL);
+INSERT INTO `permission` VALUES (368,12,21,187,'Unit Lease Deletedocument','2011-01-06 00:12:25',NULL);
+INSERT INTO `permission` VALUES (370,13,5,79,'User Update Delete','2011-01-06 00:12:25',NULL);
+INSERT INTO `permission` VALUES (371,12,21,189,'Unit Lease Myleaselist','2011-01-08 23:11:43',NULL);
+INSERT INTO `permission` VALUES (372,13,2,183,'User Index Info','2011-01-08 23:11:43',NULL);
+INSERT INTO `permission` VALUES (374,12,24,191,'Unit Unit Myunit','2011-01-09 18:06:53',NULL);
+INSERT INTO `permission` VALUES (375,13,2,192,'User Index Forgotusername','2011-01-09 18:06:54',NULL);
+INSERT INTO `permission` VALUES (376,13,2,193,'User Index Forgotinfo','2011-01-09 18:06:54',NULL);
+INSERT INTO `permission` VALUES (377,12,21,194,'Unit Lease Mylease','2011-01-13 21:09:38',NULL);
+INSERT INTO `permission` VALUES (378,12,21,195,'Unit Lease Viewmyleasebill','2011-01-13 21:09:38',NULL);
+INSERT INTO `permission` VALUES (379,12,21,196,'Unit Lease Viewmypayments','2011-01-13 21:09:38',NULL);
+INSERT INTO `permission` VALUES (380,13,2,197,'User Index Resetpassword','2011-01-13 21:09:38',NULL);
+INSERT INTO `permission` VALUES (381,12,21,198,'Unit Lease Viewevictions','2011-01-19 14:08:49',NULL);
+INSERT INTO `permission` VALUES (382,12,21,199,'Unit Lease Vieweviction','2011-01-19 14:08:49',NULL);
+INSERT INTO `permission` VALUES (383,12,21,200,'Unit Lease Createeviction','2011-01-19 14:08:49',NULL);
+INSERT INTO `permission` VALUES (384,12,21,201,'Unit Lease Viewallevictiondocuments','2011-01-19 14:08:49',NULL);
+INSERT INTO `permission` VALUES (385,12,21,202,'Unit Lease Addevictiondocument','2011-01-19 14:08:49',NULL);
+INSERT INTO `permission` VALUES (386,12,21,203,'Unit Lease Viewevictiondocument','2011-01-19 14:08:49',NULL);
+INSERT INTO `permission` VALUES (387,12,21,204,'Unit Lease Deleteevictiondocument','2011-01-19 14:08:49',NULL);
+INSERT INTO `permission` VALUES (388,12,21,205,'Unit Lease Adddocument','2011-01-19 14:08:49',NULL);
+INSERT INTO `permission` VALUES (389,12,21,206,'Unit Lease Viewalldocuments','2011-01-19 14:08:49',NULL);
+INSERT INTO `permission` VALUES (393,12,21,210,'Unit Lease Myrentbill','2011-01-19 14:08:49',NULL);
+INSERT INTO `permission` VALUES (396,12,21,213,'Unit Lease Selectleasebills','2011-01-19 14:08:49',NULL);
+INSERT INTO `permission` VALUES (397,15,6,1,'Prospects View Index','2011-02-13 15:03:36',NULL);
+INSERT INTO `permission` VALUES (398,15,6,214,'Prospects View Detail','2011-02-13 15:03:36',NULL);
+INSERT INTO `permission` VALUES (399,15,15,1,'Prospects Add Index','2011-02-13 15:03:36',NULL);
+
+INSERT INTO `rolePermission` VALUES (3,4,42,'2010-08-20 18:50:49','2010-08-20 18:50:51');
+INSERT INTO `rolePermission` VALUES (4,4,43,'2010-08-20 18:51:05','2010-08-20 18:51:07');
+INSERT INTO `rolePermission` VALUES (5,4,185,'2010-08-20 18:52:19','2010-08-20 18:52:21');
+INSERT INTO `rolePermission` VALUES (8,1,1,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (11,1,4,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (12,1,5,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (13,1,6,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (49,1,42,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (50,1,43,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (81,1,74,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (82,1,75,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (83,1,76,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (84,1,77,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (85,1,78,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (88,1,81,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (89,1,82,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (90,1,83,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (96,1,89,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (97,1,90,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (98,1,91,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (99,1,92,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (100,1,93,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (101,1,94,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (102,1,95,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (103,1,96,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (104,1,97,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (105,1,98,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (106,1,99,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (107,1,100,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (108,1,101,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (109,1,102,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (110,1,103,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (111,1,104,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (112,1,105,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (113,1,106,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (114,1,107,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (115,1,108,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (116,1,109,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (117,1,110,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (118,1,111,'2010-08-20 20:14:20',NULL);
+INSERT INTO `rolePermission` VALUES (119,1,112,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (120,1,113,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (121,1,114,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (122,1,115,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (123,1,116,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (124,1,117,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (126,1,119,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (127,1,120,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (128,1,121,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (129,1,122,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (130,1,123,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (144,1,137,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (145,1,138,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (146,1,139,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (147,1,140,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (148,1,141,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (149,1,142,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (150,1,143,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (151,1,144,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (152,1,145,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (153,1,146,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (154,1,147,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (155,1,148,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (156,1,149,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (158,1,151,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (159,1,152,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (160,1,153,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (161,1,154,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (167,1,160,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (182,1,175,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (192,1,185,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (194,1,187,'2010-08-20 20:14:21',NULL);
+INSERT INTO `rolePermission` VALUES (195,1,2,'2010-08-20 20:19:07',NULL);
+INSERT INTO `rolePermission` VALUES (196,7,2,'2010-08-20 20:19:07',NULL);
+INSERT INTO `rolePermission` VALUES (197,1,3,'2010-08-20 20:19:25',NULL);
+INSERT INTO `rolePermission` VALUES (198,7,3,'2010-08-20 20:19:25',NULL);
+INSERT INTO `rolePermission` VALUES (209,1,9,'2010-08-20 20:20:30',NULL);
+INSERT INTO `rolePermission` VALUES (210,5,9,'2010-08-20 20:20:30',NULL);
+INSERT INTO `rolePermission` VALUES (211,6,9,'2010-08-20 20:20:30',NULL);
+INSERT INTO `rolePermission` VALUES (212,7,9,'2010-08-20 20:20:30',NULL);
+INSERT INTO `rolePermission` VALUES (213,8,9,'2010-08-20 20:20:30',NULL);
+INSERT INTO `rolePermission` VALUES (226,1,14,'2010-08-20 20:25:33',NULL);
+INSERT INTO `rolePermission` VALUES (227,8,14,'2010-08-20 20:25:33',NULL);
+INSERT INTO `rolePermission` VALUES (228,1,15,'2010-08-20 20:27:10',NULL);
+INSERT INTO `rolePermission` VALUES (229,8,15,'2010-08-20 20:27:10',NULL);
+INSERT INTO `rolePermission` VALUES (230,1,16,'2010-08-20 20:27:51',NULL);
+INSERT INTO `rolePermission` VALUES (231,8,16,'2010-08-20 20:27:51',NULL);
+INSERT INTO `rolePermission` VALUES (232,1,17,'2010-08-20 20:28:10',NULL);
+INSERT INTO `rolePermission` VALUES (233,8,17,'2010-08-20 20:28:10',NULL);
+INSERT INTO `rolePermission` VALUES (235,1,18,'2010-08-20 20:28:39',NULL);
+INSERT INTO `rolePermission` VALUES (236,8,18,'2010-08-20 20:28:39',NULL);
+INSERT INTO `rolePermission` VALUES (237,1,19,'2010-08-20 20:28:53',NULL);
+INSERT INTO `rolePermission` VALUES (238,8,19,'2010-08-20 20:28:53',NULL);
+INSERT INTO `rolePermission` VALUES (239,1,20,'2010-08-20 20:29:13',NULL);
+INSERT INTO `rolePermission` VALUES (240,8,20,'2010-08-20 20:29:13',NULL);
+INSERT INTO `rolePermission` VALUES (241,1,21,'2010-08-20 20:29:52',NULL);
+INSERT INTO `rolePermission` VALUES (242,8,21,'2010-08-20 20:29:52',NULL);
+INSERT INTO `rolePermission` VALUES (243,1,22,'2010-08-20 20:30:03',NULL);
+INSERT INTO `rolePermission` VALUES (244,8,22,'2010-08-20 20:30:03',NULL);
+INSERT INTO `rolePermission` VALUES (245,1,23,'2010-08-20 20:30:14',NULL);
+INSERT INTO `rolePermission` VALUES (246,8,23,'2010-08-20 20:30:14',NULL);
+INSERT INTO `rolePermission` VALUES (247,1,24,'2010-08-20 20:30:31',NULL);
+INSERT INTO `rolePermission` VALUES (248,8,24,'2010-08-20 20:30:31',NULL);
+INSERT INTO `rolePermission` VALUES (249,1,25,'2010-08-20 20:30:42',NULL);
+INSERT INTO `rolePermission` VALUES (250,8,25,'2010-08-20 20:30:42',NULL);
+INSERT INTO `rolePermission` VALUES (251,1,26,'2010-08-20 20:30:53',NULL);
+INSERT INTO `rolePermission` VALUES (252,8,26,'2010-08-20 20:30:53',NULL);
+INSERT INTO `rolePermission` VALUES (256,1,28,'2010-08-20 20:33:06',NULL);
+INSERT INTO `rolePermission` VALUES (257,8,28,'2010-08-20 20:33:06',NULL);
+INSERT INTO `rolePermission` VALUES (258,1,29,'2010-08-20 20:33:22',NULL);
+INSERT INTO `rolePermission` VALUES (259,8,29,'2010-08-20 20:33:22',NULL);
+INSERT INTO `rolePermission` VALUES (260,1,30,'2010-08-20 20:33:36',NULL);
+INSERT INTO `rolePermission` VALUES (261,2,30,'2010-08-20 20:33:36',NULL);
+INSERT INTO `rolePermission` VALUES (262,1,31,'2010-08-20 20:33:55',NULL);
+INSERT INTO `rolePermission` VALUES (263,2,31,'2010-08-20 20:33:55',NULL);
+INSERT INTO `rolePermission` VALUES (264,1,32,'2010-08-20 20:34:09',NULL);
+INSERT INTO `rolePermission` VALUES (265,2,32,'2010-08-20 20:34:09',NULL);
+INSERT INTO `rolePermission` VALUES (266,1,33,'2010-08-20 20:34:21',NULL);
+INSERT INTO `rolePermission` VALUES (267,2,33,'2010-08-20 20:34:21',NULL);
+INSERT INTO `rolePermission` VALUES (268,1,34,'2010-08-20 20:34:37',NULL);
+INSERT INTO `rolePermission` VALUES (269,2,34,'2010-08-20 20:34:37',NULL);
+INSERT INTO `rolePermission` VALUES (270,1,35,'2010-08-20 20:34:49',NULL);
+INSERT INTO `rolePermission` VALUES (271,2,35,'2010-08-20 20:34:49',NULL);
+INSERT INTO `rolePermission` VALUES (272,1,36,'2010-08-20 20:35:05',NULL);
+INSERT INTO `rolePermission` VALUES (273,2,36,'2010-08-20 20:35:05',NULL);
+INSERT INTO `rolePermission` VALUES (274,1,37,'2010-08-20 20:35:18',NULL);
+INSERT INTO `rolePermission` VALUES (275,2,37,'2010-08-20 20:35:18',NULL);
+INSERT INTO `rolePermission` VALUES (276,1,38,'2010-08-20 20:35:33',NULL);
+INSERT INTO `rolePermission` VALUES (277,2,38,'2010-08-20 20:35:33',NULL);
+INSERT INTO `rolePermission` VALUES (278,1,39,'2010-08-20 20:35:47',NULL);
+INSERT INTO `rolePermission` VALUES (279,2,39,'2010-08-20 20:35:47',NULL);
+INSERT INTO `rolePermission` VALUES (280,1,40,'2010-08-20 20:36:06',NULL);
+INSERT INTO `rolePermission` VALUES (281,2,40,'2010-08-20 20:36:06',NULL);
+INSERT INTO `rolePermission` VALUES (298,1,52,'2010-08-20 20:38:47',NULL);
+INSERT INTO `rolePermission` VALUES (299,7,52,'2010-08-20 20:38:47',NULL);
+INSERT INTO `rolePermission` VALUES (302,1,53,'2010-08-20 20:39:35',NULL);
+INSERT INTO `rolePermission` VALUES (303,2,53,'2010-08-20 20:39:35',NULL);
+INSERT INTO `rolePermission` VALUES (305,5,53,'2010-08-20 20:39:35',NULL);
+INSERT INTO `rolePermission` VALUES (306,6,53,'2010-08-20 20:39:35',NULL);
+INSERT INTO `rolePermission` VALUES (307,7,53,'2010-08-20 20:39:35',NULL);
+INSERT INTO `rolePermission` VALUES (308,8,53,'2010-08-20 20:39:35',NULL);
+INSERT INTO `rolePermission` VALUES (355,1,8,'2010-08-21 12:44:18',NULL);
+INSERT INTO `rolePermission` VALUES (356,2,8,'2010-08-21 12:44:18',NULL);
+INSERT INTO `rolePermission` VALUES (357,5,8,'2010-08-21 12:44:18',NULL);
+INSERT INTO `rolePermission` VALUES (358,6,8,'2010-08-21 12:44:18',NULL);
+INSERT INTO `rolePermission` VALUES (359,7,8,'2010-08-21 12:44:18',NULL);
+INSERT INTO `rolePermission` VALUES (360,8,8,'2010-08-21 12:44:18',NULL);
+INSERT INTO `rolePermission` VALUES (361,1,7,'2010-08-21 12:44:31',NULL);
+INSERT INTO `rolePermission` VALUES (362,2,7,'2010-08-21 12:44:31',NULL);
+INSERT INTO `rolePermission` VALUES (363,5,7,'2010-08-21 12:44:31',NULL);
+INSERT INTO `rolePermission` VALUES (364,6,7,'2010-08-21 12:44:31',NULL);
+INSERT INTO `rolePermission` VALUES (365,7,7,'2010-08-21 12:44:31',NULL);
+INSERT INTO `rolePermission` VALUES (366,8,7,'2010-08-21 12:44:31',NULL);
+INSERT INTO `rolePermission` VALUES (367,1,54,'2010-08-21 12:56:54',NULL);
+INSERT INTO `rolePermission` VALUES (375,1,188,'2010-08-22 20:46:57',NULL);
+INSERT INTO `rolePermission` VALUES (376,2,188,'2010-08-22 20:46:57',NULL);
+INSERT INTO `rolePermission` VALUES (377,8,188,'2010-08-22 20:46:57',NULL);
+INSERT INTO `rolePermission` VALUES (381,1,150,'2010-08-23 19:50:11',NULL);
+INSERT INTO `rolePermission` VALUES (382,2,150,'2010-08-23 19:50:11',NULL);
+INSERT INTO `rolePermission` VALUES (383,3,150,'2010-08-23 19:50:11',NULL);
+INSERT INTO `rolePermission` VALUES (384,4,150,'2010-08-23 19:50:11',NULL);
+INSERT INTO `rolePermission` VALUES (385,5,150,'2010-08-23 19:50:11',NULL);
+INSERT INTO `rolePermission` VALUES (386,6,150,'2010-08-23 19:50:11',NULL);
+INSERT INTO `rolePermission` VALUES (387,7,150,'2010-08-23 19:50:11',NULL);
+INSERT INTO `rolePermission` VALUES (388,8,150,'2010-08-23 19:50:11',NULL);
+INSERT INTO `rolePermission` VALUES (389,1,10,'2010-08-23 19:59:50',NULL);
+INSERT INTO `rolePermission` VALUES (390,3,10,'2010-08-23 19:59:50',NULL);
+INSERT INTO `rolePermission` VALUES (391,4,10,'2010-08-23 19:59:50',NULL);
+INSERT INTO `rolePermission` VALUES (392,8,10,'2010-08-23 19:59:50',NULL);
+INSERT INTO `rolePermission` VALUES (401,1,13,'2010-08-23 20:00:34',NULL);
+INSERT INTO `rolePermission` VALUES (402,3,13,'2010-08-23 20:00:34',NULL);
+INSERT INTO `rolePermission` VALUES (403,4,13,'2010-08-23 20:00:34',NULL);
+INSERT INTO `rolePermission` VALUES (404,8,13,'2010-08-23 20:00:34',NULL);
+INSERT INTO `rolePermission` VALUES (405,1,133,'2010-08-23 20:01:35',NULL);
+INSERT INTO `rolePermission` VALUES (406,2,133,'2010-08-23 20:01:35',NULL);
+INSERT INTO `rolePermission` VALUES (407,3,133,'2010-08-23 20:01:35',NULL);
+INSERT INTO `rolePermission` VALUES (408,4,133,'2010-08-23 20:01:35',NULL);
+INSERT INTO `rolePermission` VALUES (409,5,133,'2010-08-23 20:01:35',NULL);
+INSERT INTO `rolePermission` VALUES (410,6,133,'2010-08-23 20:01:35',NULL);
+INSERT INTO `rolePermission` VALUES (411,7,133,'2010-08-23 20:01:35',NULL);
+INSERT INTO `rolePermission` VALUES (412,8,133,'2010-08-23 20:01:35',NULL);
+INSERT INTO `rolePermission` VALUES (429,1,176,'2010-08-23 20:11:33',NULL);
+INSERT INTO `rolePermission` VALUES (430,3,176,'2010-08-23 20:11:33',NULL);
+INSERT INTO `rolePermission` VALUES (431,4,176,'2010-08-23 20:11:33',NULL);
+INSERT INTO `rolePermission` VALUES (435,1,179,'2010-08-23 20:12:18',NULL);
+INSERT INTO `rolePermission` VALUES (436,2,179,'2010-08-23 20:12:19',NULL);
+INSERT INTO `rolePermission` VALUES (437,3,179,'2010-08-23 20:12:19',NULL);
+INSERT INTO `rolePermission` VALUES (438,4,179,'2010-08-23 20:12:19',NULL);
+INSERT INTO `rolePermission` VALUES (439,5,179,'2010-08-23 20:12:19',NULL);
+INSERT INTO `rolePermission` VALUES (440,6,179,'2010-08-23 20:12:19',NULL);
+INSERT INTO `rolePermission` VALUES (441,7,179,'2010-08-23 20:12:19',NULL);
+INSERT INTO `rolePermission` VALUES (442,8,179,'2010-08-23 20:12:19',NULL);
+INSERT INTO `rolePermission` VALUES (443,1,180,'2010-08-23 20:12:31',NULL);
+INSERT INTO `rolePermission` VALUES (444,2,180,'2010-08-23 20:12:31',NULL);
+INSERT INTO `rolePermission` VALUES (445,3,180,'2010-08-23 20:12:31',NULL);
+INSERT INTO `rolePermission` VALUES (446,4,180,'2010-08-23 20:12:31',NULL);
+INSERT INTO `rolePermission` VALUES (447,5,180,'2010-08-23 20:12:31',NULL);
+INSERT INTO `rolePermission` VALUES (448,6,180,'2010-08-23 20:12:31',NULL);
+INSERT INTO `rolePermission` VALUES (449,7,180,'2010-08-23 20:12:31',NULL);
+INSERT INTO `rolePermission` VALUES (450,8,180,'2010-08-23 20:12:31',NULL);
+INSERT INTO `rolePermission` VALUES (451,1,136,'2010-08-23 20:13:35',NULL);
+INSERT INTO `rolePermission` VALUES (452,4,136,'2010-08-23 20:13:35',NULL);
+INSERT INTO `rolePermission` VALUES (453,1,189,'2010-08-25 22:44:58',NULL);
+INSERT INTO `rolePermission` VALUES (454,5,189,'2010-08-25 22:44:58',NULL);
+INSERT INTO `rolePermission` VALUES (455,8,189,'2010-08-25 22:44:58',NULL);
+INSERT INTO `rolePermission` VALUES (456,7,189,'2010-08-25 22:44:58',NULL);
+INSERT INTO `rolePermission` VALUES (457,4,189,'2010-08-25 22:44:58',NULL);
+INSERT INTO `rolePermission` VALUES (458,2,189,'2010-08-25 22:44:58',NULL);
+INSERT INTO `rolePermission` VALUES (459,6,189,'2010-08-25 22:44:58',NULL);
+INSERT INTO `rolePermission` VALUES (460,3,189,'2010-08-25 22:44:58',NULL);
+INSERT INTO `rolePermission` VALUES (472,1,195,'2010-08-28 14:34:35',NULL);
+INSERT INTO `rolePermission` VALUES (473,5,195,'2010-08-28 14:34:35',NULL);
+INSERT INTO `rolePermission` VALUES (474,8,195,'2010-08-28 14:34:35',NULL);
+INSERT INTO `rolePermission` VALUES (475,7,195,'2010-08-28 14:34:35',NULL);
+INSERT INTO `rolePermission` VALUES (476,2,195,'2010-08-28 14:34:35',NULL);
+INSERT INTO `rolePermission` VALUES (477,6,195,'2010-08-28 14:34:35',NULL);
+INSERT INTO `rolePermission` VALUES (478,1,192,'2010-08-29 18:53:23',NULL);
+INSERT INTO `rolePermission` VALUES (479,1,196,'2010-08-29 19:06:33',NULL);
+INSERT INTO `rolePermission` VALUES (480,5,196,'2010-08-29 19:06:33',NULL);
+INSERT INTO `rolePermission` VALUES (481,8,196,'2010-08-29 19:06:33',NULL);
+INSERT INTO `rolePermission` VALUES (482,7,196,'2010-08-29 19:06:33',NULL);
+INSERT INTO `rolePermission` VALUES (483,4,196,'2010-08-29 19:06:33',NULL);
+INSERT INTO `rolePermission` VALUES (484,2,196,'2010-08-29 19:06:33',NULL);
+INSERT INTO `rolePermission` VALUES (485,6,196,'2010-08-29 19:06:33',NULL);
+INSERT INTO `rolePermission` VALUES (486,3,196,'2010-08-29 19:06:33',NULL);
+INSERT INTO `rolePermission` VALUES (487,1,197,'2010-08-29 19:06:46',NULL);
+INSERT INTO `rolePermission` VALUES (488,5,197,'2010-08-29 19:06:46',NULL);
+INSERT INTO `rolePermission` VALUES (489,8,197,'2010-08-29 19:06:46',NULL);
+INSERT INTO `rolePermission` VALUES (490,7,197,'2010-08-29 19:06:46',NULL);
+INSERT INTO `rolePermission` VALUES (491,4,197,'2010-08-29 19:06:46',NULL);
+INSERT INTO `rolePermission` VALUES (492,2,197,'2010-08-29 19:06:46',NULL);
+INSERT INTO `rolePermission` VALUES (493,6,197,'2010-08-29 19:06:46',NULL);
+INSERT INTO `rolePermission` VALUES (494,3,197,'2010-08-29 19:06:46',NULL);
+INSERT INTO `rolePermission` VALUES (496,1,198,'2010-09-01 21:15:18',NULL);
+INSERT INTO `rolePermission` VALUES (497,8,198,'2010-09-01 21:15:18',NULL);
+INSERT INTO `rolePermission` VALUES (498,2,198,'2010-09-01 21:15:18',NULL);
+INSERT INTO `rolePermission` VALUES (499,1,217,'2010-09-04 20:12:56',NULL);
+INSERT INTO `rolePermission` VALUES (500,1,216,'2010-09-04 20:13:07',NULL);
+INSERT INTO `rolePermission` VALUES (501,1,218,'2010-09-04 20:13:30',NULL);
+INSERT INTO `rolePermission` VALUES (502,1,219,'2010-09-04 20:13:40',NULL);
+INSERT INTO `rolePermission` VALUES (504,1,205,'2010-09-04 20:14:52',NULL);
+INSERT INTO `rolePermission` VALUES (505,1,206,'2010-09-04 20:15:00',NULL);
+INSERT INTO `rolePermission` VALUES (506,1,204,'2010-09-04 20:15:12',NULL);
+INSERT INTO `rolePermission` VALUES (507,1,207,'2010-09-04 20:15:20',NULL);
+INSERT INTO `rolePermission` VALUES (508,1,208,'2010-09-04 20:15:36',NULL);
+INSERT INTO `rolePermission` VALUES (509,1,209,'2010-09-04 20:15:49',NULL);
+INSERT INTO `rolePermission` VALUES (510,1,232,'2010-09-04 20:17:14',NULL);
+INSERT INTO `rolePermission` VALUES (512,1,230,'2010-09-04 20:17:45',NULL);
+INSERT INTO `rolePermission` VALUES (513,1,229,'2010-09-04 20:17:55',NULL);
+INSERT INTO `rolePermission` VALUES (514,1,233,'2010-09-04 20:18:11',NULL);
+INSERT INTO `rolePermission` VALUES (515,1,234,'2010-09-04 20:18:39',NULL);
+INSERT INTO `rolePermission` VALUES (516,1,211,'2010-09-04 20:19:09',NULL);
+INSERT INTO `rolePermission` VALUES (517,1,210,'2010-09-04 20:19:16',NULL);
+INSERT INTO `rolePermission` VALUES (518,1,212,'2010-09-04 20:19:28',NULL);
+INSERT INTO `rolePermission` VALUES (519,1,213,'2010-09-04 20:19:40',NULL);
+INSERT INTO `rolePermission` VALUES (520,1,222,'2010-09-04 20:20:15',NULL);
+INSERT INTO `rolePermission` VALUES (521,1,221,'2010-09-04 20:20:22',NULL);
+INSERT INTO `rolePermission` VALUES (522,1,220,'2010-09-04 20:20:35',NULL);
+INSERT INTO `rolePermission` VALUES (524,1,226,'2010-09-04 20:21:00',NULL);
+INSERT INTO `rolePermission` VALUES (525,1,223,'2010-09-04 20:21:09',NULL);
+INSERT INTO `rolePermission` VALUES (526,1,224,'2010-09-04 20:21:19',NULL);
+INSERT INTO `rolePermission` VALUES (527,1,225,'2010-09-04 20:21:29',NULL);
+INSERT INTO `rolePermission` VALUES (529,1,200,'2010-09-04 20:22:21',NULL);
+INSERT INTO `rolePermission` VALUES (530,1,199,'2010-09-04 20:22:27',NULL);
+INSERT INTO `rolePermission` VALUES (531,1,201,'2010-09-04 20:22:36',NULL);
+INSERT INTO `rolePermission` VALUES (532,1,202,'2010-09-04 20:22:46',NULL);
+INSERT INTO `rolePermission` VALUES (533,1,203,'2010-09-04 20:22:53',NULL);
+INSERT INTO `rolePermission` VALUES (534,1,190,'2010-09-04 20:23:08',NULL);
+INSERT INTO `rolePermission` VALUES (535,1,177,'2010-09-04 20:23:17',NULL);
+INSERT INTO `rolePermission` VALUES (536,1,235,'2010-09-04 23:50:29',NULL);
+INSERT INTO `rolePermission` VALUES (537,8,235,'2010-09-04 23:50:29',NULL);
+INSERT INTO `rolePermission` VALUES (538,2,235,'2010-09-04 23:50:29',NULL);
+INSERT INTO `rolePermission` VALUES (539,2,203,'2010-09-05 00:00:00',NULL);
+INSERT INTO `rolePermission` VALUES (540,8,203,'2010-09-05 00:00:00',NULL);
+INSERT INTO `rolePermission` VALUES (541,2,226,'2010-09-05 00:00:00',NULL);
+INSERT INTO `rolePermission` VALUES (542,4,226,'2010-09-05 00:00:00',NULL);
+INSERT INTO `rolePermission` VALUES (543,8,226,'2010-09-05 00:00:00',NULL);
+INSERT INTO `rolePermission` VALUES (544,1,278,'2010-09-06 15:44:35',NULL);
+INSERT INTO `rolePermission` VALUES (545,1,279,'2010-09-06 15:44:44',NULL);
+INSERT INTO `rolePermission` VALUES (546,1,280,'2010-09-06 15:44:50',NULL);
+INSERT INTO `rolePermission` VALUES (547,1,281,'2010-09-06 15:44:56',NULL);
+INSERT INTO `rolePermission` VALUES (548,1,270,'2010-09-06 15:45:06',NULL);
+INSERT INTO `rolePermission` VALUES (549,1,271,'2010-09-06 15:45:12',NULL);
+INSERT INTO `rolePermission` VALUES (550,1,272,'2010-09-06 15:45:21',NULL);
+INSERT INTO `rolePermission` VALUES (551,1,273,'2010-09-06 15:45:26',NULL);
+INSERT INTO `rolePermission` VALUES (552,1,263,'2010-09-06 15:45:51',NULL);
+INSERT INTO `rolePermission` VALUES (553,1,264,'2010-09-06 15:45:58',NULL);
+INSERT INTO `rolePermission` VALUES (554,1,265,'2010-09-06 15:46:04',NULL);
+INSERT INTO `rolePermission` VALUES (555,1,267,'2010-09-06 15:46:38',NULL);
+INSERT INTO `rolePermission` VALUES (556,1,268,'2010-09-06 15:46:45',NULL);
+INSERT INTO `rolePermission` VALUES (557,1,266,'2010-09-06 15:46:52',NULL);
+INSERT INTO `rolePermission` VALUES (558,1,269,'2010-09-06 15:47:08',NULL);
+INSERT INTO `rolePermission` VALUES (559,8,269,'2010-09-06 15:47:08',NULL);
+INSERT INTO `rolePermission` VALUES (560,1,73,'2010-09-06 15:48:30',NULL);
+INSERT INTO `rolePermission` VALUES (561,7,73,'2010-09-06 15:48:30',NULL);
+INSERT INTO `rolePermission` VALUES (562,1,274,'2010-09-06 15:52:48',NULL);
+INSERT INTO `rolePermission` VALUES (563,7,274,'2010-09-06 15:52:48',NULL);
+INSERT INTO `rolePermission` VALUES (564,1,275,'2010-09-06 15:52:56',NULL);
+INSERT INTO `rolePermission` VALUES (565,7,275,'2010-09-06 15:52:56',NULL);
+INSERT INTO `rolePermission` VALUES (566,1,276,'2010-09-06 15:53:04',NULL);
+INSERT INTO `rolePermission` VALUES (567,7,276,'2010-09-06 15:53:04',NULL);
+INSERT INTO `rolePermission` VALUES (568,1,277,'2010-09-06 15:53:16',NULL);
+INSERT INTO `rolePermission` VALUES (569,2,277,'2010-09-06 15:53:16',NULL);
+INSERT INTO `rolePermission` VALUES (570,1,259,'2010-09-06 15:53:38',NULL);
+INSERT INTO `rolePermission` VALUES (571,7,259,'2010-09-06 15:53:38',NULL);
+INSERT INTO `rolePermission` VALUES (572,1,260,'2010-09-06 15:53:45',NULL);
+INSERT INTO `rolePermission` VALUES (573,7,260,'2010-09-06 15:53:45',NULL);
+INSERT INTO `rolePermission` VALUES (574,1,261,'2010-09-06 15:53:52',NULL);
+INSERT INTO `rolePermission` VALUES (575,7,261,'2010-09-06 15:53:52',NULL);
+INSERT INTO `rolePermission` VALUES (576,1,262,'2010-09-06 15:54:07',NULL);
+INSERT INTO `rolePermission` VALUES (577,8,262,'2010-09-06 15:54:07',NULL);
+INSERT INTO `rolePermission` VALUES (578,7,262,'2010-09-06 15:54:07',NULL);
+INSERT INTO `rolePermission` VALUES (579,1,282,'2010-09-06 20:10:57',NULL);
+INSERT INTO `rolePermission` VALUES (580,8,282,'2010-09-06 20:10:57',NULL);
+INSERT INTO `rolePermission` VALUES (581,4,282,'2010-09-06 20:10:57',NULL);
+INSERT INTO `rolePermission` VALUES (582,2,282,'2010-09-06 20:10:57',NULL);
+INSERT INTO `rolePermission` VALUES (585,1,289,'2010-09-14 22:41:59',NULL);
+INSERT INTO `rolePermission` VALUES (586,5,289,'2010-09-14 22:41:59',NULL);
+INSERT INTO `rolePermission` VALUES (587,8,289,'2010-09-14 22:41:59',NULL);
+INSERT INTO `rolePermission` VALUES (588,7,289,'2010-09-14 22:41:59',NULL);
+INSERT INTO `rolePermission` VALUES (589,4,289,'2010-09-14 22:41:59',NULL);
+INSERT INTO `rolePermission` VALUES (590,2,289,'2010-09-14 22:41:59',NULL);
+INSERT INTO `rolePermission` VALUES (591,6,289,'2010-09-14 22:41:59',NULL);
+INSERT INTO `rolePermission` VALUES (592,3,289,'2010-09-14 22:41:59',NULL);
+INSERT INTO `rolePermission` VALUES (594,1,291,'2010-09-20 23:30:48',NULL);
+INSERT INTO `rolePermission` VALUES (595,6,291,'2010-09-20 23:30:48',NULL);
+INSERT INTO `rolePermission` VALUES (600,1,290,'2010-09-30 22:49:18',NULL);
+INSERT INTO `rolePermission` VALUES (601,5,290,'2010-09-30 22:49:18',NULL);
+INSERT INTO `rolePermission` VALUES (602,1,283,'2010-09-30 22:49:37',NULL);
+INSERT INTO `rolePermission` VALUES (603,5,283,'2010-09-30 22:49:37',NULL);
+INSERT INTO `rolePermission` VALUES (604,1,292,'2010-09-30 22:49:46',NULL);
+INSERT INTO `rolePermission` VALUES (605,5,292,'2010-09-30 22:49:46',NULL);
+INSERT INTO `rolePermission` VALUES (606,1,294,'2010-10-12 21:18:35',NULL);
+INSERT INTO `rolePermission` VALUES (607,5,294,'2010-10-12 21:18:35',NULL);
+INSERT INTO `rolePermission` VALUES (608,1,295,'2010-10-12 21:18:46',NULL);
+INSERT INTO `rolePermission` VALUES (609,5,295,'2010-10-12 21:18:46',NULL);
+INSERT INTO `rolePermission` VALUES (610,1,300,'2010-10-17 13:05:50',NULL);
+INSERT INTO `rolePermission` VALUES (611,5,300,'2010-10-17 13:05:50',NULL);
+INSERT INTO `rolePermission` VALUES (612,1,301,'2010-10-17 13:06:03',NULL);
+INSERT INTO `rolePermission` VALUES (613,5,301,'2010-10-17 13:06:03',NULL);
+INSERT INTO `rolePermission` VALUES (618,1,304,'2010-11-03 21:34:49',NULL);
+INSERT INTO `rolePermission` VALUES (619,1,305,'2010-11-03 21:35:18',NULL);
+INSERT INTO `rolePermission` VALUES (620,1,339,'2010-11-29 21:01:16',NULL);
+INSERT INTO `rolePermission` VALUES (621,1,345,'2010-11-29 21:01:25',NULL);
+INSERT INTO `rolePermission` VALUES (622,1,338,'2010-11-29 21:01:34',NULL);
+INSERT INTO `rolePermission` VALUES (623,1,349,'2010-12-05 16:14:05',NULL);
+INSERT INTO `rolePermission` VALUES (624,1,355,'2010-12-24 11:29:27',NULL);
+INSERT INTO `rolePermission` VALUES (625,8,355,'2010-12-24 11:29:27',NULL);
+INSERT INTO `rolePermission` VALUES (626,7,355,'2010-12-24 11:29:27',NULL);
+INSERT INTO `rolePermission` VALUES (627,4,355,'2010-12-24 11:29:27',NULL);
+INSERT INTO `rolePermission` VALUES (628,5,355,'2010-12-24 11:29:27',NULL);
+INSERT INTO `rolePermission` VALUES (629,2,355,'2010-12-24 11:29:27',NULL);
+INSERT INTO `rolePermission` VALUES (630,6,355,'2010-12-24 11:29:27',NULL);
+INSERT INTO `rolePermission` VALUES (631,3,355,'2010-12-24 11:29:27',NULL);
+INSERT INTO `rolePermission` VALUES (632,1,356,'2010-12-24 11:29:44',NULL);
+INSERT INTO `rolePermission` VALUES (633,8,356,'2010-12-24 11:29:44',NULL);
+INSERT INTO `rolePermission` VALUES (634,7,356,'2010-12-24 11:29:44',NULL);
+INSERT INTO `rolePermission` VALUES (635,4,356,'2010-12-24 11:29:44',NULL);
+INSERT INTO `rolePermission` VALUES (636,5,356,'2010-12-24 11:29:44',NULL);
+INSERT INTO `rolePermission` VALUES (637,2,356,'2010-12-24 11:29:44',NULL);
+INSERT INTO `rolePermission` VALUES (638,6,356,'2010-12-24 11:29:44',NULL);
+INSERT INTO `rolePermission` VALUES (639,3,356,'2010-12-24 11:29:44',NULL);
+INSERT INTO `rolePermission` VALUES (664,1,184,'2010-12-29 18:36:14',NULL);
+INSERT INTO `rolePermission` VALUES (665,8,184,'2010-12-29 18:36:14',NULL);
+INSERT INTO `rolePermission` VALUES (666,7,184,'2010-12-29 18:36:14',NULL);
+INSERT INTO `rolePermission` VALUES (667,5,184,'2010-12-29 18:36:14',NULL);
+INSERT INTO `rolePermission` VALUES (668,6,184,'2010-12-29 18:36:14',NULL);
+INSERT INTO `rolePermission` VALUES (669,1,370,'2011-01-07 02:18:12',NULL);
+INSERT INTO `rolePermission` VALUES (670,1,181,'2011-01-08 18:14:39',NULL);
+INSERT INTO `rolePermission` VALUES (671,8,181,'2011-01-08 18:14:39',NULL);
+INSERT INTO `rolePermission` VALUES (672,7,181,'2011-01-08 18:14:39',NULL);
+INSERT INTO `rolePermission` VALUES (673,4,181,'2011-01-08 18:14:39',NULL);
+INSERT INTO `rolePermission` VALUES (674,5,181,'2011-01-08 18:14:39',NULL);
+INSERT INTO `rolePermission` VALUES (675,2,181,'2011-01-08 18:14:39',NULL);
+INSERT INTO `rolePermission` VALUES (676,6,181,'2011-01-08 18:14:39',NULL);
+INSERT INTO `rolePermission` VALUES (677,9,181,'2011-01-08 18:14:39',NULL);
+INSERT INTO `rolePermission` VALUES (687,1,364,'2011-01-08 23:34:50',NULL);
+INSERT INTO `rolePermission` VALUES (688,1,372,'2011-01-08 23:35:09',NULL);
+INSERT INTO `rolePermission` VALUES (689,8,372,'2011-01-08 23:35:09',NULL);
+INSERT INTO `rolePermission` VALUES (690,7,372,'2011-01-08 23:35:09',NULL);
+INSERT INTO `rolePermission` VALUES (691,4,372,'2011-01-08 23:35:09',NULL);
+INSERT INTO `rolePermission` VALUES (692,5,372,'2011-01-08 23:35:09',NULL);
+INSERT INTO `rolePermission` VALUES (693,2,372,'2011-01-08 23:35:09',NULL);
+INSERT INTO `rolePermission` VALUES (694,6,372,'2011-01-08 23:35:09',NULL);
+INSERT INTO `rolePermission` VALUES (695,9,372,'2011-01-08 23:35:09',NULL);
+INSERT INTO `rolePermission` VALUES (704,1,178,'2011-01-08 23:35:40',NULL);
+INSERT INTO `rolePermission` VALUES (705,8,178,'2011-01-08 23:35:40',NULL);
+INSERT INTO `rolePermission` VALUES (706,7,178,'2011-01-08 23:35:40',NULL);
+INSERT INTO `rolePermission` VALUES (708,5,178,'2011-01-08 23:35:40',NULL);
+INSERT INTO `rolePermission` VALUES (709,2,178,'2011-01-08 23:35:40',NULL);
+INSERT INTO `rolePermission` VALUES (710,6,178,'2011-01-08 23:35:40',NULL);
+INSERT INTO `rolePermission` VALUES (711,9,178,'2011-01-08 23:35:40',NULL);
+INSERT INTO `rolePermission` VALUES (712,1,186,'2011-01-08 23:40:17',NULL);
+INSERT INTO `rolePermission` VALUES (713,8,186,'2011-01-08 23:40:17',NULL);
+INSERT INTO `rolePermission` VALUES (714,7,186,'2011-01-08 23:40:17',NULL);
+INSERT INTO `rolePermission` VALUES (715,4,186,'2011-01-08 23:40:17',NULL);
+INSERT INTO `rolePermission` VALUES (716,5,186,'2011-01-08 23:40:17',NULL);
+INSERT INTO `rolePermission` VALUES (717,2,186,'2011-01-08 23:40:17',NULL);
+INSERT INTO `rolePermission` VALUES (718,6,186,'2011-01-08 23:40:17',NULL);
+INSERT INTO `rolePermission` VALUES (719,9,186,'2011-01-08 23:40:17',NULL);
+INSERT INTO `rolePermission` VALUES (720,1,41,'2011-01-08 23:43:41',NULL);
+INSERT INTO `rolePermission` VALUES (721,8,41,'2011-01-08 23:43:41',NULL);
+INSERT INTO `rolePermission` VALUES (722,7,41,'2011-01-08 23:43:41',NULL);
+INSERT INTO `rolePermission` VALUES (723,4,41,'2011-01-08 23:43:41',NULL);
+INSERT INTO `rolePermission` VALUES (724,5,41,'2011-01-08 23:43:41',NULL);
+INSERT INTO `rolePermission` VALUES (725,2,41,'2011-01-08 23:43:41',NULL);
+INSERT INTO `rolePermission` VALUES (726,6,41,'2011-01-08 23:43:41',NULL);
+INSERT INTO `rolePermission` VALUES (727,9,41,'2011-01-08 23:43:41',NULL);
+INSERT INTO `rolePermission` VALUES (729,4,376,'2011-01-09 18:18:46',NULL);
+INSERT INTO `rolePermission` VALUES (730,4,363,'2011-01-09 18:19:01',NULL);
+INSERT INTO `rolePermission` VALUES (731,4,375,'2011-01-09 18:19:13',NULL);
+INSERT INTO `rolePermission` VALUES (732,4,380,'2011-01-13 21:55:06',NULL);
+INSERT INTO `rolePermission` VALUES (733,1,381,'2011-01-09 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (734,1,382,'2011-01-09 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (735,1,383,'2011-01-09 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (736,1,384,'2011-01-09 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (737,1,385,'2011-01-09 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (738,1,386,'2011-01-09 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (739,1,387,'2011-01-09 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (740,1,388,'2011-01-09 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (741,1,389,'2011-01-09 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (745,1,393,'2011-01-09 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (748,1,396,'2011-01-09 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (751,9,374,'2011-01-24 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (752,9,220,'2011-01-24 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (753,9,133,'2011-01-24 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (754,9,371,'2011-01-25 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (755,9,377,'2011-01-25 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (756,9,389,'2011-01-25 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (757,9,367,'2011-01-25 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (758,9,11,'2011-01-25 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (759,9,12,'2011-01-25 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (760,9,378,'2011-01-26 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (761,9,379,'2011-01-26 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (762,9,81,'2011-01-28 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (763,9,327,'2011-01-28 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (764,9,329,'2011-01-28 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (765,9,331,'2011-01-28 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (766,9,340,'2011-01-28 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (767,1,340,'2011-01-29 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (768,1,328,'2011-01-29 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (769,1,326,'2011-01-29 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (770,1,332,'2011-01-29 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (771,1,324,'2011-01-29 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (772,1,323,'2011-01-29 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (773,1,346,'2011-01-29 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (774,1,342,'2011-01-29 14:08:49',NULL);
+INSERT INTO `rolePermission` VALUES (775,1,227,'2011-02-12 19:12:41',NULL);
+INSERT INTO `rolePermission` VALUES (776,8,227,'2011-02-12 19:12:41',NULL);
+INSERT INTO `rolePermission` VALUES (777,7,227,'2011-02-12 19:12:41',NULL);
+INSERT INTO `rolePermission` VALUES (778,4,227,'2011-02-12 19:12:41',NULL);
+INSERT INTO `rolePermission` VALUES (779,5,227,'2011-02-12 19:12:41',NULL);
+INSERT INTO `rolePermission` VALUES (780,2,227,'2011-02-12 19:12:41',NULL);
+INSERT INTO `rolePermission` VALUES (781,6,227,'2011-02-12 19:12:41',NULL);
+INSERT INTO `rolePermission` VALUES (782,9,227,'2011-02-12 19:12:41',NULL);
+INSERT INTO `rolePermission` VALUES (783,1,228,'2011-02-12 19:39:18',NULL);
+INSERT INTO `rolePermission` VALUES (784,8,228,'2011-02-12 19:39:18',NULL);
+INSERT INTO `rolePermission` VALUES (785,7,228,'2011-02-12 19:39:18',NULL);
+INSERT INTO `rolePermission` VALUES (786,4,228,'2011-02-12 19:39:18',NULL);
+INSERT INTO `rolePermission` VALUES (787,5,228,'2011-02-12 19:39:18',NULL);
+INSERT INTO `rolePermission` VALUES (788,2,228,'2011-02-12 19:39:18',NULL);
+INSERT INTO `rolePermission` VALUES (789,6,228,'2011-02-12 19:39:18',NULL);
+INSERT INTO `rolePermission` VALUES (790,9,228,'2011-02-12 19:39:18',NULL);
+INSERT INTO `rolePermission` VALUES (791,1,399,'2011-02-13 15:55:44',NULL);
+INSERT INTO `rolePermission` VALUES (792,5,399,'2011-02-13 15:55:44',NULL);
+INSERT INTO `rolePermission` VALUES (793,1,397,'2011-02-13 15:55:55',NULL);
+INSERT INTO `rolePermission` VALUES (794,5,397,'2011-02-13 15:55:55',NULL);
+INSERT INTO `rolePermission` VALUES (795,1,398,'2011-02-13 15:56:03',NULL);
+INSERT INTO `rolePermission` VALUES (796,5,398,'2011-02-13 15:56:03',NULL);
+
+INSERT INTO `reports` VALUES (1,'rentRoll','rentRoll',4,30,'rentroll','2010-10-28 22:56:59','2010-12-11 18:02:48');
+INSERT INTO `reports` VALUES (2,'cancelledLeaseReport','cancelledLease',12,60,'cancelledlease','2010-11-24 20:04:21','2010-12-11 18:02:48');
+INSERT INTO `reports` VALUES (3,'incomingTenantsReport','incomingTenants',12,60,'incomingtenants','2010-11-24 20:04:21','2010-12-11 18:02:48');
+INSERT INTO `reports` VALUES (4,'applicantReport','appreport',1,60,'applicant','2010-11-26 21:23:55','2010-12-11 18:02:48');
+INSERT INTO `reports` VALUES (5,'outgoingTenantsReport','outgoingTenants',12,60,'outgoingtenants','2010-11-24 20:04:21','2010-12-11 18:02:48');
+INSERT INTO `reports` VALUES (6,'serviceRequests','serviceRequests',6,60,'servicerequests','2010-11-24 20:04:21',NULL);
+INSERT INTO `reports` VALUES (7,'applicantpaidFees','applicantpaidfees',1,60,'paidfees','2010-11-29 20:49:56','2010-11-29 20:49:59');
+INSERT INTO `reports` VALUES (8,'lateDueRentReport','lateDueRent',4,60,'lateduerent','2010-11-24 20:04:21','2010-12-11 18:02:48');
+INSERT INTO `reports` VALUES (9,'dueRentReport','dueRent',4,60,'duerent','2010-11-24 20:04:21','2010-12-11 18:02:48');
+INSERT INTO `reports` VALUES (10,'lateDueFeeReport','lateDueFee',4,60,'lateduefee','2010-11-24 20:04:21','2010-12-11 18:02:48');
+INSERT INTO `reports` VALUES (11,'dueFeeReport','dueFee',4,60,'duefee','2010-11-24 20:04:21','2010-12-11 18:02:48');
+INSERT INTO `reports` VALUES (12,'dueRefundsReport','dueRefunds',4,60,'duerefunds','2010-11-24 20:04:21','2010-12-11 18:02:48');
+INSERT INTO `reports` VALUES (13,'nonpaidFeesReport','nonpaidFees',1,60,'nonpaidfees','2010-12-05 15:52:43','2010-12-11 18:02:48');
+INSERT INTO `reports` VALUES (14,'balanceSheet','balanceSheet',4,60,'balancesheet','2010-12-20 20:04:21',NULL);
+INSERT INTO `reports` VALUES (15,'incomeStatement','incomeStatement',4,60,'incomestatement','2010-12-20 20:04:21',NULL);
+
+
+
+
+ALTER TABLE reports ADD CONSTRAINT reports_ibfk_1 FOREIGN KEY ( moduleId ) REFERENCES modules (id) ON DELETE CASCADE ON UPDATE CASCADE;
+ALTER TABLE permission ADD CONSTRAINT permission_ibfk_1 FOREIGN KEY ( moduleId ) REFERENCES modules (id) ON DELETE CASCADE ON UPDATE CASCADE;
+ALTER TABLE rolePermission ADD CONSTRAINT rolePermission_ibfk_1 FOREIGN KEY ( roleId ) REFERENCES role (id) ON DELETE CASCADE ON UPDATE CASCADE;
+ALTER TABLE rolePermission ADD CONSTRAINT rolePermission_ibfk_2 FOREIGN KEY ( permissionId ) REFERENCES permission (id) ON DELETE CASCADE ON UPDATE CASCADE;