diff options
author | Smita Kumari <kumarismita62@gmail.com> | 2014-05-20 20:36:12 +0400 |
---|---|---|
committer | Smita Kumari <kumarismita62@gmail.com> | 2014-05-26 21:43:03 +0400 |
commit | 200737bccef0125c56410911893d12c719f62e49 (patch) | |
tree | 49b6f00e2c29bc680f931153b366a7da024d97a1 /examples | |
parent | 161d22a58725eaec512cdedad72f7e6861102abc (diff) |
gsoc:central list of columns, added sync and remove column list on db_structure page
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
fixing indentation in mult_submits.inc.php
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
naming convention,typos, indentaion fix and removed unnecessory file db_sync_central_columns.php
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
check if central columns storage is configured, if not configured don't show the option to sync/remove
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
add/remove columns to central list of columns from tbl_structure page
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
added icon image for central columns add/delete
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
add/remove of columns option in tbl_structure page in columns rows depending upon if column is already present in central columns or not
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
fixed php notices, apporiprate message when a non existing column is removed and when a existing column is added to cenral list
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
documentation added for central_columns configuration
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
regenerated sprite
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
changed central_columns table structure + modified functions to add to central column as per new tbl def
updated delete and other function as per new db structure
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
remove notices
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
sprintf for variable message
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
fix unit test failure errors
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
fixed whitespace issues plus function definition
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
refactoring code plus fixing coding style issues
Signed-off-by: Smita Kumari <kumarismita62@gmail.com>
Diffstat (limited to 'examples')
-rw-r--r-- | examples/config.manyhosts.inc.php | 1 | ||||
-rw-r--r-- | examples/create_tables.sql | 19 |
2 files changed, 20 insertions, 0 deletions
diff --git a/examples/config.manyhosts.inc.php b/examples/config.manyhosts.inc.php index bced1fca2c..7d4d1fa98e 100644 --- a/examples/config.manyhosts.inc.php +++ b/examples/config.manyhosts.inc.php @@ -48,4 +48,5 @@ foreach ($hosts as $host) { $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches'; + $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns'; } diff --git a/examples/create_tables.sql b/examples/create_tables.sql index 953a4b6bbc..f0a3e39a7d 100644 --- a/examples/create_tables.sql +++ b/examples/create_tables.sql @@ -317,3 +317,22 @@ CREATE TABLE IF NOT EXISTS `pma__savedsearches` ( ) COMMENT='Saved searches' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `pma__central_columns` +-- + +CREATE TABLE IF NOT EXISTS `pma__central_columns` ( + `db_name` varchar(64) NOT NULL, + `col_name` varchar(64) NOT NULL, + `col_type` varchar(64) NOT NULL, + `col_collation` varchar(64) NOT NULL, + `col_isNull` boolean NOT NULL, + `col_extra` varchar(255) default '', + `col_default` text default '', + PRIMARY KEY (`db_name`,`col_name`) +) + COMMENT='Central list of columns' + DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
\ No newline at end of file |