· 8 years ago · May 11, 2018, 05:34 AM
1CREATE TABLE IF NOT EXISTS `user` (
2 `uid` INT AUTO_INCREMENT,
3 `user_name` varchar(100) NOT NULL,
4 `cid` INT NOT NULL,
5 `rid` INT NOT NULL,
6 PRIMARY KEY (`uid`),
7 FOREIGN KEY (`cid`) REFERENCES company(`cid`),
8 FOREIGN KEY (`rid`) REFERENCES role(`rid`)
9)DEFAULT CHARACTER SET latin1
10COLLATE latin1_general_cs;