/*
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 `cc_contacts` */

DROP TABLE IF EXISTS `cc_contacts`;

CREATE TABLE `cc_contacts` (
  `id` int(19) NOT NULL AUTO_INCREMENT,
  `card_id` int(19) NOT NULL DEFAULT '0',
  `first_name` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `mobile_phone` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `home_phone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `other_phone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `birthday` datetime DEFAULT NULL,
  `birthday_msg` text COLLATE utf8_unicode_ci,
  `last_sent` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `cc_contacts` */

insert  into `cc_contacts`(`id`,`card_id`,`first_name`,`last_name`,`mobile_phone`,`home_phone`,`other_phone`,`email`,`birthday`,`birthday_msg`,`last_sent`) values (1,11670,'test','test','0023772766120',NULL,NULL,'raphael.nsangou@rocketmail.com','2015-03-04 15:30:23','HBD','0000-00-00 00:00:00'),(3,174,'tient','Mark','00237697265310','00237242651088',NULL,'deuxmarco@yahoo.fr','2015-03-10 23:16:20','happi birthday','0000-00-00 00:00:00'),(4,174,'marcel','timaco','00237677066332',NULL,NULL,'mtientcheu@gmail.co','2015-03-10 23:19:49','joyeuse aniversaire!!!','0000-00-00 00:00:00'),(5,174,'nana','berthe','00237699651024',NULL,NULL,'nanaberthe@yahoo.fr','2015-03-11 22:32:01','happi birthday !','0000-00-00 00:00:00'),(8,174,'Gregloire','gur','00237677500669','00237233256621',NULL,NULL,'2015-03-12 10:19:51','Happy chrismas!','0000-00-00 00:00:00'),(9,174,'Happi','Laurent','00237670172506',NULL,NULL,'lhappi2010@yahoo.fr','2015-03-12 10:15:10','IDIMED vous souhaite happy new year!','0000-00-00 00:00:00'),(10,174,'Prince','Ndongo','00237695250320','0023777002320',NULL,'pndongo@gamail.com','2015-03-13 00:00:00','Have a nice day!','0000-00-00 00:00:00'),(11,11716,'Gregloire','Yegun','00237677500669',NULL,NULL,'gyegun@yahoo.fr','2015-03-20 06:07:00','Birthday','0000-00-00 00:00:00'),(12,11716,'IDIMED','CLINIQUE','00237650100364','00237233426529','00237694722652','gmdidmed@yahoo.fr','2015-03-12 06:12:03','Happi new year !','0000-00-00 00:00:00'),(14,1,'nacos','nacos','0016505183925',NULL,NULL,NULL,'2015-03-18 00:00:00','test bd msg','2015-03-18 03:25:02'),(15,174,'Tientcheu','Marcel','00237677066331',NULL,NULL,'deuxmarco@yahoo.fr','2015-03-18 13:29:03','joyeux anniversaire!',NULL),(20,174,'DATOUO','Roger','0023774839166','0023794895451','','rdatouo@gmail.com','1986-08-04 00:00:00','Bon',NULL),(21,1415881936,'DATOUO','Roger','00237674839166','','','rdatouo@yahoo.fr','1986-04-24 00:00:00','','0000-00-00 00:00:00'),(24,1415881936,'Test','test','00237567890','','','','2014-04-07 00:00:00','','0000-00-00 00:00:00');

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