--
-- tests for upgrade paths
--
CREATE EXTENSION pg_hint_plan VERSION "1.3.0";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.3.1";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.3.2";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.3.3";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.3.4";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.3.5";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.3.6";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.3.7";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.3.8";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.3.9";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.3.10";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.4";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.4.1";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.4.2";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.4.3";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.5";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.5.1";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.5.2";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.6.0";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.6.1";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

ALTER EXTENSION pg_hint_plan UPDATE TO "1.7.0";
\dx+ pg_hint_plan
Objects in extension "pg_hint_plan"
       Object description        
---------------------------------
 sequence hint_plan.hints_id_seq
 table hint_plan.hints
 type hint_plan.hints
 type hint_plan.hints[]
(4 rows)

\d hint_plan.hints
                               Table "hint_plan.hints"
      Column      |  Type   | Collation | Nullable |             Default              
------------------+---------+-----------+----------+----------------------------------
 id               | integer |           | not null | generated by default as identity
 query_id         | bigint  |           | not null | 
 application_name | text    |           | not null | 
 hints            | text    |           | not null | 
Indexes:
    "hints_pkey" PRIMARY KEY, btree (id)
    "hints_id_and_app" UNIQUE, btree (query_id, application_name)

DROP EXTENSION pg_hint_plan;