/tags/release-0.1-rc2/hive/external/metastore/scripts/upgrade/mysql/006-HIVE-1823.mysql.sql
SQL | 8 lines | 8 code | 0 blank | 0 comment | 0 complexity | 2255edffff7b9111ef34471d76ce1a8e MD5 | raw file
1SELECT '< HIVE-1823 Upgrade the database thrift interface to allow parameters key-value pairs >' AS ' '; 2CREATE TABLE IF NOT EXISTS `DATABASE_PARAMS` ( 3 `DB_ID` bigint(20) NOT NULL, 4 `PARAM_KEY` varchar(180) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, 5 `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, 6 PRIMARY KEY (`DB_ID`,`PARAM_KEY`), 7 CONSTRAINT `DATABASE_PARAMS_FK1` FOREIGN KEY (`DB_ID`) REFERENCES `DBS` (`DB_ID`) 8) ENGINE=InnoDB DEFAULT CHARSET=latin1;