-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.51a-community-nt


/*!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 */;

/*!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' */;


--
-- Create schema test
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ test;
USE test;

--
-- Table structure for table `test`.`customers`
--

DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
  `customer_id` int(11) NOT NULL auto_increment,
  `customer_name` varchar(225) default NULL,
  `customer_address` text,
  `customer_type` varchar(100) default NULL,
  `entry_modified_date` datetime default NULL,
  PRIMARY KEY  (`customer_id`),
  UNIQUE KEY `customer_name` (`customer_name`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `test`.`customers`
--

/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
INSERT INTO `customers` (`customer_id`,`customer_name`,`customer_address`,`customer_type`,`entry_modified_date`) VALUES 
 (1,'Customer 1','Langford road, Bangalore','Company','2009-08-04 15:30:44'),
 (2,'Customer 2','electronic city, Bangalore','Company','2009-05-28 14:29:50'),
 (3,'Customer 3','BTM, Bangalore','Training institute','2009-05-28 14:29:50'),
 (5,'Customer 4','Langford road, Bangalore','Company','2009-08-03 19:40:54'),
 (6,'Customer 5','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (7,'Customer 6','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (8,'Customer 7','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (9,'Customer 8','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (10,'Customer 9','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (11,'Customer 10','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (12,'Customer 11','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (13,'Customer 12','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (14,'Customer 13','Langford road, Bangalore','Company','2009-06-03 10:18:55');
INSERT INTO `customers` (`customer_id`,`customer_name`,`customer_address`,`customer_type`,`entry_modified_date`) VALUES 
 (15,'Customer 14','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (16,'Customer 15','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (17,'Customer 16','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (18,'Customer 17','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (19,'Customer 18','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (20,'Customer 19','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (21,'Customer 20','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (22,'Customer 21','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (23,'Customer 22','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (24,'Customer 23','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (25,'Customer 24','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (26,'Customer 25','Langford road, Bangalore','Company','2009-06-03 10:18:55');
INSERT INTO `customers` (`customer_id`,`customer_name`,`customer_address`,`customer_type`,`entry_modified_date`) VALUES 
 (27,'Customer 26','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (28,'Customer 27','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (29,'Customer 28','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (30,'Customer 29','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (31,'Customer 30','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (32,'Customer 31','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (33,'Customer 32','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (34,'Customer 33','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (35,'Customer 34','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (36,'Customer 35','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (37,'Customer 36','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (38,'Customer 37','Langford road, Bangalore','Company','2009-06-03 10:18:55');
INSERT INTO `customers` (`customer_id`,`customer_name`,`customer_address`,`customer_type`,`entry_modified_date`) VALUES 
 (39,'Customer 38','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (40,'Customer 39','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (41,'Customer 40','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (42,'Customer 41','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (43,'Customer 42','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (44,'Customer 43','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (45,'Customer 44','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (46,'Customer 45','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (47,'Customer 46','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (48,'Customer 47','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (49,'Customer 48','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (50,'Customer 49','Langford road, Bangalore','Company','2009-06-03 10:18:55');
INSERT INTO `customers` (`customer_id`,`customer_name`,`customer_address`,`customer_type`,`entry_modified_date`) VALUES 
 (51,'Customer 50','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (52,'Customer 51','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (53,'Customer 52','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (54,'Customer 53','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (55,'Customer 54','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (56,'Customer 55','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (57,'Customer 56','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (58,'Customer 57','Langford road, Bangalore','Company','2009-06-03 10:18:55'),
 (59,'Customer 58','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (60,'Customer 59','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (61,'Customer 60','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (62,'Customer 61','Langford road, Bangalore','Company','2009-06-03 10:18:56');
INSERT INTO `customers` (`customer_id`,`customer_name`,`customer_address`,`customer_type`,`entry_modified_date`) VALUES 
 (63,'Customer 62','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (64,'Customer 63','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (65,'Customer 64','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (66,'Customer 65','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (67,'Customer 66','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (68,'Customer 67','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (69,'Customer 68','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (70,'Customer 69','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (71,'Customer 70','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (72,'Customer 71','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (73,'Customer 72','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (74,'Customer 73','Langford road, Bangalore','Company','2009-06-03 10:18:56');
INSERT INTO `customers` (`customer_id`,`customer_name`,`customer_address`,`customer_type`,`entry_modified_date`) VALUES 
 (75,'Customer 74','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (76,'Customer 75','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (77,'Customer 76','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (78,'Customer 77','Langford road, Bangalore','Company','2009-06-03 10:18:56'),
 (79,'Customer 78','Langford road, Bangalore','Company','2009-06-03 10:18:56');
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;

/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;