Hi folks, I am trying to create system which will let users upload media to the server, the question that I ask is weather using a single table to store the uploaded files is better than using separate tables to store each file type in terms of coding.
Seems to me that if I use the multiple table I will be creating exactly the same data, but in a different table. Example: audios,videos,images etc.... My table structure: CREATE TABLE `uploaded_files` ( `id` int(11) unsigned NOT NULL auto_increment, `foreign_id` int(10) unsigned NOT NULL, `model` varchar(255) NOT NULL COMMENT 'Associated model name', `media` varchar(55) NOT NULL, `filename` varchar(255) default NULL, `ext` varchar(10) default NULL, `mime` varchar(55) default NULL, `filesize` int(11) NOT NULL, `webpath` varchar(255) NOT NULL COMMENT 'Web path to show file', `full_path` text NOT NULL COMMENT 'Full path to file_src', `hasThumb` tinyint(1) unsigned NOT NULL, `thumbs` text, `width` int(11) default NULL, `height` int(11) default NULL, `description` varchar(155) default NULL, `created` datetime default NULL, `updated` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; Basically, I am looking for an easy solution that will reduce the amount of code I write.... Hope some of you guys can help. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
