|
Server IP : 103.11.96.170 / Your IP : 18.218.245.163 Web Server : Microsoft-IIS/10.0 System : Windows NT WIN-F6SLGVICLOP 10.0 build 17763 (Windows Server 2016) AMD64 User : elibrary.unsap.ac.id ( 0) PHP Version : 7.4.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF Directory (0777) : D:/localhost/elibrary/../surat-fti/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 5.7.33 - MySQL Community Server (GPL) -- Server OS: Win64 -- HeidiSQL Version: 11.3.0.6295 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!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 */; -- Dumping database structure for unsap_fti_aset CREATE DATABASE IF NOT EXISTS `unsap_fti_aset` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `unsap_fti_aset`; -- Dumping structure for table unsap_fti_aset.tb_aplikasi CREATE TABLE IF NOT EXISTS `tb_aplikasi` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nama` varchar(256) NOT NULL, `telp` varchar(16) NOT NULL, `email` varchar(256) NOT NULL, `alamat` text NOT NULL, `logo` varchar(128) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- Dumping data for table unsap_fti_aset.tb_aplikasi: ~1 rows (approximately) /*!40000 ALTER TABLE `tb_aplikasi` DISABLE KEYS */; REPLACE INTO `tb_aplikasi` (`id`, `nama`, `telp`, `email`, `alamat`, `logo`) VALUES (1, 'ASET FTI', '0000', 'fti@unsap.ac.id', 'Jl.Angkrek Situ No.19', 'Logo-1692792860.png'); /*!40000 ALTER TABLE `tb_aplikasi` ENABLE KEYS */; -- Dumping structure for table unsap_fti_aset.tb_barang CREATE TABLE IF NOT EXISTS `tb_barang` ( `id` int(11) NOT NULL AUTO_INCREMENT, `id_ruang` int(11) NOT NULL, `nama_barang` varchar(250) NOT NULL, `merk` varchar(50) NOT NULL, `tanggal` date NOT NULL, `keadaan` varchar(125) NOT NULL, `harga` varchar(50) NOT NULL, `gambar` varchar(150) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=300 DEFAULT CHARSET=utf8mb4; -- Dumping data for table unsap_fti_aset.tb_barang: ~282 rows (approximately) /*!40000 ALTER TABLE `tb_barang` DISABLE KEYS */; REPLACE INTO `tb_barang` (`id`, `id_ruang`, `nama_barang`, `merk`, `tanggal`, `keadaan`, `harga`, `gambar`) VALUES (9, 17, 'KURSI TUNGGU', '-', '2023-08-31', '100', '1500000', 'gambar-1693449100.jpg'), (10, 17, 'Lampu Hias Dinding', 'Noname', '2023-08-31', '100', '1', ''), (11, 17, 'Alat Pemadam Api Ringan (APAR)', 'Noname', '2023-08-31', '100', '99', ''), (12, 18, 'Monitor ', 'Samsung', '2023-08-31', '90', '1', ''), (13, 18, 'CPU', 'HP', '2023-08-31', '90', '1', ''), (14, 18, 'Meja Keeja', 'Pro Design', '2023-08-31', '90', '1', ''), (15, 18, 'Kursi Besi', 'Vios', '2023-08-31', '90', '1', ''), (16, 18, 'AC', 'Daikin', '2023-08-31', '100', '3000000', ''), (17, 18, 'Hanger', 'Noname', '2023-08-31', '100', '1', ''), (18, 18, 'Spiker PC ', 'Accer', '2023-08-31', '80', '1', ''), (19, 18, 'Tong Sampah ', 'DIY', '2023-08-31', '100', '15000', ''), (20, 18, 'Terminal listrik', 'Noname', '2023-08-31', '100', '1', ''), (21, 19, 'Meja Kerja', 'Noname', '2023-08-31', '100', '1', ''), (22, 19, 'Kursi Besi', 'Vios', '2023-08-31', '90', '1', ''), (23, 19, 'AC', 'Daikin', '2023-08-31', '100', '3000000', ''), (24, 19, 'Meja Kecil', 'Noname', '2023-08-31', '80', '1', ''), (25, 19, 'Monitor ', 'Accer', '2023-08-31', '80', '1', ''), (26, 20, 'Meja Kerja', 'Noname', '2023-08-31', '80', '1', ''), (27, 19, 'Kursi Besi', 'Vios', '2023-08-31', '80', '1', ''), (28, 19, 'AC', 'Daikin', '2023-08-31', '100', '3000000', ''), (29, 19, 'Monitor ', 'Accer', '2023-08-31', '80', '1', ''), (30, 19, 'Meja Kecil', 'Noname', '2023-08-31', '80', '1', ''), (31, 19, 'Meja Kecil', 'Noname', '2023-08-31', '80', '1', ''), (33, 21, 'Meja Kerja', 'Noname', '2023-08-31', '80', '1', ''), (34, 20, 'Kursi', 'Vios', '2023-08-31', '80', '1', ''), (35, 20, 'AC', 'Daikin', '2023-08-31', '100', '3000000', ''), (36, 20, 'Monitor', 'Accer', '2023-08-31', '80', '1', ''), (37, 20, 'Meja Kecil', 'Noname', '2023-08-31', '80', '1', ''), (38, 21, 'Kursi Besi', 'Vios', '2023-08-31', '80', '1', ''), (39, 21, 'Monitor', 'LG', '2023-08-31', '80', '1', ''), (40, 21, 'CPU', 'HP', '2023-08-31', '80', '1', ''), (42, 21, 'AC', 'Daikin', '2023-08-31', '100', '3000000', ''), (43, 22, 'Monitor ', 'AOC', '2023-08-31', '80', '1', ''), (44, 22, 'Monitor', 'LG', '2023-08-31', '30', '1', ''), (45, 22, 'CPU', 'Lenovo', '2023-08-31', '80', '1', ''), (46, 22, 'CPU', 'Accer', '2023-08-31', '30', '1', ''), (47, 22, 'Meja Kerja', 'Noname', '2023-08-31', '80', '1', ''), (53, 22, 'Kursi Besi', 'Vios', '2023-08-31', '80', '1', ''), (54, 22, 'Dispenser', 'Miyako', '2023-08-31', '70', '1', ''), (55, 22, 'Terminal Listrik', 'Noname', '2023-08-31', '80', '1', ''), (56, 22, 'Lemari Arsip', 'Brother', '2023-08-31', '80', '1', ''), (57, 22, 'AC', 'Daikin', '2023-08-31', '100', '3000000', ''), (58, 22, 'Rak Kayu', 'Noname', '2023-08-31', '80', '1', ''), (59, 22, 'Timbangan Badan ', 'Iscale', '2023-08-31', '80', '1', ''), (60, 22, 'Kotak Obat', 'Noname', '2023-08-31', '70', '1', ''), (61, 22, 'Jam Dinding', 'Quartz', '2023-08-31', '100', '100000', ''), (62, 22, 'Tong Sampah', 'Interior', '2023-08-31', '80', '1', ''), (63, 23, 'Meja Kerja', 'Noname', '2023-08-31', '80', '1', ''), (64, 23, 'Kursi Besi', 'Vios', '2023-08-31', '80', '1', ''), (65, 23, 'AC', 'Daikin', '2023-08-31', '100', '3000000', ''), (66, 23, 'Lemari Kayu', 'Noname', '2023-08-31', '80', '1', ''), (67, 23, 'Terminal Listrik', 'Noname', '2023-08-31', '80', '1', ''), (68, 23, 'White Board Kecil', 'Noname', '2023-08-31', '80', '1', ''), (69, 23, 'White Board Kecil', 'Noname', '2023-08-31', '80', '1', ''), (70, 23, 'Terminal T', 'Noname', '2023-08-31', '80', '1', ''), (71, 23, 'Monitor', 'Samsung', '2023-08-31', '80', '1', ''), (72, 24, 'Printer ', 'Epson', '2023-08-31', '80', '1', ''), (73, 24, 'Mega Kerja', 'Noname', '2023-08-31', '80', '1', ''), (74, 24, 'Kursi Besi', 'Vios', '2023-08-31', '80', '1', ''), (75, 24, 'Rak Kecil', 'Noname', '2023-08-31', '80', '1', ''), (76, 24, 'AC', 'Daikin', '2023-08-31', '100', '3000000', ''), (77, 25, 'Monitor ', 'Accer', '2023-08-31', '80', '1', ''), (78, 25, 'Monitor', 'AOC', '2023-08-31', '80', '1', ''), (79, 25, 'CPU', 'Votre', '2023-08-31', '80', '1', ''), (80, 25, 'CPU', 'HP', '2023-08-31', '80', '1', ''), (81, 25, 'Printer', 'HP', '2023-08-31', '80', '1', ''), (82, 25, 'Printer ', 'Accer', '2023-08-31', '80', '1', ''), (83, 25, 'Kursi Besi', 'Vios', '2023-08-31', '80', '1', ''), (84, 25, 'Kursi Besi', 'Fortuner', '2023-08-31', '80', '1', ''), (85, 25, 'Meja Pelayanan ', 'Noname', '2023-08-31', '80', '1', ''), (86, 25, 'AC', 'Daikin', '2023-08-31', '100', '1', ''), (87, 26, 'Meja Kerja', 'Noname', '2023-08-31', '80', '1', ''), (88, 26, 'Kursi Besi', 'Vios1', '2023-08-31', '80', '1', ''), (89, 26, 'Lemari Arsip (Kayu)', 'Graver', '2023-08-31', '80', '1', ''), (90, 26, 'AC', 'Daikin', '2023-08-31', '80', '1', ''), (91, 26, 'Monitor', 'Philips', '2023-08-31', '80', '1', ''), (92, 26, 'Tong Sampah', 'MPW', '2023-08-31', '80', '1', ''), (93, 26, 'Terminal Listrik', 'Noname', '2023-08-31', '80', '1', ''), (94, 26, 'Printer ', 'Lenovo', '2023-08-31', '80', '1', ''), (95, 27, 'Monitor', 'Accer', '2023-09-02', '80', '1', ''), (96, 27, 'CPU', 'Lenovo', '2023-09-02', '80', '1', ''), (97, 27, 'Printer', 'Epson', '2023-09-02', '80', '1', ''), (98, 27, 'Monitor', 'Samsung', '2023-09-02', '80', '1', ''), (99, 27, 'Kursi Besi', 'Vios', '2023-09-02', '80', '1', ''), (100, 27, 'Kursi Besi', 'Chitose', '2023-09-02', '80', '1', ''), (101, 27, 'Meja Kayu', 'Noname', '2023-09-04', '50', '1', ''), (102, 27, 'Jam Dinding ', 'Quartz', '2023-09-04', '50', '1', ''), (103, 27, 'Speaker PC', 'Accer', '2023-09-04', '50', '1', ''), (104, 27, 'Tong Sampah ', 'Noname', '2023-09-04', '50', '1', ''), (105, 27, 'Terminal', 'Noname', '2023-09-04', '50', '1', ''), (106, 27, 'TP Link ', 'Noname', '2023-09-04', '50', '1', ''), (107, 29, 'Monitor ', 'Noname', '2023-09-04', '50', '1', ''), (108, 29, 'CPU', 'Noname', '2023-09-04', '50', '1', ''), (109, 29, 'Printer', 'Noname', '2023-09-04', '50', '1', ''), (110, 29, 'Speaker PC ', 'Accer', '2023-09-04', '50', '1', ''), (111, 29, 'Meja Kerja', 'Noname', '2023-09-04', '50', '1', ''), (113, 29, 'Kursi Besi', 'Vios', '2023-09-04', '50', '1', ''), (114, 29, 'Terminal listrik', 'Noname', '2023-09-04', '50', '1', ''), (115, 28, 'Monitor ', 'Noname', '2023-09-04', '50', '1', ''), (116, 28, 'CPU', 'Noname', '2023-09-04', '50', '1', ''), (117, 28, 'Printer', 'Noname', '2023-09-04', '50', '1', ''), (118, 28, 'Spiker PC ', 'Noname', '2023-09-04', '50', '1', ''), (119, 28, 'Meja Kecil', 'Noname', '2023-09-04', '50', '1', ''), (120, 28, 'Meja Kerja', 'Noname', '2023-09-04', '50', '1', ''), (121, 28, 'Kursi Besi', 'Vios', '2023-09-04', '50', '1', ''), (122, 28, 'Rak Kayu', 'Noname', '2023-09-04', '50', '1', ''), (123, 30, 'AC', 'Daikin', '2023-09-06', '80', '3000000', ''), (124, 30, 'Jam Dinding', 'Quartz', '2023-09-06', '50', '1', ''), (125, 30, 'Meja Besar ', 'Noname', '2023-09-06', '70', '1', ''), (126, 30, 'Meja Kerja ', 'Noname', '2023-09-06', '70', '1', ''), (127, 30, 'Tiang Bendera ', 'Noname', '2023-09-06', '70', '1', ''), (128, 30, 'Lemari Besi', 'Noname', '2023-09-06', '70', '1', ''), (129, 30, 'Monitor', 'LG', '2023-09-06', '50', '1', ''), (130, 30, 'Printer', 'Epson', '2023-09-06', '50', '1', ''), (131, 30, 'Kursi Besi', 'Fortuner', '2023-09-06', '50', '1', ''), (132, 30, 'Kursi Besi', 'Fortuner', '2023-09-06', '50', '1', ''), (133, 30, 'Foto Garuda ', 'Noname', '2023-09-06', '50', '1', ''), (134, 30, 'Foto Presiden', 'Noname', '2023-09-06', '50', '1', ''), (135, 30, 'Foto Wakil Presiden ', 'Noname', '2023-09-06', '50', '1', ''), (136, 30, 'Bendera Merah Putih ', 'Noname', '2023-09-06', '50', '1', ''), (137, 30, 'Bendera Fakultas ', 'Noname', '2023-09-06', '50', '1', ''), (138, 30, 'Tempat Sampah ', 'Noname', '2023-09-06', '50', '1', ''), (139, 31, 'Meja Kerja', 'Noname', '2023-09-09', '50', '1', ''), (140, 31, 'Monitor', 'Noname', '2023-09-09', '50', '1', ''), (141, 31, 'AC', 'Daikin', '2023-09-09', '50', '1', ''), (142, 31, 'Rak Kayu', 'Noname', '2023-09-09', '50', '1', ''), (143, 31, 'Tong Sampah', 'Noname', '2023-09-09', '50', '1', ''), (144, 32, 'Meja Oval ', 'Noname', '2023-09-09', '60', '1', ''), (145, 32, 'Meja Kerja', 'Noname', '2023-09-09', '50', '1', ''), (146, 32, 'Bangku Panjang', 'Noname', '2023-09-11', '70', '1', ''), (147, 32, 'Kursi Besi', 'Vios', '2023-09-11', '50', '1', ''), (148, 32, 'AC', 'Daikin', '2023-09-11', '90', '3000000', ''), (149, 32, 'Jam Dinding ', 'Quartz', '2023-09-11', '50', '1', ''), (150, 32, 'Kipas Angin ', 'Noname', '2023-09-11', '50', '1', ''), (151, 32, 'Tong Sampah ', 'Noname', '2023-09-11', '50', '1', ''), (152, 32, 'Rak piring besar', 'Noname', '2023-09-11', '70', '50000', ''), (153, 32, 'Lemari Kayu ', 'Noname', '2023-09-11', '50', '1', ''), (154, 32, 'Rak piring kecil', 'Noname', '2023-09-11', '70', '1', ''), (155, 32, 'Kompor', 'Noname', '2023-09-11', '50', '1', ''), (156, 32, 'Dispenser ', 'Noname', '2023-09-11', '50', '1', ''), (157, 32, 'Lemari Es', 'Noname', '2023-09-11', '50', '1', ''), (158, 32, 'Tabung Gas ', 'Noname', '2023-09-11', '50', '1', ''), (159, 32, 'Keset', 'Noname', '2023-09-11', '50', '1', ''), (160, 33, 'Karpet Sajadah ', 'Noname', '2023-09-11', '50', '1', ''), (161, 33, 'Sejadah ', 'Noname', '2023-09-11', '50', '1', ''), (162, 33, 'Mukena ', 'Noname', '2023-09-11', '50', '1', ''), (163, 32, 'Jam Dinding ', 'Quartz', '2023-09-11', '50', '1', ''), (164, 32, 'Quran ', 'Noname', '2023-09-11', '50', '1', ''), (165, 32, 'Keset', 'Noname', '2023-09-11', '50', '1', ''), (166, 32, 'Rak Sandal', 'Noname', '2023-09-11', '50', '1', ''), (167, 34, 'Ember', 'Noname', '2023-09-11', '50', '1', ''), (168, 34, 'Gayung', 'Noname', '2023-09-11', '50', '1', ''), (169, 34, 'Ember', 'Noname', '2023-09-11', '50', '1', ''), (170, 34, 'Rak Dinding Kecil', 'Noname', '2023-09-11', '50', '1', ''), (171, 34, 'Kaca Cermin ', 'Noname', '2023-09-11', '50', '1', ''), (172, 34, 'Tong Sampah', 'Noname', '2023-09-11', '50', '1', ''), (173, 35, 'Meja', 'Noname', '2023-09-11', '50', '0', ''), (174, 35, 'Kursi', 'Noname', '2023-09-11', '50', '1', ''), (175, 36, 'Monitor', 'Noname', '2023-09-11', '50', '1', ''), (176, 36, 'CPU', 'Noname', '2023-09-11', '50', '1', ''), (177, 36, 'Meja Kerja ', 'Noname', '2023-09-11', '50', '1', ''), (178, 36, 'Spiker PC', 'Noname', '2023-09-11', '50', '1', ''), (179, 36, 'Jam Dinding', 'Noname', '2023-09-11', '50', '1', ''), (180, 36, 'Dispenser', 'Noname', '2023-09-11', '50', '1', ''), (181, 36, 'TV', 'Noname', '2023-09-11', '50', '1', ''), (182, 36, 'Rak TV', 'Noname', '2023-09-11', '50', '1', ''), (183, 36, 'Kursi Besi ', 'Noname', '2023-09-11', '50', '1', ''), (184, 36, 'Kursi Panjang ', 'Noname', '2023-09-11', '50', '1', ''), (185, 36, 'Gayung ', 'Noname', '2023-09-11', '50', '1', ''), (186, 36, 'Tong Sampah', 'Noname', '2023-09-11', '50', '1', ''), (187, 37, 'Kursi Meja ', 'Noname', '2023-09-11', '50', '1', ''), (188, 37, 'Meja Dosen ', 'Noname', '2023-09-11', '50', '1', ''), (189, 37, 'Papan Tulis ', 'Noname', '2023-09-11', '50', '1', ''), (190, 37, 'Kipas Angin', 'Noname', '2023-09-11', '50', '0', ''), (191, 37, 'Tong Sampah', 'DIY', '2023-09-11', '50', '1', ''), (192, 37, 'Jam Dinding ', 'Quartz', '2023-09-11', '70', '100000', ''), (193, 37, 'Infocus', 'Noname ', '2023-09-11', '50', '1', ''), (194, 38, 'Kursi + Meja ', 'Noname', '2023-09-11', '50', '1', ''), (195, 38, 'Meja Dosen ', 'Noname', '2023-09-11', '50', '1', ''), (196, 38, 'Papan Tulis ', 'noname', '2023-09-11', '50', '1', ''), (197, 38, 'Kipas Angin ', 'noname', '2023-09-11', '50', '0', ''), (198, 38, 'Tong Sampah ', 'Noname ', '2023-09-11', '50', '1', ''), (199, 38, 'Jam Dinding ', 'Quartz', '2023-09-11', '70', '100000', ''), (200, 38, 'Infocus ', 'Noname', '2023-09-11', '50', '1', ''), (201, 39, 'Kursi + Meja ', 'Noname', '2023-09-11', '50', '1', ''), (202, 39, 'Meja Dosen ', 'Noname', '2023-09-11', '50', '1', ''), (203, 58, 'Papan Tulis ', 'Noname', '2023-09-11', '50', '1', ''), (204, 39, 'Kipas Angin', 'Noname', '2023-09-11', '50', '1', ''), (205, 39, 'Tong Sampah ', 'DIY', '2023-09-11', '70', '35000', ''), (206, 39, 'Jam Dinding ', 'Quartz', '2023-09-11', '70', '100000', ''), (207, 39, 'Infocus', 'Noname', '2023-09-11', '50', '1', ''), (208, 40, 'Kursi + Meja ', 'Noname', '2023-09-11', '50', '1', ''), (209, 40, 'Meja Dosen ', 'Noname', '2023-09-11', '50', '1', ''), (210, 40, 'Papan Tulis ', 'Noname', '2023-09-11', '50', '1', ''), (211, 40, 'Kipas Angin ', 'Noname ', '2023-09-11', '50', '1', ''), (212, 40, 'Tong Sampah', 'DIY', '2023-09-11', '70', '1', ''), (213, 40, 'Jam Dinding ', 'Quartz', '2023-09-11', '70', '100000', ''), (214, 41, 'Kursi + Meja ', 'Noname', '2023-09-11', '50', '1', ''), (215, 41, 'Meja Dosen ', 'Noname', '2023-09-11', '50', '0', ''), (216, 41, 'Papapn Tulis', 'Noname ', '2023-09-11', '50', '1', ''), (217, 41, 'KIpas Angin ', 'Noname ', '2023-09-11', '50', '1', ''), (218, 41, 'Tong Sampah', 'Noname', '2023-09-11', '50', '35000', ''), (219, 41, 'Jam Dinding ', 'Quartz', '2023-09-11', '70', '100000', ''), (220, 42, 'Kursi+Meja ', 'Noname', '2023-09-11', '50', '1', ''), (221, 42, 'Meja Dosen ', 'Noname', '2023-09-11', '50', '1', ''), (222, 42, 'Papan Tulis ', 'Noname ', '2023-09-11', '50', '1', ''), (223, 42, 'Kipas Angin', 'Noname', '2023-09-11', '50', '0', ''), (224, 42, 'Tong Sampah', 'DIY', '2023-09-11', '50', '35000', ''), (225, 42, 'Jam Dinding ', 'Quartz', '2023-09-11', '70', '100000', ''), (226, 43, 'Kursi + Meja ', 'Noname ', '2023-09-11', '50', '1', ''), (227, 43, 'Meja Dosen ', 'Noname', '2023-09-11', '50', '1', ''), (228, 43, 'Papan Tulis ', 'Noname ', '2023-09-11', '50', '0', ''), (229, 43, 'AC', 'Noname', '2023-09-11', '50', '1', ''), (230, 43, 'Tong Sampah', 'DIY', '2023-09-11', '70', '35000', ''), (231, 43, 'Jam Dinding ', 'Quartz', '2023-09-11', '70', '100000', ''), (232, 44, 'KUrsi Meja ', 'Noname ', '2023-09-11', '50', '1', ''), (233, 44, 'Meja Dosen ', 'Noname ', '2023-09-11', '50', '1', ''), (234, 44, 'Papan Tulis ', 'Noname', '2023-09-11', '50', '1', ''), (235, 44, 'AC ', 'Noname', '2023-09-11', '50', '0', ''), (236, 44, 'Tong Sampah ', 'DIY', '2023-09-11', '70', '35000', ''), (237, 44, 'Jam Dinding ', 'Quartz', '2023-09-11', '70', '100000', ''), (238, 45, 'Kursi Meja ', 'Noname ', '2023-09-11', '50', '1', ''), (239, 45, 'Meja Dosen ', 'Noname ', '2023-09-11', '50', '1', ''), (240, 45, 'Papan Tulis ', 'Noname ', '2023-09-11', '50', '1', ''), (241, 45, 'Kipas Angin/AC ', 'Noname ', '2023-09-11', '50', '0', ''), (242, 45, 'Tong Sampah ', 'DIY ', '2023-09-11', '70', '34999', ''), (243, 45, 'Jam Dinding ', 'Quartz ', '2023-09-11', '70', '100000', ''), (244, 46, 'Meja Panjang ', 'Noname ', '2023-09-11', '50', '1', ''), (245, 46, 'Terminal Listrik ', 'Noname ', '2023-09-11', '50', '0', ''), (246, 46, 'Kursi Besi ', 'Vios ', '2023-09-11', '50', '1', ''), (247, 46, 'Kursi Kayu Panjang ', 'Noname ', '2023-09-11', '50', '1', ''), (248, 46, 'Tong Sampah ', 'Noname ', '2023-09-11', '50', '1', ''), (249, 46, '1 Set Meja Tamu ', 'Noname ', '2023-09-11', '50', '1', ''), (250, 46, 'Kipas Angin', 'Noname ', '2023-09-11', '50', '1', ''), (251, 47, 'Meja Kayu ', 'Noname ', '2023-09-11', '50', '1', ''), (252, 47, 'Meja Kayu Besar ', 'Noname ', '2023-09-11', '50', '0', ''), (253, 47, 'Kursi Tamu 1 Set ', 'Noname ', '2023-09-11', '40', '1', ''), (254, 47, 'Kursi Besi ', 'vios ', '2023-09-11', '50', '0', ''), (255, 47, 'Kipas Angin ', 'Noname ', '2023-09-11', '50', '1', ''), (256, 47, 'AC ', 'Noname ', '2023-09-11', '50', '1', ''), (257, 47, 'Rak Novel ', 'Noname ', '2023-09-11', '50', '0', ''), (258, 47, 'Rak Besi ', 'Noname ', '2023-09-11', '50', '1', ''), (259, 47, 'Bupet Jati', 'Noname ', '2023-09-11', '50', '1', ''), (260, 47, 'Meja Leter L', 'Noname ', '2023-09-11', '50', '1', ''), (261, 47, 'Tong Sampah ', 'Noname', '2023-09-11', '50', '1', ''), (262, 47, 'Jam Dinding ', 'Noname ', '2023-09-11', '50', '-1', ''), (263, 56, 'Monitor dan PC ', 'Noname ', '2023-09-11', '50', '0', ''), (264, 56, 'AC', 'LG', '2023-09-11', '50', '1', ''), (265, 56, 'Pacum Cleanner ', 'Sanyo ', '2023-09-11', '50', '1', ''), (266, 56, 'Jam Dinding ', 'Noname ', '2023-09-11', '50', '1', ''), (267, 56, 'Tong Sampah ', 'Noname ', '2023-09-11', '50', '0', ''), (268, 56, 'Kursi ', 'Chitos ', '2023-09-11', '50', '1', ''), (269, 57, 'PC', 'HP', '2023-09-12', '50', '1', ''), (270, 57, 'AC', 'LG', '2023-09-12', '50', '1', ''), (271, 57, 'Pacum Cleanner', 'Sanyo', '2023-09-12', '50', '1', ''), (272, 57, 'Jam Dinding ', 'noname', '2023-09-12', '50', '1', ''), (273, 57, 'Tong Sampah ', 'noname', '2023-09-12', '50', '1', ''), (274, 57, 'Kursi Besi', 'Chitos', '2023-09-12', '50', '1', ''), (276, 57, 'Meja Dosen ', 'Noname', '2023-09-12', '50', '1', ''), (277, 57, 'Papan Tulis', 'Noname', '2023-09-12', '50', '1', ''), (278, 57, 'Infocus', 'Noname', '2023-09-12', '50', '1', ''), (279, 57, 'Layar Infocus', 'Noname', '2023-09-12', '50', '1', ''), (280, 57, 'Meja Komputer ', 'Noname ', '2023-09-12', '50', '1', ''), (281, 58, 'Komputer ', 'Noname ', '2023-09-12', '60', '1', ''), (282, 58, 'AC', 'Noname', '2023-09-12', '50', '1', ''), (283, 58, 'Printer ', 'NoName', '2023-09-12', '50', '1', ''), (284, 59, 'Komputer ', 'Noname', '2023-09-12', '60', '1', ''), (285, 23, 'Kursi Putar', 'Inco', '2023-09-19', '100', '0', ''), (286, 31, 'Kursi Putar', 'Inco', '2023-09-19', '100', '0', ''), (287, 24, 'Kursi Putar', 'Inco', '2023-09-19', '100', '0', ''), (288, 21, 'Kursi Putar', 'Inco', '2023-09-19', '100', '0', ''), (289, 20, 'Kursi Putar', 'Inco', '2023-09-19', '100', '0', ''), (290, 18, 'Kursi Putar', 'Inco', '2023-09-19', '100', '0', ''), (291, 19, 'Kursi Putar', 'Inco', '2023-09-19', '100', '0', ''), (292, 30, 'Kursi Putar', 'Inco', '2023-09-19', '100', '0', ''), (293, 18, 'Lemari Arsip', 'Frontline', '2023-09-19', '100', '0', ''), (294, 26, 'Lemari Arsip', 'Frontline', '2023-09-19', '100', '0', ''), (295, 21, 'Lemari Arsip', 'Frontline', '2023-09-19', '100', '0', ''), (296, 24, 'Lemari Arsip', 'Frontline', '2023-09-19', '100', '0', ''), (297, 18, 'PC', 'L275xW170xH350mm', '2023-09-19', '100', '0', ''), (298, 30, 'Televisi', 'Sharp', '2023-09-16', '100', '0', ''), (299, 30, 'Monitor', '20MK400/49CM/19,5', '2023-09-16', '100', '0', ''); /*!40000 ALTER TABLE `tb_barang` ENABLE KEYS */; -- Dumping structure for table unsap_fti_aset.tb_gedung CREATE TABLE IF NOT EXISTS `tb_gedung` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nama_gedung` varchar(250) NOT NULL, `jumlah_ruang` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4; -- Dumping data for table unsap_fti_aset.tb_gedung: ~2 rows (approximately) /*!40000 ALTER TABLE `tb_gedung` DISABLE KEYS */; REPLACE INTO `tb_gedung` (`id`, `nama_gedung`, `jumlah_ruang`) VALUES (2, 'Gedung Lama', '25'), (4, 'Gedung Baru', '21'); /*!40000 ALTER TABLE `tb_gedung` ENABLE KEYS */; -- Dumping structure for table unsap_fti_aset.tb_log CREATE TABLE IF NOT EXISTS `tb_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `idUser` int(11) NOT NULL, `ipAddress` varchar(32) NOT NULL, `device` text NOT NULL, `status` varchar(16) NOT NULL, `terdaftar` datetime NOT NULL, PRIMARY KEY (`id`), KEY `FK04` (`idUser`), CONSTRAINT `FK01` FOREIGN KEY (`idUser`) REFERENCES `tb_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=latin1; -- Dumping data for table unsap_fti_aset.tb_log: ~61 rows (approximately) /*!40000 ALTER TABLE `tb_log` DISABLE KEYS */; REPLACE INTO `tb_log` (`id`, `idUser`, `ipAddress`, `device`, `status`, `terdaftar`) VALUES (1, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-12 09:54:19'), (2, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-12 15:32:39'), (3, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-12 21:43:31'), (4, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-13 19:45:46'), (5, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-02-13 21:52:38'), (6, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-02-13 21:52:44'), (7, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Login', '2023-02-24 19:49:45'), (8, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Logout', '2023-02-24 22:15:58'), (9, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Login', '2023-02-24 22:16:06'), (10, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Logout', '2023-02-25 00:39:41'), (11, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Login', '2023-02-25 00:41:44'), (12, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Login', '2023-02-25 08:02:09'), (13, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Logout', '2023-02-26 22:22:34'), (14, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Login', '2023-02-26 22:37:23'), (15, 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', 'Login', '2023-02-28 18:13:21'), (16, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36', 'Login', '2023-08-23 19:06:23'), (17, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36', 'Logout', '2023-08-23 19:14:27'), (18, 1, '192.168.10.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Safari/605.1.15', 'Login', '2023-08-23 19:27:57'), (19, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36', 'Login', '2023-08-23 19:34:06'), (20, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36', 'Logout', '2023-08-23 19:38:52'), (21, 1, '192.168.10.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Safari/605.1.15', 'Logout', '2023-08-23 19:39:43'), (22, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 12; en-us; Mi 10T Pro Build/SKQ1.211006.001) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/112.0.5615.136 Mobile Safari/537.36 XiaoMi/MiuiBrowser/13.35.0-gn', 'Login', '2023-08-23 19:43:59'), (23, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 12; en-us; Mi 10T Pro Build/SKQ1.211006.001) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/112.0.5615.136 Mobile Safari/537.36 XiaoMi/MiuiBrowser/13.35.0-gn', 'Logout', '2023-08-23 19:45:07'), (24, 1, '192.168.10.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_7_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.6 Mobile/15E148 Safari/604.1', 'Login', '2023-08-23 19:47:15'), (25, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Mobile Safari/537.36', 'Login', '2023-08-23 19:51:15'), (26, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Mobile Safari/537.36', 'Logout', '2023-08-23 19:53:10'), (27, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36', 'Login', '2023-08-25 12:40:05'), (28, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-08-28 09:03:20'), (29, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 11; in-id; CPH2269 Build/RP1A.200720.011) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36 HeyTapBrowser/45.10.1.1.1', 'Login', '2023-08-28 15:03:24'), (30, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0', 'Login', '2023-08-30 09:43:32'), (31, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 11; in-id; CPH2269 Build/RP1A.200720.011) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36 HeyTapBrowser/45.10.1.1.1', 'Login', '2023-08-30 10:39:39'), (32, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0', 'Logout', '2023-08-30 10:42:17'), (33, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0', 'Login', '2023-08-30 10:43:03'), (34, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 11; in-id; CPH2269 Build/RP1A.200720.011) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36 HeyTapBrowser/45.10.1.1.1', 'Login', '2023-08-30 15:26:54'), (35, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/117.0', 'Login', '2023-08-31 09:27:55'), (36, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 11; in-id; CPH2269 Build/RP1A.200720.011) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36 HeyTapBrowser/45.10.1.1.1', 'Login', '2023-08-31 11:18:35'), (37, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-08-31 13:41:40'), (38, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 11; in-id; CPH2269 Build/RP1A.200720.011) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36 HeyTapBrowser/45.10.1.1.1', 'Login', '2023-08-31 18:43:53'), (39, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-09-02 08:47:07'), (40, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 11; in-id; CPH2269 Build/RP1A.200720.011) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36 HeyTapBrowser/45.10.1.1.1', 'Login', '2023-09-04 10:17:25'), (41, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 11; in-id; CPH2269 Build/RP1A.200720.011) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36 HeyTapBrowser/45.10.1.1.1', 'Login', '2023-09-04 14:51:35'), (42, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-09-06 10:02:00'), (43, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Logout', '2023-09-06 11:15:06'), (44, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-09-09 09:49:15'), (45, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 11; in-id; CPH2269 Build/RP1A.200720.011) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36 HeyTapBrowser/45.10.1.1.1', 'Login', '2023-09-11 09:53:26'), (46, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.76', 'Login', '2023-09-11 11:09:18'), (47, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.76', 'Login', '2023-09-11 11:09:18'), (48, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.76', 'Logout', '2023-09-11 15:23:12'), (49, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', 'Login', '2023-09-12 09:34:49'), (50, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', 'Login', '2023-09-12 14:35:28'), (51, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', 'Logout', '2023-09-12 14:37:40'), (52, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', 'Login', '2023-09-12 14:41:08'), (53, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', 'Logout', '2023-09-12 14:43:20'), (54, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', 'Login', '2023-09-12 14:43:42'), (55, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', 'Logout', '2023-09-12 14:47:49'), (56, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36', 'Login', '2023-09-12 14:48:28'), (57, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 11; in-id; CPH2269 Build/RP1A.200720.011) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36 HeyTapBrowser/45.10.1.1.1', 'Login', '2023-09-18 05:48:39'), (58, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 11; in-id; CPH2269 Build/RP1A.200720.011) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36 HeyTapBrowser/45.10.1.1.1', 'Login', '2023-09-25 18:54:42'), (59, 1, '192.168.10.1', 'Mozilla/5.0 (Linux; U; Android 11; in-id; CPH2269 Build/RP1A.200720.011) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36 HeyTapBrowser/45.10.1.1.1', 'Login', '2023-09-26 09:22:04'), (60, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', 'Login', '2023-09-26 09:25:28'), (61, 1, '192.168.10.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 'Login', '2023-10-19 09:41:10'); /*!40000 ALTER TABLE `tb_log` ENABLE KEYS */; -- Dumping structure for table unsap_fti_aset.tb_ruang CREATE TABLE IF NOT EXISTS `tb_ruang` ( `id` int(11) NOT NULL AUTO_INCREMENT, `id_gedung` int(11) NOT NULL, `nama_ruang` varchar(250) NOT NULL, `jumlah_barang` int(11) NOT NULL, `keterangan` varchar(250) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4; -- Dumping data for table unsap_fti_aset.tb_ruang: ~43 rows (approximately) /*!40000 ALTER TABLE `tb_ruang` DISABLE KEYS */; REPLACE INTO `tb_ruang` (`id`, `id_gedung`, `nama_ruang`, `jumlah_barang`, `keterangan`) VALUES (17, 4, 'RUANG TUNGGU', 6, 'RUANG TUNGGU FAKULTAS'), (18, 4, 'RUANG KEPALA PRODI SI', 9, 'RUANG KEPALA PRODI SISTEM INFORMASI'), (19, 4, 'RUANG KAPRODI INFORMATIKA', 5, 'RUANG KAPRODI INFORMATIKA'), (20, 4, 'RUANG UPT LPPM', 5, 'RUANG UPT LPPM'), (21, 4, 'RUANG UPT LPM', 6, 'RUANG UPT LPM'), (22, 4, 'RUANG ARSIP', 13, 'RUANG ARSIP'), (23, 4, 'RUANG WADEK I ', 9, 'RUANG WADEK I '), (24, 4, 'RUANG WADEK II', 5, 'RUANG WADEK II'), (25, 4, 'RUANG PELAYANAN', 6, 'RUANG PELAYANAN'), (26, 4, 'RUANG KABAUM', 8, 'RUANG KABAUM'), (27, 4, 'RUANG KABAAK', 10, 'RUANG KABAAK'), (28, 4, 'RUANG STAFF PRODI INFORMATIKA', 10, 'RUANG STAFF PRODI INFORMATIKA'), (29, 4, 'RUANG STAFF PRODI SI', 7, 'RUANG STAFF PRODI SI'), (30, 4, 'RUANG DEKAN', 16, 'RUANG DEKAN'), (31, 4, 'RUANG WADEK III', 7, 'RUANG WADEK III'), (32, 4, 'RUANG DAPUR', 20, 'RUANG DAPUR'), (33, 4, 'MUSHOLLA', 7, 'MUSHOLLA'), (34, 4, 'TOILET', 5, 'TOILET'), (35, 4, 'BALKON', 2, 'BALKON'), (36, 2, 'RUANG SECURITY', 12, 'RUANG SECURITY'), (37, 2, 'RUANG I', 7, 'RUANG PERKULIAHAN '), (38, 2, 'RUANG II', 7, 'RUANG PERKULIAHAN'), (39, 2, 'RUANG III', 7, 'RUANG PERKULIAHAN'), (40, 2, 'RUANG IV', 7, 'RUANG PERKULIAHAN'), (41, 2, 'RUANG V', 7, 'RUANG PERKULIAHAN'), (42, 2, 'RUANG VI', 7, 'RUANG PERKULIAHAN'), (43, 2, 'RUANG VIII', 7, 'RUANG PERKULIAHAN'), (44, 2, 'RUANG IX', 7, 'RUANG PERKULIAHAN'), (45, 2, 'RUANG X', 7, 'RUANG PERKULIAHAN'), (46, 2, 'RUANG PIKET', 7, 'GEDUNG LAMA BAGIAN BAWAH'), (47, 2, 'RUANG DOSEN', 12, 'GEDUNG LAMA BAGIAN BAWAH'), (50, 2, 'RUANG KUMPUL MAHASISWA EX PARKIR', 999, 'GEDUNG LAMA BAGIAN BAWAH'), (51, 2, 'TOILET GEDUNG LAMA ', 999, 'GEDUNG LAMA BAGIAN BAWAH'), (52, 2, 'MUSHOLLA MAHASISWA GEDUNG LAMA', 999, 'GEDUNG LAMA BAGIAN BAWAH'), (53, 2, 'EX RUANG UKM DAN SENAT', 999, 'GEDUNG LAMA BAGIAN BAWAH'), (54, 2, 'RUANG UKM LISSUNG', 999, 'GEDUNG LAMA BAGIAN ATAS'), (55, 2, 'RUANG UNSAP RADIO', 999, 'GEDUNG LAMA BAGIAN ATAS'), (56, 2, 'LABORATORIUM KOMPUTER I', 127, 'GEDUNG LAMA BAGIAN ATAS'), (57, 2, 'LABORATORIUM KOMPUTER II', 127, 'GEDUNG LAMA BAGIAN ATAS'), (58, 2, 'LABORATORIUM KOMPUTER III', 999, 'GEDUNG LAMA BAGIAN ATAS'), (59, 2, 'LABORATORIUM KOMPUTER IV', 999, 'GEDUNG LAMA BAGIAN ATAS'), (60, 2, 'RUANG ADMIN NOC DAN JARINGAN LAB 2 DAN 3', 999, 'GEDUNG LAMA BAGIAN ATAS'), (61, 2, 'RUANG ADMIN DAN SERVER LAB 1', 999, 'GEDUNG LAMA BAGIAN ATAS'); /*!40000 ALTER TABLE `tb_ruang` ENABLE KEYS */; -- Dumping structure for table unsap_fti_aset.tb_user CREATE TABLE IF NOT EXISTS `tb_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nama` varchar(256) NOT NULL, `telp` varchar(16) NOT NULL, `email` varchar(256) NOT NULL, `username` varchar(256) NOT NULL, `password` varchar(256) NOT NULL, `foto` varchar(128) NOT NULL, `skin` varchar(8) NOT NULL, `level` varchar(16) NOT NULL, `terdaftar` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- Dumping data for table unsap_fti_aset.tb_user: ~1 rows (approximately) /*!40000 ALTER TABLE `tb_user` DISABLE KEYS */; REPLACE INTO `tb_user` (`id`, `nama`, `telp`, `email`, `username`, `password`, `foto`, `skin`, `level`, `terdaftar`) VALUES (1, 'SARPRAS FTI', '0000', 'fti@unsap.ac.id', 'admin', '$2y$10$83tQbAKuyFIFq6RPXyXtgO6C7SESQRx1R7l7Yu/Gpk3uMQ1xFrOtm', 'Profil-1692792760.png', 'purple', 'Administrator', '2022-09-06 18:57:59'); /*!40000 ALTER TABLE `tb_user` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;