· 9 years ago · Sep 30, 2016, 08:12 AM
1CREATE TABLE IF NOT EXISTS `member` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `username` varchar(50) NOT NULL,
4 `password` varchar(50) NOT NULL,
5 `email` varchar(100) NOT NULL,
6 `contact` varchar(100) NOT NULL,
7 `facebook` varchar(100) NOT NULL,
8 `cnic` varchar(100) NOT NULL,
9 `expertise` varchar(100) NOT NULL,
10 `com_code` varchar(255) DEFAULT NULL,
11 PRIMARY KEY (`id`),
12 UNIQUE KEY `username` (`username`)
13) ENGINE=InnoDB
14
15create table profileimage(
16imageid int primary key not null,
17username foreign key references member(username)
18ON DELETE CASCADE
19 ON UPDATE CASCADE,
20imagepath varchar(255) not null
21);