Database Leaked Azanahotel.id

CREATE TABLE `userdata` (
  `id` int(11) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` longtext NOT NULL,
  `role` varchar(255) NOT NULL,
  `api` varchar(255) NOT NULL,
  `nohp` varchar(255) NOT NULL,
  `alamat` varchar(255) NOT NULL,
  `bio` longtext NOT NULL,
  `foto` longtext NOT NULL,
  `fb` varchar(255) NOT NULL,
  `twt` varchar(255) NOT NULL,
  `ig` varchar(255) NOT NULL,
  `status` varchar(3) NOT NULL,
  `loyalty_status` varchar(255) NOT NULL,
  `point` varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=1706 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userdata`
--

INSERT INTO `userdata` (`id`, `nama` `email`, `password`, `role`, `api`, `nohp`, `alamat`, `bio`, `foto`, `fb`, `twt`, `ig`, `status`, `loyalty_status`, `point`) VALUES
(1, 'Guest', 'Guest@gmail.com', '6bc74676849f5a6eb19f7ac09ffef7e78fd75f92646b5edf4600baf7a6ea0ed91ff044cd6ba2805287bd5278bcd857aa1d6631b06862a60eaeea7a5d4bf1c59a', 'customer', '1238135480426596', '5545', 'sss', 'ssss', '1629276176_2a3d307dd0f29f98484f.png', 'sfff', 'ffff', 'ffff', '1', '1', '0'),
(2, 'rrrr', 'grtr@gmail.com', '3627909a29c31381a071ec27f7c9ca97726182aed29a7ddd2e54353322cfb30abb9e3a6df2ac2c20fe23436311d678564d0c8d305930575f60e2d3d048184d79', 'customer', '5295818277440163', '', '', '', '', '', '', '', '1', '1', '0'),
(3, 'oke', 'yinguan2@gmail.com', '3627909a29c31381a071ec27f7c9ca97726182aed29a7ddd2e54353322cfb30abb9e3a6df2ac2c20fe23436311d678564d0c8d305930575f60e2d3d048184d79', 'customer', '2648855910692147', '081827117891', '', '', '1667528161_487af12ab7b2c3524b1f.jpeg', '', '', '', '1', '1', '0'),
(4, 'tttt', 'lutung5@gmail.com', '6bc74676849f5a6eb19f7ac09ffef7e78fd75f92646b5edf4600baf7a6ea0ed91ff044cd6ba2805287bd5278bcd857aa1d6631b06862a60eaeea7a5d4bf1c59a', 'customer', '2883764639912140', '08565655888', '', '', '1655976800_fee935f57098e00d9ee1.jpeg', '', '', '', '1', '1', '0'),
(5, 'Joni', 'tstrandro@gmail.com', 'fa585d89c851dd338a70dcf535aa2a92fee7836dd6aff1226583e88e0996293f16bc009c652826e0fc5c706695a03cddce372f139eff4d13959da6f1f5d3eabe', 'customer', '3711846205932987', '', '', '', '', '', '', '', '1', '1', '0'),
(6, 'toni', 'toni@gmail.com', '3627909a29c31381a071ec27f7c9ca97726182aed29a7ddd2e54353322cfb30abb9e3a6df2ac2c20fe23436311d678564d0c8d305930575f60e2d3d048184d79', 'customer', '6504367579928138', '', '', '', '', '', '', '', '1', '1', '0'),
(7, 'Agung', 'agungutamatkj@gmail.com', '6141551a891ba71c71710769199571db681040df97bb935a83afc3f173d80a0ce0eb45ab62e43d88014124059f398d54ad6080ff9cc1b94c98394e525eaea2e1', 'customer', '8631448523159026', '081229434281', 'Gabugan, Tanon, Sragen', '', '1664716804_4798242c2cdf867606d4.jpeg', '', '', '', '1', '1', '0'),
(8, 'ulala', 'ulala@gmail.com', '3627909a29c31381a071ec27f7c9ca97726182aed29a7ddd2e54353322cfb30abb9e3a6df2ac2c20fe23436311d678564d0c8d305930575f60e2d3d048184d79', 'customer', '5161848392760453', '', '', '', '', '', '', '', '1', '1', '0'),
(9, 'Rahmat Riyadi', 'lulugj@gmail.com', '3627909a29c31381a071ec27f7c9ca97726182aed29a7ddd2e54353322cfb30abb9e3a6df2ac2c20fe23436311d678564d0c8d305930575f60e2d3d048184d79', 'customer', '7661845932239847', '08888888888', '', '', '', '', '', '', '1', '1', '0'),
(10, 'Lalalll', 'Lalas236@gmail.com', '3627909a29c31381a071ec27f7c9ca97726182aed29a7ddd2e54353322cfb30abb9e3a6df2ac2c20fe23436311d678564d0c8d305930575f60e2d3d048184d79', 'customer', '8686401245321993', '08116495234', '', '', '1635303536_71658ab29fb2753c05fc.jpeg', '', '', '', '1', '1', '0'),
(11, 'Agung', 'agungtkjsakti@gmail.com', '0dd3e512642c97ca3f747f9a76e374fbda73f9292823c0313be9d78add7cdd8f72235af0c553dd26797e78e1854edee0ae002f8aba074b066dfce1af114e32f8', 'customer', '6350673549812729', '0811222333', 'kjnkjlnkjn', 'html{background-color:black;}', '', '', '', '', '1', '1', '0'),
(12, 'Erisa Dwi Nur Aini', 'erisadwinuraini0907@gmail.com', '5ebb9141217a738086aab089267061a147ac887a867227ba483bde9c5a1790e517c59e65f313bcb220bc345478e1e1dc250d01fc27a35725ae71031d8a0c8df5', 'customer', '8781159024267633', '', '', '', '', '', '', '', '1', '1', '0'),
(13, 'Rehansyah Aji Pramana', 'rehanpramana07@gmail.com', 'd93a3bb7ea2e33f8f1e36f7459d0e7009fc5ec6dfd629d57c66af3cd4a8e883a08c2038f5e437302ce72a33e8349bb3ff4cc607eb972f81171f3b1daad51e1b4', 'customer', '1265218047583493', '', '', '', '', '', '', '', '1', '1', '0'),
(14, 'Nyia Gita', 'nyiagita@yahoo.com', 'edabdf123fb200f2f96570a3965a66116d7d30ee970485bd715e83e759ecc3c5344867a23273a84f902a9fd75bca95c279049b098bd14c04b0bae89cf31d7d2f', 'customer', '8218036355494167', '', '', '', '', '', '', '', '1', '1', '0'),
(15, 'Taajwa Zakkia', 'zakkiataajwa@gmail.com', '0a232db98d1315240d8d146a45a158a8da67b869b30bf24b6d04df9ef62ead3161eaede07dd1287db4dcbb57d873599431f746de3c6db004383c5035314a45e7', 'customer', '3786997405348615', '', '', '', '', '', '', '', '1', '1', '0'),
(16, 'FRONTONE BOUTIQUE B21 MALANG', 'frontoneb21malang@gmail.com', '1b69c8fca6c5843e48e02e78f366f00ac881e6f402f49f7607d2ac4fdbfdb978b724e429a6d968690478fe6f39024c246929292ac31f44c5fcb7cab0a2959fc2', 'customer', '1688679025297415', '081290808060', 'baluran', '', '1635760000_b77aa44f04ad7d6a2ff5.jpg', 'Frontone Malang', '@frontonemalang', '@frontoneb21malang', '1', '1', '0'),
(17, 'Java Hielgant Raymond Takeshi', 'javatjahmadsareta@gmail.com', '1e2f5d2bc9b002529670cd9227608513a56cdafc0a46ec58614a4ced20c00057dcfcd9e6085cd1c6d60a015267289e95b92ce8c05c65e00bced0a98980b1aecc', 'customer', '2336954298610485', '', '', '', '', '', '', '', '1', '1', '0'),
(18, 'The Cube Hotel', 'thecubehotelyk@gmail.com', '3627909a29c31381a071ec27f7c9ca97726182aed29a7ddd2e54353322cfb30abb9e3a6df2ac2c20fe23436311d678564d0c8d305930575f60e2d3d048184d79', 'customer', '2766931195248834', '08112792079', 'JL.Parangtritis no.16 Mantrijeron Yogyakarta', '', '', '', '', '', '1', '1', '0'),
(19, 'Rahayu Desita Setiya', 'desitaayu01@gmail.com', '06fa1288d45f939e67b28d8a4024a42c9f2f68eeb1fce778d88f2e3fd054044bcc1d20e76f2c641571f42e07885bc300c27a616c7e82e58ee003d8b85409bf2c', 'customer', '9913256346841082', '', '', '', '', '', '', '', '1', '1', '0'),
(20, 'Amelia Alvia nugrahani', 'amelalvia@yahoo.com', 'f002809a96829632f96f4c0f92e56607df3b98b9f286d57fa745c1b6019d66d3d10a956c3c7a693e102c59113460ec3e43a38c1915415718156157163dfcfe21', 'customer', '7652408169433597', '', '', '', '', '', '', '', '1', '1', '0'),
(21, 'joni', 'andro@gmail.com', '507cc813eeaab797b3598c6051be3fe74c43bef9689b7fccfb4a50cd1f73f7a2af2da8be8f75d42153210528fd2bdf33630996ef6bd64ab0e9fbab9e1a9068cd', 'customer', '8491306952267835', '', '', '', '', '', '', '', '1', '1', '0'),
(22, 'Faris luthfi', 'Farisluthfi714@gmail.com', '2cee7a31af2e468ddb7c80369e21c33599096aeeac5dd7c6d9e83ece43623f75bdafca8cde712e225f1a4fa021e0f400b991ca7e9b1f19dc999b819e1369a897', 'customer', '1791754386695282', '', '', '', '', '', '', '', '1', '1', '0'),
(23, 'Fadhilah Asyifa Dewanti', 'fadhilahasyifad@gmail.com', '6c4a63b9631a7c98a6628359bce9808d9975d616c75e8c32d0944c26fd0ed0f9321d918d362fe354a44d5f38c3bda2612bd57ffcf3b451f5e088a88cf6d798f1', 'customer', '7916413054823958', '', '', '', '', '', '', '', '1', '1', '0'),
(24, 'Agustin eriska ', 'Agustineriska4@gmail.com', 'f272bde3a05d1e2beacff0852af0935518c8e5977ac79413fa89d169c461f6b5d60eeefd6b128470c36c14e4f5a1cf192d01f93caa01dcb55ce6fedf8008173c', 'customer', '9358917754224360', '', '', '', '', '', '', '', '1', '1', '0'),
(25, 'Ferdi prasetya', 'ferdi.prasetya86@gmail.com', 'ac15760e42d34f795122437b62028761d6ad4638dac3f27028900b7e44b27b706aaf8646db5261db541332687e063d32ade1a83e57adbbb5ee8f6e324dfe0c14', 'customer', '3802493114782769', '', '', '', '', '', '', '', '1', '1', '0'),
(26, 'Amarilys illanova', 'amarilysillanova96@gmail.com', '99c314ef09b71365f916ab914671504e0f02cad68a3a883238cf596035278a2c19116fe7b63187188e0582b832e03a4376d7b4affa13298023a1fffc2a5b2096', 'customer', '5336209817478265', '', '', '', '', '', '', '', '1', '1', '0'),
(27, 'Laraswati', 'larasarc14@gmail.com', 'a13ebbe7dbfb480727da8678ec6cdc38a33aefbf740d9ed3c3d0fbc557b61600a0045d424e1451ea4ce4a911bbbffe075ebce876b8a675df11862599fab6e83e', 'customer', '2371924687013554', '', '', '', '', '', '', '', '1', '1', '0'),
(28, 'Amanda', 'Amandahannapermatap@gmail.com', '4ee6b29f1985f61f5e6e89285d2ab83ade046434a26295fe3e2f977e0b2586ea91742296c9a77859cbf2b1ceff048aef12cc1258c8bc13fbcb048e431543e499', 'customer', '3798476691328215', '', '', '', '', '', '', '', '1', '1', '0'),
(29, 'Muhammad raflidar', 'muhraflidar@gmail.com', '344877ba231d6e276d739ff4d4642c0c195a5ba86e255920e6bfb6f5a56a28756873ce50bb8783b07b38b2a516bfa67937dc29cf6390182de3b3f560d7889f86', 'customer', '4734276152093598', '', '', '', '', '', '', '', '1', '1', '0'),
(30, 'femi prestia ', 'femyfrestyaa@gmail.com', '942f5437aa23bb24ec3db635da0fb91c94061d10987448fea24c66e1d0a1324bc5187df9e009f6aaafe157fd79091559b605cb585aeb65fdb4aedde07f8f8f71', 'customer', '4187653715286902', '', '', '', '', '', '', '', '1', '1', '0'),