/*!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.25-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: fmedia_axa
-- ------------------------------------------------------
-- Server version	10.5.25-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

DROP TABLE IF EXISTS `about`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `about` WRITE;
/*!40000 ALTER TABLE `about` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `about` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `active_guests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `active_guests` WRITE;
/*!40000 ALTER TABLE `active_guests` DISABLE KEYS */;
INSERT INTO `active_guests` VALUES ('182.253.40.141',1467170879);
/*!40000 ALTER TABLE `active_guests` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `active_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `active_users` WRITE;
/*!40000 ALTER TABLE `active_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `active_users` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `banned_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `banned_users` WRITE;
/*!40000 ALTER TABLE `banned_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `banned_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `berita`
--

DROP TABLE IF EXISTS `berita`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `berita` (
  `id_berita` int(5) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `judul_seo` varchar(100) NOT NULL,
  `isi_berita` text NOT NULL,
  `hari` varchar(20) NOT NULL,
  `tanggal` date NOT NULL,
  `jam` time NOT NULL,
  `session_id` varchar(255) DEFAULT NULL,
  `gam` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_berita`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `berita`
--

LOCK TABLES `berita` WRITE;
/*!40000 ALTER TABLE `berita` DISABLE KEYS */;
INSERT INTO `berita` VALUES (3,'admin','Lorem Ipsum','lorem-ipsum','<p style=\"text-align: justify;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n<p style=\"text-align: justify;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n','Rabu','2015-08-12','15:21:39','55cb0213e5b8f','5500.jpg');
/*!40000 ALTER TABLE `berita` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gambar`
--

DROP TABLE IF EXISTS `gambar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gambar` (
  `id_gambar` int(5) NOT NULL AUTO_INCREMENT,
  `data_upload` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `session_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci 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,
  `judul` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `ss_gambar` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `tanggal` date DEFAULT NULL,
  PRIMARY KEY (`id_gambar`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gambar`
--

LOCK TABLES `gambar` WRITE;
/*!40000 ALTER TABLE `gambar` DISABLE KEYS */;
INSERT INTO `gambar` VALUES (7,'35822.jpg','55cb0213e5b8f','image/jpeg','437272',NULL,NULL,'2015-08-12'),(8,'13150.jpg','55cb0213e5b8f','image/jpeg','437272',NULL,NULL,'2015-08-12'),(9,'50714.mp4','55cb0213e5b8f','video/mp4','1639410','AXA Health Expert','26596.png','2015-08-12');
/*!40000 ALTER TABLE `gambar` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `history_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `history_user` WRITE;
/*!40000 ALTER TABLE `history_user` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `history_user` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `login_attempts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `login_attempts` WRITE;
/*!40000 ALTER TABLE `login_attempts` DISABLE KEYS */;
INSERT INTO `login_attempts` VALUES ('::1',1,'2015-07-08 15:17:23');
/*!40000 ALTER TABLE `login_attempts` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `solusi-kesehatan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `solusi-kesehatan` WRITE;
/*!40000 ALTER TABLE `solusi-kesehatan` DISABLE KEYS */;
/*!40000 ALTER TABLE `solusi-kesehatan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `userid` varchar(32) NOT NULL DEFAULT '',
  `username` varchar(30) NOT NULL,
  `password` varchar(32) NOT NULL,
  `userlevel` tinyint(4) NOT NULL DEFAULT 1,
  `email` varchar(64) NOT NULL,
  `timestamp` int(11) NOT NULL DEFAULT 0,
  `parent_directory` varchar(30) DEFAULT NULL,
  `phone_number` varchar(16) DEFAULT NULL,
  `confirmcode` varchar(32) DEFAULT NULL,
  `name` varchar(128) NOT NULL,
  `avatar` varchar(500) NOT NULL,
  `about` varchar(255) NOT NULL,
  `kondisi` varchar(1) NOT NULL DEFAULT '0',
  `status` varchar(160) DEFAULT NULL,
  `bahasa` varchar(2) DEFAULT NULL,
  `id_module` int(5) DEFAULT NULL,
  `auth_file` enum('0','1','2') NOT NULL DEFAULT '0',
  `jabatan` varchar(150) DEFAULT NULL,
  `active` enum('2','1','0') DEFAULT '0',
  `first_time` enum('2','1','0') DEFAULT '0',
  `uid` int(5) NOT NULL AUTO_INCREMENT,
  `color` varchar(255) DEFAULT NULL,
  `short_desc` varchar(100) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `cover_image` varchar(255) DEFAULT NULL,
  `terpercaya` enum('1','0') DEFAULT '0',
  `penulis_terbaik` enum('1','0') DEFAULT '0',
  `donatur` enum('1','0') DEFAULT '0',
  `nilai` int(5) DEFAULT NULL,
  PRIMARY KEY (`uid`,`userid`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES ('979b9a085c8cea6bac55d6a93226952a','admin','0192023a7bbd73250516f069df18b500',1,'',1441795568,'','08999265184','','admin','76483.jpg','','0','    ',NULL,NULL,'0','admin','1','0',1,'yellow','','axa','mandiri',NULL,'1','1','1',10);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `video`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `video` WRITE;
/*!40000 ALTER TABLE `video` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `video` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `video_page`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `video_page` WRITE;
/*!40000 ALTER TABLE `video_page` DISABLE KEYS */;
INSERT INTO `video_page` VALUES (1,'solusi kesehatan',NULL),(2,'Customer',NULL),(3,'Proteksi',NULL),(4,'Investasi Proteksi',NULL);
/*!40000 ALTER TABLE `video_page` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-07-03  4:53:23