login | register
Sun 12 of Oct, 2008 (12:51 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');

Permalink  •  0 Comments

Comments

Related Items

Documentation » Technical Documentation

Documentation geared towards developers and people who want to learn about the core processes of bitweaver

HEAD ON! Support has been added for Pear::DB!  •  Oracle Reservations for Two  •  ReleaseTwo: Shedding that last bits of our roots, finding the core of our being  •  getContentList  •  How to add a pagination to an object list  •  Moving bw in another directory  •  pma and mysql  •  safe mode on / open_base_dir  •  sequence and auto  •  The package I am currently developping is suddenly desactivated  •  APIDocumentation  •  Archived Picture Upload with Fisheye under Windows  •  Bitweaver and Browser Cookies  •  bitweaverCVS  •  bitweaverFeatures  •  bitweaverPerformance  •  CodingGuidelines  •  CreatingServices  •  CssSchema  •  InstallbitweaverDoc  •  IntegrationTutorial  •  LibertyFormats  •  LibertyMime  •  LibertyServices  •  phpdoc content status  •  PortingTikiWikiPackages  •  PrototypeAjaxObject  •  PrototypeReference  •  SamplePackage  •  SearchPackageDevNotes  •  TUTORIAL - Displaying Icons ONLY to AUTHORS of the page  •  Tutorial - Liberty Plugins  •  Tutorial - Liberty Plugins II  •  UsersDoc