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:
- 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.
- examples/create_table.sql -> added the Table structure for table
`pma__central_columns`
Correct.
- 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.
- 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