Tutorial codeigniter Part. 1

Saturday, May 22nd, 2021

Berikut adalah contoh tabel dan database yang dipakai dalam video.

CREATE TABLE `arus_kas` (
  `id` int(3) NOT NULL,
  `Nama` varchar(75) NOT NULL,
  `NIM` varchar(15) NOT NULL,
  `Angkatan` varchar(4) NOT NULL,
  `Jurusan` varchar(50) NOT NULL,
  `Pembayaran` int(15) NOT NULL,
  `Jenis` varchar(50) NOT NULL,
  `Waktu` datetime NOT NULL,
  `Metode` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `arus_kas`
--

INSERT INTO `arus_kas` (`id`, `Nama`, `NIM`, `Angkatan`, `Jurusan`, `Pembayaran`, `Jenis`, `Waktu`, `Metode`) VALUES
(4, 'Abc', '987097', '2017', 'Manajemen', 2000000, 'SPP', '2020-11-20 11:21:21', 'ebanking'),
(5, 'asd', '987097', '2019', 'asd', 1000000, 'SPP', '2004-12-20 09:48:38', 'ebanking');

ALTER TABLE `arus_kas`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);


ALTER TABLE `arus_kas`
  MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;