Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `providers` (
- `PRV_ID` int(11) NOT NULL AUTO_INCREMENT,
- `PRV_SHORTDESC` varchar(90) DEFAULT NULL,
- `PRVDOC_NUMBER` varchar(20) DEFAULT NULL,
- `PRV_GMAP` varchar(200) DEFAULT NULL,
- `PRVADD_ADDRESS` varchar(100) DEFAULT NULL,
- `PRVADD_ADDNBR` varchar(10) DEFAULT NULL,
- `PRVADD_ZIP` varchar(12) DEFAULT NULL,
- `PRVADD_CITY` varchar(30) DEFAULT NULL,
- `ST_CODE` varchar(5) DEFAULT NULL,
- `PRVADD_ADDCOMP` varchar(50) DEFAULT NULL,
- PRIMARY KEY (`PRV_ID`)
- ) ENGINE=InnoDB AUTO_INCREMENT=7917 DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement