CREATE TABLE User (
    u_id int unsigned not null auto_increment,
    u_name varchar(127),
    primary key (u_id)
);
CREATE TABLE Post (
    p_id int unsigned not null auto_increment,
    p_content TEXT,
    p_u_id int unsigned not null,
    primary key (p_id)
);
CREATE TABLE Comment (
    c_id int unsigned not null auto_increment,
    c_content TEXT,
    c_u_id int unsigned not null,
    c_p_id int unsigned not NULL,
    primary key (c_id)
);
-- INSERT VALUES

INSERT INTO User VALUES 
    (null,'John Doe'),
    (null,'Jane Doe'),
    (null,'Mickey Mouse'),
    (null,'Minnie Mouse');

INSERT INTO Post VALUES 
    ( null,'Here\'s my post content, rant rant rant...', 2);

INSERT INTO Comment VALUES 
    (null, 'This is my comment to your post', 1, 1),
    (null, 'Well I agree', 3, 1),
    (null, 'Well I disagree', 4, 1) ;

































