 --
 
 CREATE TABLE `users` (
+  `id_user` int(11) NOT NULL,
+  `username` varchar(100) NOT NULL,
   `nama` varchar(11) NOT NULL,
   `email` varchar(11) NOT NULL,
   `notelepon` varchar(255) NOT NULL,
-  `username` varchar(255) NOT NULL,
   `password` varchar(255) NOT NULL,
-  `group` tinyint(1) NOT NULL
+  `group` tinyint(1) NOT NULL,
+  `level` enum('admin','member') NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 --
 -- Dumping data for table `users`
 --
 
-INSERT INTO `users` (`nama`, `email`, `notelepon`, `username`, `password`, `group`) VALUES
-('Admin', 'admin@gmail', '12345', 'admin', '12345', 1),
-('andre', 'andre', 'andre', 'andre', 'andre', 0),
-('ayu', 'ayu@gmail.c', '12345', 'ayu', '25f9e794323b453885f5181f1b624d0b', 0),
-('candra', 'aaa@gmail.c', '123456789', 'candra', '25f9e794323b453885f5181f1b624d0b', 0),
-('jtgf', 'jfjgc', 'gcnjgcf', 'cngjf', 'fhj', 0),
-('Made Erna S', 'ernasusanti', '081916544885', 'erna', 'ernaaaa', 0),
-('gfgh', 'ngng', 'hgcngj', 'fjngv', 'hngc', 0),
-('gfsrgf', 'hfdxhf', 'xfhx', 'fxbfh', 'xgv', 0),
-('fdh', 'gdch', 'fvcd', 'gcg', 'gbncf', 0),
-('erna', 'jhjmh', 'jhjmhv', 'jmhvh', 'hv mjhvj', 0),
-('juliandika', 'juuliandika', '12345', 'juli', '12345', 2),
-('juli andika', 'juli', '12345', 'juli_andika', '827ccb0eea8a706c4c34a16891f84e7b', 2),
-('erna', 'jhfv', 'jmhvj', 'mhvjm', 'vjm', 0),
-('wiendu', 'wienduadi04', '082247973051', 'wiendu', 'a1cedb591a45b7348f71c3624ea56375', 0);
+INSERT INTO `users` (`id_user`, `username`, `nama`, `email`, `notelepon`, `password`, `group`, `level`) VALUES
+(1, 'admin', 'Admin', 'admin@gmail', '12345', '827ccb0eea8a706c4c34a16891f84e7b', 1, 'admin'),
+(2, '', 'andre', 'andre', 'andre', 'andre', 0, 'admin'),
+(3, '', 'ayu', 'ayu@gmail.c', '12345', '25f9e794323b453885f5181f1b624d0b', 0, 'admin'),
+(4, '', 'candra', 'aaa@gmail.c', '123456789', '25f9e794323b453885f5181f1b624d0b', 0, 'admin'),
+(5, '', 'jtgf', 'jfjgc', 'gcnjgcf', 'fhj', 0, 'admin'),
+(6, '', 'Made Erna S', 'ernasusanti', '081916544885', 'ernaaaa', 0, 'admin'),
+(7, '', 'gfgh', 'ngng', 'hgcngj', 'hngc', 0, 'admin'),
+(8, '', 'gfsrgf', 'hfdxhf', 'xfhx', 'xgv', 0, 'admin'),
+(9, '', 'fdh', 'gdch', 'fvcd', 'gbncf', 0, 'admin'),
+(10, '', 'erna', 'jhjmh', 'jhjmhv', 'hv mjhvj', 0, 'admin'),
+(11, '', 'juliandika', 'juuliandika', '12345', '12345', 2, 'admin'),
+(12, '', 'juli andika', 'juli', '12345', '827ccb0eea8a706c4c34a16891f84e7b', 2, 'admin'),
+(13, 'member', 'member', '3', '3', '827ccb0eea8a706c4c34a16891f84e7b', 1, 'member'),
+(14, '', 'erna', 'jhfv', 'jmhvj', 'vjm', 0, 'admin'),
+(15, '', 'wiendu', 'wienduadi04', '082247973051', 'a1cedb591a45b7348f71c3624ea56375', 0, 'admin'),
+(16, 'candra', 'candra', 'candra', '', '827ccb0eea8a706c4c34a16891f84e7b', 0, 'member'),
+(17, 'wienduadi', 'wiendu adi', 'wiendu', '123', '827ccb0eea8a706c4c34a16891f84e7b', 0, 'member'),
+(18, 'ernasusanti', 'Erna', 'Erna', '12345', '827ccb0eea8a706c4c34a16891f84e7b', 0, 'member');
 
 --
 -- Indexes for dumped tables

-- AUTO_INCREMENT for table `data`
--
ALTER TABLE `data`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `groups`
--

--

INSERT INTO `project_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('81d8l40e8rfrt5dkum9tmab9v7kdpcbc', '::1', 1495845621, 0x5f5f63695f6c6173745f726567656e65726174657c693a313439353834353632313b6c6f676765645f696e7c733a31323a225375646168204c6f6767696e223b69647c4e3b757365726e616d657c733a353a2261646d696e223b6c6576656c7c733a353a2261646d696e223b),
('ppa2283d9l4kd9gn028nlbc1kp1qen89', '::1', 1495845777, 0x5f5f63695f6c6173745f726567656e65726174657c693a313439353834353632313b6c6f676765645f696e7c733a31323a225375646168204c6f6767696e223b69647c4e3b757365726e616d657c733a353a2261646d696e223b6c6576656c7c733a353a2261646d696e223b),
('ovfd35hvaqnlmeenaj21jvfr5r34nic2', '::1', 1495846158, 0x5f5f63695f6c6173745f726567656e65726174657c693a313439353834363135383b6c6f676765645f696e7c733a31323a225375646168204c6f6767696e223b69647c4e3b757365726e616d657c733a353a2261646d696e223b6c6576656c7c733a353a2261646d696e223b),
('ufua8oiqq3nvi7h68qqkvl0rrm55jpjj', '::1', 1495846231, 0x5f5f63695f6c6173745f726567656e65726174657c693a313439353834363231393b6c6f676765645f696e7c733a31323a225375646168204c6f6767696e223b69647c4e3b757365726e616d657c733a353a2261646d696e223b6c6576656c7c733a353a2261646d696e223b),
('9uvh21t6gna3gk1j2l6avmts4u583i92', '::1', 1495846547, 0x5f5f63695f6c6173745f726567656e65726174657c693a313439353834363534373b6c6f676765645f696e7c733a31323a225375646168204c6f6767696e223b69647c4e3b757365726e616d657c733a363a226d656d626572223b6c6576656c7c733a363a226d656d626572223b),
('cgm9ncioh2bjfn8d1jjh4ud09dkggr3m', '::1', 1495846672, 0x5f5f63695f6c6173745f726567656e65726174657c693a313439353834363534373b6c6f676765645f696e7c733a31323a225375646168204c6f6767696e223b69647c4e3b757365726e616d657c733a353a2261646d696e223b6c6576656c7c733a353a2261646d696e223b),
('jibag4bhrgf78a9qckbu3ftss668i9l4', '::1', 1495846833, 0x5f5f63695f6c6173745f726567656e65726174657c693a313439353834363737373b6c6f676765645f696e7c733a31323a225375646168204c6f6767696e223b69647c4e3b757365726e616d657c733a363a226d656d626572223b6c6576656c7c733a363a226d656d626572223b);

-- --------------------------------------------------------

--
-- Table structure for table `transaksi`
--

CREATE TABLE `transaksi` (
  `id_transaksi` int(100) NOT NULL,
  `id_user` int(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `nama_product` varchar(100) NOT NULL,
  `image` text NOT NULL,
  `Bahan` varchar(100) NOT NULL,
  `Panjang` double NOT NULL,
  `Lebar` double NOT NULL,
  `Jumlah` int(20) NOT NULL,
  `Harga` double NOT NULL,
  `No_Telepon` varchar(50) NOT NULL,
  `Keterangan` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transaksi`
--

INSERT INTO `transaksi` (`id_transaksi`, `id_user`, `username`, `nama_product`, `image`, `Bahan`, `Panjang`, `Lebar`, `Jumlah`, `Harga`, `No_Telepon`, `Keterangan`) VALUES
(9, 16, 'candra', 'Art Paper 2', '180px-Bali_Ca2.png', '', 0, 0, 0, 0, '', ''),
(10, 16, 'candra', 'HVS', '180px-Bali_Ca3.png', 'Flexi China', 2, 2, 2, 60000, '22324243', 'wsdsds'),
(11, 16, 'candra', 'Print Baliho', '180px-Bali_Ta2.png', 'Flexi Korea', 2, 3, 2, 100000, '35343', 'redfdfd'),
(12, 17, 'wienduadi', 'Print Baliho', '180px-Bali_Pa1.png', 'Flexi Korea', 2, 2, 100, 4000000, '1234', 'Antar Jemput'),
(13, 17, 'wienduadi', 'Print Baliho Lagi', '180px-Bali_Ca.jpg', 'Glossy Paper', 2, 2, 12, 720000, '123', 'Antar jemput'),
(14, 1, 'admin', 'Print Baru', '180px-Bali_Ca4.png', 'Glossy Paper', 2, 3, 2, 140000, '123456', 'ree'),
(15, 1, 'admin', 'Print Baru', '180px-Bali_Ca5.png', 'Glossy Paper', 2, 3, 2, 140000, '123456', 'ree'),
(16, 13, 'member', 'wewe', '180px-Bali_Ga.jpg', 'Flexi Korea', 4, 4, 2, 200000, '121324', 'erere');

-- --------------------------------------------------------

