diff options
| author | Deven Bansod <devenbansod.bits@gmail.com> | 2015-06-29 11:03:42 +0300 |
|---|---|---|
| committer | Deven Bansod <devenbansod.bits@gmail.com> | 2015-06-29 11:03:42 +0300 |
| commit | 2e6abf3cb25d649aee3af3ea08ab1b9c8f844114 (patch) | |
| tree | 52baf1abf0026c19e85f1f5eb7e1f08b948c088d /sql | |
| parent | e46c645837aac374e256bd21acdd4c3c13189b18 (diff) | |
Modified structure for pma__designer_settings table
Signed-off-by: Deven Bansod <devenbansod.bits@gmail.com>
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/create_tables.sql | 5 | ||||
| -rw-r--r-- | sql/create_tables_drizzle.sql | 5 |
2 files changed, 4 insertions, 6 deletions
diff --git a/sql/create_tables.sql b/sql/create_tables.sql index 5b55d1e5d7..c24981046e 100644 --- a/sql/create_tables.sql +++ b/sql/create_tables.sql @@ -330,9 +330,8 @@ CREATE TABLE IF NOT EXISTS `pma__central_columns` ( CREATE TABLE IF NOT EXISTS `pma__designer_settings` ( `username` varchar(64) NOT NULL, - `setting` varchar(64) NOT NULL, - `stored_value` varchar(64) NOT NULL, - PRIMARY KEY (`username`,`setting`) + `settings_data` text NOT NULL, + PRIMARY KEY (`username`) ) COMMENT='Settings related to Designer' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; diff --git a/sql/create_tables_drizzle.sql b/sql/create_tables_drizzle.sql index e0c8342b76..707d047354 100644 --- a/sql/create_tables_drizzle.sql +++ b/sql/create_tables_drizzle.sql @@ -282,9 +282,8 @@ CREATE TABLE IF NOT EXISTS `pma__savedsearches` ( CREATE TABLE IF NOT EXISTS `pma__designer_settings` ( `username` varchar(64) NOT NULL, - `setting` varchar(64) NOT NULL, - `stored_value` varchar(64) NOT NULL, - PRIMARY KEY (`username`,`setting`) + `settings_data` text NOT NULL, + PRIMARY KEY (`username`) ) COMMENT='Settings related to Designer' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; |