--
-- Host: localhost    Database: fmedia_axa
-- ------------------------------------------------------


--
-- Table structure for table `about`
--

CREATE TABLE `about` (
  `id_about` int(5) NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) DEFAULT NULL,
  `left_content` text DEFAULT NULL,
  `right_content` text DEFAULT NULL,
  `desk_judul` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_about`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `about`
--

INSERT INTO `about` VALUES (1,'About Us','<p style=\"text-align:right\"><span style=\"font-size:14px\">Sebagai pemimpin global<br />\r\ndalam perlindungan keuangan,<br />\r\nGrup AXA didedikasikan untuk<br />\r\nmelindungi masyarakat dan properti.<br />\r\nGrup AXA berkomitmen untuk melayani<br />\r\npara nasabah, baik perorangan maupun<br />\r\nperusahaan, di setiap tahap kehidupan mereka<br />\r\ndengan menyediakan produk dan layanan<br />\r\nyang memenuhi kebutuhan mereka, termasuk asuransi, perlindungan pribadi, dan rencana tabungan masa depan</span></p>\r\n','<p><span style=\"font-size:14px\">AXA di Indonesia merupakan bagian dari AXA Group, salah satu perusahaan. Asuransi dan manajemen aset terbesar di dunia. AXA beroperasi dengan fokus pada asuransi jiwa, asuransi umum dan manajemen aset melalui beragam jalur distribusi di bawah PT AXA Mandiri Financial Services, PT AXA Financial Indonesia, PT AXA Life Indonesia, PT Mandiri AXA General Insurance, PT Asuransi AXA Indonesia, dan PT AXA Asset Management Indonesia.</span></p>\r\n','<p><span style=\"font-size:14px\">Memberikan solusi asuransi untuk Anda</span></p>\r\n\r\n<p><span style=\"font-size:14px\">dengan jaringan layanan terluas di seluruh dunia</span></p>\r\n','48740.jpg');

--
-- Table structure for table `active_guests`
--

CREATE TABLE `active_guests` (
  `ip` varchar(15) NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `active_guests`
--

INSERT INTO `active_guests` VALUES ('182.253.40.141',1467170879);

--
-- Table structure for table `active_users`
--

CREATE TABLE `active_users` (
  `username` varchar(30) NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `active_users`
--


--
-- Table structure for table `banned_users`
--

CREATE TABLE `banned_users` (
  `username` varchar(30) NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `banned_users`
--


--
-- Table structure for table `history_user`
--

CREATE TABLE `history_user` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `action` varchar(50) DEFAULT NULL,
  `ip` varchar(100) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `history_user`
--

INSERT INTO `history_user` VALUES (11,'admin','login','139.193.98.99','2015-09-08','14:22:58'),(12,'admin','login','139.193.98.99','2015-09-09','16:50:57');

--
-- Table structure for table `login_attempts`
--

CREATE TABLE `login_attempts` (
  `ip` varchar(20) DEFAULT NULL,
  `attempts` int(11) DEFAULT 0,
  `lastlogin` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `login_attempts`
--

INSERT INTO `login_attempts` VALUES ('::1',1,'2015-07-08 15:17:23');

--
-- Table structure for table `solusi-kesehatan`
--

CREATE TABLE `solusi-kesehatan` (
  `id_solusi` int(5) NOT NULL AUTO_INCREMENT,
  `data_upload` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_solusi`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `solusi-kesehatan`
--


--
-- Table structure for table `video`
--

CREATE TABLE `video` (
  `id_video` int(5) NOT NULL AUTO_INCREMENT,
  `nama_video` varchar(255) DEFAULT NULL,
  `link_video` varchar(255) DEFAULT NULL,
  `id_page` int(5) DEFAULT NULL,
  `Type` varchar(150) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `Size` varchar(150) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `ss_gambar` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_video`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `video`
--

INSERT INTO `video` VALUES (27,'video kita yang diupload bersama','24164.mp4',2,'video/mp4','1639410','6114.jpg'),(28,'video kita yang diupload bersama dengan macet di waktu sore','74655.mp4',2,'video/mp4','7613901','29350.jpg'),(29,'AXA Manifesto','97012.mp4',4,'video/mp4','7613901','88858.png'),(30,'AXA Health Expert','54205.mp4',4,'video/mp4','1639410','53253.png'),(31,'AXA Manifesto','14054.mp4',3,'video/mp4','7613901','32236.png'),(32,'AXA Health Expert','86676.mp4',3,'video/mp4','1639410','34180.png'),(33,'AXA Manifesto','40387.mp4',1,'video/mp4','7613901','73828.png'),(34,'AXA Health Expert','86728.mp4',1,'video/mp4','1639410','84939.png'),(35,'AXA Health Expert','36063.mp4',1,'video/mp4','1639410','63708.png'),(36,'AXA Manifesto','66937.mp4',1,'video/mp4','7613901','1645.png'),(37,'AXA Health Expert','36960.mp4',1,'video/mp4','1639410','69525.png'),(38,'AXA Manifesto','80359.mp4',1,'video/mp4','7613901','77087.png'),(39,'video kita yang diupload bersama','885.mp4',2,'video/mp4','7613901','20294.jpg'),(40,'video kita yang diupload bersama','25920.mp4',2,'video/mp4','1639410','59489.jpg'),(41,'video kita yang diupload bersama','43476.mp4',2,'video/mp4','1639410','55034.jpg'),(42,'video kita yang diupload bersama','30633.mp4',2,'video/mp4','7613901','63268.jpg'),(43,'video kita yang diupload bersama','2532.mp4',2,'video/mp4','7613901','94787.jpg'),(44,'AXA Health Expert','46365.mp4',2,'video/mp4','1639410','15387.jpg'),(45,'AXA Health Expert','14391.mp4',2,'video/mp4','1639410','32091.jpg'),(46,'AXA Health Expert','421.mp4',2,'video/mp4','1639410','26392.jpg'),(47,'AXA Flowers','99926.mp4',3,'video/mp4','1317562','88998.jpg'),(48,'AXA Health Care','47330.mp4',3,'video/mp4','1639410','82652.jpg'),(49,'AXA Flowers','58066.mp4',4,'video/mp4','1317562','5447.jpg');

--
-- Table structure for table `video_page`
--

CREATE TABLE `video_page` (
  `id_page` int(5) NOT NULL AUTO_INCREMENT,
  `title_vid` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_page`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `video_page`
--

INSERT INTO `video_page` VALUES (1,'solusi kesehatan',NULL),(2,'Customer',NULL),(3,'Proteksi',NULL),(4,'Investasi Proteksi',NULL);


