To some extent I agree that this is trivial but I was thinking that if the module system was built a little more dynamically allowing table_to_table integration it would allow more possibilities.
I do agree that putting everything into 1 table would make no sense.
I'm thinking 3 at the moment:
- keep setting for module position
- keep extension for main module information, could add in information for version etc ...
- table for more extensive data like html, blobs and such
(-) possibly a 4th for table_to_table reference for performance issues
here is sample of what I'm seeing:
Code: Select all
(1484, 'information', 'information_status', '1'),
(1483, 'information', 'information_position', 'footer'),
(779, 'manufacturer', 'manufacturer_sort_order', '2'),
(778, 'manufacturer', 'manufacturer_status', '0'),
(765, 'bestseller', 'bestseller_sort_order', '3'),
(764, 'bestseller', 'bestseller_status', '0'),
(763, 'bestseller', 'bestseller_position', 'right'),
(762, 'bestseller', 'bestseller_limit', '10'),
(774, 'featured', 'featured_position', 'right'),
(775, 'featured', 'featured_status', '0'),
(787, 'category', 'category_position', 'right'),
(1525, 'bottomdes', 'bottom_des_status', '1'),
(1526, 'bottomdes', 'bottom_des_sort_order', '2'),
(1523, 'bottomdes', 'bottom_des_code', 'This is the bottom description mod'),
(1494, 'mymodule', 'mymodule_position', 'footer'),
(1493, 'mymodule', 'mymodule_code1', '<p>\r\n this is the my module mod</p>\r\n'),
(1492, 'mymodule', 'mymodule_header', '0'),
(1524, 'bottomdes', 'bottom_des_position', 'footer'),
(1522, 'bottomdes', 'bottom_des_title', 'Bottom Description'),
(1491, 'mymodule', 'mymodule_title1', 'My Module Mod'),
(1485, 'information', 'information_sort_order', '1'),
(1495, 'mymodule', 'mymodule_status', '1'),
(1496, 'mymodule', 'mymodule_sort_order', '3');
I do realize that I used a 3rd party extension and will probably re-write to use a setup similar to the information module but I really do wonder if this is the best way to go for database design.
930sc ... because it is fun!
?
