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 ?
But while using all columns will be available to use from all databases to
users ?
Where do we keep "manage central columns list" tab ? I'm thinking Settings
menu tab will be a good place may be ?
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
2. examples/create_table.sql -> added the Table structure for table
`pma__central_columns`
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.
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]
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