search

bachtiar-madya-p / IO_ASSET-V3.0

1 stars 1 forks source link

create CRUD province #51

Closed bachtiar-madya-p closed 4 years ago

bachtiar-madya-p commented 4 years ago

values 


CREATE TABLE `masterprovince` (
  `provinceid` varchar(50) NOT NULL,
  `provincecode` varchar(20) DEFAULT NULL,
  `provincename` varchar(30) DEFAULT NULL,
  `isactive` tinyint(4) NOT NULL,
  PRIMARY KEY (`provinceid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1