 
 /*Data for the table `ci_sessions` */
 
-insert  into `ci_sessions`(`id`,`ip_address`,`timestamp`,`data`) values ('09egu7qake53lfqh3fdt6vaal9ocf0ku','::1',1486617956,'__ci_last_regenerate|i:1486617669;'),('0h7v9qj9532c3br8jqks740ko8tem1nh','::1',1486621456,'__ci_last_regenerate|i:1486621429;'),('2accrd5nvdg20dlb4u7on0fm58mt6pln','::1',1486614910,'__ci_last_regenerate|i:1486614909;'),('33uvpr39hrcksbequ254pe0742jgj0t6','::1',1486623126,'__ci_last_regenerate|i:1486622850;'),('3l10l8491tmc007s8crfrc683eu9ia75','::1',1486618749,'__ci_last_regenerate|i:1486618543;'),('40l6ihgv9r33cq2u9dchft3rj6js5frt','::1',1486615367,'__ci_last_regenerate|i:1486615366;'),('41h560s4rlal8mkmc08d7agvn0ana3ol','127.0.0.1',1486325069,'__ci_last_regenerate|i:1486325069;'),('48t32n0et5m33q5t9mphhfrjvc2qisje','::1',1486624253,'__ci_last_regenerate|i:1486623967;'),('51v5ah232hd9ij4f1dtlfci9blgolssc','::1',1486623451,'__ci_last_regenerate|i:1486623339;'),('81ih0dnll6s12dqcau2j6a1apuo01p20','::1',1486621982,'__ci_last_regenerate|i:1486621733;'),('bumusqqonos4e6h8d60pe1pqed8i141o','::1',1486325118,'__ci_last_regenerate|i:1486324870;init|s:29:\"This is just an intialisation\";'),('c2uijh5q2t32j9e2g3ug2hl6737puvre','::1',1486613785,'__ci_last_regenerate|i:1486613783;'),('c9t927uq1rpr3796qvccelff7ts5nnnp','::1',1486321593,'__ci_last_regenerate|i:1486321593;init|s:29:\"This is just an intialisation\";'),('e2beovpelhp4fj0tq83tricf562310g5','::1',1486618262,'__ci_last_regenerate|i:1486618241;'),('g8p3nflilv2c0t7ppulr19jbsqt12jon','::1',1486622038,'__ci_last_regenerate|i:1486622038;'),('i0sqoprr8hqrvqese9foalvjsl84khts','127.0.0.1',1486325004,'__ci_last_regenerate|i:1486325004;'),('i1opsn96gi9qnge3skeop5i3h6lommuk','::1',1486223430,'__ci_last_regenerate|i:1486223430;init|s:29:\"This is just an intialisation\";'),('k0amvkqe5nc4b502f2er5uu86aeskgs2','::1',1486325452,'__ci_last_regenerate|i:1486325181;init|s:29:\"This is just an intialisation\";'),('l40r7mg8q18pbqodi20d8fk1hkstc72r','::1',1486324812,'__ci_last_regenerate|i:1486324538;init|s:29:\"This is just an intialisation\";'),('m6m6juuc21s4plh4eqvgvuq3a1dss1k8','::1',1486325593,'__ci_last_regenerate|i:1486325566;init|s:29:\"This is just an intialisation\";'),('metcv4o5jji98ak2msimnf597c9r7lmk','::1',1486383479,'__ci_last_regenerate|i:1486383477;init|s:29:\"This is just an intialisation\";'),('qa3tpceaam90iovs5puu194jbn9485pr','127.0.0.1',1486324871,'__ci_last_regenerate|i:1486324871;');
+insert  into `ci_sessions`(`id`,`ip_address`,`timestamp`,`data`) values ('09egu7qake53lfqh3fdt6vaal9ocf0ku','::1',1486617956,'__ci_last_regenerate|i:1486617669;'),('0h7v9qj9532c3br8jqks740ko8tem1nh','::1',1486621456,'__ci_last_regenerate|i:1486621429;'),('0q0knub327jrtkcsdr1da7p4jlfj5708','::1',1486892022,'__ci_last_regenerate|i:1486892006;'),('0vd8qsslc5jk7sueomvqcmsgdatpks8i','::1',1486783672,'__ci_last_regenerate|i:1486783389;'),('18nm119qbitmb5j1jlpa3g31cm0gmami','::1',1486867242,'__ci_last_regenerate|i:1486867240;'),('1nkv0dliuk18n9bnc9dq9ni02shktdm1','::1',1486988688,'__ci_last_regenerate|i:1486988530;'),('1vcbfsp4nhb0vbsp1v7c453kt2cvphga','::1',1486984380,'__ci_last_regenerate|i:1486984209;'),('2346u8p0sung29hhv1atp1ka486uemn1','::1',1486649056,'__ci_last_regenerate|i:1486648930;'),('25h84in20ubp8rjj3t83g8e1kr92idan','::1',1486901992,'__ci_last_regenerate|i:1486901893;'),('2accrd5nvdg20dlb4u7on0fm58mt6pln','::1',1486614910,'__ci_last_regenerate|i:1486614909;'),('2epu3dm510g19o4m688j5r36sune4a4c','::1',1486819007,'__ci_last_regenerate|i:1486819005;'),('2hi78vp4fvegr636mlin6ksdla8e65ei','::1',1486648498,'__ci_last_regenerate|i:1486648377;'),('3315q69aa41b3tksvl0ifile2km21tbb','::1',1486646786,'__ci_last_regenerate|i:1486646705;'),('33uvpr39hrcksbequ254pe0742jgj0t6','::1',1486623126,'__ci_last_regenerate|i:1486622850;'),('3l10l8491tmc007s8crfrc683eu9ia75','::1',1486618749,'__ci_last_regenerate|i:1486618543;'),('40l6ihgv9r33cq2u9dchft3rj6js5frt','::1',1486615367,'__ci_last_regenerate|i:1486615366;'),('41h560s4rlal8mkmc08d7agvn0ana3ol','127.0.0.1',1486325069,'__ci_last_regenerate|i:1486325069;'),('48t32n0et5m33q5t9mphhfrjvc2qisje','::1',1486624253,'__ci_last_regenerate|i:1486623967;'),('51v5ah232hd9ij4f1dtlfci9blgolssc','::1',1486623451,'__ci_last_regenerate|i:1486623339;'),('5k39bo84v8u41p28ib5jlhgsjhtcn9ff','::1',1486796699,'__ci_last_regenerate|i:1486796496;'),('5qni94p1a1rdlvdphq3jaqmh3ct5k9k7','::1',1486786589,'__ci_last_regenerate|i:1486786589;'),('5uqdjs90j9h6vbj5uaflf0sd5r72ccqa','::1',1486784312,'__ci_last_regenerate|i:1486784079;'),('7hlvukveerdeq2komdn4u1klrsbo9s4c','::1',1486652660,'__ci_last_regenerate|i:1486652513;'),('81ih0dnll6s12dqcau2j6a1apuo01p20','::1',1486621982,'__ci_last_regenerate|i:1486621733;'),('88v4k3naucpqd9uekmtscct5p91ollfl','::1',1486781379,'__ci_last_regenerate|i:1486781301;'),('8m4gf990hb2lrlouge4lnflccu4rnnpe','::1',1486802174,'__ci_last_regenerate|i:1486801899;'),('8msbc2sbq88k6k0lsec6hmnfj3qq1but','::1',1486650732,'__ci_last_regenerate|i:1486650732;'),('8r5chrijb81esod561gk4aug61liaqul','::1',1486798594,'__ci_last_regenerate|i:1486798384;'),('8rl8e682ogl546gmahjdu9331bnhi6q6','::1',1486636832,'__ci_last_regenerate|i:1486636832;'),('9gc71mp9sfvr125b4iagj7r5vk7a9d38','::1',1486784977,'__ci_last_regenerate|i:1486784709;'),('9gocr3g4akgp9u1qjb0913ob1a2mrokq','::1',1486993714,'__ci_last_regenerate|i:1486993464;'),('agl3kacvgsi1g18jcg1g97nlbdm7mg3v','::1',1486802862,'__ci_last_regenerate|i:1486802685;'),('ao6rhh548of414radd8ot86hadhc3me0','::1',1486902435,'__ci_last_regenerate|i:1486902211;'),('b1usstdmp6iovue1dbs5sveqlcq12mk2','::1',1486817751,'__ci_last_regenerate|i:1486817452;'),('b99ksnno98rs8f8s4kg0qbkhd7kgg4fu','::1',1486782044,'__ci_last_regenerate|i:1486781760;'),('bitqs5voovcl8l3ii212t263q9qkdfel','::1',1486788308,'__ci_last_regenerate|i:1486788308;'),('blumacb2mla0apepvn0ngf38i7uqh663','::1',1486787080,'__ci_last_regenerate|i:1486787080;'),('bpuvcdhflbuk67b7nnv2kmp89arnjd2b','::1',1486894336,'__ci_last_regenerate|i:1486894227;'),('bumusqqonos4e6h8d60pe1pqed8i141o','::1',1486325118,'__ci_last_regenerate|i:1486324870;init|s:29:\"This is just an intialisation\";'),('c2uijh5q2t32j9e2g3ug2hl6737puvre','::1',1486613785,'__ci_last_regenerate|i:1486613783;'),('c9t927uq1rpr3796qvccelff7ts5nnnp','::1',1486321593,'__ci_last_regenerate|i:1486321593;init|s:29:\"This is just an intialisation\";'),('cr03bklppkc713ilvv21u75hq4557ks8','::1',1486783283,'__ci_last_regenerate|i:1486783074;'),('d0qtgo148np2ios1tg3o1go0s2213h0l','::1',1486782355,'__ci_last_regenerate|i:1486782069;'),('d5cq47t8jfggd2k64pl6mdqjandjgnd4','::1',1486987126,'__ci_last_regenerate|i:1486987124;'),('dknrl99lb0e2msbc7rabk25kuk82o8fa','::1',1486970390,'__ci_last_regenerate|i:1486970388;'),('e2beovpelhp4fj0tq83tricf562310g5','::1',1486618262,'__ci_last_regenerate|i:1486618241;'),('e3ub6auhmcveisj08vcst6rq3lpnonck','::1',1486993781,'__ci_last_regenerate|i:1486993780;'),('e52itdecdbq6gea0j6o0j9n560nl4sbu','::1',1486877605,'__ci_last_regenerate|i:1486877604;'),('e6e14gblnpookbe5ad9j36nq51174bg6','::1',1486818965,'__ci_last_regenerate|i:1486818676;'),('ec4vqi43lag5f4n1ad99tinh7fvslk3i','::1',1486788863,'__ci_last_regenerate|i:1486788799;'),('eq2ckt28svavd32qv96ai2rl3k7ehjdm','::1',1486838424,'__ci_last_regenerate|i:1486838419;'),('f65qvtr4fti8hr26mjlf5jf7bt3oui3v','::1',1486833446,'__ci_last_regenerate|i:1486833265;'),('f7f26oapere9c0utoafli9l57ifheqen','::1',1486833812,'__ci_last_regenerate|i:1486833566;'),('fdmeu5eoohhpp6gju7d8fshot6na5f8p','::1',1486902674,'__ci_last_regenerate|i:1486902672;'),('g8p3nflilv2c0t7ppulr19jbsqt12jon','::1',1486622038,'__ci_last_regenerate|i:1486622038;'),('ghqa8fb5gqv694u9qgep0ld7ehgar126','::1',1486651345,'__ci_last_regenerate|i:1486651068;'),('h5htd2ls84h31hagkfmqou6f6pjhad68','::1',1486776498,'__ci_last_regenerate|i:1486776497;'),('hbaq4vi1pmlkk0mj0ah4153kk5mjdueq','::1',1486971305,'__ci_last_regenerate|i:1486971303;'),('hfv80oeeg49v01ui7a2map21jnnlfsfc','::1',1486782754,'__ci_last_regenerate|i:1486782455;'),('hm382i6lsgctmbc2h1pms4gig8v5c2ut','::1',1486651534,'__ci_last_regenerate|i:1486651503;'),('ht0kso5aoplenf6e715qutj1cqesikl1','::1',1486785667,'__ci_last_regenerate|i:1486785611;'),('hvtlf79b2sm18cuq3k6ektej341jtsav','::1',1486983458,'__ci_last_regenerate|i:1486983162;'),('i0sqoprr8hqrvqese9foalvjsl84khts','127.0.0.1',1486325004,'__ci_last_regenerate|i:1486325004;'),('i1opsn96gi9qnge3skeop5i3h6lommuk','::1',1486223430,'__ci_last_regenerate|i:1486223430;init|s:29:\"This is just an intialisation\";'),('iea2u43o1cf9r2m50cthppvrutqedekh','::1',1486837940,'__ci_last_regenerate|i:1486837935;'),('j6cs1rj1d2oc2o8glp5jf26j034qbqr4','::1',1486802204,'__ci_last_regenerate|i:1486802203;'),('k0amvkqe5nc4b502f2er5uu86aeskgs2','::1',1486325452,'__ci_last_regenerate|i:1486325181;init|s:29:\"This is just an intialisation\";'),('k695dpiicfak6os5rikh9ofdhud1se7q','::1',1486968958,'__ci_last_regenerate|i:1486968772;'),('k6e9gplj46gmete1q6kf7q9cot9nqb8k','::1',1486818046,'__ci_last_regenerate|i:1486817947;'),('l40r7mg8q18pbqodi20d8fk1hkstc72r','::1',1486324812,'__ci_last_regenerate|i:1486324538;init|s:29:\"This is just an intialisation\";'),('lotse1cjb7cgq5fvgbkepug6pn2lha2c','::1',1486837681,'__ci_last_regenerate|i:1486837507;'),('m1q7p6k9fg5l3gral32h9jneut83jfr3','::1',1486798947,'__ci_last_regenerate|i:1486798892;'),('m6m6juuc21s4plh4eqvgvuq3a1dss1k8','::1',1486325593,'__ci_last_regenerate|i:1486325566;init|s:29:\"This is just an intialisation\";'),('matb5icehu6a52if46vf4ipjclm2nvmo','::1',1486834836,'__ci_last_regenerate|i:1486834559;'),('metcv4o5jji98ak2msimnf597c9r7lmk','::1',1486383479,'__ci_last_regenerate|i:1486383477;init|s:29:\"This is just an intialisation\";'),('mg5igjndk933303br625aror9b1jh4ko','::1',1486818297,'__ci_last_regenerate|i:1486818296;'),('n8foasrb2lv76nmh1ugm3ulot66viifa','::1',1486835173,'__ci_last_regenerate|i:1486835006;'),('nf6gkv9vs23dvu31rn9s7h9fgnhnlhtf','::1',1486777445,'__ci_last_regenerate|i:1486777350;'),('nt178j9m2euu4llb0mbbj70cn8dnpdr4','::1',1486784007,'__ci_last_regenerate|i:1486783707;'),('o5s2reff4trb53bv6uqn6dvkf54s9roe','::1',1486796486,'__ci_last_regenerate|i:1486796194;'),('o7onpjst06m1chou435udk3e3pumsqqo','::1',1486652118,'__ci_last_regenerate|i:1486652118;'),('o8927v77722g98qrgokmce0cm9h1j4th','::1',1486785919,'__ci_last_regenerate|i:1486785919;'),('o8bdv26bphnt9j7vuk95eiq507hfplj4','::1',1486893689,'__ci_last_regenerate|i:1486893389;'),('o8gnbsj29npob8tj4jvvt59ucvek0l1p','::1',1486834188,'__ci_last_regenerate|i:1486833894;'),('oqbdk550mrrt0rqh253f2oe0cmueej1r','::1',1486987657,'__ci_last_regenerate|i:1486987505;'),('ou4h9q7arilfh0rai05mp0iiu062odcq','::1',1486816948,'__ci_last_regenerate|i:1486816814;'),('qa3tpceaam90iovs5puu194jbn9485pr','127.0.0.1',1486324871,'__ci_last_regenerate|i:1486324871;'),('qr0g64i4c3sbd57ohpikg6et7rmp2nhh','::1',1486998587,'__ci_last_regenerate|i:1486998323;'),('r1igta7e7psv69vn2ush6tticegk8ph9','::1',1486969294,'__ci_last_regenerate|i:1486969112;'),('r2nj1a53ol4nn31or75osr787gblbrc9','::1',1486984050,'__ci_last_regenerate|i:1486983881;'),('r4nvjtd8f347sqbupc78dk3t2gonghs3','::1',1486983706,'__ci_last_regenerate|i:1486983486;'),('r7gmd6fh5fnonj89mgp49tore7q6v3io','::1',1486777124,'__ci_last_regenerate|i:1486776878;'),('rlabnv4bnckmevhterc78i7riojekfqm','::1',1486783003,'__ci_last_regenerate|i:1486782770;'),('squ3v62vab2feftmcucc9bahgmb1hr27','::1',1486997065,'__ci_last_regenerate|i:1486997014;'),('t1h8pf6phrver5k0tjrpb6prh9p9jb3e','::1',1486777789,'__ci_last_regenerate|i:1486777789;'),('to2qkii6qoqk2l0smgoqj1bj4mst41e9','::1',1486646290,'__ci_last_regenerate|i:1486646160;'),('u0teomtgc7fnuf21a5pimlqtpo5o3mu5','::1',1486981623,'__ci_last_regenerate|i:1486981378;'),('u1apq3jju57nn6spers7a5iov287d52r','::1',1486785318,'__ci_last_regenerate|i:1486785161;'),('u41ruam80v8h08521neregefeu8isj20','::1',1486817416,'__ci_last_regenerate|i:1486817141;'),('v2p71vohk2edt7b8dtvv231nnq4eg6ra','::1',1486798074,'__ci_last_regenerate|i:1486797816;'),('v5vrhkdp8hmil0fav8122t9nmmjq82bl','::1',1486981953,'__ci_last_regenerate|i:1486981740;');
 
 /* Procedure structure for procedure `sp_tranusers` */
 

