-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.1.21-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win32
-- HeidiSQL Version:             9.3.0.4984
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
/*!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' */;

-- Dumping structure for table camera_app_0006.advertisement
CREATE TABLE IF NOT EXISTS `advertisement` (
  `adv_id` int(11) NOT NULL AUTO_INCREMENT,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `description` text,
  `status` varchar(255) DEFAULT NULL,
  `user_created` int(11) DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `user_modified` int(11) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `client_id` int(11) NOT NULL,
  PRIMARY KEY (`adv_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.advertisement: ~0 rows (approximately)
/*!40000 ALTER TABLE `advertisement` DISABLE KEYS */;
INSERT INTO `advertisement` (`adv_id`, `start_date`, `end_date`, `description`, `status`, `user_created`, `date_created`, `user_modified`, `date_modified`, `client_id`) VALUES
	(1, '2015-06-01', '2017-12-21', 'Ads from camera apps o010', '23', 1, '2015-06-01 14:29:03', 1, '2017-03-03 14:54:47', 0);
/*!40000 ALTER TABLE `advertisement` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.advertisement_detail
CREATE TABLE IF NOT EXISTS `advertisement_detail` (
  `adv_detail_id` int(11) NOT NULL AUTO_INCREMENT,
  `adv_id` int(11) DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `content_type` varchar(255) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `max_display` int(11) DEFAULT NULL,
  `current_display` int(11) DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `user_created` int(11) DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `user_modified` int(11) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`adv_detail_id`),
  KEY `adv` (`adv_id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.advertisement_detail: 3 rows
/*!40000 ALTER TABLE `advertisement_detail` DISABLE KEYS */;
INSERT INTO `advertisement_detail` (`adv_detail_id`, `adv_id`, `content`, `content_type`, `duration`, `priority`, `max_display`, `current_display`, `status`, `start_date`, `end_date`, `user_created`, `date_created`, `user_modified`, `date_modified`) VALUES
	(16, 1, '12677.73910.Year-End-Campaign-December-FMT.JPG', 'image', 10, 1, 10, NULL, '1', '2015-06-01 00:00:00', '2017-12-21 00:00:00', 1, '2017-03-03 14:55:25', NULL, NULL),
	(15, 1, '24195.ijn event.jpg', 'image', 10, 1, 2, NULL, '1', '2015-06-01 00:00:00', '2017-12-21 00:00:00', 1, '2017-03-03 14:52:31', NULL, NULL),
	(13, 7, '26486.mainpage2.jpg', 'image', 12, 2, 1, NULL, '0', '2017-02-10 00:00:00', '2017-03-10 00:00:00', 1, '2017-03-02 18:38:54', NULL, NULL);
/*!40000 ALTER TABLE `advertisement_detail` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.client
CREATE TABLE IF NOT EXISTS `client` (
  `client_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `client_code` varchar(150) DEFAULT NULL,
  `client_name` varchar(255) CHARACTER SET utf8 DEFAULT '',
  `client_pic` varchar(255) DEFAULT NULL,
  `client_address` text,
  `client_state` varchar(255) DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `user_created` int(10) unsigned DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `user_modified` int(10) unsigned DEFAULT NULL,
  `client_status` int(11) DEFAULT NULL,
  `client_logo` varchar(255) DEFAULT NULL,
  `client_email` varchar(255) DEFAULT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`client_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.client: 0 rows
/*!40000 ALTER TABLE `client` DISABLE KEYS */;
/*!40000 ALTER TABLE `client` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.content
CREATE TABLE IF NOT EXISTS `content` (
  `content_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `content_type` int(11) DEFAULT NULL COMMENT '1-image',
  `content` varchar(200) DEFAULT NULL,
  `content_category` enum('1','2','3') DEFAULT NULL COMMENT '1-header, 2-frame, 3-background',
  `priority` int(11) DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `status` enum('1','2') DEFAULT NULL COMMENT '1-enable, 2-disable',
  PRIMARY KEY (`content_id`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.content: 13 rows
/*!40000 ALTER TABLE `content` DISABLE KEYS */;
INSERT INTO `content` (`content_id`, `content_type`, `content`, `content_category`, `priority`, `date_created`, `date_modified`, `status`) VALUES
	(2, 1, '20150313172745_header.png', '1', 1, '2015-02-05 18:52:23', '2015-03-13 17:27:46', '1'),
	(5, 1, '20150217105741_full_background.png', '3', 1, '2015-02-17 10:53:29', '2015-02-17 10:57:41', '1'),
	(29, 1, '20170310143502_frame design x 3-01.png', '2', 6, '2015-09-22 10:33:08', '2017-03-10 14:35:02', '1'),
	(28, 1, '20170310162029_9.png', '2', 5, '2015-09-22 10:32:55', '2017-03-10 16:20:29', '1'),
	(27, 1, '20170310143517__00.png', '2', 4, '2015-09-22 10:32:43', '2017-03-10 14:35:17', '1'),
	(24, 1, '20170310143540_-01.png', '2', 1, '2015-09-22 10:30:00', '2017-03-10 14:35:40', '1'),
	(25, 1, '20170310161521_2.png', '2', 2, '2015-09-22 10:32:16', '2017-03-10 16:15:21', '1'),
	(26, 1, '20170310161612_3.png', '2', 3, '2015-09-22 10:32:30', '2017-03-10 16:16:12', '1'),
	(30, 1, '20170310161620_8.png', '2', 0, '2017-03-07 15:33:13', '2017-03-10 16:16:20', '1'),
	(31, 1, '20170310161627_4.png', '2', 7, '2017-03-10 14:37:56', '2017-03-10 16:16:27', '1'),
	(32, 1, '20170310161634_5.png', '2', 8, '2017-03-10 14:39:12', '2017-03-10 16:16:34', '1'),
	(33, 1, '20170310161639_6.png', '2', 9, '2017-03-10 14:39:21', '2017-03-10 16:16:39', '1'),
	(34, 1, '20170310161645_7.png', '2', 10, '2017-03-10 14:39:28', '2017-03-10 16:16:45', '1');
/*!40000 ALTER TABLE `content` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.device
CREATE TABLE IF NOT EXISTS `device` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `device_id` varchar(150) DEFAULT NULL,
  `android_id` varchar(150) DEFAULT NULL,
  `fmt_id` varchar(10) DEFAULT NULL,
  `version_id` varchar(50) DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `last_sync` datetime DEFAULT NULL,
  `ip_remote` varchar(20) DEFAULT NULL,
  `ip_local` varchar(20) DEFAULT NULL,
  `remark` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `date_inserted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `android_id` (`android_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.device: 1 rows
/*!40000 ALTER TABLE `device` DISABLE KEYS */;
INSERT INTO `device` (`id`, `device_id`, `android_id`, `fmt_id`, `version_id`, `last_update`, `last_sync`, `ip_remote`, `ip_local`, `remark`, `date_inserted`) VALUES
	(3, '3210', 'a 001', 'fmt001', 'v 001', '2014-08-27 11:02:00', '2014-09-10 15:09:36', '211.24.227.196', '211.24.227.196.1', NULL, '2014-08-27 14:50:35');
/*!40000 ALTER TABLE `device` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.device_status
CREATE TABLE IF NOT EXISTS `device_status` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `android_id` varchar(255) DEFAULT NULL,
  `os_ver_id` varchar(10) DEFAULT NULL,
  `fmt_id` varchar(50) DEFAULT NULL,
  `version_id` varchar(10) DEFAULT NULL,
  `remote_ip` varchar(50) DEFAULT NULL,
  `local_ip` varchar(255) DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `time` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.device_status: 0 rows
/*!40000 ALTER TABLE `device_status` DISABLE KEYS */;
/*!40000 ALTER TABLE `device_status` ENABLE KEYS */;


-- Dumping structure for table camera_app_001.disclaimer
CREATE TABLE IF NOT EXISTS `disclaimer` (
  `id` int(11) NOT NULL,
  `disclaimer` varchar(250) DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `user_modified` int(11) DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `user_created` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_001.disclaimer: 1 rows
/*!40000 ALTER TABLE `disclaimer` DISABLE KEYS */;
INSERT INTO `disclaimer` (`id`, `disclaimer`, `date_created`, `user_modified`, `date_modified`, `status`, `user_created`) VALUES
	(0, '店家擁有照片使用權，\n是否同意繼續拍照？', '2017-04-04 12:27:30', NULL, '2017-04-06 18:28:52', NULL, NULL);
/*!40000 ALTER TABLE `disclaimer` ENABLE KEYS */;

-- Dumping structure for table camera_app_0006.email
CREATE TABLE IF NOT EXISTS `email` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email_from` varchar(255) DEFAULT NULL,
  `email_to` varchar(255) DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  `image_name` varchar(255) DEFAULT NULL,
  `date_email` datetime DEFAULT NULL,
  `share_via` varchar(25) DEFAULT NULL,
  `fmtID` varchar(255) DEFAULT NULL,
  `deviceID` varchar(255) DEFAULT NULL,
  `from_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.email: 0 rows
/*!40000 ALTER TABLE `email` DISABLE KEYS */;
/*!40000 ALTER TABLE `email` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.email_copy
CREATE TABLE IF NOT EXISTS `email_copy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email_from` varchar(255) DEFAULT NULL,
  `email_to` varchar(255) DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  `image_name` varchar(255) DEFAULT NULL,
  `date_email` datetime DEFAULT NULL,
  `share_via` varchar(25) DEFAULT NULL,
  `fmtID` varchar(255) DEFAULT NULL,
  `deviceID` varchar(255) DEFAULT NULL,
  `from_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Dumping data for table camera_app_0006.email_copy: 0 rows
/*!40000 ALTER TABLE `email_copy` DISABLE KEYS */;
/*!40000 ALTER TABLE `email_copy` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.hashtag
CREATE TABLE IF NOT EXISTS `hashtag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hashtag` text,
  `date_created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.hashtag: 2 rows
/*!40000 ALTER TABLE `hashtag` DISABLE KEYS */;
INSERT INTO `hashtag` (`id`, `hashtag`, `date_created`) VALUES
	(4, 'mobilead', '2014-08-28 15:25:00'),
	(6, 'test', '2017-02-24 10:00:00');
/*!40000 ALTER TABLE `hashtag` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.ref_general
CREATE TABLE IF NOT EXISTS `ref_general` (
  `ref_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ref_name` varchar(255) DEFAULT NULL,
  `ref_keyword` varchar(15) DEFAULT NULL,
  `ref_group` int(11) unsigned DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `user_modified` int(11) unsigned DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `user_created` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`ref_id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.ref_general: 23 rows
/*!40000 ALTER TABLE `ref_general` DISABLE KEYS */;
INSERT INTO `ref_general` (`ref_id`, `ref_name`, `ref_keyword`, `ref_group`, `date_modified`, `user_modified`, `date_created`, `user_created`) VALUES
	(1, 'Terminal Brand Group', NULL, 0, NULL, NULL, NULL, NULL),
	(2, 'Main Category', 'category', 1, NULL, NULL, NULL, NULL),
	(3, 'Sub Category', 'subcategory', 1, NULL, NULL, NULL, NULL),
	(4, 'User_Group', NULL, 0, NULL, NULL, NULL, NULL),
	(5, 'Superadmin', NULL, 4, NULL, NULL, NULL, NULL),
	(6, 'Content', NULL, 4, NULL, NULL, NULL, NULL),
	(7, 'Slot_Type', 'slottype', 0, NULL, NULL, NULL, NULL),
	(8, 'Single', NULL, 7, NULL, NULL, NULL, NULL),
	(9, 'Common', NULL, 7, NULL, NULL, NULL, NULL),
	(10, 'Multiple', NULL, 7, NULL, NULL, NULL, NULL),
	(11, 'Advertisement', NULL, 7, NULL, NULL, NULL, NULL),
	(12, 'Content_Type', NULL, 0, NULL, NULL, NULL, NULL),
	(13, 'Image', NULL, 12, NULL, NULL, NULL, NULL),
	(14, 'Video', NULL, 12, NULL, NULL, NULL, NULL),
	(15, 'Status_Content', NULL, 0, NULL, NULL, NULL, NULL),
	(16, 'Active', NULL, 15, NULL, NULL, NULL, NULL),
	(17, 'Not Active', NULL, 15, NULL, NULL, NULL, NULL),
	(18, 'Mall_Admin', NULL, 4, NULL, NULL, NULL, NULL),
	(20, 'Shop_Admin', NULL, 4, NULL, NULL, NULL, NULL),
	(21, 'Advertisement_Status', '', 0, '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00', NULL),
	(22, 'Pending', '', 21, '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00', NULL),
	(23, 'Approved', '', 21, '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00', NULL),
	(24, 'Not Approved', '', 21, '0000-00-00 00:00:00', NULL, '0000-00-00 00:00:00', NULL);
/*!40000 ALTER TABLE `ref_general` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.scroll_text
CREATE TABLE IF NOT EXISTS `scroll_text` (
  `st_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `st_title` varchar(255) DEFAULT NULL,
  `st_description` varchar(255) DEFAULT NULL,
  `st_start_date` datetime DEFAULT NULL,
  `st_end_date` datetime DEFAULT NULL,
  `st_duration_time` int(10) DEFAULT NULL,
  `st_status` int(1) DEFAULT NULL,
  `st_ordering` int(10) DEFAULT NULL,
  PRIMARY KEY (`st_id`),
  KEY `start` (`st_start_date`),
  KEY `end` (`st_end_date`),
  KEY `ordering` (`st_ordering`)
) ENGINE=MyISAM AUTO_INCREMENT=139 DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.scroll_text: 4 rows
/*!40000 ALTER TABLE `scroll_text` DISABLE KEYS */;
INSERT INTO `scroll_text` (`st_id`, `st_title`, `st_description`, `st_start_date`, `st_end_date`, `st_duration_time`, `st_status`, `st_ordering`) VALUES
	(135, 'Test                ', '------MobileAD Camera Test------', '2014-06-27 00:00:00', '2017-12-31 00:00:00', 10, 1, 1),
	(136, 'Test      2 ', 'Share your photos to Facebook, Twitter or your email address. it is FREE!    ', '2014-07-27 00:00:00', '2014-12-31 00:00:00', 10, 0, 2),
	(137, '    ', 'Please Grab Your Picture @ Red Bull Fan Pages www.facebook.com/racenightmy..!!    ', '2015-01-28 13:04:22', '2015-12-21 09:00:00', NULL, 0, NULL),
	(138, '      ', 'Smile, please! free Wonda Coffee...  ', '2015-08-01 00:00:00', '2015-12-31 00:00:00', NULL, 0, NULL);
/*!40000 ALTER TABLE `scroll_text` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.settings
CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_code` varchar(150) DEFAULT NULL,
  `printer_ip` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.settings: 1 rows
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` (`id`, `client_code`, `printer_ip`) VALUES
	(1, '001', '192.168.0.1');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.share_facebook
CREATE TABLE IF NOT EXISTS `share_facebook` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `page_user_admin` varchar(255) DEFAULT NULL,
  `page_id` varchar(255) DEFAULT NULL,
  `place_id` varchar(255) DEFAULT NULL,
  `token_app_user` varchar(255) DEFAULT NULL,
  `token_page_admin` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.share_facebook: 1 rows
/*!40000 ALTER TABLE `share_facebook` DISABLE KEYS */;
INSERT INTO `share_facebook` (`id`, `page_user_admin`, `page_id`, `place_id`, `token_app_user`, `token_page_admin`) VALUES
	(1, 'Apple Lily', '807249852696815', '167688613254839', 'CAACPIpoitFABAHTFVZAOEKmZAauzDKnZBfim6sw56ZCNYt3vMZCkLjWX9BY6Lji60UgLnt1Hbe70yoyePPqQgRHMPWI2rxA5hgI7i7TLYuQEmXkP8rj3PKJ5CE5P4U6abuSwPPRdnKrvhzykwM7UxHw5ZB7hJZBIAvPgMhKgZCQ7FVutIIK54pnE0gZAN8HBkVoF8hvctMqKyBDJZBguepm9mW', 'CAACPIpoitFABAFnVIJ2MWtmyfZCX6r2Asmch5dX95lvkEwy30HjpMR3Xb69uZCsZBJ3GagZCvHHPYoeevCfv1oWZBf3JPR1iVYqGy7BZAQIDC68fzjx6bgprfZAeFVJoAZAd51ZBqZBS1mJcMHcQFF2bu5vJw3TtmA25kKHRJk8TMbDeNhdm9JFgmdZBIQbtuLd7ngZD');
/*!40000 ALTER TABLE `share_facebook` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.user_detail
CREATE TABLE IF NOT EXISTS `user_detail` (
  `user_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `user_fullname` varchar(255) DEFAULT NULL,
  `user_email` varchar(255) DEFAULT NULL,
  `user_password` varchar(255) DEFAULT NULL,
  `user_contactno` varchar(255) DEFAULT NULL,
  `user_group` varchar(255) DEFAULT NULL,
  `user_status` varchar(255) DEFAULT NULL,
  `user_created` datetime DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `user_modified` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `total_login` int(11) NOT NULL DEFAULT '0',
  `force_update` tinyint(3) unsigned DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  KEY `login` (`username`,`user_password`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.user_detail: 6 rows
/*!40000 ALTER TABLE `user_detail` DISABLE KEYS */;
INSERT INTO `user_detail` (`user_id`, `username`, `user_fullname`, `user_email`, `user_password`, `user_contactno`, `user_group`, `user_status`, `user_created`, `date_created`, `user_modified`, `date_modified`, `last_login`, `total_login`, `force_update`) VALUES
	(1, 'admin', 'Administrator', 'saifuddin@m3tech.com.my', 'c93ccd78b2076528346216b3b2f701e6', '0192142606', '5', '1', NULL, NULL, '2014-05-16 17:21:54', NULL, '2017-04-17 07:54:15', 910, NULL),
	(2, 'content', 'Content Admin', 'anif@m3tech.com.my', 'f41e63d77aa489a826d32d111f875334', '+60163259874', '5', '1', NULL, NULL, '2014-05-16 17:22:08', NULL, '2014-06-11 18:15:19', 9, NULL),
	(3, 'Didi', 'Nor DIyanah', 'diyanahh@m3online.com', 'a9d28ead13dfb45d419ee6d812661f89', '+60199117851', '5', '1', '2017-03-02 14:23:57', NULL, NULL, NULL, NULL, 0, NULL),
	(4, 'dada', 'Nor DIyanah', 'diyanahh@m3online.comm', '3691308f2a4c2f6983f2880d32e29c84', '+60199117851', '5', '1', '2017-03-02 14:30:08', NULL, NULL, NULL, NULL, 0, NULL),
	(5, 'Fatahul', 'fatahul', 'fatahul@m3tech.com.my', '5f4dcc3b5aa765d61d8327deb882cf99', '+60126306016', '5', '1', '2017-03-02 14:43:08', NULL, NULL, NULL, NULL, 0, NULL),
	(6, 'diyanahhhhh@m3online.com', 'Didiy Diyanah', 'diyanahhhhh@m3online.com', '64ZNXE', '199117851', '6', '2', '0000-00-00 00:00:00', '2017-04-17 13:06:54', NULL, NULL, NULL, 0, NULL);
/*!40000 ALTER TABLE `user_detail` ENABLE KEYS */;


-- Dumping structure for table camera_app_0006.watermark
CREATE TABLE IF NOT EXISTS `watermark` (
  `watermark_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `watermark_name` varchar(150) DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`watermark_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- Dumping data for table camera_app_0006.watermark: 1 rows
/*!40000 ALTER TABLE `watermark` DISABLE KEYS */;
INSERT INTO `watermark` (`watermark_id`, `watermark_name`, `date_created`, `date_modified`) VALUES
	(3, '-------MobileAD', '2015-01-22 16:48:44', '2017-03-07 11:51:12');
/*!40000 ALTER TABLE `watermark` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
