· 8 years ago · Jul 03, 2018, 07:22 AM
1DROP DATABASE IF EXISTS faceBook;
2CREATE DATABASE faceBook;
3USE faceBook;
4CREATE TABLE Account
5(
6 UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
7 UserName varchar(30) NOT NULL,
8 Password varchar(30) NOT NULL,
9 FirstName varchar(30) NOT NULL,
10 LastName varchar(30) NOT NULL
11);
12CREATE TABLE Profile
13(
14 UserName varchar(30) NOT NULL,
15 eMail varchar(30) NOT NULL,
16 Affiliation varchar(30) NOT NULL,
17 Interests varchar(30) NOT NULL,
18 BirthDay Date NOT NULL,
19 WishList varchar(100) NOT NULL,
20 FOREIGN KEY (UserName) References Account(UserName)
21);