DROP TABLE IF EXISTS `ca_reservation`;

CREATE TABLE `ca_reservation` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `guestid` bigint(20) NOT NULL DEFAULT '0',
  `roomid` bigint(20) NOT NULL DEFAULT '0',
  `resdate` date NOT NULL,
  `restimefrom` time DEFAULT NULL,
  `restimeto` time DEFAULT NULL,
  `estguest` int(11) NOT NULL DEFAULT '1',
  `dppaid` bit(1) NOT NULL DEFAULT b'0',
  `dpamount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `datecreated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdbyid` bigint(20) NOT NULL DEFAULT '0',
  `datemodified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modifiedbyid` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `ca_reservation` */


CREATE TABLE `ca_booking` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `bksrctypeid` int(11) NOT NULL DEFAULT '0',
  `rsvid` bigint(20) NOT NULL DEFAULT '0',
  `guestid` bigint(20) NOT NULL DEFAULT '0',
  `rmtypeid` bigint(20) NOT NULL DEFAULT '0',
  `roomid` bigint(20) NOT NULL DEFAULT '0',
  `guesta` int(11) NOT NULL DEFAULT '0',
  `guestc` int(11) NOT NULL DEFAULT '0',
  `isovernight` bit(1) NOT NULL DEFAULT b'0',
  `createdbyid` bigint(20) NOT NULL DEFAULT '0',
  `datecreated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modifiedbyid` bigint(20) NOT NULL DEFAULT '0',
  `datemodified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`,`rsvid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `ca_booking` */

