uYpqEg4x

1CREATE DATABASE IF NOT EXISTS SOCIAL_NETWORK;
2use SOCIAL_NETWORK;
3
4CREATE TABLE IF NOT EXISTS User_(
5firstName varchar(255) NOT NULL,
6lastName varchar(255) NOT NULL,
7nickName varchar(255),
8password varchar(255) NOT NULL,
9phone varchar(255),
10email varchar(255) NOT NULL,
11gender bit NOT NULL,
12birthdate date NOT NULL,
13pic blob NOT NULL,
14homeTown varchar(255),
15maritalStatus varchar(255),
16aboutMe varchar(1000),
17
18PRIMARY KEY(email)
19);
20
21CREATE TABLE IF NOT EXISTS Friendship(
22friend1_email varchar(255) NOT NULL,
23friend2_email varchar(255) NOT NULL,
24IsFriend bit NOT NULL,
25
26PRIMARY KEY(friend1_email,friend2_email)
27);