login | register
Thu 18 of Mar, 2010 (08:45 UTC)

bitweaver - Web Application Framework and CMS

Web Application Framework and CMS

Refresh cacheRSS feedPrint

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