Relation Between Two Tables

Hi,

I have two tables as post and gallery, and i have made a relationship gallery to post table.

My requirement is,

When user upload content it store in the post table(content field) ,

If user upload the images are video i want to store the images/video name in, gallery table and the gallery id refers to the post table. I dont know how to do it. please any one help me?

post table:

[sql]CREATE TABLE IF NOT EXISTS post (

id bigint(20) unsigned NOT NULL AUTO_INCREMENT,

user_id bigint(20) unsigned NOT NULL,

gallery_id bigint(20) unsigned NOT NULL,

content longtext,

photo varchar(128) DEFAULT NULL,

video varchar(128) DEFAULT NULL,

created timestamp NULL DEFAULT NULL,

updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (id),

KEY fk_forum_post_user (user_id),

KEY fk_forum_post_gallery (gallery_id)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

ALTER TABLE post

ADD CONSTRAINT fk_post_gallery FOREIGN KEY (gallery_id) REFERENCES gallery (id) ON DELETE CASCADE ON UPDATE CASCADE,[/sql]

gallery table

[sql]CREATE TABLE IF NOT EXISTS gallery (

id bigint(20) unsigned NOT NULL AUTO_INCREMENT,

user_id bigint(20) unsigned NOT NULL,

type int(11) NOT NULL DEFAULT ‘1’ COMMENT ‘1- Photo, 2-Video, 3-Documents, 4-Unknown’,

profile_picture varchar(50) DEFAULT NULL,

forum_image varchar(200) DEFAULT NULL,

forum_video varchar(200) DEFAULT NULL,

forum_video_link varchar(200) DEFAULT NULL,

created timestamp NULL DEFAULT NULL,

updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (id),

KEY fk_gallery_user (user_id)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=60 ;[/sql]

is any other idea is to do or how can i move forward?