/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 10.4.22-MariaDB : Database - crm
*********************************************************************
*/



CREATE DATABASE /*!32312 IF NOT EXISTS*/`crm` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;

USE `crm`;

/*Table structure for table `prequest` */


CREATE TABLE `prequest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contactno` varchar(11) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `wdd` varchar(255) DEFAULT NULL,
  `cms` varchar(255) DEFAULT NULL,
  `seo` varchar(255) DEFAULT NULL,
  `smo` varchar(255) DEFAULT NULL,
  `swd` varchar(255) DEFAULT NULL,
  `dwd` varchar(255) DEFAULT NULL,
  `fwd` varchar(255) DEFAULT NULL,
  `dr` varchar(255) DEFAULT NULL,
  `whs` varchar(255) DEFAULT NULL,
  `wm` varchar(255) DEFAULT NULL,
  `ed` varchar(255) DEFAULT NULL,
  `wta` varchar(255) DEFAULT NULL,
  `opi` varchar(255) DEFAULT NULL,
  `ld` varchar(255) DEFAULT NULL,
  `da` varchar(255) DEFAULT NULL,
  `osc` varchar(255) DEFAULT NULL,
  `nd` varchar(255) DEFAULT NULL,
  `others` varchar(255) DEFAULT NULL,
  `query` longtext DEFAULT NULL,
  `posting_date` date DEFAULT NULL,
  `remark` longtext DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `prequest` */

insert  into `prequest`(`id`,`name`,`email`,`contactno`,`company`,`wdd`,`cms`,`seo`,`smo`,`swd`,`dwd`,`fwd`,`dr`,`whs`,`wm`,`ed`,`wta`,`opi`,`ld`,`da`,`osc`,`nd`,`others`,`query`,`posting_date`,`remark`,`status`) values (1,'User Recursivo','recursivoweb@mail.com','1234567890','Test','Website Design & Development','','','','','Dynamic Website Design','','','Web Hosting Services','','Ecommerce Development','Walk Through Animation','','','','','','','This is for testing','2021-04-22','This is for test',NULL);

/*Table structure for table `ticket` */


CREATE TABLE `ticket` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_id` varchar(11) DEFAULT NULL,
  `email_id` varchar(300) DEFAULT NULL,
  `subject` varchar(300) DEFAULT NULL,
  `task_type` varchar(300) DEFAULT NULL,
  `prioprity` varchar(300) DEFAULT NULL,
  `ticket` longtext DEFAULT NULL,
  `attachment` varchar(300) DEFAULT NULL,
  `status` varchar(300) DEFAULT NULL,
  `admin_remark` longtext DEFAULT NULL,
  `posting_date` date DEFAULT NULL,
  `admin_remark_date` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

/*Data for the table `ticket` */

insert  into `ticket`(`id`,`ticket_id`,`email_id`,`subject`,`task_type`,`prioprity`,`ticket`,`attachment`,`status`,`admin_remark`,`posting_date`,`admin_remark_date`) values (12,'5','recursivoweb@mail.com','Test Ticket','billing','important','This ticket for testing purpose.','','closed','Ticket resolved.  Solution provided','2021-04-22','2022-07-14 16:56:02');

/*Table structure for table `usercheck` */


CREATE TABLE `usercheck` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `logindate` varchar(255) DEFAULT '',
  `logintime` varchar(255) DEFAULT '',
  `user_id` int(11) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT '',
  `ip` varbinary(16) DEFAULT NULL,
  `mac` varbinary(16) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Data for the table `usercheck` */

insert  into `usercheck`(`id`,`logindate`,`logintime`,`user_id`,`username`,`email`,`ip`,`mac`,`city`,`country`) values (1,'2021/04/22','05:59:18pm',1,'User Recursivo','recursivoweb@mail.com','::1','12-F4-8D-12-99-9','',''),(2,'2021/04/22','10:00:15pm',1,'User Recursivo','recursivoweb@mail.com','::1','12-F4-8D-12-99-9','',''),(3,'2022/07/15','03:30:30am',1,'User Recursivo','recursivoweb@mail.com','::1','Nombre de host. ','','');

