   `datemodified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `modifiedbyid` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`,`rmtypeid`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
+
+/*Data for the table `ca_room_rates` */
+
+insert  into `ca_room_rates`(`id`,`rmtypeid`,`regular`,`regtimein`,`regtimeout`,`overnight`,`ovntimein`,`ovntimeout`,`extension`,`extratebase`,`datecreated`,`createdbyid`,`datemodified`,`modifiedbyid`) values (1,1,'1000.00','07:00:00','17:00:00','1000.00','19:00:00','05:00:00','1000.00',1,'2017-02-09 00:06:32',0,'2017-02-09 00:06:32',0),(2,2,'1500.00','07:00:00','17:00:00','1500.00','19:00:00','05:00:00','1500.00',1,'2017-02-09 00:06:32',0,'2017-02-09 00:06:32',0),(3,3,'2000.00','07:00:00','17:00:00','2000.00','19:00:00','05:00:00','2000.00',1,'2017-02-09 00:06:32',0,'2017-02-09 00:06:32',0),(4,4,'2500.00','07:00:00','17:00:00','2500.00','19:00:00','05:00:00','2500.00',1,'2017-02-09 00:06:32',0,'2017-02-09 00:06:32',0);
 
 /*Table structure for table `ca_rooms` */
 

  `datemodified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modifiedbyid` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `ca_user_roles` */


  `datemodified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modifiedbyid` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `ca_user_roles` */

insert  into `ca_user_roles`(`id`,`roledesc`,`allowlogin`,`allowbilling`,`allowreserve`,`allowinventory`,`allowcashier`,`allowsettings`,`datecreated`,`createdbyid`,`datemodified`,`modifiedbyid`) values (1,'CA-Administrator','','','','','','','2017-02-06 02:53:17',0,'2017-02-06 02:53:17',0);

/*Table structure for table `ca_users` */

