Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `group` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` varchar(100) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
- CREATE TABLE IF NOT EXISTS `member` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `groupid` int(11) NOT NULL,
- `firstname` varchar(20) NOT NULL,
- `lastname` varchar(200) NOT NULL,
- `membersince` varchar(10) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement