Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+07:00";
- CREATE TABLE IF NOT EXISTS `mbank_mandiri` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `tanggal` date DEFAULT NULL,
- `keterangan` varchar(110) DEFAULT NULL,
- `debet` decimal(10,2) DEFAULT '0.00',
- `credit` decimal(10,2) DEFAULT '0.00',
- `saldo` decimal(10,2) DEFAULT '0.00',
- `retreived` datetime NOT NULL,
- `flag` tinyint(3) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- CREATE TABLE IF NOT EXISTS `mbank_logman` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `tanggal` datetime NOT NULL,
- `keterangan` varchar(100) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `tanggal` (`tanggal`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement