/*
SQLyog Community Edition- MySQL GUI v6.52
MySQL - 5.5.8-log : Database - jetcamer_marketing
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 database if not exists `jetcamer_marketing`;

USE `jetcamer_marketing`;

/*Table structure for table `jos_jeemasms_history` */

DROP TABLE IF EXISTS `jos_jeemasms_history`;

CREATE TABLE `jos_jeemasms_history` (
  `history_id` int(11) NOT NULL AUTO_INCREMENT,
  `acc_id` int(11) DEFAULT NULL,
  `apiname` varchar(50) NOT NULL,
  `mobileto` longtext,
  `sendername` varchar(50) DEFAULT NULL,
  `message` longtext,
  `notes` longtext,
  `created` datetime DEFAULT NULL,
  `smscount` float DEFAULT NULL,
  `response` varchar(255) DEFAULT NULL,
  `result` tinyint(1) NOT NULL,
  `book_id` int(50) NOT NULL,
  `launched_url` longtext,
  PRIMARY KEY (`history_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

/*Data for the table `jos_jeemasms_history` */

insert  into `jos_jeemasms_history`(`history_id`,`acc_id`,`apiname`,`mobileto`,`sendername`,`message`,`notes`,`created`,`smscount`,`response`,`result`,`book_id`,`launched_url`) values (5,3226,'peguyni','0016505184436','peguyni','re sre','','2014-11-05 19:06:19',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1268341039&sender=peguyni&number[]=0016505184436&msg=re+sre'),(6,3226,'peguyni','0016505184436','peguyni','a voir','','2014-11-05 21:10:38',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1268341039&sender=peguyni&number[]=0016505184436&msg=a+voir'),(7,3226,'=> peguyni','0016505184436','peguyni','sdsd','','2014-11-05 21:26:56',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1268341039&sender=peguyni&number[]=0016505184436&msg=sdsd'),(8,1,'=> public','0016505184436','public','j test tjrs','','2014-11-06 07:32:22',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505184436&msg=j+test+tjrs'),(9,1,'=> public','0016505184436','public','sdd  rere','','2014-11-07 03:39:47',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505184436&msg=sdd++rere'),(10,1,'=> public','0016505184436','public','j test','','2014-11-10 04:42:59',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505184436&msg=j+test'),(11,1,'=> public','0016505184436','public','tes program','Message sent from cronjob 2014-11-11 17:22:42','2014-11-11 17:37:28',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505184436&msg=tes+program'),(12,1,'=> public','0016505184436','public','autre schedule','Message sent from cronjob 2014-11-10 17:45:00','2014-11-11 18:11:38',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505184436&msg=autre+schedule'),(13,1,'=> public','0016505184436','public','dernier test','Message sent from cronjob 2014-11-11 18:16:33','2014-11-11 18:17:53',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505184436&msg=dernier+test'),(14,1,'=> public','0016505184436','public','j essai a nouveau l cron','Message sent from cronjob 2014-11-11 18:20:28','2014-11-11 18:21:01',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505184436&msg=j+essai+a+nouveau+l+cron'),(15,1,'=> public','0016505184436','public','j test','','2014-11-17 02:14:31',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505184436&msg=j+test'),(16,1,'=> public','0016505184436','public','autre msm','','2014-11-23 05:46:56',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505184436&msg=autre+msm'),(17,1,'=> public','00237675474635','public','Bonjour, beneficiez de nos nouvelles promotions. 7000 FCFA la nuitee jusqu\\\'au 1 fevrier !!!','','2015-01-17 14:21:57',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=00237675474635&msg=Bonjour%2C+beneficiez+de+nos+nouvelles+promotions.+7000+FCFA+la+nuitee+jusqu%27au+1+fevrier+%21%21%21'),(18,1,'=> public','0016505183925','public','j ss nacos','','2015-02-19 06:58:19',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505183925&msg=j+ss+nacos'),(19,1,'=> public','testscheduled','public','Bonjour, beneficiez de nos nouvelles promotions. 7000 FCFA la nuitee jusqu\\\'au 1 fevrier !!!','Message sent from cronjob 2015-02-19 07:04:00','2015-02-19 07:04:02',0,'Error sending msg to: http://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=testscheduled&msg=Bonjour%2C+beneficiez+de+nos+nouvelles+promotions.+7000+FCFA+la+nuitee+jusqu%27au+1+fevrier+%21%21%21',0,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=testscheduled&msg=Bonjour%2C+beneficiez+de+nos+nouvelles+promotions.+7000+FCFA+la+nuitee+jusqu%27au+1+fevrier+%21%21%21'),(20,1,'=> public','0016505183925','public','Bonjour, beneficiez de nos nouvelles promotions. 7000 FCFA la nuitee jusqu\\\'au 1 fevrier !!!','Message sent from cronjob 2015-02-19 07:07:00','2015-02-19 07:07:01',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505183925&msg=Bonjour%2C+beneficiez+de+nos+nouvelles+promotions.+7000+FCFA+la+nuitee+jusqu%27au+1+fevrier+%21%21%21'),(21,1,'=> public','0016505183925','public','Bonjour, beneficiez de nos nouvelles promotions. 7000 FCFA la nuitee jusqu\\\'au 1 fevrier !!!','Message sent from cronjob 2015-02-19 08:45:00','2015-02-19 10:45:01',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505183925&msg=Bonjour%2C+beneficiez+de+nos+nouvelles+promotions.+7000+FCFA+la+nuitee+jusqu%27au+1+fevrier+%21%21%21'),(22,1,'=> public','0016505183925','public','Bonjour, beneficiez de nos nouvelles promotions. 7000 FCFA la nuitee jusqu\\\'au 1 fevrier !!!','Message sent from cronjob 2015-02-19 08:48:00','2015-02-19 10:47:01',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1122138026&sender=public&number[]=0016505183925&msg=Bonjour%2C+beneficiez+de+nos+nouvelles+promotions.+7000+FCFA+la+nuitee+jusqu%27au+1+fevrier+%21%21%21'),(23,11670,'=> ralph','00237695316025','ralph','test','Message sent from cronjob 2015-02-19 21:45:00','2015-02-19 21:46:02',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1414363789&sender=ralph&number[]=00237695316025&msg=test'),(24,11670,'=> ralph','00237695316025','ralph','test2','Message sent from cronjob 2015-02-19 21:55:00','2015-02-19 21:55:02',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1414363789&sender=ralph&number[]=00237695316025&msg=test2'),(25,1024,'=> fabricevip','0012403963196','fabricevip','Visit us at www.panicomputer.com for all your IT needs.','','2015-03-03 21:44:10',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1301392684&sender=fabricevip&number[]=0012403963196&msg=Visit+us+at+www.panicomputer.com+for+all+your+IT+needs.'),(26,1024,'=> fabricevip','0012406462004','fabricevip','Visit us at www.panicomputer.com for all your IT needs.','','2015-03-03 21:44:10',0,'Error sending msg to: http://jetcamer.com/nna/sms/marketing/?card=1301392684&sender=fabricevip&number[]=0012406462004&msg=Visit+us+at+www.panicomputer.com+for+all+your+IT+needs.',0,0,'https://jetcamer.com/nna/sms/marketing/?card=1301392684&sender=fabricevip&number[]=0012406462004&msg=Visit+us+at+www.panicomputer.com+for+all+your+IT+needs.'),(27,1024,'=> fabricevip','0016505183925','fabricevip','Visit us at www.panicomputer.com for all your IT needs.','','2015-03-03 21:44:10',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1301392684&sender=fabricevip&number[]=0016505183925&msg=Visit+us+at+www.panicomputer.com+for+all+your+IT+needs.'),(28,1024,'=> fabricevip','0012408322307','fabricevip','Visit us at www.panicomputer.com for all your IT needs.','','2015-03-03 21:44:10',1,'ok',1,0,'https://jetcamer.com/nna/sms/marketing/?card=1301392684&sender=fabricevip&number[]=0012408322307&msg=Visit+us+at+www.panicomputer.com+for+all+your+IT+needs.'),(29,1024,'=> fabricevip','0012404053968','fabricevip','Visit us at www.panicomputer.com for all your IT needs.','','2015-03-03 21:44:10',0,'Error sending msg to: http://jetcamer.com/nna/sms/marketing/?card=1301392684&sender=fabricevip&number[]=0012404053968&msg=Visit+us+at+www.panicomputer.com+for+all+your+IT+needs.',0,0,'https://jetcamer.com/nna/sms/marketing/?card=1301392684&sender=fabricevip&number[]=0012404053968&msg=Visit+us+at+www.panicomputer.com+for+all+your+IT+needs.');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
