DROP TABLE IF EXISTS gallery;
CREATE TABLE `gallery` (
`id_gallery` int(11) NOT NULL auto_increment,
`description` varchar(150) default NULL,
PRIMARY KEY (`id_gallery`),
UNIQUE KEY `UK_galeria` (`id_gallery`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS picture;
CREATE TABLE `picture` (
`id_picture` int(11) NOT NULL auto_increment,
`id_gallery` int(11) NOT NULL default '0',
`file_name` varchar(100) default NULL,
`description` varchar(150) default NULL,
PRIMARY KEY (`id_picture`),
UNIQUE KEY `UK_foto` (`id_picture`)
) TYPE=MyISAM;
|
Download
