TYxrY7hK

1DROP TABLE IF EXISTS memory;
2
3DROP TABLE IF EXISTS memoryMoment;
4
5DROP TABLE IF EXISTS memoryPlace;
6
7DROP TABLE IF EXISTS memoryDescription;
8
9CREATE TABLE memory
10(
11memoryID INT AUTO_INCREMENT UNIQUE NOT NULL,
12memoryName VARCHAR(255) NOT NULL,
13PRIMARY KEY(memoryID) 
14);
15
16CREATE TABLE memoryMoment
17(
18memoryMomentID INT AUTO_INCREMENT UNIQUE NOT NULL, 
19memoryMomentDate DATE NOT NULL,
20memoryMomentTime TIME NOT NULL,
21memoryID INT NOT NULL,
22PRIMARY KEY(memoryMomentID),
23FOREIGN KEY(memoryID) REFERENCES memory(memoryID) 
24);
25
26CREATE TABLE memoryPlace
27(
28memoryPlaceID INT AUTO_INCREMENT UNIQUE NOT NULL, 
29memoryPlaceName VARCHAR(255) NOT NULL,
30memoryID INT NOT NULL,
31PRIMARY KEY(memoryPlaceID),
32FOREIGN KEY(memoryID) REFERENCES memory(memoryID)  
33);
34
35CREATE TABLE memoryDescription
36(
37memoryDescriptionID INT AUTO_INCREMENT UNIQUE NOT NULL,
38memoryDescriptionFull VARCHAR(255) NOT NULL,
39memoryID INT NOT NULL,
40PRIMARY KEY(memoryDescriptionID),
41FOREIGN KEY(memoryID) REFERENCES memory(memoryID) 
42);
43
44INSERT INTO memory(memoryID,memoryName)
45VALUES(NULL,'new pet');
46INSERT INTO memory(memoryID,memoryName)
47VALUES(NULL,'gift received');
48INSERT INTO memory(memoryID,memoryName)
49VALUES(NULL,'new mobile');
50
51INSERT INTO memoryMoment(memoryMomentID,memoryMomentDate,memoryMomentTime,memoryID)
52VALUES(NULL,'2016-12-19','12:30:14',1);
53INSERT INTO memoryMoment(memoryMomentID,memoryMomentDate,memoryMomentTime,memoryID)
54VALUES(NULL,'2017-1-1','2:30:14',2);
55INSERT INTO memoryMoment(memoryMomentID,memoryMomentDate,memoryMomentTime,memoryID)
56VALUES(NULL,'2016-12-31','1:30:14',3);
57
58INSERT INTO memoryPlace(memoryPlaceID,memoryPlaceName,memoryID)
59VALUES(NULL,'DHAKA',1);
60INSERT INTO memoryPlace(memoryPlaceID,memoryPlaceName,memoryID)
61VALUES(NULL,'RANGPUR',2);
62INSERT INTO memoryPlace(memoryPlaceID,memoryPlaceName,memoryID)
63VALUES(NULL,'BARISHAL',3);
64
65INSERT INTO memoryDescription(memoryDescriptionID,memoryDescriptionFull,memoryID)
66VALUES(NULL,'I have bought a new white cat',1);
67INSERT INTO memoryDescription(memoryDescriptionID,memoryDescriptionFull,memoryID)
68VALUES(NULL,'one of my best friends have sent me a black whiteboard marker',2);
69INSERT INTO memoryDescription(memoryDescriptionID,memoryDescriptionFull,memoryID)
70VALUES(NULL,'I have bought a new samsung galaxy note IV',3);