API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2019
429
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 31.63 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.9.0.1
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Oct 22, 2019 at 09:13 AM
  7. -- Server version: 10.3.15-MariaDB
  8. -- PHP Version: 7.3.6
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Database: `siswa_native`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `alumni`
  29. --
  30.  
  31. CREATE TABLE `alumni` (
  32. `nis` varchar(6) NOT NULL,
  33. `nama_alumni` varchar(30) NOT NULL,
  34. `th_lulus` year(4) NOT NULL,
  35. `id_jurusan` tinyint(2) NOT NULL,
  36. `sub_kelas` char(1) NOT NULL,
  37. `id_ortu` int(5) NOT NULL,
  38. `alamat` text NOT NULL
  39. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  40.  
  41. --
  42. -- Dumping data for table `alumni`
  43. --
  44.  
  45. INSERT INTO `alumni` (`nis`, `nama_alumni`, `th_lulus`, `id_jurusan`, `sub_kelas`, `id_ortu`, `alamat`) VALUES
  46. ('12347', 'Baim', 2017, 2, 'A', 2, 'Bantul, Yogyakarta');
  47.  
  48. -- --------------------------------------------------------
  49.  
  50. --
  51. -- Table structure for table `detail_poin`
  52. --
  53.  
  54. CREATE TABLE `detail_poin` (
  55. `id_detail_poin` int(10) NOT NULL,
  56. `tanggal` date NOT NULL,
  57. `tahun_ajaran` char(9) NOT NULL,
  58. `nis` varchar(6) NOT NULL,
  59. `id_pelanggaran` tinyint(3) DEFAULT NULL,
  60. `id_prestasi` tinyint(3) DEFAULT NULL,
  61. `ket` text DEFAULT NULL
  62. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  63.  
  64. --
  65. -- Dumping data for table `detail_poin`
  66. --
  67.  
  68. INSERT INTO `detail_poin` (`id_detail_poin`, `tanggal`, `tahun_ajaran`, `nis`, `id_pelanggaran`, `id_prestasi`, `ket`) VALUES
  69. (1, '2017-11-13', '2016/2017', '16433', 1, NULL, ''),
  70. (2, '2017-11-13', '2016/2017', '16422', 1, NULL, ''),
  71. (3, '2017-11-13', '2016/2017', '16426', 1, NULL, ''),
  72. (4, '2017-11-14', '2016/2017', '16444', 5, NULL, ''),
  73. (6, '2017-11-13', '2016/2017', '16430', 5, NULL, ''),
  74. (7, '2017-11-14', '2016/2017', '16441', 1, NULL, ''),
  75. (8, '2017-11-14', '2016/2017', '12347', NULL, 2, NULL),
  76. (9, '2017-07-05', '2016/2017', '16421', NULL, 6, ''),
  77. (10, '2017-07-05', '2016/2017', '16425', NULL, 6, ''),
  78. (12, '2017-07-05', '2016/2017', '16429', NULL, 6, ''),
  79. (13, '2017-07-05', '2016/2017', '16435', NULL, 6, ''),
  80. (14, '2017-07-05', '2016/2017', '16440', NULL, 6, ''),
  81. (15, '2017-07-05', '2016/2017', '16445', NULL, 6, ''),
  82. (16, '2017-07-05', '2016/2017', '16451', NULL, 6, ''),
  83. (17, '2017-07-05', '2016/2017', '16457', NULL, 6, ''),
  84. (18, '2017-08-20', '2016/2017', '16439', NULL, 4, ''),
  85. (19, '2017-08-20', '2016/2017', '16424', NULL, 4, ''),
  86. (20, '2017-09-21', '2016/2017', '16440', NULL, 2, ''),
  87. (21, '2017-10-14', '2016/2017', '16427', NULL, 3, ''),
  88. (22, '2017-10-14', '2016/2017', '16444', NULL, 3, ''),
  89. (23, '2017-10-14', '2016/2017', '16421', NULL, 3, ''),
  90. (24, '2017-10-19', '2016/2017', '16434', NULL, 12, ''),
  91. (25, '2017-07-05', '2016/2017', '16420', 1, NULL, ''),
  92. (26, '2017-07-05', '2016/2017', '16423', 5, NULL, ''),
  93. (27, '2017-07-14', '2016/2017', '16435', 5, NULL, ''),
  94. (28, '2017-07-21', '2016/2017', '16428', 1, NULL, ''),
  95. (29, '2017-08-08', '2016/2017', '16439', 1, NULL, ''),
  96. (30, '2017-08-10', '2016/2017', '16431', 1, NULL, ''),
  97. (31, '2017-08-23', '2016/2017', '16430', 1, NULL, ''),
  98. (32, '2017-08-24', '2016/2017', '16429', 1, NULL, ''),
  99. (33, '2017-08-12', '2016/2017', '16445', 5, NULL, ''),
  100. (34, '2017-11-09', '2016/2017', '16427', 1, NULL, ''),
  101. (35, '2017-11-10', '2016/2017', '16420', 2, NULL, ''),
  102. (36, '2017-09-05', '2016/2017', '16426', 1, NULL, ''),
  103. (37, '2017-10-14', '2016/2017', '16430', 5, NULL, ''),
  104. (42, '2017-12-05', '2017/2018', '16421', 2, NULL, ''),
  105. (44, '2017-12-11', '2017/2018', '16425', 1, NULL, ''),
  106. (45, '2016-12-01', '2016/2017', '16419', 5, NULL, 'Main Playstation'),
  107. (46, '2016-12-05', '2016/2017', '16419', 5, NULL, 'Main di Alkid'),
  108. (47, '2016-12-08', '2016/2017', '16419', 1, NULL, 'Tidak mendapatkan alat transportasi dari rumah ke kampus'),
  109. (48, '2017-01-17', '2016/2017', '16426', 7, NULL, 'Berbicara keras dan melempar sapu ke teman lainya'),
  110. (49, '2017-01-20', '2016/2017', '16426', 7, NULL, 'Memukul - mukul meja'),
  111. (50, '2017-02-25', '2016/2017', '16421', 1, NULL, 'Ban sepeda motor bagian belakang bocor'),
  112. (51, '2017-02-25', '2016/2017', '16424', 2, NULL, 'Dijual'),
  113. (52, '2017-02-26', '2016/2017', '16423', 8, NULL, 'Malas'),
  114. (53, '2017-03-17', '2016/2017', '16427', 4, NULL, ''),
  115. (54, '2017-04-17', '2016/2017', '16431', 6, NULL, 'Kelaparan'),
  116. (55, '2017-05-17', '2016/2017', '16446', 9, NULL, 'Bosan mengikuti mata pelajaran'),
  117. (56, '2017-05-17', '2016/2017', '16428', 10, NULL, ''),
  118. (57, '2017-06-17', '2016/2017', '16422', 5, NULL, ''),
  119. (58, '2017-07-17', '2017/2018', '16420', NULL, 6, ''),
  120. (59, '2017-08-17', '2017/2018', '16421', NULL, 1, ''),
  121. (60, '2017-09-17', '2017/2018', '16421', NULL, 2, ''),
  122. (61, '2017-09-27', '2017/2018', '16421', NULL, 3, ''),
  123. (62, '2017-10-17', '2016/2017', '16419', NULL, 8, ''),
  124. (63, '2017-10-17', '2016/2017', '16427', NULL, 8, ''),
  125. (64, '2017-10-17', '2017/2018', '16432', NULL, 8, ''),
  126. (65, '2017-10-17', '2017/2018', '16434', NULL, 6, '');
  127.  
  128. -- --------------------------------------------------------
  129.  
  130. --
  131. -- Table structure for table `guru`
  132. --
  133.  
  134. CREATE TABLE `guru` (
  135. `nip` char(18) NOT NULL,
  136. `nama_guru` varchar(30) NOT NULL,
  137. `no_hp` varchar(12) NOT NULL,
  138. `jabatan` varchar(20) DEFAULT NULL
  139. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  140.  
  141. --
  142. -- Dumping data for table `guru`
  143. --
  144.  
  145. INSERT INTO `guru` (`nip`, `nama_guru`, `no_hp`, `jabatan`) VALUES
  146. ('1234', 'Yuliani Enie', '080808080808', ''),
  147. ('123456712345123456', 'Enie Yuliani', '086432178932', ''),
  148. ('123456789100987654', 'Anie', '089765123456', 'Wali Kelas'),
  149. ('123456789101112131', 'Yuliani', '085867628434', 'Wali Kelas'),
  150. ('195003121212121212', 'Jusuf Kalla', '081299999222', 'Wali Kelas'),
  151. ('195602120632179432', 'Drs.Totok Wisnutoro', '085255214895', 'Wali Kelas'),
  152. ('195709282003126532', 'Dra. Sri Eko Handayani Ratnawa', '085867354211', 'Wali Kelas'),
  153. ('195802129001235743', 'Drs.Sriyana', '085292502250', 'Wali kelas'),
  154. ('195807072001021683', 'Dra. Yohana Umiyati', '082109098888', 'Wali Kelas'),
  155. ('195912036217893216', 'Cahyono Agus W.,S.Pd', '087325678419', 'Wali Kelas'),
  156. ('196002112004001643', 'Drs. Supriyono Wibowo', '081354321166', 'Wali Kelas'),
  157. ('196003242001032451', 'Drs.Nugroho Sukowati', '085614895432', 'Wali Kelas'),
  158. ('196012124682345721', 'Niken Tyas Utami, S.Pd', '081209321212', 'Wali Kelas'),
  159. ('196012210953218765', 'Muh.Wardiyanto', '089867813010', 'Wali kelas'),
  160. ('196110061988031004', 'Drs. Agung Widyatmoko, M.Pd', '082109542874', 'Wali Kelas'),
  161. ('196203252100021134', 'Erma Ade Susmonowati, S.Pd', '081256321452', 'Wali Kelas'),
  162. ('196302031988031010', 'Drs.Aragani mizan zakaria,M.pd', '098134378134', 'Wali Kelas'),
  163. ('196601092002345123', 'Budiono', '089876543210', 'Wali Kelas'),
  164. ('196601182008012001', 'Diah Herawati, S.Pd', '082134567213', 'Wali Kelas'),
  165. ('196603042003017690', 'Evi Suryanti, S.Pd', '089822447788', 'Wali Kelas'),
  166. ('197006082004028799', 'Slamet Riyanti, S.Pd', '085867009911', 'Wali Kelas'),
  167. ('197103072006042003', 'Siti Ulfiyatul Hoiriyah, S.Pd', '081256790321', 'Wali Kelas'),
  168. ('197310062001120011', 'Eka Vicianto, S.Pd.T', '08123451234', 'Guru Kesiswaan'),
  169. ('197702098943217654', 'Endang Listyandari, S.Pd', '089854123764', 'Wali Kelas'),
  170. ('197808102006042007', 'Rum Ismawati, S.Si', '085729674321', 'Wali Kelas'),
  171. ('198204262009022004', 'Himawati Widyastuti, M.Si', '081215346789', 'Wali Kelas'),
  172. ('785432190890989096', 'Aragani Mizan Zakaria', '081265789234', 'Kepala Sekolah');
  173.  
  174. -- --------------------------------------------------------
  175.  
  176. --
  177. -- Table structure for table `jurusan`
  178. --
  179.  
  180. CREATE TABLE `jurusan` (
  181. `id_jurusan` tinyint(2) NOT NULL,
  182. `nama_jurusan` varchar(50) NOT NULL
  183. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  184.  
  185. --
  186. -- Dumping data for table `jurusan`
  187. --
  188.  
  189. INSERT INTO `jurusan` (`id_jurusan`, `nama_jurusan`) VALUES
  190. (1, 'Desain Pemodelan dan Informasi Bangunan'),
  191. (2, 'Teknik Konstruksi Gedung, Sanitasi dan Perawatan'),
  192. (3, 'Geologi Pertambangan'),
  193. (4, 'Teknik Sistem Informasi, Jaringan dan Aplikasi'),
  194. (5, 'Teknik Komputer dan Jaringan'),
  195. (6, 'Teknik Audio Video'),
  196. (7, 'Teknik Otomasi Industri'),
  197. (8, 'Teknik Fabrikasi Logam dan Perawatan Otomotif'),
  198. (9, 'Kimia Industri'),
  199. (10, 'Teknik Pengolahan Migas dan Petrokimia'),
  200. (11, 'Kimia Analis'),
  201. (12, 'Teknik Elektronika Daya dan Komunikasi');
  202.  
  203. -- --------------------------------------------------------
  204.  
  205. --
  206. -- Table structure for table `kat_pelanggaran`
  207. --
  208.  
  209. CREATE TABLE `kat_pelanggaran` (
  210. `id_kat_pelanggaran` tinyint(2) NOT NULL,
  211. `nama_kategori` varchar(30) NOT NULL
  212. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  213.  
  214. --
  215. -- Dumping data for table `kat_pelanggaran`
  216. --
  217.  
  218. INSERT INTO `kat_pelanggaran` (`id_kat_pelanggaran`, `nama_kategori`) VALUES
  219. (1, 'Komponen Kelakuan'),
  220. (2, 'Komponen Kerapihan'),
  221. (3, 'Komponen Kerajinan');
  222.  
  223. -- --------------------------------------------------------
  224.  
  225. --
  226. -- Table structure for table `kelas`
  227. --
  228.  
  229. CREATE TABLE `kelas` (
  230. `id_kelas` tinyint(3) NOT NULL,
  231. `id_jurusan` tinyint(2) NOT NULL,
  232. `tingkat_kelas` varchar(4) NOT NULL,
  233. `sub_kelas` char(1) NOT NULL,
  234. `nip` char(18) DEFAULT NULL,
  235. `jml_siswa` tinyint(2) DEFAULT NULL
  236. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  237.  
  238. --
  239. -- Dumping data for table `kelas`
  240. --
  241.  
  242. INSERT INTO `kelas` (`id_kelas`, `id_jurusan`, `tingkat_kelas`, `sub_kelas`, `nip`, `jml_siswa`) VALUES
  243. (1, 1, 'X', 'A', '195802129001235743', 32),
  244. (4, 2, 'XI', 'A', '195912036217893216', 32),
  245. (5, 3, 'X', 'A', '196003242001032451', 32),
  246. (7, 1, 'X', 'B', '195602120632179432', 32),
  247. (8, 2, 'X', 'A', '196012210953218765', 32),
  248. (10, 4, 'X', 'A', '196601182008012001', 32),
  249. (11, 5, 'X', 'A', '197103072006042003', 32),
  250. (12, 6, 'X', 'A', '197702098943217654', 32),
  251. (13, 7, 'X', 'A', '197808102006042007', 32),
  252. (14, 8, 'X', 'A', '198204262009022004', 32),
  253. (15, 3, 'X', 'B', '196012124682345721', 32),
  254. (16, 8, 'X', 'B', '196203252100021134', 32),
  255. (17, 9, 'X', 'A', '195807072001021683', 32),
  256. (18, 10, 'X', 'A', '195709282003126532', 32),
  257. (19, 11, 'X', 'A', '196002112004001643', 32),
  258. (20, 12, 'X', 'A', '196603042003017690', 32),
  259. (21, 2, 'XII', 'A', '196601092002345123', 32),
  260. (24, 2, 'XIII', 'A', '195003121212121212', 32);
  261.  
  262. -- --------------------------------------------------------
  263.  
  264. --
  265. -- Table structure for table `orang_tua`
  266. --
  267.  
  268. CREATE TABLE `orang_tua` (
  269. `id_ortu` int(5) NOT NULL,
  270. `nama_ortu` varchar(30) NOT NULL,
  271. `alamat_ortu` text NOT NULL,
  272. `no_hp` varchar(12) NOT NULL
  273. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  274.  
  275. --
  276. -- Dumping data for table `orang_tua`
  277. --
  278.  
  279. INSERT INTO `orang_tua` (`id_ortu`, `nama_ortu`, `alamat_ortu`, `no_hp`) VALUES
  280. (1, 'Bunga Citra Lestari', 'Yogyakarta', '098764374251'),
  281. (2, 'Krisdayanti', 'Bantul, Yogyakarta', '089999999999'),
  282. (3, 'Chucky', 'Condong Catur, Depok, Sleman, Yogyakarta', '086666666666'),
  283. (4, 'Ridwan Asrori', 'Ngemplak, Sleman Yogyakarta', '083866304002'),
  284. (5, 'HM Aris', 'Grembyangan, Madurejo, Prambanan, Sleman', '0811294783'),
  285. (6, 'Yudha Yumayana', 'Giwangan, Yogyakarta', '085647021807'),
  286. (7, 'Wachid Cahyadi', 'Kramen, Sidoagung, Godean, Sleman, Yogyakarta', '087835312932'),
  287. (8, 'Rahmat Hakim', 'Tumut, Sumbersari, Moyudan, Sleman', '08564021804'),
  288. (9, 'Ridwan', 'Balong, Umbulharjo, Cangkringan, Sleman', '085728000422'),
  289. (10, 'Aris Joko Saraswo', 'Jl. Raya Condet No. 55 Kec. Pasar Rebo, Jakarta Timur', '085728054444'),
  290. (11, 'Bambang', 'Perumahan Griya Kencan Permai, Argorejo, Sedayu, Bantul\r\n', ''),
  291. (12, 'Anton Tedda', 'Karanggayam, Sitimulyo, Piyungan, Bantul, Yogyakarta', '081567629043'),
  292. (13, 'Herry Wicaksono', 'Perum Jambusari Indah, Wedomartani, Ngemplak, Sleman, Yogyakarta', '081393937071'),
  293. (14, 'Ratno hermawan', 'Buyutan, Banyurejo, Tempel, Sleman', '085229624162'),
  294. (15, 'Makmur Amin', 'Banyon, Pendowoharjo, Sewo, Bantul', '085642353664'),
  295. (16, 'Michael Christianto', 'Pugeran, Maguwoharjo, Depok, Sleman', '081225927888'),
  296. (17, 'Arief Rahman', 'Sawungsari, Hargobinangun, Pakem', '081548515774'),
  297. (18, 'Basworo Dibyo', 'Candirejo, Sardonoharjo, Ngaglik, Sleman', '081393365787'),
  298. (19, 'Dodiek Hari', 'Kaliurang Barat, Hargobinangun, Pakem', '081288046553'),
  299. (20, 'N Wicaksono KP', 'Gorongan No. 153, Condong Catur, Depok, Sleman', '085643870947'),
  300. (21, 'Randy', 'Juragan, Sidoluhur, Godean, Sleman', '08156704040'),
  301. (22, 'S. Budi Santoso', 'Jowah, Sidoluhur, Godean, Sleman', '0811327546'),
  302. (23, 'Hadi Sumarsono', 'Perum Bukit Permata, Candi Gebang, Sleman', '081218765349'),
  303. (24, 'Teguh Sumampaw', 'Plemburan, Sariharjo, Ngaglik, Sleman', '08122638778'),
  304. (25, 'Riszki Gunawan', 'Pakisaji, Candibinangun, Pakem', '08812960156'),
  305. (26, 'Rian Sofyan', 'Prokerten, Trimurti, Srandakan, Bantul', '081393358287'),
  306. (27, 'Ali Wijaya', 'Gatak, Sidoluhur, Godean, Sleman', '08122588007'),
  307. (28, 'Satromo', 'Jurugan, Bangunkerto, Turi, Sleman', '085281961396'),
  308. (29, 'Wakik', 'Dadapan Pinggir, Sidomulyo, Bambanglipuro, Bantul', '085281961396'),
  309. (30, 'Anyari', 'Kwangen, Argomulyo, Cangkringan, Sleman', '085281961396'),
  310. (31, 'Abu Hasan', 'Sembego, Depok, Sleman, Yogyakarta', '085235950990'),
  311. (32, 'Isbandi', 'Jl. Swelobumi No. 03 Pringgolayan, Dabag, Condongcatur, Depok, Sleman', '082331983841'),
  312. (33, 'Abdus Salam', 'Ngentak, Umbulharjo, Ngemplak, Sleman', '082234422140'),
  313. (34, 'Jumali', 'Sambilegi Baru, Maguwoharjo, Depok, Sleman', '085257592582'),
  314. (35, 'Kusnadi', 'Banteng, Hargobinangun, Pakem, Sleman', '085281961396'),
  315. (36, 'Didit', 'Payangan Utara, Girirejo, Imogri, Bantul', '085281961396'),
  316. (37, 'Untung', 'Pugeran, Maguwoharjo, Depok, Sleman', '085281961396'),
  317. (38, 'Junaidi', 'Karanglo, Purwomartani, Kalasan, Sleman', '085281961396'),
  318. (39, 'Amas Yunus', 'Krapyak, Wedomartani, Ngemplak, Sleman', '08154701609'),
  319. (40, 'Eddy Machmud', 'Perum Lojajar Indah, Ngaglik, Sleman', '08123942158'),
  320. (41, 'Riza Falepi', 'Jl. Teratai, Perum Concat, Sleman', '0811888039'),
  321. (42, 'Bubun Budiawan', 'Kradenan, Girirejo, Imogiri, Bantul', '081321117604'),
  322. (43, 'Haris Mulyana', 'Jl. Nogomudo No. 293, Gowok, Depok, Sleman', '081221495162'),
  323. (44, 'Slamet Riyadi', 'Tegalngijon, Sumberagung, Moyudan, Sleman', '081321929302');
  324.  
  325. -- --------------------------------------------------------
  326.  
  327. --
  328. -- Table structure for table `pelanggaran`
  329. --
  330.  
  331. CREATE TABLE `pelanggaran` (
  332. `id_pelanggaran` tinyint(3) NOT NULL,
  333. `nama_pelanggaran` varchar(150) NOT NULL,
  334. `id_sub_kategori` tinyint(2) NOT NULL,
  335. `poin` tinyint(3) NOT NULL
  336. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  337.  
  338. --
  339. -- Dumping data for table `pelanggaran`
  340. --
  341.  
  342. INSERT INTO `pelanggaran` (`id_pelanggaran`, `nama_pelanggaran`, `id_sub_kategori`, `poin`) VALUES
  343. (1, 'Terlambat hadir di sekolah / keg.PBM lebih dari 5 menit', 1, 2),
  344. (2, 'Tidak membawa buku paket/pelajaran', 1, 5),
  345. (3, 'TIdak mengerjakan tugas sesuai dengan batas waktu yang ditentukan', 1, 7),
  346. (4, 'Mencontek/ menconteki', 1, 10),
  347. (5, 'Keluar kampus tanpa ijin guru/ karyawan (membolos)', 1, 10),
  348. (6, 'Makan/ minum/ tidur saat PBM tanpa ijin guru/ karyawan', 1, 10),
  349. (7, 'Membuat gaduh di kelas', 1, 10),
  350. (8, 'Tidak mengikuti ekstrakurikuler wajib di sekolah', 1, 10),
  351. (9, 'Menggunakan media player dan atau alat komunikasi saat PBM', 1, 20),
  352. (10, 'Membawa/ meminjamkan alat selain yang menunjang PBM', 1, 20),
  353. (11, 'Tidak mengikuti kegiatan keagamaan tanpa keterangan', 1, 20),
  354. (12, 'Tidak mengikuti upacara bendera', 1, 10),
  355. (13, 'Menggunakan Narkoba', 5, 127),
  356. (16, 'berkata -kata tidak sopan', 2, 50);
  357.  
  358. -- --------------------------------------------------------
  359.  
  360. --
  361. -- Table structure for table `prestasi`
  362. --
  363.  
  364. CREATE TABLE `prestasi` (
  365. `id_prestasi` tinyint(3) NOT NULL,
  366. `nama_prestasi` varchar(100) NOT NULL,
  367. `poin` smallint(3) NOT NULL
  368. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  369.  
  370. --
  371. -- Dumping data for table `prestasi`
  372. --
  373.  
  374. INSERT INTO `prestasi` (`id_prestasi`, `nama_prestasi`, `poin`) VALUES
  375. (1, 'Juara lomba tingkat Nasional', 150),
  376. (2, 'Juara lomba tingkat Provinsi', 100),
  377. (3, 'Juara lomba tingkat Kabupaten/Kota', 50),
  378. (4, 'Juara lomba tingkat Kecamatan', 25),
  379. (5, 'Juara lomba tingkat Sekolah', 20),
  380. (6, 'Peringkat 1-3 di kelas', 20),
  381. (7, 'Pengurus aktif OSIS/PK/Pramuka per tahun', 10),
  382. (8, 'Pengurus aktif kelas per tahun', 5),
  383. (9, 'Pengurus aktif organisasi kemasyarakatan', 5),
  384. (10, 'Menjadi panitia kegiatan sekolah', 4),
  385. (11, 'Mengikuti lomba sebagai wakil sekolah', 3),
  386. (12, 'Mendapat nilai tertinggi ulangan harian', 2);
  387.  
  388. -- --------------------------------------------------------
  389.  
  390. --
  391. -- Table structure for table `siswa`
  392. --
  393.  
  394. CREATE TABLE `siswa` (
  395. `nis` varchar(6) NOT NULL,
  396. `nama_siswa` varchar(30) NOT NULL,
  397. `th_angkatan` year(4) NOT NULL,
  398. `alamat` text NOT NULL,
  399. `id_kelas` tinyint(3) NOT NULL,
  400. `id_ortu` int(5) NOT NULL
  401. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  402.  
  403. --
  404. -- Dumping data for table `siswa`
  405. --
  406.  
  407. INSERT INTO `siswa` (`nis`, `nama_siswa`, `th_angkatan`, `alamat`, `id_kelas`, `id_ortu`) VALUES
  408. ('12345', 'enie', 2014, 'Panjen Maguwoharjo Depok Sleman Yogyakarta', 1, 1),
  409. ('16419', 'Ahmad Umar Said', 2014, 'Grembyangan, Madurejo, Prambanan, Sleman', 1, 4),
  410. ('16420', 'Anggun Septin Kartika Wulan', 2016, 'Giwangan, Yogyakarta', 1, 5),
  411. ('16421', 'Annisah Nur Hidayati', 2016, 'Kramen, Sidoagung, Godean, Sleman, Yogyakarta', 1, 6),
  412. ('16422', 'Arif Dwi Susanto', 2016, 'Tumut, Sumbersari, Moyudan, Sleman', 1, 7),
  413. ('16423', 'Ariyani Putri Pertiwi', 2016, 'Balong, Umbulharjo, Cangkringan, Sleman', 1, 8),
  414. ('16424', 'Asep Cahya Bangkit Kuswandi', 2016, 'Jl. Raya Condet No. 55 Kec. Pasar Rebo, Jakarta Timur', 5, 9),
  415. ('16425', 'Avido Tinandhia', 2016, 'Perumahan Griya Kencan Permai, Argorejo, Sedayu, Bantul', 5, 10),
  416. ('16426', 'Bayu Wijayanto', 2016, 'Karanggayam, Sitimulyo, Piyungan, Bantul, Yogyakarta', 5, 11),
  417. ('16427', 'Benedictus Donny Mahardika', 2016, 'Perum Jambusari Indah, Wedomartani, Ngemplak, Sleman, Yogyakarta', 5, 12),
  418. ('16428', 'Cahyo Budi Utomo', 2016, 'Buyutan, Banyurejo, Tempel, Sleman', 5, 13),
  419. ('16429', 'Daru Pahlevi', 2016, 'Banyon, Pendowoharjo, Sewo, Bantul', 7, 14),
  420. ('16430', 'Deni Setiyawan', 2016, 'Pugeran, Maguwoharjo, Depok, Sleman', 7, 15),
  421. ('16431', 'Ditto Krisna Aji', 2016, 'Sawungsari, Hargobinangun, Pakem', 7, 16),
  422. ('16432', 'Fathul Husni', 2016, 'Candirejo, Sardonoharjo, Ngaglik, Sleman', 7, 17),
  423. ('16433', 'Ferdian Nur Rizky', 2016, 'Kaliurang Barat, Hargobinangun, Pakem', 7, 18),
  424. ('16434', 'Fitri Hera Nurviandini', 2016, 'Gorongan No. 153, Condong Catur, Depok, Sleman', 24, 19),
  425. ('16435', 'Galih Rizal Basroni', 2016, 'Juragan, Sidoluhur, Godean, Sleman', 24, 20),
  426. ('16436', 'Gigih Nur Pratomo', 2016, 'Jowah, Sidoluhur, Godean, Sleman', 24, 21),
  427. ('16437', 'Gilang Risky Fauzi Putra', 2016, 'Perum Bukit Permata, Candi Gebang, Sleman', 24, 22),
  428. ('16438', 'Harmanto', 2016, 'Plemburan, Sariharjo, Ngaglik, Sleman', 24, 23),
  429. ('16439', 'Heri Gusmiyanto', 2016, 'Pakisaji, Candibinangun, Pakem', 10, 24),
  430. ('16440', 'Isna Wahyuntari', 2016, 'Prokerten, Trimurti, Srandakan, Bantul', 10, 25),
  431. ('16441', 'Kruis Mila Mimi Sabdani', 2016, 'Gatak, Sidoluhur, Godean, Sleman', 10, 26),
  432. ('16442', 'Adrian Dwiki Yudha', 2016, 'Jurugan, Bangunkerto, Turi, Sleman', 10, 27),
  433. ('16443', 'Bristia Prabowo', 2016, 'Dadapan Pinggir, Sidomulyo, Bambanglipuro, Bantul', 10, 28),
  434. ('16444', 'Dewangga Adila Nugraha', 2016, 'Kwangen, Argomulyo, Cangkringan, Sleman', 11, 29),
  435. ('16445', 'Eko Puji Lestari', 2016, 'Sembego, Depok, Sleman, Yogyakarta', 11, 30),
  436. ('16446', 'Iin Mutaqima', 2016, 'Jl. Swelobumi No. 03 Pringgolayan, Dabag, Condongcatur, Depok, Sleman', 11, 31),
  437. ('16447', 'Ahmad Habibi', 2016, 'Ngentak, Umbulharjo, Ngemplak, Sleman', 11, 32),
  438. ('16448', 'Heri Purnama', 2016, 'Sambilegi Baru, Maguwoharjo, Depok, Sleman', 11, 33),
  439. ('16449', 'Lukito Njono Putro', 2016, 'Banteng, Hargobinangun, Pakem, Sleman', 12, 34),
  440. ('16450', 'Nia Suparniatun', 2016, 'Payangan Utara, Girirejo, Imogri, Bantul', 12, 35),
  441. ('16451', 'Muhammad Yusuf', 2016, 'Pugeran, Maguwoharjo, Depok, Sleman', 12, 36),
  442. ('16452', 'Yoga Arif Santosa', 2016, 'Karanglo, Purwomartani, Kalasan, Sleman', 12, 37),
  443. ('16453', 'Tazkiyatun Nihayah', 2016, 'Krapyak, Wedomartani, Ngemplak, Sleman', 12, 38),
  444. ('16454', 'Zahir Elfares Wasim', 2016, 'Perum Lojajar Indah, Ngaglik, Sleman', 13, 39),
  445. ('16455', 'Mariana Febri Tri Kusdiarti', 2016, 'Jl. Teratai, Perum Concat, Sleman', 13, 40),
  446. ('16456', 'Tri Wahyuni Nursiyami', 2016, 'Kradenan, Girirejo, Imogiri, Bantul', 13, 41),
  447. ('16457', 'Rika Indriati', 2016, 'Jl. Nogomudo No. 293, Gowok, Depok, Sleman', 13, 42),
  448. ('16458', 'Noorshin Tri', 2016, 'Tegalngijon, Sumberagung, Moyudan, Sleman', 13, 43),
  449. ('16557', 'andika pradianto', 2015, 'timoho', 20, 23);
  450.  
  451. -- --------------------------------------------------------
  452.  
  453. --
  454. -- Table structure for table `siswa_do`
  455. --
  456.  
  457. CREATE TABLE `siswa_do` (
  458. `nis` varchar(6) NOT NULL,
  459. `nama` varchar(30) NOT NULL,
  460. `th_keluar` year(4) NOT NULL,
  461. `id_jurusan` tinyint(2) NOT NULL
  462. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  463.  
  464. --
  465. -- Dumping data for table `siswa_do`
  466. --
  467.  
  468. INSERT INTO `siswa_do` (`nis`, `nama`, `th_keluar`, `id_jurusan`) VALUES
  469. ('12348', 'Thinkerbell', 2017, 1);
  470.  
  471. -- --------------------------------------------------------
  472.  
  473. --
  474. -- Table structure for table `sub_kat_pelanggaran`
  475. --
  476.  
  477. CREATE TABLE `sub_kat_pelanggaran` (
  478. `id_sub_kategori` tinyint(2) NOT NULL,
  479. `nama_sub_kategori` varchar(100) NOT NULL,
  480. `id_kat_pelanggaran` tinyint(2) NOT NULL
  481. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  482.  
  483. --
  484. -- Dumping data for table `sub_kat_pelanggaran`
  485. --
  486.  
  487. INSERT INTO `sub_kat_pelanggaran` (`id_sub_kategori`, `nama_sub_kategori`, `id_kat_pelanggaran`) VALUES
  488. (1, 'Belajar Mengajar', 1),
  489. (2, 'Penghinaan', 1),
  490. (3, 'Sarana Prasarana', 1),
  491. (4, 'Memakai Perhiasan', 1),
  492. (5, 'Rokok/ Miras/ Narkoba/ Petasan/ Pornografi', 1),
  493. (6, 'Pemalsuan/ Pencurian/ Zina/ Pemerasan/ Perjudian/ Kesopanan/ Penyelewengan/ Geng', 1),
  494. (7, 'Rambut', 2),
  495. (8, 'Pakaian', 2),
  496. (9, 'Kehadiran', 3);
  497.  
  498. -- --------------------------------------------------------
  499.  
  500. --
  501. -- Table structure for table `temp_rapat`
  502. --
  503.  
  504. CREATE TABLE `temp_rapat` (
  505. `id_temp_rapat` int(12) NOT NULL,
  506. `nis` varchar(6) NOT NULL,
  507. `jml_poin_pelanggaran` smallint(3) NOT NULL,
  508. `lihat` char(1) NOT NULL
  509. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  510.  
  511. -- --------------------------------------------------------
  512.  
  513. --
  514. -- Table structure for table `temp_sp_1`
  515. --
  516.  
  517. CREATE TABLE `temp_sp_1` (
  518. `id_temp_sp_1` int(12) NOT NULL,
  519. `nis` varchar(6) NOT NULL,
  520. `jml_poin_pelanggaran` smallint(3) NOT NULL,
  521. `lihat` char(1) NOT NULL
  522. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  523.  
  524. --
  525. -- Dumping data for table `temp_sp_1`
  526. --
  527.  
  528. INSERT INTO `temp_sp_1` (`id_temp_sp_1`, `nis`, `jml_poin_pelanggaran`, `lihat`) VALUES
  529. (1, '16430', 22, 'Y');
  530.  
  531. -- --------------------------------------------------------
  532.  
  533. --
  534. -- Table structure for table `temp_sp_2`
  535. --
  536.  
  537. CREATE TABLE `temp_sp_2` (
  538. `id_temp_sp_2` int(12) NOT NULL,
  539. `nis` varchar(6) NOT NULL,
  540. `jml_poin_pelanggaran` smallint(3) NOT NULL,
  541. `lihat` char(1) NOT NULL
  542. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  543.  
  544. -- --------------------------------------------------------
  545.  
  546. --
  547. -- Table structure for table `temp_sp_3`
  548. --
  549.  
  550. CREATE TABLE `temp_sp_3` (
  551. `id_temp_sp_3` int(12) NOT NULL,
  552. `nis` varchar(6) NOT NULL,
  553. `jml_poin_pelanggaran` smallint(3) NOT NULL,
  554. `lihat` char(1) NOT NULL
  555. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  556.  
  557. -- --------------------------------------------------------
  558.  
  559. --
  560. -- Table structure for table `th_ajaran`
  561. --
  562.  
  563. CREATE TABLE `th_ajaran` (
  564. `id_th_ajaran` mediumint(5) NOT NULL,
  565. `tahun_ajaran` char(9) NOT NULL,
  566. `sekarang` char(1) NOT NULL
  567. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  568.  
  569. --
  570. -- Dumping data for table `th_ajaran`
  571. --
  572.  
  573. INSERT INTO `th_ajaran` (`id_th_ajaran`, `tahun_ajaran`, `sekarang`) VALUES
  574. (1, '2016/2017', 'N'),
  575. (2, '2017/2018', 'Y');
  576.  
  577. -- --------------------------------------------------------
  578.  
  579. --
  580. -- Table structure for table `tindakan`
  581. --
  582.  
  583. CREATE TABLE `tindakan` (
  584. `id_tindakan` tinyint(3) NOT NULL,
  585. `nama_tindakan` varchar(30) NOT NULL,
  586. `ketentuan` varchar(100) NOT NULL
  587. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  588.  
  589. --
  590. -- Dumping data for table `tindakan`
  591. --
  592.  
  593. INSERT INTO `tindakan` (`id_tindakan`, `nama_tindakan`, `ketentuan`) VALUES
  594. (1, 'SP 1', 'Jumlah poin pelanggaran lebih dari 35 dan kurang dari 50');
  595.  
  596. -- --------------------------------------------------------
  597.  
  598. --
  599. -- Table structure for table `user`
  600. --
  601.  
  602. CREATE TABLE `user` (
  603. `id_login` int(5) NOT NULL,
  604. `username` varchar(15) NOT NULL,
  605. `password` text NOT NULL,
  606. `nip` char(18) DEFAULT NULL,
  607. `nis` varchar(6) DEFAULT NULL,
  608. `id_ortu` int(5) DEFAULT NULL,
  609. `hak_akses` tinyint(1) NOT NULL
  610. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  611.  
  612. --
  613. -- Dumping data for table `user`
  614. --
  615.  
  616. INSERT INTO `user` (`id_login`, `username`, `password`, `nip`, `nis`, `id_ortu`, `hak_akses`) VALUES
  617. (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '', '12345', 0, 1),
  618. (3, 'yuliani', 'dcf52f84dbf511ee4a0abcfc18093ee4', '123456789101112131', '', 0, 3),
  619. (8, 'kesiswaan', 'accc7841ce41b0f788a737bf9798ea4f', '123456712345123456', '', 0, 2),
  620. (9, 'kepsek', '8561863b55faf85b9ad67c52b3b851ac', '196302031988031010', '', 0, 4),
  621. (10, 'deni', '469eb28221c8e6d092ddafacb87799bf', '', '', 0, 5),
  622. (11, 'walikelas', 'dcf52f84dbf511ee4a0abcfc18093ee4', '196012124682345721', '', 0, 3),
  623. (12, 'rumisma', '8b96c1db10e701d69a6f0b58d7cf2bee', '197808102006042007', '', 0, 3),
  624. (13, 'sriyana', 'dcf52f84dbf511ee4a0abcfc18093ee4', '195802129001235743', '', 0, 3);
  625.  
  626. --
  627. -- Indexes for dumped tables
  628. --
  629.  
  630. --
  631. -- Indexes for table `alumni`
  632. --
  633. ALTER TABLE `alumni`
  634. ADD PRIMARY KEY (`nis`),
  635. ADD KEY `id_jurusan` (`id_jurusan`),
  636. ADD KEY `id_ortu` (`id_ortu`);
  637.  
  638. --
  639. -- Indexes for table `detail_poin`
  640. --
  641. ALTER TABLE `detail_poin`
  642. ADD PRIMARY KEY (`id_detail_poin`),
  643. ADD KEY `nis` (`nis`),
  644. ADD KEY `id_pelanggaran` (`id_pelanggaran`),
  645. ADD KEY `id_prestasi` (`id_prestasi`),
  646. ADD KEY `tahun_ajaran` (`tahun_ajaran`);
  647.  
  648. --
  649. -- Indexes for table `guru`
  650. --
  651. ALTER TABLE `guru`
  652. ADD PRIMARY KEY (`nip`);
  653.  
  654. --
  655. -- Indexes for table `jurusan`
  656. --
  657. ALTER TABLE `jurusan`
  658. ADD PRIMARY KEY (`id_jurusan`);
  659.  
  660. --
  661. -- Indexes for table `kat_pelanggaran`
  662. --
  663. ALTER TABLE `kat_pelanggaran`
  664. ADD PRIMARY KEY (`id_kat_pelanggaran`);
  665.  
  666. --
  667. -- Indexes for table `kelas`
  668. --
  669. ALTER TABLE `kelas`
  670. ADD PRIMARY KEY (`id_kelas`),
  671. ADD KEY `id_jurusan` (`id_jurusan`),
  672. ADD KEY `nip` (`nip`);
  673.  
  674. --
  675. -- Indexes for table `orang_tua`
  676. --
  677. ALTER TABLE `orang_tua`
  678. ADD PRIMARY KEY (`id_ortu`);
  679.  
  680. --
  681. -- Indexes for table `pelanggaran`
  682. --
  683. ALTER TABLE `pelanggaran`
  684. ADD PRIMARY KEY (`id_pelanggaran`),
  685. ADD KEY `id_kat_pelanggaran` (`id_sub_kategori`);
  686.  
  687. --
  688. -- Indexes for table `prestasi`
  689. --
  690. ALTER TABLE `prestasi`
  691. ADD PRIMARY KEY (`id_prestasi`);
  692.  
  693. --
  694. -- Indexes for table `siswa`
  695. --
  696. ALTER TABLE `siswa`
  697. ADD PRIMARY KEY (`nis`),
  698. ADD KEY `id_ortu` (`id_ortu`),
  699. ADD KEY `id_kelas` (`id_kelas`);
  700.  
  701. --
  702. -- Indexes for table `siswa_do`
  703. --
  704. ALTER TABLE `siswa_do`
  705. ADD PRIMARY KEY (`nis`);
  706.  
  707. --
  708. -- Indexes for table `sub_kat_pelanggaran`
  709. --
  710. ALTER TABLE `sub_kat_pelanggaran`
  711. ADD PRIMARY KEY (`id_sub_kategori`),
  712. ADD KEY `id_kat_pelanggaran` (`id_kat_pelanggaran`);
  713.  
  714. --
  715. -- Indexes for table `temp_rapat`
  716. --
  717. ALTER TABLE `temp_rapat`
  718. ADD PRIMARY KEY (`id_temp_rapat`);
  719.  
  720. --
  721. -- Indexes for table `temp_sp_1`
  722. --
  723. ALTER TABLE `temp_sp_1`
  724. ADD PRIMARY KEY (`id_temp_sp_1`);
  725.  
  726. --
  727. -- Indexes for table `temp_sp_2`
  728. --
  729. ALTER TABLE `temp_sp_2`
  730. ADD PRIMARY KEY (`id_temp_sp_2`);
  731.  
  732. --
  733. -- Indexes for table `temp_sp_3`
  734. --
  735. ALTER TABLE `temp_sp_3`
  736. ADD PRIMARY KEY (`id_temp_sp_3`);
  737.  
  738. --
  739. -- Indexes for table `th_ajaran`
  740. --
  741. ALTER TABLE `th_ajaran`
  742. ADD PRIMARY KEY (`id_th_ajaran`),
  743. ADD UNIQUE KEY `tahun_ajaran` (`tahun_ajaran`);
  744.  
  745. --
  746. -- Indexes for table `tindakan`
  747. --
  748. ALTER TABLE `tindakan`
  749. ADD PRIMARY KEY (`id_tindakan`);
  750.  
  751. --
  752. -- Indexes for table `user`
  753. --
  754. ALTER TABLE `user`
  755. ADD PRIMARY KEY (`id_login`),
  756. ADD KEY `nip` (`nip`),
  757. ADD KEY `nis` (`nis`),
  758. ADD KEY `id_ortu` (`id_ortu`);
  759.  
  760. --
  761. -- AUTO_INCREMENT for dumped tables
  762. --
  763.  
  764. --
  765. -- AUTO_INCREMENT for table `detail_poin`
  766. --
  767. ALTER TABLE `detail_poin`
  768. MODIFY `id_detail_poin` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;
  769.  
  770. --
  771. -- AUTO_INCREMENT for table `jurusan`
  772. --
  773. ALTER TABLE `jurusan`
  774. MODIFY `id_jurusan` tinyint(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  775.  
  776. --
  777. -- AUTO_INCREMENT for table `kat_pelanggaran`
  778. --
  779. ALTER TABLE `kat_pelanggaran`
  780. MODIFY `id_kat_pelanggaran` tinyint(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  781.  
  782. --
  783. -- AUTO_INCREMENT for table `kelas`
  784. --
  785. ALTER TABLE `kelas`
  786. MODIFY `id_kelas` tinyint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
  787.  
  788. --
  789. -- AUTO_INCREMENT for table `orang_tua`
  790. --
  791. ALTER TABLE `orang_tua`
  792. MODIFY `id_ortu` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;
  793.  
  794. --
  795. -- AUTO_INCREMENT for table `pelanggaran`
  796. --
  797. ALTER TABLE `pelanggaran`
  798. MODIFY `id_pelanggaran` tinyint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
  799.  
  800. --
  801. -- AUTO_INCREMENT for table `prestasi`
  802. --
  803. ALTER TABLE `prestasi`
  804. MODIFY `id_prestasi` tinyint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  805.  
  806. --
  807. -- AUTO_INCREMENT for table `sub_kat_pelanggaran`
  808. --
  809. ALTER TABLE `sub_kat_pelanggaran`
  810. MODIFY `id_sub_kategori` tinyint(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  811.  
  812. --
  813. -- AUTO_INCREMENT for table `temp_rapat`
  814. --
  815. ALTER TABLE `temp_rapat`
  816. MODIFY `id_temp_rapat` int(12) NOT NULL AUTO_INCREMENT;
  817.  
  818. --
  819. -- AUTO_INCREMENT for table `temp_sp_1`
  820. --
  821. ALTER TABLE `temp_sp_1`
  822. MODIFY `id_temp_sp_1` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  823.  
  824. --
  825. -- AUTO_INCREMENT for table `temp_sp_2`
  826. --
  827. ALTER TABLE `temp_sp_2`
  828. MODIFY `id_temp_sp_2` int(12) NOT NULL AUTO_INCREMENT;
  829.  
  830. --
  831. -- AUTO_INCREMENT for table `temp_sp_3`
  832. --
  833. ALTER TABLE `temp_sp_3`
  834. MODIFY `id_temp_sp_3` int(12) NOT NULL AUTO_INCREMENT;
  835.  
  836. --
  837. -- AUTO_INCREMENT for table `th_ajaran`
  838. --
  839. ALTER TABLE `th_ajaran`
  840. MODIFY `id_th_ajaran` mediumint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  841.  
  842. --
  843. -- AUTO_INCREMENT for table `tindakan`
  844. --
  845. ALTER TABLE `tindakan`
  846. MODIFY `id_tindakan` tinyint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  847.  
  848. --
  849. -- AUTO_INCREMENT for table `user`
  850. --
  851. ALTER TABLE `user`
  852. MODIFY `id_login` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  853.  
  854. --
  855. -- Constraints for dumped tables
  856. --
  857.  
  858. --
  859. -- Constraints for table `alumni`
  860. --
  861. ALTER TABLE `alumni`
  862. ADD CONSTRAINT `alumni_ibfk_1` FOREIGN KEY (`id_jurusan`) REFERENCES `jurusan` (`id_jurusan`),
  863. ADD CONSTRAINT `alumni_ibfk_2` FOREIGN KEY (`id_ortu`) REFERENCES `orang_tua` (`id_ortu`);
  864.  
  865. --
  866. -- Constraints for table `kelas`
  867. --
  868. ALTER TABLE `kelas`
  869. ADD CONSTRAINT `kelas_ibfk_1` FOREIGN KEY (`id_jurusan`) REFERENCES `jurusan` (`id_jurusan`),
  870. ADD CONSTRAINT `kelas_ibfk_2` FOREIGN KEY (`nip`) REFERENCES `guru` (`nip`);
  871.  
  872. --
  873. -- Constraints for table `pelanggaran`
  874. --
  875. ALTER TABLE `pelanggaran`
  876. ADD CONSTRAINT `pelanggaran_ibfk_1` FOREIGN KEY (`id_sub_kategori`) REFERENCES `sub_kat_pelanggaran` (`id_sub_kategori`);
  877.  
  878. --
  879. -- Constraints for table `siswa`
  880. --
  881. ALTER TABLE `siswa`
  882. ADD CONSTRAINT `siswa_ibfk_1` FOREIGN KEY (`id_kelas`) REFERENCES `kelas` (`id_kelas`),
  883. ADD CONSTRAINT `siswa_ibfk_2` FOREIGN KEY (`id_ortu`) REFERENCES `orang_tua` (`id_ortu`);
  884.  
  885. --
  886. -- Constraints for table `sub_kat_pelanggaran`
  887. --
  888. ALTER TABLE `sub_kat_pelanggaran`
  889. ADD CONSTRAINT `sub_kat_pelanggaran_ibfk_1` FOREIGN KEY (`id_kat_pelanggaran`) REFERENCES `kat_pelanggaran` (`id_kat_pelanggaran`);
  890. COMMIT;
  891.  
  892. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  893. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  894. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!