-- MySQL dump 10.11 -- -- Host: 178.1.0.202 Database: insys_common -- ------------------------------------------------------ -- Server version 4.1.20-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `insys_common` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `insys_common` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `insys_common`; -- -- Table structure for table `accesscontrol` -- DROP TABLE IF EXISTS `accesscontrol`; CREATE TABLE `accesscontrol` ( `EmplCode` char(8) NOT NULL default '', `ModuleId` int(11) NOT NULL default '0', `AccessCtrl` char(4) default NULL, `AuditDate` datetime default NULL, `AuditUser` char(8) default NULL, PRIMARY KEY (`EmplCode`,`ModuleId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `accesscontrol` -- LOCK TABLES `accesscontrol` WRITE; /*!40000 ALTER TABLE `accesscontrol` DISABLE KEYS */; INSERT INTO `accesscontrol` VALUES ('007',1,'1111','2008-12-19 11:48:27','admin'),('007',2,'1111','2008-12-23 08:35:18','admin'),('007',3,'1111','2008-12-23 11:49:24','admin'),('007',4,'1111','2008-12-23 17:41:09','admin'),('007',5,'1111','2008-12-24 09:09:05','admin'),('007',6,'1111','2008-12-24 13:34:35','admin'),('007',7,'1111','2008-12-29 09:56:15','admin'),('007',8,'1111','2008-12-31 11:53:11','admin'),('007',9,'1111','2009-01-04 09:15:59','admin'),('007',10,'1111','2009-01-07 09:51:35','admin'),('007',11,'1111','2009-01-07 15:38:25','admin'),('007',12,'1111','2009-01-08 11:29:20','admin'),('007',13,'1111','2009-01-08 11:29:23','admin'),('007',14,'1111','2009-01-08 11:29:27','admin'),('007',15,'1111','2009-01-08 11:29:30','admin'),('007',16,'1111','2009-01-08 11:29:33','admin'),('007',17,'1111','2009-01-08 11:29:43','admin'),('fixeduse',1,'1111','2009-01-12 14:10:27','admin'),('fixeduse',2,'1111','2009-01-12 14:10:31','admin'),('fixeduse',3,'1111','2009-01-12 14:10:34','admin'),('fixeduse',4,'1111','2009-01-12 14:10:37','admin'),('fixeduse',5,'1111','2009-01-12 14:10:40','admin'),('fixeduse',6,'1111','2009-01-12 14:10:43','admin'),('fixeduse',7,'1111','2009-01-12 14:10:47','admin'),('fixeduse',8,'1111','2009-01-12 14:10:51','admin'),('fixeduse',9,'1111','2009-01-12 14:10:54','admin'),('fixeduse',10,'1111','2009-01-12 14:10:58','admin'),('fixeduse',11,'1111','2009-01-12 14:11:02','admin'),('fixeduse',12,'1111','2009-01-12 14:11:05','admin'),('fixeduse',13,'1111','2009-01-12 14:11:08','admin'),('fixeduse',14,'1111','2009-01-12 14:11:11','admin'),('fixeduse',15,'1111','2009-01-12 14:11:13','admin'),('fixeduse',16,'1111','2009-01-12 14:11:16','admin'),('fixeduse',17,'1111','2009-01-12 14:11:20','admin'); /*!40000 ALTER TABLE `accesscontrol` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `company` -- DROP TABLE IF EXISTS `company`; CREATE TABLE `company` ( `DBId` int(11) NOT NULL default '0', `CmpnyId` varchar(20) default NULL, `CmpnyName` varchar(50) default NULL, `CrtdDate` datetime default NULL, PRIMARY KEY (`DBId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `company` -- LOCK TABLES `company` WRITE; /*!40000 ALTER TABLE `company` DISABLE KEYS */; INSERT INTO `company` VALUES (1,'fixedassets','fixed assets','2008-04-23 00:00:00'),(2,'test','test','2008-12-16 10:34:00'); /*!40000 ALTER TABLE `company` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `companyaccess` -- DROP TABLE IF EXISTS `companyaccess`; CREATE TABLE `companyaccess` ( `EmplCode` char(8) NOT NULL default '', `DBId` int(11) NOT NULL default '0', `AccessCtrl` char(1) default NULL, `AuditDate` datetime default NULL, `AuditUser` char(8) default NULL, PRIMARY KEY (`EmplCode`,`DBId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `companyaccess` -- LOCK TABLES `companyaccess` WRITE; /*!40000 ALTER TABLE `companyaccess` DISABLE KEYS */; INSERT INTO `companyaccess` VALUES ('007',1,'Y','2008-04-29 04:19:14','admin'),('007',2,'Y','2008-05-15 17:04:35','admin'),('admin',1,'Y','2008-04-23 00:00:00','admin'),('fixeduse',1,'Y','2009-01-12 14:14:04','admin'); /*!40000 ALTER TABLE `companyaccess` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `employee` -- DROP TABLE IF EXISTS `employee`; CREATE TABLE `employee` ( `EmplCode` varchar(8) NOT NULL default '', `EmplName` varchar(100) default NULL, `Pass` varchar(50) default NULL, `Locked` char(1) default NULL, `ObjType` int(11) default NULL, `AuditDate` datetime default NULL, `AuditUser` varchar(8) default NULL, `Admin` char(1) default NULL, PRIMARY KEY (`EmplCode`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `employee` -- LOCK TABLES `employee` WRITE; /*!40000 ALTER TABLE `employee` DISABLE KEYS */; INSERT INTO `employee` VALUES ('007','Agen 007','ganteng','N',0,'2008-04-29 05:28:12','admin','Y'),('admin','administrator','1234','N',0,'2008-04-23 00:00:00','admin','Y'),('fixeduse','Fixed Assets','202','N',0,'2009-01-12 14:05:48','admin','Y'); /*!40000 ALTER TABLE `employee` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `module` -- DROP TABLE IF EXISTS `module`; CREATE TABLE `module` ( `ModuleID` int(11) NOT NULL default '0', `ModuleCode` varchar(50) default NULL, `Dscription` varchar(50) default NULL, `ObjType` int(11) default NULL, `AuditDate` datetime default NULL, `AuditUser` varchar(8) default NULL, `ReadPath` varchar(255) default NULL, `WritePath` varchar(255) default NULL, `ReadFmt` varchar(255) default NULL, `WriteFmt` varchar(255) default NULL, `ServerIp` varchar(255) default NULL, `DBName` varchar(255) default NULL, `Uid` varchar(30) default NULL, `Pwd` varchar(30) default NULL, `Menu` varchar(100) default NULL, PRIMARY KEY (`ModuleID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `module` -- LOCK TABLES `module` WRITE; /*!40000 ALTER TABLE `module` DISABLE KEYS */; INSERT INTO `module` VALUES (1,'FrmAccount',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Master And Table Maintenance'),(2,'FrmFormula',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Master And Table Maintenance'),(3,'FrmLocation',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Master And Table Maintenance'),(4,'FrmCostCenter',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Master And Table Maintenance'),(5,'FrmVendor',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Master And Table Maintenance'),(6,'FrmCategory',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Master And Table Maintenance'),(7,'FrmAsset',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Master And Table Maintenance'),(8,'FrmGlobal',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Master And Table Maintenance'),(9,'FrmProcessMonthly',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Transaction'),(10,'FrmProcessYearly',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Transaction'),(11,'rptVendor',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Report'),(12,'rptAsset',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Report'),(13,'rptAccount',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Report'),(14,'rptCategory',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Report'),(15,'rptCostCenter',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Report'),(16,'rptFormula',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Report'),(17,'rptLocation',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Report'); /*!40000 ALTER TABLE `module` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sqlcommandlogs` -- DROP TABLE IF EXISTS `sqlcommandlogs`; CREATE TABLE `sqlcommandlogs` ( `cmdid` int(11) NOT NULL default '0', `cmdsql` text NOT NULL, `cmdsyncsts` char(1) NOT NULL default '', `auditdate` timestamp NULL default NULL, `audituser` varchar(15) default NULL, PRIMARY KEY (`cmdid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `sqlcommandlogs` -- LOCK TABLES `sqlcommandlogs` WRITE; /*!40000 ALTER TABLE `sqlcommandlogs` DISABLE KEYS */; INSERT INTO `sqlcommandlogs` VALUES (1,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid=^1^','N','2008-12-15 18:32:20','User'),(2,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 18:32:20','User'),(3,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid=^1^','N','2008-12-15 18:32:31','User'),(4,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 18:32:31','User'),(5,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid=^1^','N','2008-12-15 18:34:48','User'),(6,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 18:34:48','User'),(7,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid=^1^','N','2008-12-15 18:36:42','User'),(8,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 18:36:42','User'),(9,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid=^1^','N','2008-12-15 18:39:09','User'),(10,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 18:39:09','User'),(11,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid=^1^','N','2008-12-15 18:40:07','User'),(12,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 18:40:07','User'),(13,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid=^1^','N','2008-12-15 19:56:46','User'),(14,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 19:56:46','User'),(15,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid=^1^','N','2008-12-15 20:02:27','User'),(16,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 20:02:27','User'),(17,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 20:02:27','User'),(18,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 20:02:27','User'),(19,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 20:02:27','User'),(20,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 20:02:27','User'),(21,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid=^1^','N','2008-12-15 21:22:36','User'),(22,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:22:36','User'),(23,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:22:36','User'),(24,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:22:36','User'),(25,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:22:36','User'),(26,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:22:36','User'),(27,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid=^1^','N','2008-12-15 21:23:49','User'),(28,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:23:49','User'),(29,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:23:50','User'),(30,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:23:50','User'),(31,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:23:50','User'),(32,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:23:50','User'),(33,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:24:15','User'),(34,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:24:15','User'),(35,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:24:15','User'),(36,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:24:15','User'),(37,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 21:24:20','User'),(38,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 21:24:21','User'),(39,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:24:23','User'),(40,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:24:23','User'),(41,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 21:24:26','User'),(42,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 21:24:26','User'),(43,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:24:28','User'),(44,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:24:28','User'),(45,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:29:34','User'),(46,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:29:34','User'),(47,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:29:34','User'),(48,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:29:34','User'),(49,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:30:48','User'),(50,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:30:48','User'),(51,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:30:48','User'),(52,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:30:48','User'),(53,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:33:08','User'),(54,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:33:08','User'),(55,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:33:08','User'),(56,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:33:08','User'),(57,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:33:48','User'),(58,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:33:48','User'),(59,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:33:48','User'),(60,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:33:48','User'),(61,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:34:18','User'),(62,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:34:18','User'),(63,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:34:18','User'),(64,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:34:18','User'),(65,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:45:15','User'),(66,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:45:15','User'),(67,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:45:15','User'),(68,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:45:15','User'),(69,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:45:56','User'),(70,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:45:56','User'),(71,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:45:56','User'),(72,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:45:56','User'),(73,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:47:18','User'),(74,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:47:18','User'),(75,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:47:18','User'),(76,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:47:18','User'),(77,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:48:19','User'),(78,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:48:19','User'),(79,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:48:19','User'),(80,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:48:19','User'),(81,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:49:00','User'),(82,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:49:00','User'),(83,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:49:00','User'),(84,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:49:00','User'),(85,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:49:34','User'),(86,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:49:34','User'),(87,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:49:34','User'),(88,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:49:34','User'),(89,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:49:40','User'),(90,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:49:40','User'),(91,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:49:40','User'),(92,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:49:40','User'),(93,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:50:10','User'),(94,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:50:10','User'),(95,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:50:10','User'),(96,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:50:10','User'),(97,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:50:30','User'),(98,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:50:30','User'),(99,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:50:30','User'),(100,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:50:30','User'),(101,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:50:52','User'),(102,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:50:52','User'),(103,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:50:53','User'),(104,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:50:53','User'),(105,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:51:21','User'),(106,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:51:21','User'),(107,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:51:21','User'),(108,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:51:21','User'),(109,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:52:17','User'),(110,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:52:17','User'),(111,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:52:17','User'),(112,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:52:17','User'),(113,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:53:10','User'),(114,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:53:10','User'),(115,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:53:10','User'),(116,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:53:10','User'),(117,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:55:00','User'),(118,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:55:00','User'),(119,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:55:00','User'),(120,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:55:00','User'),(121,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:55:23','User'),(122,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:55:23','User'),(123,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:55:23','User'),(124,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:55:23','User'),(125,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:56:31','User'),(126,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:56:31','User'),(127,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:56:31','User'),(128,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:56:31','User'),(129,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:57:06','User'),(130,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:57:06','User'),(131,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:57:06','User'),(132,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:57:06','User'),(133,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 21:59:44','User'),(134,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 21:59:44','User'),(135,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 21:59:44','User'),(136,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 21:59:44','User'),(137,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:00:48','User'),(138,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:00:48','User'),(139,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:00:48','User'),(140,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:00:48','User'),(141,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:01:23','User'),(142,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:01:23','User'),(143,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:01:23','User'),(144,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:01:23','User'),(145,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:01:49','User'),(146,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:01:49','User'),(147,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:01:49','User'),(148,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:01:49','User'),(149,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:02:38','User'),(150,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:02:38','User'),(151,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:02:38','User'),(152,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:02:38','User'),(153,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:03:04','User'),(154,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:03:04','User'),(155,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:03:04','User'),(156,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:03:04','User'),(157,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:05:15','User'),(158,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:05:15','User'),(159,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:05:15','User'),(160,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:05:15','User'),(161,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:05:37','User'),(162,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:05:37','User'),(163,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:05:37','User'),(164,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:05:37','User'),(165,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:13:52','User'),(166,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:13:52','User'),(167,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:13:52','User'),(168,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:13:52','User'),(169,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:14:31','User'),(170,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:14:31','User'),(171,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:14:31','User'),(172,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:14:31','User'),(173,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:15:10','User'),(174,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:15:10','User'),(175,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:15:10','User'),(176,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:15:10','User'),(177,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:39:11','User'),(178,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:39:11','User'),(179,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:39:11','User'),(180,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:39:11','User'),(181,'select EmplCode,EmplName from employee order by EmplCode','N','2008-12-15 22:39:13','User'),(182,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:41:07','User'),(183,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:41:07','User'),(184,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:41:07','User'),(185,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:41:07','User'),(186,'select EmplCode,EmplName from employee order by EmplCode','N','2008-12-15 22:41:09','User'),(187,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:42:00','User'),(188,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:42:00','User'),(189,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:42:00','User'),(190,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:42:00','User'),(191,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:45:28','User'),(192,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:45:28','User'),(193,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:45:28','User'),(194,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:45:28','User'),(195,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 22:45:32','User'),(196,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 22:45:32','User'),(197,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:45:34','User'),(198,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:45:34','User'),(199,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 22:45:35','User'),(200,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 22:45:35','User'),(201,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:46:02','User'),(202,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:46:02','User'),(203,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:46:02','User'),(204,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:46:02','User'),(205,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 22:46:05','User'),(206,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 22:46:05','User'),(207,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:46:06','User'),(208,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:46:06','User'),(209,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:46:23','User'),(210,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:46:23','User'),(211,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:46:23','User'),(212,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:46:23','User'),(213,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:47:41','User'),(214,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:47:41','User'),(215,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:47:41','User'),(216,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:47:41','User'),(217,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>0 order by dbid limit 1','N','2008-12-15 22:52:33','User'),(218,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:52:33','User'),(219,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:52:33','User'),(220,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:52:33','User'),(221,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 22:52:39','User'),(222,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 22:52:39','User'),(223,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 22:53:05','User'),(224,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:53:05','User'),(225,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:53:05','User'),(226,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:53:05','User'),(227,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 22:53:36','User'),(228,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:53:36','User'),(229,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:53:36','User'),(230,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:53:36','User'),(231,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 22:53:47','User'),(232,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:53:47','User'),(233,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:53:47','User'),(234,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:53:47','User'),(235,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 22:54:10','User'),(236,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:54:10','User'),(237,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:54:10','User'),(238,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:54:10','User'),(239,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 22:55:35','User'),(240,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:55:35','User'),(241,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:55:35','User'),(242,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:55:35','User'),(243,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 22:56:49','User'),(244,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:56:49','User'),(245,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:56:49','User'),(246,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:56:49','User'),(247,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 22:58:29','User'),(248,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:58:29','User'),(249,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:58:29','User'),(250,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:58:29','User'),(251,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 22:58:38','User'),(252,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 22:58:38','User'),(253,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:58:40','User'),(254,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:58:40','User'),(255,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 22:58:41','User'),(256,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^test^','N','2008-12-15 22:58:41','User'),(257,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:58:43','User'),(258,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:58:43','User'),(259,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 22:59:01','User'),(260,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:59:01','User'),(261,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:59:01','User'),(262,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:59:02','User'),(263,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 22:59:50','User'),(264,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:59:50','User'),(265,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:59:50','User'),(266,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:59:50','User'),(267,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 22:59:59','User'),(268,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 22:59:59','User'),(269,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 22:59:59','User'),(270,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 22:59:59','User'),(271,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:00:44','User'),(272,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:00:44','User'),(273,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:00:44','User'),(274,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:00:44','User'),(275,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:00:59','User'),(276,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:00:59','User'),(277,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:00:59','User'),(278,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:00:59','User'),(279,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:01:15','User'),(280,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:01:15','User'),(281,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:01:15','User'),(282,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:01:15','User'),(283,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:02:21','User'),(284,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:02:21','User'),(285,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:02:21','User'),(286,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:02:21','User'),(287,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:02:30','User'),(288,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:02:30','User'),(289,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:02:30','User'),(290,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:02:30','User'),(291,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:08:02','User'),(292,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:08:02','User'),(293,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:08:02','User'),(294,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:08:02','User'),(295,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:08:58','User'),(296,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:08:58','User'),(297,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:08:58','User'),(298,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:08:58','User'),(299,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:09:53','User'),(300,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:09:53','User'),(301,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:09:53','User'),(302,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:09:53','User'),(303,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:10:21','User'),(304,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:10:21','User'),(305,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:10:21','User'),(306,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:10:21','User'),(307,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:11:16','User'),(308,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:11:16','User'),(309,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:11:16','User'),(310,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:11:16','User'),(311,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:13:39','User'),(312,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:13:39','User'),(313,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:13:39','User'),(314,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:13:39','User'),(315,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:14:34','User'),(316,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:14:34','User'),(317,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:14:34','User'),(318,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:14:34','User'),(319,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:18:19','User'),(320,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:18:19','User'),(321,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:18:19','User'),(322,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:18:19','User'),(323,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:19:41','User'),(324,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:19:41','User'),(325,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:19:41','User'),(326,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:19:41','User'),(327,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:20:54','User'),(328,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:20:54','User'),(329,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:20:54','User'),(330,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:20:54','User'),(331,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:22:16','User'),(332,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:22:16','User'),(333,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:22:16','User'),(334,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:22:16','User'),(335,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:22:24','User'),(336,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:22:24','User'),(337,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:22:24','User'),(338,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:22:24','User'),(339,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:25:12','User'),(340,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:25:12','User'),(341,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:25:12','User'),(342,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:25:12','User'),(343,'select DBId, CmpnyId, CmpnyName, CrtdDate from company order by dbid limit 1','N','2008-12-15 23:26:50','User'),(344,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where cmpnyid=^fixedassets^','N','2008-12-15 23:26:50','User'),(345,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>1 order by dbid limit 1','N','2008-12-15 23:26:50','User'),(346,'select DBId, CmpnyId, CmpnyName, CrtdDate from company where dbid>2 order by dbid limit 1','N','2008-12-15 23:26:50','User'); /*!40000 ALTER TABLE `sqlcommandlogs` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2011-03-25 11:20:59