Smita a écrit :
Hi,
I have started working on Central List of Columns. I had to clarify few things so writing here.
Central columns list will be stored per database, right ? Yes.
But while using all columns will be available to use from all databases to users ? I believe that in general, it will be better to only show the central list for the current db. There might be some cases where it's useful to show a column list for more that one db or to give a choice of db, but the UI would be too complex IMO.
Where do we keep "manage central columns list" tab ? I'm thinking Settings menu tab will be a good place may be ?
I suggest to put this link on the db Structure page, next to "Data dictionary".
This is what I have done till now:
1. config.inc.php - > added line $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns'; how to commit config changes ? as its in git-ignore No, your commit should go to config.sample.php and libraries/config.default.php.
2. examples/create_table.sql -> added the Table structure for table `pma__central_columns`
Correct.
3. In General settings block on landing page -> added "Manage central list of columns link" that goes to prefs_central_columns.php?token=XXXXXXXXXXXXXXXXXXXx [1.png] As this is a new feature, users wont be knowing anything like that exist so keeping a link at landing page that points to it should be good.
See my suggestion above. I thing that putting a link on the landing page is too prominent.
4. In the settings menu tab added another submenu "manage Central Columns List" where user can choose columns to add to the list and delete from the list.[2.png, 3.png]
See my suggestion above.
For adding the columns, we'll give users a dropdown of all databases and for selected database, checkboxes with columns name/definition to add to central list.
let me know if any concerns?
Thanks and Regards - Smita
-- Marc Delisle (phpMyAdmin)