/
all_migrations.sql
89 lines (86 loc) · 3.6 KB
/
all_migrations.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
-- migrations on .xyz
-- add typical_purposes to methods
\include 'migrations/migration_002.sql'
-- add communication_outcomes to methods
\include 'migrations/migration_003.sql'
-- add groups to users
\include 'migrations/migration_004.sql'
-- set isadmin to true for certain users
\include 'migrations/migration_007.sql'
-- new migrations
-- create types localized_value, full_file, full_link and map columns to them
-- also move issues -> general_issues, add method_types, tools_techniques and
-- types, fix data for scope_of_implementation, case_view_localized, etc.
\include 'migrations/migration_011.sql'
-- create functions get_components and get_object_title_list
-- define type full_case
\include 'migrations/migration_012.sql'
-- Data cleanup for cases.general_issues and cases.special_topics
\include 'migrations/migration_013.sql'
-- Create table tags_localized, clean up tags data
\include 'migrations/migration_014.sql'
-- data cleanup for scope_of_influence, time_limited, purposes, and approaches
-- updates to case_view_localized
\include 'migrations/migration_016.sql'
-- data cleanup on very many case fields
\include 'migrations/migration_019.sql'
-- data cleanup for scope_of_influence, participants_interactions, learning_resources
\include 'migrations/migration_021.sql'
-- Update case_view_localized
-- data cleanup for if_voting, insights_outcomes, implementers_of_change
\include 'migrations/migration_023.sql'
-- drop functions get_methods and get_organizations
-- define methods get_case_by_id() and friends
\include 'migrations/migration_024.sql'
-- type user_name
-- define function get_user_name
\include 'migrations/migration_030.sql'
-- define functions urls_to_links and urls_to_files
-- convert evaluation_report + evaluation_links
\include 'migrations/migration_031.sql'
-- move latitude & longitude to floats
-- define type full_case, drop other types
\include 'migrations/migration_033.sql'
-- migrate methods to new model and clean up
\include 'migrations/migration_034.sql'
-- migrate organizations to new model and clean up
\include 'migrations/migration_035.sql'
-- update object_short to include post_date and bookmarked
\include 'migrations/migration_036.sql'
-- create table for new localization keys
\include 'migrations/migration_037.sql'
-- create search index
\include 'migrations/migration_038.sql'
-- add columns level_complexity and purpose_method
\include 'migrations/migration_039.sql'
-- Add fallback for languages that don't have local localization
\include 'migrations/migration_040.sql'
-- Add table for storing login sessions
\include 'migrations/migration_041.sql'
-- Add columns to add completeness_enum, and set enums
-- for `case` , `organization`, and `methods`
\include 'migrations/migration_042.sql'
-- Get enums by id
\include 'migrations/migration_043.sql'
-- Add level_polarization on organizations table
\include 'migrations/migration_044.sql'
-- Add column on case table
\include 'migrations/migration_045.sql'
-- Update get_edit_authors function
\include 'migrations/migration_046.sql'
-- Create index for things
\include 'migrations/migration_047.sql'
\include 'migrations/migration_048.sql'
\include 'migrations/migration_049.sql'
\include 'migrations/migration_050.sql'
\include 'migrations/migration_051.sql'
\include 'migrations/migration_052.sql'
\include 'migrations/migration_053.sql'
\include 'migrations/migration_054.sql'
\include 'migrations/migration_055.sql'
\include 'migrations/migration_056.sql'
\include 'migrations/migration_057.sql'
\include 'migrations/migration_058.sql'
\include 'migrations/migration_059.sql'
\include 'migrations/migration_060.sql'
\include 'migrations/migration_061.sql'