Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `member` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `username` varchar(50) NOT NULL,
- `password` varchar(50) NOT NULL,
- `email` varchar(100) NOT NULL,
- `contact` varchar(100) NOT NULL,
- `facebook` varchar(100) NOT NULL,
- `cnic` varchar(100) NOT NULL,
- `expertise` varchar(100) NOT NULL,
- `com_code` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `username` (`username`)
- ) ENGINE=InnoDB
- create table profileimage(
- imageid int primary key not null,
- username foreign key references member(username)
- ON DELETE CASCADE
- ON UPDATE CASCADE,
- imagepath varchar(255) not null
- );
Add Comment
Please, Sign In to add comment