diff options
author | Madhura Jayaratne <madhura.cj@gmail.com> | 2015-06-30 23:27:38 +0300 |
---|---|---|
committer | Madhura Jayaratne <madhura.cj@gmail.com> | 2015-07-02 18:33:57 +0300 |
commit | 545db4a44353e0ee70a1a93ea01dce4d5c4cad70 (patch) | |
tree | 8cc592657975caecc316941fac2442f732d03224 /sql | |
parent | 89b75b3a4e94fb33e427281dce12fe474c248291 (diff) |
rfe #812 store export definitions for reuse
Signed-off-by: Madhura Jayaratne <madhura.cj@gmail.com>
Diffstat (limited to 'sql')
-rw-r--r-- | sql/create_tables.sql | 19 | ||||
-rw-r--r-- | sql/create_tables_drizzle.sql | 19 |
2 files changed, 38 insertions, 0 deletions
diff --git a/sql/create_tables.sql b/sql/create_tables.sql index c24981046e..4b78a16e46 100644 --- a/sql/create_tables.sql +++ b/sql/create_tables.sql @@ -335,3 +335,22 @@ CREATE TABLE IF NOT EXISTS `pma__designer_settings` ( ) COMMENT='Settings related to Designer' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `pma__exporttemplates` +-- + +CREATE TABLE IF NOT EXISTS `pma__exporttemplates` ( + `id` int(5) unsigned NOT NULL AUTO_INCREMENT, + `username` varchar(64) COLLATE utf8_bin NOT NULL, + `db_name` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `table_name` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `template_name` varchar(64) COLLATE utf8_bin NOT NULL, + `template_data` text COLLATE utf8_bin NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `u_user_db_table_template` (`username`,`db_name`,`table_name`,`template_name`) +) + COMMENT='Saved export templates' + DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; diff --git a/sql/create_tables_drizzle.sql b/sql/create_tables_drizzle.sql index 1634225053..c3264ab6fd 100644 --- a/sql/create_tables_drizzle.sql +++ b/sql/create_tables_drizzle.sql @@ -287,3 +287,22 @@ CREATE TABLE IF NOT EXISTS `pma__designer_settings` ( ) COMMENT='Settings related to Designer' COLLATE utf8_bin; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `pma__exporttemplates` +-- + +CREATE TABLE IF NOT EXISTS `pma__exporttemplates` ( + `id` int(5) unsigned NOT NULL AUTO_INCREMENT, + `username` varchar(64) COLLATE utf8_bin NOT NULL, + `db_name` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `table_name` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `template_name` varchar(64) COLLATE utf8_bin NOT NULL, + `template_data` text COLLATE utf8_bin NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `u_user_db_table_template` (`username`,`db_name`,`table_name`,`template_name`) +) + COMMENT='Saved export templates' + COLLATE utf8_bin;
\ No newline at end of file |