login | register
Tue 18 of Nov, 2008 (15:39 UTC)

bitweaver - Web Application Framework and CMS

Web Application Framework and CMS

Refresh cache

pma and mysql

by sylvie
Monday 15 of May, 2006
Posted to sylvie's Blog
There are my pma settings for bwHead. It helps a lot to understand the bw schema with mysql
INSERT INTO `pma_relation` VALUES ('bwHead', 'liberty_comments', 'content_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'liberty_attachments', 'content_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'liberty_comments', 'parent_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'liberty_comments', 'root_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'liberty_structures', 'content_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'liberty_structures', 'root_structure_id', 'bwHead', 'liberty_structures', 'structure_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'users_groups_map', 'user_id', 'bwHead', 'users_users', 'user_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'users_groups_map', 'group_id', 'bwHead', 'users_groups', 'group_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'wiki_pages', 'content_id', 'bwHead', 'liberty_content', 'content_id');
 
INSERT INTO `pma_relation` VALUES ('bwHead', 'pigeonholes', 'content_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'pigeonholes', 'structure_id', 'bwHead', 'liberty_structures', 'structure_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'pigeonhole_members', 'parent_id', 'bwHead', 'liberty_content', 'content_id');
 
INSERT INTO `pma_relation` VALUES ('bwHead', 'stars_history', 'content_id', 'bwHead', 'liberty_content', 'content_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'stars_history', 'user_id', 'bwHead', 'users_users', 'user_id');
INSERT INTO `pma_relation` VALUES ('bwHead', 'stars', 'content_id', 'bwHead', 'liberty_content', 'content_id');
 
 
INSERT INTO `pma_table_info` ( `db_name` , `table_name` , `display_field` ) VALUES ('bwHead', 'liberty_content', 'title');
INSERT INTO `pma_table_info` ( `db_name` , `table_name` , `display_field` ) VALUES ('bwHead', 'users_users', 'login');
INSERT INTO `pma_table_info` ( `db_name` , `table_name` , `display_field` ) VALUES ('bwHead', 'users_groups', 'group_name');

Comments