# phpMyAdmin MySQL-Dump
# version 2.2.3
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: Dec 17, 2008 at 02:10 PM
# Server version: 3.23.47
# PHP Version: 4.1.1
# Database : `bisnis`
# --------------------------------------------------------

#
# Table structure for table `admin`
#

CREATE TABLE admin (
  id int(11) NOT NULL auto_increment,
  user varchar(20) NOT NULL default '',
  pass varchar(18) NOT NULL default '',
  nama varchar(50) default NULL,
  alamat varchar(100) default NULL,
  telepon varchar(20) default NULL,
  bank varchar(50) default NULL,
  norekening varchar(20) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `admin`
#

INSERT INTO admin VALUES (1, 'admin', 'admin', 'Nama anda', 'Alamat anda', '0123456789', 'Mandiri/BCA', 'Norek anda');
# --------------------------------------------------------

#
# Table structure for table `data`
#

CREATE TABLE data (
  id int(11) NOT NULL auto_increment,
  refid varchar(10) NOT NULL default '',
  data1 varchar(50) NOT NULL default '',
  data2 varchar(100) NOT NULL default '',
  data3 varchar(100) NOT NULL default '',
  data4 varchar(100) NOT NULL default '',
  data5 mediumtext NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `data`
#

INSERT INTO data VALUES (1, 'harga', '', '100.000', '100', '', '');
INSERT INTO data VALUES (2, 'pengumuman', '', '', '', '', '');
INSERT INTO data VALUES (4, 'deadline', '7', '', '', '', '');
# --------------------------------------------------------

#
# Table structure for table `menu`
#

CREATE TABLE menu (
  id int(11) NOT NULL auto_increment,
  Nama varchar(25) NOT NULL default '',
  link varchar(100) NOT NULL default '',
  target varchar(10) NOT NULL default '',
  PRIMARY KEY  (id,Nama,link,target)
) TYPE=MyISAM;

#
# Dumping data for table `menu`
#

INSERT INTO menu VALUES (15, 'MEMBER', 'dft_member.php', 'mainFrame');
INSERT INTO menu VALUES (16, 'PEMESAN', 'dft_pemesan.php', 'mainFrame');
INSERT INTO menu VALUES (19, 'PROFIL ADMIN', 'adminprofile.php', 'mainFrame');
INSERT INTO menu VALUES (22, 'DAFTAR MENU', 'd_menu.php', 'mainFrame');
INSERT INTO menu VALUES (27, 'FIND', 'find.php', 'mainFrame');
INSERT INTO menu VALUES (28, 'BLOKIR', 'dft_blokir.php', 'mainFrame');
INSERT INTO menu VALUES (29, 'MAIN PAGE', '../index.php', 'mainFrame');
INSERT INTO menu VALUES (30, 'HARGA', 'settinghargapro.php', 'mainFrame');
INSERT INTO menu VALUES (31, 'STATISTIK', 'refer.php', 'mainFrame');
INSERT INTO menu VALUES (32, 'LOGOUT', 'logout.php', 'mainFrame');
INSERT INTO menu VALUES (36, 'DAFTAR PROSPEK', 'dft_pros.php', 'mainFrame');
# --------------------------------------------------------

#
# Table structure for table `statistik`
#

CREATE TABLE statistik (
  userid varchar(20) default 'none',
  date varchar(10) NOT NULL default '',
  time varchar(10) NOT NULL default '',
  browser varchar(200) default 'Could Not Find This Data',
  ipaddress varchar(50) default 'Could Not Find This Data',
  refferalurl varchar(200) default 'none detected (maybe a direct link)'
) TYPE=MyISAM;

#
# Dumping data for table `statistik`
#

# --------------------------------------------------------

#
# Table structure for table `subribe`
#

CREATE TABLE subribe (
  id int(11) NOT NULL auto_increment,
  nama varchar(25) default NULL,
  email varchar(50) default NULL,
  subject varchar(50) default NULL,
  komentar text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `subribe`
#

# --------------------------------------------------------

#
# Table structure for table `user`
#

CREATE TABLE user (
  id int(11) NOT NULL auto_increment,
  userid varchar(30) NOT NULL default '',
  pass varchar(20) NOT NULL default '',
  stat char(3) NOT NULL default '',
  nama varchar(50) NOT NULL default '',
  alamat varchar(100) default NULL,
  kota varchar(25) NOT NULL default '',
  telepon varchar(20) NOT NULL default '',
  email varchar(50) NOT NULL default '',
  reseller varchar(50) NOT NULL default '',
  rekening varchar(100) NOT NULL default '',
  transfer varchar(20) NOT NULL default '',
  tanggal varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `user`
#