/*Table structure for table `ca_booking_guest` */

DROP TABLE IF EXISTS `ca_booking_guest`;

CREATE TABLE `ca_booking_guest` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `bkid` bigint(20) NOT NULL DEFAULT '0',
  `bcid` bigint(20) NOT NULL DEFAULT '0',
  `gname` varchar(50) DEFAULT NULL,
  `gclass` int(11) NOT NULL DEFAULT '1',
  `timein` time DEFAULT NULL,
  `expdate` datetime DEFAULT NULL,
  `createdbyid` bigint(20) NOT NULL DEFAULT '0',
  `datecreate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`,`bkid`,`bcid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `ca_booking_guest` */

/*Table structure for table `ca_booking_items` */

DROP TABLE IF EXISTS `ca_booking_items`;

CREATE TABLE `ca_booking_items` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `bkid` bigint(20) NOT NULL DEFAULT '0',
  `itemtype` int(11) NOT NULL DEFAULT '0',
  `itemdesc` varchar(150) NOT NULL DEFAULT 'Item-0',
  `itemqty` int(11) NOT NULL DEFAULT '1',
  `itemamt` decimal(10,2) NOT NULL DEFAULT '0.00',
  `ispaid` bit(1) NOT NULL DEFAULT b'0',
  `createdbyid` bigint(20) NOT NULL DEFAULT '0',
  `datecreated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `ca_booking_items` */

/*Table structure for table `ca_guest_info` */

