Download file SQL Script Parkir PHP

Sebelumnya maaf kepada teman2 yang sudah nunggu luuuama banget. Ya sudah lama ga maen blog. lama ga cari duit online. kelamaan di forex. waxaxaxax Ok berdasarkan permintaan teman2 yang sudah banyak di komen, saya akhirnya mencari, mengais dan mngorek data2 lama yang ga tahu ada dimana. maklum abis ganti hardisk. kemaren sudah fulllllll. Saya posting langsung aja ya.

Oia, sudah saya coba lagi kemarin menggunakan Xampp terbaru (PHP 5) banyak error karena saya masih menggunakan PHP 4, yang notabene belum bisa dipakai langsung. jadi buat teman2 yang mau di kembangkan silahkan saja. Semoga database untuk Script Parkir meggunakan PHP ini bermanfaat.


-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 22, 2011 at 12:28 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `ikpp`
--

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

--
-- Table structure for table `auth`
--

CREATE TABLE `auth` (
  `id_auth` int(3) NOT NULL auto_increment,
  `user_auth` varchar(20) NOT NULL,
  `pwd_auth` varchar(100) NOT NULL,
  PRIMARY KEY  (`id_auth`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `auth`
--

INSERT INTO `auth` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3');

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

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `id_company` int(1) NOT NULL,
  `nama_company` varchar(50) NOT NULL,
  `alamat_company` varchar(150) NOT NULL,
  `kota_company` varchar(30) NOT NULL,
  `telp_company` varchar(15) NOT NULL,
  `logo_company` varchar(30) NOT NULL default 'logo.png',
  PRIMARY KEY  (`id_company`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `company`
--

INSERT INTO `company` VALUES (1, 'Ramayana Mall', 'Jl. Kencana Jaya No.3', 'Cilegon', '(0254) 4234234', 'logo.png');

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

--
-- Table structure for table `report`
--


CREATE TABLE `report` (
  `id_report` int(10) unsigned NOT NULL auto_increment,
  `start_report` time default NULL,
  `tgl_start_report` date default NULL,
  `end_report` time default NULL,
  `tgl_end_report` date default NULL,
  `durasi_report` int(15) unsigned default NULL,
  `biaya_report` int(10) unsigned default NULL,
  `nama_kendaraan` varchar(25) NOT NULL,
  `nopol_report` varchar(10) NOT NULL,
  PRIMARY KEY  (`id_report`),
  UNIQUE KEY `nopol_report` (`nopol_report`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=91 ;



INSERT INTO `report` VALUES (1, '00:28:52', '2011-10-22', '06:24:14', '2011-10-22', 355, 3000, '1', '66');
INSERT INTO `report` VALUES (2, '01:06:12', '2011-10-22', '06:16:26', '2011-10-22', 309, 3000, '1', '1111');
INSERT INTO `report` VALUES (5, '06:57:00', '2011-10-22', '09:38:25', '2011-10-22', 158, 8000, '2', '666');
INSERT INTO `report` VALUES (8, '07:58:20', '2011-10-22', '11:24:12', '2011-10-22', 138, 8000, '2', 'AB1231MM');
INSERT INTO `report` VALUES (9, '07:58:33', '2011-10-22', '11:24:40', '2011-10-22', 16, 2000, '1', 'AB1234MA');
INSERT INTO `report` VALUES (10, '10:19:08', '2011-10-22', '10:29:55', '2011-10-22', 8, 6000, '3', 'dadad');
INSERT INTO `report` VALUES (11, '10:32:33', '2011-10-22', '11:23:17', '2011-10-22', 19, 2000, '1', 'xxx');

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

--
-- Table structure for table `tarif`
--

CREATE TABLE `tarif` (
  `tarif_id` int(3) NOT NULL auto_increment,
  `nama_kendaraan` varchar(25) NOT NULL,
  `tarif_perjam` int(10) unsigned NOT NULL default '1',
  `tarif_min` int(10) unsigned NOT NULL default '1',
  `tarif_max` int(10) unsigned NOT NULL default '1',
  PRIMARY KEY  (`tarif_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tarif`
--

INSERT INTO `tarif` VALUES (1, '1', 1000, 30, 3000);
INSERT INTO `tarif` VALUES (2, '2', 2000, 60, 30000);
INSERT INTO `tarif` VALUES (3, '3', 3000, 60, 30000);