Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `r_promojual` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `nomor` VARCHAR(15) NULL DEFAULT NULL,
- `kodebarang` VARCHAR(10) NULL DEFAULT NULL,
- `kodesupplier` VARCHAR(5) NULL DEFAULT NULL,
- `brand` VARCHAR(20) NULL DEFAULT NULL,
- `subbrand` VARCHAR(30) NULL DEFAULT NULL,
- `tgla` DATETIME NULL DEFAULT NULL,
- `tglb` DATETIME NULL DEFAULT NULL,
- `jenis` VARCHAR(15) NULL DEFAULT NULL,
- `buy` DOUBLE NULL DEFAULT 0,
- `get` DOUBLE NULL DEFAULT 0,
- `kodeget` VARCHAR(10) NULL DEFAULT NULL,
- `pricelist` VARCHAR(2) NULL DEFAULT 'T',
- `persen` DOUBLE NULL DEFAULT 0,
- `chet` VARCHAR(2) NULL DEFAULT 'T',
- `cretail` VARCHAR(2) NULL DEFAULT 'T',
- `cgrosir` VARCHAR(2) NULL DEFAULT 'T',
- `het` DOUBLE NULL DEFAULT 0,
- `tgl_input` DATETIME NULL DEFAULT current_timestamp(),
- `userid` VARCHAR(10) NULL DEFAULT NULL,
- INDEX `id` (`id`)
- )
- COLLATE='latin1_swedish_ci'
- ENGINE=MyISAM
- ROW_FORMAT=DYNAMIC
- AUTO_INCREMENT=77
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement