<div dir="ltr"><div><div><div>Hi,<br><br>I have started working on Central List of Columns. I had to clarify few things so writing here.<br><br>Central columns list will be stored per database, right ?<br>But while using all columns will be available to use from all databases to users ?<br>
<br>Where do we keep "manage central columns list" tab ? I'm thinking Settings menu tab will be a good place may be ?<br>This is what I have done till now:<br><br>1. config.inc.php - > added line $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';<br>
how to commit config changes ? as its in git-ignore<br><br>2. examples/create_table.sql -> added the Table structure for table `pma__central_columns`<br><br></div>3.
In General settings block on landing page -> added "Manage central
list of columns link" that goes to prefs_central_columns.php?token=XXXXXXXXXXXXXXXXXXXx<br>
</div><div>[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.<br></div><br>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]<br>
<div><br></div><div>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. <br><br></div><div>let me know if any concerns?<br>
<br></div>Thanks and Regards<br></div>- Smita<br></div>