Berikut ini adalah contoh database yang hendak dibuatkan kode program-nya:
# MySQL-Front 3.2Â (Build 6.6)
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES ‘utf8′ */;
# Host: localhost   Database: contoh dfgen
# ——————————————————
# Server version 5.0.77-community-nt
#
# Table structure for table barang
#
DROP TABLE IF EXISTS `barang`;
CREATE TABLE `barang` (
`id` int(11) unsigned NOT NULL auto_increment,
`nama` varchar(40) default NULL,
`satuan` varchar(15) default NULL,
`sedia awal` decimal(12,2) unsigned default NULL,
PRIMARY KEYÂ (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table barang
#
#
# Table structure for table kueri fungsional
#
DROP TABLE IF EXISTS `kueri fungsional`;
CREATE TABLE `kueri fungsional` (
`id` int(11) unsigned NOT NULL auto_increment,
`waktu entri` datetime default NULL,
`nama` varchar(40) default NULL,
`teks` text,
PRIMARY KEYÂ (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table kueri fungsional
#
#
# Table structure for table kueri operator
#
DROP TABLE IF EXISTS `kueri operator`;
CREATE TABLE `kueri operator` (
`id` int(11) unsigned NOT NULL auto_increment,
`operator` int(11) default NULL,
`penjelasan` varchar(40) default NULL,
`adv base query` text,
`adv base filter` text,
`bas base kueri` text,
`bas base filter` text,
`tabel induk` varchar(40) default NULL,
PRIMARY KEYÂ (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table kueri operator
#
#
# Table structure for table modul program
#
DROP TABLE IF EXISTS `modul program`;
CREATE TABLE `modul program` (
`id` int(11) unsigned NOT NULL auto_increment,
`waktu entri` datetime default NULL,
`tanggal` date default NULL,
`kategori` varchar(40) default NULL,
`nama` varchar(40) default NULL,
`tampil` varchar(40) default NULL,
`penggunaan` tinytext,
PRIMARY KEYÂ (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table modul program
#
#
# Table structure for table operator rights
#
DROP TABLE IF EXISTS `operator rights`;
CREATE TABLE `operator rights` (
`id` int(11) unsigned NOT NULL auto_increment,
`operator` int(11) unsigned default NULL,
`modul program` int(11) unsigned default NULL,
PRIMARY KEYÂ (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table operator rights
#
#
# Table structure for table operator status
#
DROP TABLE IF EXISTS `operator status`;
CREATE TABLE `operator status` (
`id` int(11) unsigned NOT NULL auto_increment,
`nama` varchar(30) default NULL,
PRIMARY KEYÂ (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table operator status
#
#
# Table structure for table operator
#
DROP TABLE IF EXISTS `operator`;
CREATE TABLE `operator` (
`id` int(11) unsigned NOT NULL auto_increment,
`waktu entri` datetime default NULL,
`kode` varchar(15) default NULL,
`nama` varchar(40) default NULL,
`password` varchar(40) default NULL,
`on computer` varchar(40) default NULL,
`on user` varchar(40) default NULL,
`operator status` tinyint(3) unsigned default NULL,
PRIMARY KEYÂ (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table operator
#
#
# Table structure for table pelanggan
#
DROP TABLE IF EXISTS `pelanggan`;
CREATE TABLE `pelanggan` (
`id` int(11) unsigned NOT NULL auto_increment,
`nama` varchar(40) default NULL,
`alamat` varchar(40) default NULL,
`telepon` varchar(15) default NULL,
PRIMARY KEYÂ (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table pelanggan
#
#
# Table structure for table penjualan detil
#
DROP TABLE IF EXISTS `penjualan detil`;
CREATE TABLE `penjualan detil` (
`id` int(11) unsigned NOT NULL auto_increment,
`penjualan` int(11) unsigned default NULL,
`nomor` int(11) unsigned default NULL,
`barang` int(11) unsigned default NULL,
`satuan` varchar(15) default NULL,
`unit harga` decimal(12,2) unsigned NOT NULL default ’0.00′,
`jml harga` decimal(11,2) unsigned NOT NULL default ’0.00′,
PRIMARY KEYÂ (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table penjualan detil
#
#
# Table structure for table penjualan
#
DROP TABLE IF EXISTS `penjualan`;
CREATE TABLE `penjualan` (
`id` int(11) unsigned NOT NULL auto_increment,
`kode` varchar(10) default NULL,
`pelanggan` int(11) unsigned default NULL,
`keterangan` varchar(40) default NULL,
`nomor order` varchar(15) default NULL,
`sub total` decimal(12,2) unsigned NOT NULL default ’0.00′,
`discount` decimal(12,2) unsigned NOT NULL default ’0.00′,
`grand total` decimal(12,2) unsigned default NULL,
`dibayar` decimal(12,2) unsigned default NULL,
`lunas` varchar(10) default NULL,
`operator` int(11) unsigned default NULL,
PRIMARY KEYÂ (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table penjualan
#
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
This post has been viewed 40 times.
No related posts.
