37 lines
837 B
PL/PgSQL
Executable File
37 lines
837 B
PL/PgSQL
Executable File
|
|
ALTER TABLE JIQuery
|
|
ADD COLUMN new_sql_query TEXT;
|
|
BEGIN;
|
|
UPDATE JIQuery
|
|
SET new_sql_query = sql_query;
|
|
COMMIT;
|
|
|
|
ALTER TABLE JIQuery
|
|
ALTER COLUMN new_sql_query SET NOT NULL;
|
|
|
|
ALTER TABLE JIQuery
|
|
DROP COLUMN sql_query;
|
|
ALTER TABLE JIQuery
|
|
RENAME COLUMN new_sql_query TO sql_query;
|
|
|
|
--
|
|
|
|
ALTER TABLE JIOlapUnit
|
|
ADD COLUMN new_mdx_query TEXT;
|
|
BEGIN;
|
|
UPDATE JIOlapUnit
|
|
SET new_mdx_query = mdx_query;
|
|
COMMIT;
|
|
|
|
ALTER TABLE JIOlapUnit
|
|
ALTER COLUMN new_mdx_query SET NOT NULL;
|
|
|
|
ALTER TABLE JIOlapUnit
|
|
DROP COLUMN mdx_query;
|
|
ALTER TABLE JIOlapUnit
|
|
RENAME COLUMN new_mdx_query TO mdx_query;
|
|
|
|
--
|
|
|
|
ALTER TABLE JIDataType
|
|
RENAME COLUMN maxValue TO max_value; |