search

bachtiar-madya-p / IO_ASSET-V3.0

1 stars 1 forks source link

create CRUD vendor #54

Closed bachtiar-madya-p closed 4 years ago

bachtiar-madya-p commented 4 years ago

values


CREATE TABLE `mastervendor` (
  `vendorid` varchar(50) NOT NULL,
  `vendorcode` varchar(50) NOT NULL,
  `vendorname` varchar(100) NOT NULL,
  `contact` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `address` text NOT NULL,
  `note` text NOT NULL,
  `rate` int(11) NOT NULL,
  `registered` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`vendorid`)
)DEFAULT CHARSET=latin1