-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathsqitch.plan
781 lines (780 loc) · 91.3 KB
/
sqitch.plan
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
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
%syntax-version=1.0.0
%project=ccbc
revoke_function_execute 2022-09-01T16:03:01Z Matthieu Foucault <[email protected]> # revoke default function execution permission
create_roles 2022-04-11T23:46:54Z Marcel Mueller <[email protected]> # Add create_roles
schemas/public 2022-04-11T22:30:24Z Marcel Mueller <[email protected]> # Add main ccbc schema
schemas/private 2022-04-11T23:55:16Z Marcel Mueller <[email protected]> # Add private schema
types/keycloak_jwt [schemas/public] 2022-05-26T20:39:57Z Bryan Krauss <[email protected]> # keycloak jwt type
util_functions/upsert_policy [create_roles] 2022-05-26T22:06:05Z Bryan Krauss <[email protected]> # util function for working with RLS
trigger_functions/update_timestamps [schemas/private] 2022-05-27T17:34:46Z Bryan Krauss <[email protected]> # A trigger function to update timestamp in tables
trigger_functions/archived_records_are_immutable 2022-05-27T20:19:58Z Bryan Krauss <[email protected]> # trigger function for making achived rec immutable
util_functions/upsert_timestamp_columns [trigger_functions/update_timestamps] 2022-05-27T17:40:27Z Bryan Krauss <[email protected]> # A util function that add timestamps to table column
util_functions/grant_permissions [create_roles] 2022-05-17T18:13:44Z Bryan Krauss <[email protected]> # Creates util function to grant permission to different ccbc users
util_functions/verify_grants [schemas/public] 2022-05-27T20:39:15Z Bryan Krauss <[email protected]> # util function to verify grant permissions on tables
functions/session [schemas/public types/keycloak_jwt] 2022-05-27T20:29:47Z Bryan Krauss <[email protected]> # user session
tables/connect_session 2022-04-11T23:59:30Z Marcel Mueller <[email protected]> # Add connect_session table
tables/ccbc_user 2022-05-26T17:58:53Z Bryan Krauss <[email protected]> # Users table for ccbc project
mutations/create_user_from_session 2022-05-26T20:41:37Z Bryan Krauss <[email protected]> # A mutation to create a user from the session table
trigger_functions/create_intake_sequence 2022-08-23T16:32:25Z Matthieu Foucault <[email protected]> # Add a trigger function to create the intake sequence
tables/intake [trigger_functions/create_intake_sequence] 2022-07-22T15:27:16Z Anthony Bushara <[email protected]> # Creates the intake table
tables/application [tables/intake] 2022-04-11T22:31:16Z Marcel Mueller <[email protected]> # Add application table to store application data
computed_columns/application_project_name [tables/application] 2022-07-15T16:39:24Z Anthony Bushara <[email protected]> # Exposes Application Name as Computed Column
tables/application_status_type 2022-08-29T18:35:18Z Anthony Bushara <[email protected]> # Types of Statuses assignable to an application
tables/application_status 2022-07-08T13:27:08Z Marcel Mueller <[email protected]> # add table application_status
tables/attachment [tables/application] 2022-07-07T23:19:04Z Marcel Mueller <[email protected]> # add table attachment
functions/open_intake 2022-08-16T13:48:54Z Anthony Bushara <[email protected]> # Function to display the current open intake
mutations/submit_application 2022-08-23T17:18:10Z Matthieu Foucault <[email protected]> # create a mutation to submit an application
computed_columns/application_status [tables/application_status] 2022-08-30T22:06:26Z Anthony Bushara <[email protected]> # Computed column to display the current status of an application
mutations/withdraw_application [tables/application_status tables/application] 2022-08-30T22:38:37Z Anthony Bushara <[email protected]> # Mutation to withdraw an application
mutations/create_application 2022-08-31T16:16:23Z Anthony Bushara <[email protected]> # Creates a new application
@1.0.0 2022-09-01T23:42:33Z Matthieu Foucault <[email protected]> # release v1.0.0
@1.0.1 2022-09-02T00:40:17Z Matthieu Foucault <[email protected]> # release v1.0.1
@1.1.0 2022-09-06T23:59:22Z Matthieu Foucault <[email protected]> # release v1.1.0
@1.1.1 2022-09-09T20:35:47Z Marcel Mueller,,, <marcel@Thinkpad> # release v1.1.1
@1.2.0 2022-09-14T23:35:48Z Matthieu Foucault <[email protected]> # release v1.2.0
mutations/submit_application [mutations/[email protected]] 2022-09-13T19:52:43Z Marcel Mueller <[email protected]> # Check all submission fields in form_data are filled before submission
@1.3.0 2022-09-21T21:25:00Z Matthieu Foucault <[email protected]> # release v1.3.0
@1.4.0 2022-09-23T18:31:05Z Matthieu Foucault <[email protected]> # release v1.4.0
functions/next_intake 2022-09-28T21:46:58Z Marcel Mueller <[email protected]> # Function to display the next intake
@1.5.0 2022-09-28T23:08:06Z Matthieu Foucault <[email protected]> # release v1.5.0
@1.6.0 2022-10-05T17:25:28Z Matthieu Foucault <[email protected]> # release v1.6.0
tables/form_data_status_type 2022-09-27T18:54:22Z Anthony Bushara <[email protected]> # Status types of a form data
tables/form_data 2022-09-27T18:50:23Z Anthony Bushara <[email protected]> # Table to hold form data
tables/application_form_data 2022-09-28T15:36:09Z Anthony Bushara <[email protected]> # Table linking form_data and and application
computed_columns/application_form_data 2022-09-28T18:00:16Z Anthony Bushara <[email protected]> # Computed Column to expose an application's form data
mutations/create_application [mutations/[email protected]] 2022-09-29T15:38:35Z Anthony Bushara <[email protected]> # Add logic for use with application_form_data and form_data
computed_columns/application_project_name [computed_columns/[email protected]] 2022-09-29T18:50:24Z Anthony Bushara <[email protected]> # Rework to use application_form_data to access the form data
mutations/submit_application [mutations/[email protected]] 2022-09-29T18:56:58Z Anthony Bushara <[email protected]> # Rework to access form data through computed column
@1.7.0 2022-10-12T18:54:15Z Matthieu Foucault <[email protected]> # release v1.7.0
computed_columns/form_data_is_editable 2022-10-07T14:27:32Z Anthony Bushara <[email protected]> # Computed column to determine if an application's form data is editable
mutations/withdraw_application [mutations/[email protected]] 2022-10-13T12:34:25Z Anthony Bushara <[email protected]> # Add ensuring that a withdrawn application's form data is committed
tables/form_data_001_is_editable_policy 2022-10-13T16:45:08Z Anthony Bushara <[email protected]> # Adds policy to prevent a form from being edited if form_data_is_editable returns false
@1.8.0 2022-10-17T17:31:36Z Matthieu Foucault <[email protected]> # release v1.8.0
functions/receive_applications 2022-10-07T19:23:03Z Marcel Mueller <[email protected]> # Function to change the status of an application to received
create_roles [[email protected]] 2022-10-11T17:25:07Z Marcel Mueller <[email protected]> # Add ccbc_job_executor role to create_roles
ccbc_job_executor_permissions 2022-10-07T22:34:55Z Marcel Mueller <[email protected]> # Initial permissions for ccbc_job_executor
tables/application_status_type_001_add_status_received 2022-10-11T18:39:51Z Marcel Mueller <[email protected]> # Insert received application status type
computed_columns/application_status [computed_columns/[email protected]] 2022-10-17T20:08:21Z Marcel Mueller <[email protected]> # Grant execute function to ccbc_job_executor
@1.9.0 2022-10-21T15:25:23Z Marcel Mueller <[email protected]> # release v1.9.0
create_roles [[email protected]] 2022-10-20T21:44:00Z Marcel Mueller <[email protected]> # Add ccbc_analyst and ccbc_admin roles
functions/session [functions/[email protected]] 2022-10-20T21:52:01Z Marcel Mueller <[email protected]> # Grant execute on session for ccbc_analyst and ccbc_admin roles
schemas/private [schemas/[email protected]] 2022-10-20T22:24:32Z Marcel Mueller <[email protected]> # Grant private schema usage to ccbc_analyst and ccbc_admin
schemas/public [schemas/[email protected]] 2022-10-20T22:24:37Z Marcel Mueller <[email protected]> # Grant public schema usage to ccbc_analyst and ccbc_admin
functions/receive_applications [functions/[email protected]] 2022-10-21T17:50:30Z Matthieu Foucault <[email protected]> # fix permissions for ccbc_job_executor
ccbc_job_executor_permissions [[email protected]] 2022-10-21T18:05:34Z Matthieu Foucault <[email protected]> # add missing permissions for job_executor
tables/ccbc_user_001_admin_analyst_permissions 2022-10-21T19:25:33Z Marcel Mueller <[email protected]> # grant permissions on table ccbc_user to ccbc_admin and ccbc_analyst
mutations/create_user_from_session [mutations/[email protected]] 2022-10-21T19:27:58Z Marcel Mueller <[email protected]> # grant execute on function to ccbc_admin and ccbc_analyst
@1.10.0 2022-10-24T23:29:33Z Matthieu Foucault <[email protected]> # release v1.10.0
views/summary_view 2022-10-24T20:16:50Z ,,, Vladimir <[email protected]> # feat: view for metabase users
mutations/update_application_form 2022-10-25T19:15:08Z Matthieu Foucault <[email protected]> # custom mutation to update the application form data
tables/ccbc_user_001_no_unique_email 2022-10-26T19:00:26Z Matthieu Foucault <[email protected]> # remove unique constraint on email
@1.11.0 2022-10-26T19:55:03Z Marcel Mueller <[email protected]> # release v1.11.0
tables/application_001_add_analyst_permission 2022-10-24T14:56:56Z Anthony Bushara <[email protected]> # Adds the analyst permissions and RLS for the application table
tables/application_status_001_give_read_and_insert_to_ccbc_analyst 2022-10-24T17:29:23Z Anthony Bushara <[email protected]> # Gives the select and insert permission to ccbc_analyst
computed_columns/application_project_name [computed_columns/[email protected]] 2022-10-24T19:27:49Z Anthony Bushara <[email protected]> # Add ccbc_analyst to application_project_name computed column
computed_columns/application_status [computed_columns/[email protected]] 2022-10-24T19:30:15Z Anthony Bushara <[email protected]> # Add ccbc_analyst to application_status computed column
tables/application_form_data_001_add_rls_for_analyst 2022-10-24T19:51:34Z Anthony Bushara <[email protected]> # Add row level security for analyst
tables/form_data_002_add_permisions_for_analyst 2022-10-24T20:30:23Z Anthony Bushara <[email protected]> # Add permissions for analyst
computed_columns/application_organization_name 2022-10-25T15:05:18Z Anthony Bushara <[email protected]> # computed column to display the organization name for analysts
computed_columns/application_form_data [computed_columns/[email protected]] 2022-10-25T18:34:11Z Anthony Bushara <[email protected]> # Add ccbc_analyst permission
views/summary_view [views/[email protected]] 2022-10-28T18:38:28Z ,,, Vladimir <[email protected]> # drop summary_view
@1.12.0 2022-11-01T16:10:04Z Marcel Mueller <[email protected]> # release v1.12.0
@1.13.0 2022-11-03T19:19:43Z Marcel Mueller <[email protected]> # release v1.13.0
tables/analyst 2022-11-04T16:51:27Z Marcel Mueller <[email protected]> # add analyst table
computed_columns/form_data_is_editable [computed_columns/[email protected]] 2022-11-10T00:35:11Z Matthieu Foucault <[email protected]> # rewrite in sql
@1.14.0 2022-11-15T18:54:34Z Marcel Mueller <[email protected]> # release v1.14.0
@1.15.0 2022-11-15T21:08:21Z Marcel Mueller <[email protected]> # release v1.15.0
tables/form_type 2022-11-08T15:22:59Z Anthony Bushara <[email protected]> # The type of form data, used to differentiate different schemas for queries
tables/form 2022-11-03T20:31:46Z Anthony Bushara <[email protected]> # Table holding json schema for forms
tables/form_data_003_add_schema_reference 2022-11-08T16:05:05Z Anthony Bushara <[email protected]> # Adds the reference to the schema to the table
computed_columns/application_form_data [computed_columns/[email protected]] 2022-11-08T19:06:31Z Anthony Bushara <[email protected]> # Rework to ensure that form data is returning intake data
mutations/create_application [mutations/[email protected]] 2022-11-08T19:27:16Z Anthony Bushara <[email protected]> # Add form_schema to insert for form_data
mutations/submit_application [mutations/[email protected]] 2022-11-10T16:09:19Z Anthony Bushara <[email protected]> # Use the schema to get the number of acknowledgements
@1.16.0 2022-11-16T20:24:01Z Marcel Mueller <[email protected]> # release v1.16.0
@1.16.1 2022-11-17T21:45:55Z Marcel Mueller <[email protected]> # release v1.16.1
tables/analyst_001_update_names 2022-11-18T17:58:18Z Anthony Bushara <[email protected]> # Fix Carreen's name and remove Meherzad from the list
@1.16.2 2022-11-22T20:15:51Z Marcel Mueller <[email protected]> # release v1.16.2
tables/analyst_002 2022-11-15T20:15:40Z Marcel Mueller <[email protected]> # add active column to analyst table
tables/application_analyst_lead 2022-11-14T15:36:21Z Marcel Mueller <[email protected]> # add application_analyst_lead table
computed_columns/application_analyst_lead 2022-11-14T16:01:37Z Marcel Mueller <[email protected]> # add computed column application_analyst_lead
@1.17.0 2022-11-28T18:53:30Z Marcel Mueller <[email protected]> # release v1.17.0
computed_columns/application_analyst_lead [computed_columns/[email protected]] 2022-11-30T15:54:01Z Marcel Mueller <[email protected]> # refactor application_analyst_lead computed column to return null values
@1.18.0 2022-11-30T19:24:38Z Marcel Mueller <[email protected]> # release v1.18.0
tables/rfi_data_status_type 2022-11-27T22:38:12Z ,,, Vladimir <[email protected]> # add RFI status type
tables/rfi_data 2022-11-27T22:35:17Z ,,, Vladimir <[email protected]> # add table for RFI
tables/application_rfi_data 2022-11-27T22:39:18Z ,,, Vladimir <[email protected]> # add relation between application and RFI
computed_columns/application_rfi 2022-11-28T20:42:15Z ,,, Vladimir <[email protected]> # add application_rfi computed column
mutations/create_rfi 2022-11-28T22:45:40Z ,,, Vladimir <[email protected]> # add create_rfi mutation
@1.19.0 2022-12-02T22:22:21Z Marcel Mueller <[email protected]> # release v1.19.0
tables/form_type_001_add_assessment_type 2022-11-23T16:53:01Z Anthony Bushara <[email protected]> # Adds the assessment type to the form_type table
tables/form_data_004_sequence_permissions_analyst 2022-11-24T21:03:19Z Anthony Bushara <[email protected]> # Adds the select and usage permissions to analyst and admin users
mutations/create_assessment_form 2022-11-24T15:58:41Z Anthony Bushara <[email protected]> # Mutation to create an assessment form
computed_columns/application_assessment_form 2022-11-25T15:30:35Z Anthony Bushara <[email protected]> # Computed column to retrieve an assessment form based on the schema slug
computed_columns/application_form_data [computed_columns/[email protected]] 2022-11-29T16:24:19Z Anthony Bushara <[email protected]> # Rework to properly return intake form data only
tables/attachment_001_add_analyst_roles 2022-12-06T16:02:43Z Anthony Bushara <[email protected]> # Add the analyst and admin roles to attachment table
@1.20.0 2022-12-06T18:31:10Z Marcel Mueller <[email protected]> # release v1.20.0
@1.21.0 2022-12-08T14:53:31Z Anthony Bushara <[email protected]> # release v1.21.0
@1.22.0 2022-12-08T20:08:49Z Anthony Bushara <[email protected]> # release v1.22.0
@1.23.0 2022-12-11T04:15:58Z Marcel Mueller <[email protected]> # release v1.23.0
@1.23.1 2022-12-13T03:39:09Z Anthony Bushara <[email protected]> # release v1.23.1
tables/analyst_002_update_lia_lastname 2022-12-13T19:16:31Z Anthony Bushara <[email protected]> # Changes Lia's last name
computed_columns/application_status [computed_columns/[email protected]] 2022-12-13T18:14:55Z ,,, Vladimir <[email protected]> # ccbc_readonly role
mutations/update_rfi 2022-12-08T20:49:50Z Anthony Bushara <[email protected]> # Mutation to insert rather than update in place and archive previous rfis
@1.24.0 2022-12-14T19:20:34Z Marcel Mueller <[email protected]> # release v1.24.0
@1.24.1 2022-12-15T23:38:22Z Marcel Mueller <[email protected]> # release v1.24.1
@1.24.2 2022-12-16T00:33:49Z Marcel Mueller <[email protected]> # release v1.24.2
@1.25.0 2022-12-16T14:21:15Z Anthony Bushara <[email protected]> # release v1.25.0
@1.26.0 2022-12-16T15:30:52Z Marcel Mueller <[email protected]> # release v1.26.0
@1.27.0 2022-12-16T17:50:57Z Anthony Bushara <[email protected]> # release v1.27.0
@1.28.0 2022-12-16T20:26:51Z Marcel Mueller <[email protected]> # release v1.28.0
tables/application_status_type_002_add_types 2022-12-14T00:01:17Z Marcel Mueller <[email protected]> # add new status types
tables/application_status_002_change_reason 2022-12-13T20:24:06Z Marcel Mueller <[email protected]> # add change_reason column
@1.29.0 2022-12-20T22:20:22Z Marcel Mueller <[email protected]> # release v1.29.0
tables/form_data_005_add_reason_for_change 2022-12-20T18:51:09Z Marcel Mueller <[email protected]> # add reason_for_change column
mutations/create_new_form_data 2022-12-20T18:57:38Z Marcel Mueller <[email protected]> # add mutation create_new_form_data
computed_columns/form_data_is_editable [computed_columns/[email protected]] 2022-12-21T17:20:08Z Marcel Mueller <[email protected]> # add analyst permissions
functions/open_intake [functions/[email protected]] 2022-12-21T17:32:21Z Marcel Mueller <[email protected]> # add permissions for analysts
tables/intake_001_add_permissions 2022-12-21T17:39:34Z Marcel Mueller <[email protected]> # add permissions for analysts
@1.30.0 2022-12-23T22:28:13Z Marcel Mueller <[email protected]> # release v1.30.0
computed_columns/application_all_assessments 2023-01-03T21:01:13Z Marcel Mueller <[email protected]> # add computed column to return all assessments form data
mutations/create_assessment_form [mutations/[email protected]] 2023-01-03T23:26:52Z Marcel Mueller <[email protected]> # archive old assessment form
tables/rfi_data_001_allow_insert_for_ccbc_auth_user 2022-12-15T20:49:50Z Anthony Bushara <[email protected]> # Mutation to insert rather than update in place and archive previous rfis
computed_columns/application_rfi [computed_columns/[email protected]] 2022-12-22T06:24:48Z Anthony Bushara <[email protected]> # Rework to return the whole rfi row
computed_columns/application_has_rfi_open 2022-12-22T06:11:48Z Anthony Bushara <[email protected]> # Computed column to check if the application rfi is open to view and edit
@1.31.0 2023-01-05T22:43:11Z Marcel Mueller <[email protected]> # release v1.31.0
tables/assessment_type 2023-01-05T18:54:16Z Anthony Bushara <[email protected]> # Table to hold types of assessments
tables/assessment_data 2023-01-05T18:52:35Z Anthony Bushara <[email protected]> # Table to hold all assessments
@1.30.1 2023-01-05T21:02:43Z Anthony Bushara <[email protected]> # Tag to rework create_assessment
mutations/create_assessment_form [mutations/[email protected]] 2023-01-05T21:03:01Z Anthony Bushara <[email protected]> # Rework create assessments to use new table
computed_columns/application_all_assessments [computed_columns/[email protected]] 2023-01-05T23:19:47Z Anthony Bushara <[email protected]> # Rework to use new assessments table
computed_columns/application_assessment_form [computed_columns/[email protected]] 2023-01-06T12:21:13Z Anthony Bushara <[email protected]> # Use new assessment_data table for this query
@1.32.0 2023-01-06T18:38:39Z Marcel Mueller <[email protected]> # release v1.32.0
@1.33.0 2023-01-11T18:57:08Z Marcel Mueller <[email protected]> # release v1.33.0
computed_columns/application_has_rfi_open [computed_columns/[email protected]] 2023-01-11T19:48:04Z Marcel Mueller <[email protected]> # fix due date ending 1 day early
@1.34.0 2023-01-16T18:05:54Z Marcel Mueller <[email protected]> # release v1.34.0
@1.35.0 2023-01-24T18:40:51Z Marcel Mueller <[email protected]> # release v1.35.0
@1.35.1 2023-01-24T23:09:45Z Marcel Mueller <[email protected]> # release v1.35.1
@1.35.2 2023-01-25T19:12:41Z Marcel Mueller <[email protected]> # release v1.35.2
@1.36.0 2023-01-26T19:12:12Z Marcel Mueller <[email protected]> # release v1.36.0
types/keycloak_jwt_001_add_role 2023-01-20T23:06:27Z Marcel Mueller <[email protected]> # add role to keycloak_jwt type
functions/session [functions/[email protected]] 2023-01-20T23:09:42Z Marcel Mueller <[email protected]> # add role to session
@1.37.0 2023-01-27T19:18:54Z Marcel Mueller <[email protected]> # release v1.37.0
@1.38.0 2023-02-03T19:06:23Z Marcel Mueller <[email protected]> # release v1.38.0
tables/application_status_type_003_status_order 2023-01-20T15:52:39Z Anthony Bushara <[email protected]> # Adds an int column to the status type to give it an order
computed_columns/application_status_order 2023-01-20T19:57:51Z Anthony Bushara <[email protected]> # Computed column to display the order of the given application's status
tables/application_package 2023-02-02T17:45:10Z Marcel Mueller <[email protected]> # Add table application package
mutations/create_package 2023-02-03T19:14:34Z Marcel Mueller <[email protected]> # mutation to create application_package
computed_columns/application_package 2023-02-06T22:21:00Z Marcel Mueller <[email protected]> # add computed column application_package
@1.39.0 2023-02-07T19:28:09Z Marcel Mueller <[email protected]> # release v1.39.0
@1.40.0 2023-02-14T15:32:05Z Marcel Mueller <[email protected]> # release v1.40.0
@1.41.0 2023-02-14T23:42:00Z Marcel Mueller <[email protected]> # release v1.41.0
computed_columns/application_analyst_lead [computed_columns/[email protected]] 2023-02-14T21:25:03Z Anthony Bushara <[email protected]> # Add nullif to handle null rows
@1.41.1 2023-02-16T16:57:53Z Marcel Mueller <[email protected]> # release v1.41.1
computed_columns/application_intake_number 2023-02-16T15:26:28Z Anthony Bushara <[email protected]> # computed column to get intake number for sorting and filtering
@1.42.0 2023-02-22T17:51:40Z Anthony Bushara <[email protected]> # release v1.42.0
extensions/uuid 2023-02-22T02:17:14Z ,,, Vladimir <[email protected]> # add uuid-ossp
extensions/audit 2023-02-22T00:25:20Z ,,, Vladimir <[email protected]> # add audit extension
@1.43.0 2023-02-23T21:53:09Z Marcel Mueller <[email protected]> # release v1.43.0
computed_columns/application_status_sort_filter 2023-02-14T21:37:47Z Marcel Mueller <[email protected]> # computed column to return string with status order with status name appended
@1.44.0 2023-02-27T17:27:37Z Marcel Mueller <marcel@m2> # release v1.44.0
import/application 2023-02-24T02:26:52Z ,,, Vladimir <[email protected]> # add application import
import/application_status 2023-02-24T02:27:50Z ,,, Vladimir <[email protected]> # add application_status import
import/rfi_data 2023-02-24T02:28:29Z ,,, Vladimir <[email protected]> # add rfi_data import
import/attachment 2023-02-24T02:28:53Z ,,, Vladimir <[email protected]> # add attachment import
import/assessment_data 2023-02-24T02:29:22Z ,,, Vladimir <[email protected]> # add assesstment import
import/import_once 2023-02-24T02:30:52Z ,,, Vladimir <[email protected]> # run import once
backfill_history 2023-02-24T21:31:50Z ,,, Vladimir <[email protected]> # backfill history once
tables/analyst_003_permissions 2023-02-24T19:05:15Z Marcel Mueller <[email protected]> # add update and insert permissions on analyst table
@1.45.0 2023-02-28T18:53:10Z Marcel Mueller <marcel@m2> # release v1.45.0
@1.46.0 2023-03-01T20:32:23Z Anthony Bushara <[email protected]> # release v1.46.0
tables/history_item 2023-03-01T20:14:20Z ,,, Vladimir <[email protected]> # add ccbc_public.history_item
computed_columns/application_history 2023-02-28T12:50:04Z ,,, Vladimir <[email protected]> # add computed_columns/application_history
extensions/audit_form_data 2023-03-02T18:55:44Z ,,, Vladimir <[email protected]> # add form_data auditing.
@1.47.0 2023-03-03T16:44:09Z Anthony Bushara <[email protected]> # release v1.47.0
@1.47.1 2023-03-03T18:27:21Z Marcel Mueller <[email protected]> # release v1.47.1
extensions/analyst_lead 2023-03-03T18:30:34Z ,,, Vladimir <[email protected]> # enable audit for more tables
import/application_analyst_lead 2023-03-03T18:34:38Z ,,, Vladimir <[email protected]> # add backfill for application_analyst_lead table
import/application_package 2023-03-03T18:35:15Z ,,, Vladimir <[email protected]> # add backfill for application_package table
import/form_data 2023-03-03T18:35:16Z ,,, Vladimir <[email protected]> # add backfill for form_data table
backfill_history [[email protected]] 2023-03-03T18:46:15Z ,,, Vladimir <[email protected]> # add auditing for more tables
computed_columns/application_history [computed_columns/[email protected]] 2023-03-03T19:49:34Z ,,, Vladimir <[email protected]> # add history for more tables
@1.48.0 2023-03-06T20:33:13Z Marcel Mueller <marcel@m2> # release v1.48.0
import/application [import/[email protected]] 2023-03-06T22:00:03Z ,,, Vladimir <[email protected]> # fix error in deduplication clause
import/application_status [import/[email protected]] 2023-03-06T22:01:50Z ,,, Vladimir <[email protected]> # fix error in deduplication clause
import/application_package [import/[email protected]] 2023-03-06T22:02:10Z ,,, Vladimir <[email protected]> # fix error in deduplication clause
import/application_analyst_lead [import/[email protected]] 2023-03-06T22:02:20Z ,,, Vladimir <[email protected]> # fix error in deduplication clause
import/assessment_data [import/[email protected]] 2023-03-06T22:02:39Z ,,, Vladimir <[email protected]> # fix error in deduplication clause
import/form_data [import/[email protected]] 2023-03-06T22:02:46Z ,,, Vladimir <[email protected]> # fix error in deduplication clause
import/rfi_data [import/[email protected]] 2023-03-06T22:02:52Z ,,, Vladimir <[email protected]> # fix error in deduplication clause
backfill_history [[email protected]] 2023-03-06T22:08:20Z ,,, Vladimir <[email protected]> # fix backfill issues
@1.48.1 2023-03-06T22:44:08Z Marcel Mueller <marcel@m2> # release v1.48.1
tables/gapless_counter 2023-02-17T16:03:16Z Anthony Bushara <[email protected]> # Table used to generate gapless sequences
tables/intake_002_add_reference_to_counter 2023-02-21T16:10:57Z Anthony Bushara <[email protected]> # Adds a fk to the counter table for gapless sequence
util_functions/increment_counter 2023-02-23T20:14:42Z Anthony Bushara <[email protected]> # Function to increment counter
mutations/submit_application [mutations/[email protected]] 2023-02-21T16:24:39Z Anthony Bushara <[email protected]> # Rework submit applications to use gapless counter
mutations/create_intake 2023-02-24T16:15:43Z Anthony Bushara <[email protected]> # Function to create an intake
tables/intake_003_add_insert_permissions 2023-02-27T15:20:58Z Anthony Bushara <[email protected]> # Adds insert and update on intakes
tables/intake_004_drop_trigger 2023-02-27T16:38:34Z Anthony Bushara <[email protected]> # Removes trigger from intake table
@1.49.0 2023-03-07T22:02:11Z Marcel Mueller <marcel@m2> # release v1.49.0
import/application [import/[email protected]] 2023-03-08T21:53:17Z ,,, Vladimir <[email protected]> # fix import script
import/application_status [import/[email protected]] 2023-03-08T21:53:18Z ,,, Vladimir <[email protected]> # fix import script
import/application_package [import/[email protected]] 2023-03-08T21:53:19Z ,,, Vladimir <[email protected]> # fix import script
import/application_analyst_lead [import/[email protected]] 2023-03-08T21:53:19Z ,,, Vladimir <[email protected]> # fix import script
import/assessment_data [import/[email protected]] 2023-03-08T21:53:20Z ,,, Vladimir <[email protected]> # fix import script
import/form_data [import/[email protected]] 2023-03-08T21:53:21Z ,,, Vladimir <[email protected]> # fix import script
import/rfi_data [import/[email protected]] 2023-03-08T21:53:21Z ,,, Vladimir <[email protected]> # fix import script
import/attachment [import/[email protected]] 2023-03-08T21:53:22Z ,,, Vladimir <[email protected]> # fix import script
backfill_history [[email protected]] 2023-03-08T21:53:23Z ,,, Vladimir <[email protected]> # fix import script
computed_columns/application_history [computed_columns/[email protected]] 2023-03-08T23:37:07Z ,,, Vladimir <[email protected]> # fix application_status change history
tables/history_item [tables/[email protected]] 2023-03-10T20:03:50Z ,,, Vladimir <[email protected]> # add index
@1.50.0 2023-03-14T18:28:42Z Marcel Mueller <marcel@m2> # release v1.50.0
@1.51.0 2023-03-15T19:25:12Z Marcel Mueller <[email protected]> # release v1.51.0
computed_columns/application_history [computed_columns/[email protected]] 2023-03-15T15:14:14Z Anthony Bushara <[email protected]> # fix history to include unassigning an analyst
@1.52.0 2023-03-20T16:33:20Z Anthony Bushara <[email protected]> # release v1.52.0
@1.53.0 2023-03-21T18:11:27Z Anthony Bushara <[email protected]> # release v1.53.0
@1.54.0 2023-03-24T20:37:51Z Marcel Mueller <[email protected]> # release v1.54.0
tables/conditional_approval_data 2023-03-14T15:29:41Z Marcel Mueller <marcel@m2> # add conditional_approval_data table
mutations/create_conditional_approval 2023-03-14T16:19:19Z Marcel Mueller <marcel@m2> # add create_conditional_approval mutation
computed_columns/application_conditional_approval 2023-03-14T16:19:04Z Marcel Mueller <marcel@m2> # add conditional_approval computed column
computed_columns/application_history [computed_columns/[email protected]] 2023-03-24T21:58:49Z Marcel Mueller <[email protected]> # add support for conditional_approval_data
@1.55.0 2023-03-27T17:01:16Z Marcel Mueller <[email protected]> # release v1.55.0
@1.56.0 2023-03-28T23:13:22Z Marcel Mueller <marcel@m2> # release v1.56.0
tables/gis_data 2023-03-29T20:05:35Z ,,, Vladimir <[email protected]> # add gis_data
types/gis_data_item 2023-03-29T20:06:00Z ,,, Vladimir <[email protected]> # add gis_data_item type
computed_columns/application_gis_data 2023-03-29T20:16:18Z ,,, Vladimir <[email protected]> # add application_gis_data function
mutations/save_gis_data 2023-03-29T21:14:07Z ,,, Vladimir <[email protected]> # add save_gis_data mutation
@1.57.0 2023-04-04T23:13:20Z Anthony Bushara <[email protected]> # release v1.57.0
@1.57.1 2023-04-05T15:44:41Z Anthony Bushara <[email protected]> # release v1.57.1
@1.57.2 2023-04-05T18:15:50Z Anthony Bushara <[email protected]> # release v1.57.2
mutations/create_rfi [mutations/[email protected]] 2023-04-05T14:33:20Z Anthony Bushara <[email protected]> # Rework to fix error where an RFI is counting the number of archived RFIs
@1.58.0 2023-04-12T13:13:45Z Anthony Bushara <[email protected]> # release v1.58.0
tables/application_status_type_004_analyst_visible 2023-04-06T14:20:04Z Anthony Bushara <[email protected]> # Adds a column that will prevent analysts from seeing a status type
tables/application_status_type_005_add_applicant_conditionally_approved 2023-04-06T19:23:17Z Anthony Bushara <[email protected]> # Add a conditionally approved that is visible to the applicant but not visible to analysts
mutations/submit_conditionally_approved 2023-04-05T19:09:21Z Anthony Bushara <[email protected]> # Mutation to both submit the conditional approval and change the status of an application to Conditionally Approved
computed_columns/application_analyst_status 2023-04-07T18:49:51Z Anthony Bushara <[email protected]> # Computed column to display only the most recent visible status for an analyst
computed_columns/application_external_status 2023-04-06T20:02:51Z Rafael Solorzano <[email protected]> # Computed column to return external status of an application
tables/application_gis_data 2023-04-09T10:07:08Z ,,, Vladimir <[email protected]> # add application_gis_data table
mutations/parse_gis_data 2023-04-12T21:46:04Z ,,, Vladimir <[email protected]> # add parse_gis_data mutation
@1.59.0 2023-04-14T18:07:03Z Marcel Mueller <[email protected]> # release v1.59.0
tables/history_item [tables/[email protected]] 2023-04-14T22:42:36Z Marcel Mueller <[email protected]> # fix history index migration error
@1.59.1 2023-04-14T22:58:16Z Marcel Mueller <[email protected]> # release v1.59.1
@1.59.2 2023-04-17T22:21:41Z Marcel Mueller <[email protected]> # release v1.59.2
import/application_status_archived 2023-04-17T23:46:04Z ,,, Vladimir <[email protected]> # backfill archived_at and archived_by columns in application_status table
backfill_archived_statuses 2023-04-17T23:53:23Z ,,, Vladimir <[email protected]> # add archived_at and archived_by columns to application_status table and backfill them
trigger_functions/set_archived 2023-04-17T23:55:02Z ,,, Vladimir <[email protected]> # add set_archived trigger
util_functions/upsert_archive_trigger 2023-04-17T23:56:44Z ,,, Vladimir <[email protected]> # add upsert_archive_trigger
tables/application_status_003_archive_trigger 2023-04-17T23:57:32Z ,,, Vladimir <[email protected]> # add changes to application_status table
mutations/create_rfi [mutations/[email protected]] 2023-04-17T22:32:48Z Anthony Bushara <[email protected]> # Rework to no longer use the count
@1.60.0 2023-04-18T16:11:47Z Anthony Bushara <[email protected]> # release v1.60.0
create_roles [[email protected]] 2023-04-19T12:35:54Z Anthony Bushara <[email protected]> # Add role for trigger function that gives it update permission on all statuses
tables/application_status_004_archiver_role_permissions 2023-04-19T13:00:16Z Anthony Bushara <[email protected]> # give archiver role permissions for the application_status stable
schemas/public [schemas/[email protected]] 2023-04-19T13:25:08Z Anthony Bushara <[email protected]> # Add ccbc_archiver to schema
trigger_functions/set_archived [trigger_functions/[email protected]] 2023-04-19T13:15:14Z Anthony Bushara <[email protected]> # Use new archiver role rather than postgres
functions/session [functions/[email protected]] 2023-04-19T15:08:12Z Anthony Bushara <[email protected]> # Add ccbc_archiver to use session function
tables/ccbc_user_003_grant_archiver_select_permission 2023-04-19T15:15:38Z Anthony Bushara <[email protected]> # grants the archiver select permission to ccbc_archiver
@1.61.0 2023-04-19T17:42:53Z Anthony Bushara <[email protected]> # release v1.61.0
tables/ccbc_user_004_add_external_analyst 2023-04-19T23:06:12Z Marcel Mueller <[email protected]> # Add column external_analyst
mutations/create_user_from_session [mutations/[email protected]] 2023-04-19T23:13:17Z Marcel Mueller <[email protected]> # update for external_analyst
tables/history_item_001_add_external_analyst 2023-04-19T23:15:09Z Marcel Mueller <[email protected]> # add external_analyst column
computed_columns/application_history [computed_columns/[email protected]] 2023-04-19T23:19:30Z Marcel Mueller <[email protected]> # add support for external_analyst
tables/announcement 2023-04-20T21:39:01Z ,,, Vladimir <[email protected]> # add table announcement
tables/application_announcement 2023-04-20T21:39:28Z ,,, Vladimir <[email protected]> # add table application_announcement
mutations/create_announcement 2023-04-20T21:41:18Z ,,, Vladimir <[email protected]> # add mutation create_announcement
@1.62.0 2023-04-21T16:03:56Z Marcel Mueller <[email protected]> # release v1.62.0
computed_columns/application_gis_data [computed_columns/[email protected]] 2023-04-24T16:19:26Z Marcel Mueller <[email protected]> # update to return application_gis_data row
tables/application_gis_assessment_hh 2023-04-24T20:24:07Z Marcel Mueller <marcel@m2> # add new table application_gis_assessment_hh
mutations/save_gis_assessment_hh 2023-04-24T21:11:50Z Marcel Mueller <marcel@m2> # add mutation save_gis_assessment_hh
computed_columns/application_gis_assessment_hh 2023-04-24T22:36:59Z Marcel Mueller <marcel@m2> # add computed_column application_gis_assessment_hh
types/gis_data_count 2023-04-25T17:28:56Z ,,, Vladimir <[email protected]> # add type gis_data_count
computed_columns/gis_data_counts 2023-04-25T17:38:30Z ,,, Vladimir <[email protected]> # add function gis_data_counts
mutations/parse_gis_data [mutations/[email protected]] 2023-04-25T19:05:31Z ,,, Vladimir <[email protected]> # updated mutations/parse_gis_data
@1.63.0 2023-04-27T21:09:29Z Marcel Mueller <marcel@m2> # release v1.63.0
@1.64.0 2023-05-02T18:26:07Z Marcel Mueller <marcel@m2> # release v1.64.0
tables/application_announcement_add_primary 2023-05-01T21:08:27Z ,,, Vladimir <[email protected]> # add primary/secondary flag to application_announcement
computed_columns/application_announcements 2023-05-01T18:48:50Z ,,, Vladimir <[email protected]> # add application_all_announcements computed column
mutations/update_announcement 2023-05-01T19:48:50Z ,,, Vladimir <[email protected]> # add update_announcement mutation
mutations/create_announcement [mutations/[email protected]] 2023-05-01T21:38:15Z ,,, Vladimir <[email protected]> # update mutations/create_announcement_record to handle is_primary flag
computed_columns/gis_data_counts [computed_columns/[email protected]] 2023-04-28T19:19:49Z Anthony Bushara <[email protected]> # rework to set as stable rather than volatile
@1.65.0 2023-05-03T17:17:51Z Anthony Bushara <[email protected]> # release v1.65.0
@1.65.1 2023-05-04T21:56:33Z Marcel Mueller <[email protected]> # release v1.65.1
extensions/application_gis_data.sql 2023-05-02T23:37:03Z Rafael Solorzano <[email protected]> # enable audit on application gis data table
import/application_gis_data 2023-05-03T15:18:01Z Rafael Solorzano <[email protected]> # application gis data import
@1.66.0 2023-05-09T18:48:28Z Anthony Bushara <[email protected]> # release v1.66.0
computed_columns/application_history [computed_columns/[email protected]] 2023-05-05T20:17:01Z Rafael Solorzano <[email protected]> # add application_gis_data table to history
computed_columns/gis_data_counts [computed_columns/[email protected]] 2023-05-09T21:24:49Z Rafael Solorzano <[email protected]> # rework logic for gis counts and add unchanged and unmatched
@1.67.0 2023-05-12T16:49:45Z Anthony Bushara <[email protected]> # release v1.67.0
mutations/delete_announcement 2023-05-08T13:00:07Z ,,, Vladimir <[email protected]> # add custom delete_announcement mutation
computed_columns/application_announcements [computed_columns/[email protected]] 2023-05-18T00:08:11Z ,,, Vladimir <[email protected]> # update application_announcement to skip archived
@1.68.0 2023-05-17T13:26:00Z Anthony Bushara <[email protected]> # release v1.68.0
@1.69.0 2023-05-19T22:45:23Z ,,, <runner@fv-az482-816> # release v1.69.0
@1.70.0 2023-05-24T15:48:59Z Marcel Mueller <marcel@m2> # release v1.70.0
extensions/audit_announcement 2023-05-15T17:58:18Z Marcel Mueller <[email protected]> # enable history tracking for announcement table
tables/application_announcement_001_operation 2023-05-15T18:59:55Z Marcel Mueller <[email protected]> # add column history_operation
mutations/update_announcement [mutations/[email protected]] 2023-05-15T19:21:35Z Marcel Mueller <[email protected]> # add support for history_operation column
computed_columns/application_history [computed_columns/[email protected]] 2023-05-15T19:27:02Z Marcel Mueller <[email protected]> # add support for announcement history
mutations/delete_announcement [mutations/[email protected]] 2023-05-23T17:29:11Z Marcel Mueller <marcel@m2> # add support for announcement history
tables/application_sow_data 2023-05-17T17:26:00Z ,,, Vladimir <[email protected]> # add table application_sow_data
tables/sow_tab_2 2023-05-17T17:26:00Z ,,, Vladimir <[email protected]> # add table sow_tab_2
@1.71.0 2023-05-30T01:15:12Z Marcel Mueller <[email protected]> # release v1.71.0
tables/sow_tab_1 2023-05-29T14:44:45Z Anthony Bushara <[email protected]> # Table to hold the first sow tab from the excel file
@1.72.0 2023-05-31T21:28:13Z Marcel Mueller <[email protected]> # release v1.72.0
tables/project_information_data 2023-05-25T20:56:37Z Marcel Mueller <marcel@m2> # form data for project information form
mutations/create_project_information 2023-05-25T21:27:43Z Marcel Mueller <marcel@m2> # add mutation create project information
computed_columns/application_project_information 2023-05-25T23:41:42Z Marcel Mueller <marcel@m2> # add computed column project_information
tables/sow_tab_7.sql 2023-05-30T21:52:57Z Rafael Solorzano <[email protected]> # Table to hold the seventh tab from the sow Excel file
extensions/audit_sow 2023-06-01T21:52:15Z Marcel Mueller <marcel@m2> # enable history tracking for sow and project information
computed_columns/application_history [computed_columns/[email protected]] 2023-06-01T21:58:05Z Marcel Mueller <marcel@m2> # return history for project_information_data table
tables/sow_tab_8 2023-06-01T20:02:07Z Vladimir <[email protected]> # add table sow_tab_8
@1.73.0 2023-06-02T21:24:39Z Marcel Mueller <marcel@m2> # release v1.73.0
@1.73.1 2023-06-02T22:54:19Z Marcel Mueller <marcel@m2> # release v1.73.1
computed_columns/application_history [computed_columns/[email protected]] 2023-06-07T18:22:26Z Rafael Solorzano <[email protected]> # enable updated for rfi data
@1.74.0 2023-06-09T16:27:00Z Marcel Mueller <[email protected]> # release v1.74.0
@1.75.0 2023-06-13T21:48:06Z Anthony Bushara <[email protected]> # release v1.75.0
tables/application_status_type_006_add_new_types 2023-06-12T23:08:53Z Marcel Mueller <marcel@m2> # add new status types
@1.76.0 2023-06-22T17:20:00Z Anthony Bushara <[email protected]> # release v1.76.0
tables/change_request_data 2023-06-20T20:07:25Z Marcel Mueller <marcel@m2> # add table change request data
mutations/create_change_request 2023-06-20T21:20:49Z Marcel Mueller <marcel@m2> # add mutation create_change_request
tables/sow_grant_update 2023-06-14T22:46:52Z Rafael Solorzano <[email protected]> # grant update for archive purposes
mutations/create_application_sow 2023-06-22T20:36:51Z Rafael Solorzano <[email protected]> # create application sow data with archive
mutations/archive_application_sow 2023-06-22T22:50:07Z Rafael Solorzano <[email protected]> # archive all sow data based on application id
@1.77.0 2023-06-26T17:18:08Z CCBC Service Account <[email protected]> # release v1.77.0
computed_columns/application_history [computed_columns/[email protected]] 2023-06-23T19:08:54Z Anthony Bushara <[email protected]> # Include change_request_data
@1.78.0 2023-06-26T21:52:30Z CCBC Service Account <[email protected]> # release v1.78.0
@1.79.0 2023-06-27T16:48:31Z CCBC Service Account <[email protected]> # release v1.79.0
tables/application_sow_data_001_amendment 2023-06-23T16:58:42Z Marcel Mueller <[email protected]> # add amendment_number and is_amendment columns
mutations/create_application_sow_data 2023-06-23T17:25:15Z Marcel Mueller <[email protected]> # add mutation create_application_sow_data
mutations/create_application_sow [mutations/[email protected]] 2023-06-26T20:33:40Z Marcel Mueller <[email protected]> # drop mutation and use create_application_sow_data instead
mutations/archive_application_sow [mutations/[email protected]] 2023-06-26T20:54:06Z Marcel Mueller <[email protected]> # update archive mutation to use amendment_number
tables/json_data_comments 2023-06-28T22:21:45Z ,,, Vladimir <[email protected]> # add markup comments to json_data fields
mutations/parse_gis_data [mutations/[email protected]] 2023-06-28T15:06:06Z Marcel Mueller <[email protected]> # parse gis data based on application status
computed_columns/gis_data_counts [computed_columns/[email protected]] 2023-06-28T18:09:01Z Marcel Mueller <[email protected]> # update gis data counts to check application status
@1.80.0 2023-06-30T15:39:41Z CCBC Service Account <[email protected]> # release v1.80.0
@1.80.1 2023-06-30T21:21:00Z CCBC Service Account <[email protected]> # release v1.80.1
tables/json_data_comments [tables/[email protected]] 2023-06-30T18:50:17Z ,,, Vladimir <[email protected]> # updated links to schema viewer
missing_metadata 2023-06-29T16:55:38Z Marcel Mueller <[email protected]> # add missing table and column descriptions
@1.81.0 2023-07-04T19:55:10Z CCBC Service Account <[email protected]> # release v1.81.0
@1.81.1 2023-07-05T16:57:56Z CCBC Service Account <[email protected]> # release v1.81.1
@1.82.0 2023-07-05T21:51:43Z CCBC Service Account <[email protected]> # release v1.82.0
@1.83.0 2023-07-11T16:02:18Z CCBC Service Account <[email protected]> # release v1.83.0
@1.84.0 2023-07-12T22:34:04Z CCBC Service Account <[email protected]> # release v1.84.0
mutations/create_change_request [mutations/[email protected]] 2023-07-07T19:07:03Z Marcel Mueller <marcel@m2> # update mutation for different amendment number handling
tables/change_request_data_001_amendment 2023-07-07T19:08:14Z Marcel Mueller <marcel@m2> # change change_request_number column to amendment_number
@1.85.0 2023-07-13T18:29:11Z CCBC Service Account <[email protected]> # release v1.85.0
@1.86.0 2023-07-14T15:29:48Z CCBC Service Account <[email protected]> # release v1.86.0
@1.87.0 2023-07-18T21:39:36Z CCBC Service Account <[email protected]> # release v1.87.0
computed_columns/application_amendment_numbers 2023-07-11T22:45:39Z Marcel Mueller <marcel@m2> # computed column to return string of all amendment numbers
mutations/create_change_request [mutations/[email protected]] 2023-07-18T23:00:53Z Marcel Mueller <marcel@m2> # use row id to archive old change request
@1.88.0 2023-07-20T18:14:45Z CCBC Service Account <[email protected]> # release v1.88.0
@1.88.1 2023-07-20T20:21:29Z CCBC Service Account <[email protected]> # release v1.88.1
@1.89.0 2023-07-26T14:39:02Z CCBC Service Account <[email protected]> # release v1.89.0
@1.90.0 2023-07-27T16:25:53Z CCBC Service Account <[email protected]> # release v1.90.0
tables/intake_005_add_description 2023-07-19T23:20:24Z Marcel Mueller <marcel@m2> # add description column
functions/next_intake [functions/[email protected]] 2023-07-24T20:08:07Z Marcel Mueller <marcel@m2> # grant analyst permissions
mutations/create_intake [mutations/[email protected]] 2023-07-24T21:51:46Z Marcel Mueller <marcel@m2> # add description input and verify intake number
mutations/archive_application 2023-07-26T22:48:25Z Rafael Solorzano <[email protected]> # functionality to archive application and its form data
mutations/archive_intake 2023-07-27T15:39:07Z Marcel Mueller <marcel@m2> # add mutation to soft delete/archive intake
tables/intake_006_partial_unique 2023-07-27T20:03:03Z Marcel Mueller <marcel@m2> # drop unique constraint and add partial unique index
@1.91.0 2023-08-02T21:36:10Z CCBC Service Account <[email protected]> # release v1.91.0
tables/application_community_progress_report_data 2023-08-03T18:33:03Z Rafael Solorzano <[email protected]> # create community progress report table
@1.92.0 2023-08-04T20:51:41Z CCBC Service Account <[email protected]> # release v1.92.0
functions/extract_uuids 2023-08-03T19:24:48Z Anthony Bushara <[email protected]> # Utility function to extract uuids out of any jsonb provided
computed_columns/rfi_data_attachments 2023-08-04T16:23:42Z Anthony Bushara <[email protected]> # Computed column to provide all attachments rows of an rfi
mutations/update_application_form [mutations/[email protected]] 2023-07-26T15:04:47Z Anthony Bushara <[email protected]> # Reject if updated_at does not match
tables/application_community_report_excel_data 2023-08-02T21:46:28Z Marcel Mueller <[email protected]> # add table to store community report data
mutations/create_application_community_report_excel_data 2023-08-03T14:31:46Z Marcel Mueller <[email protected]> # add mutation to create community report excel data
@1.93.0 2023-08-09T16:44:16Z CCBC Service Account <[email protected]> # release v1.93.0
@1.93.1 2023-08-09T21:51:31Z CCBC Service Account <[email protected]> # release v1.93.1
computed_columns/application_zones 2023-08-08T19:53:49Z Rafael Solorzano <[email protected]> # get zone from application
computed_columns/application_zone 2023-08-08T23:18:42Z Rafael Solorzano <[email protected]> # single zone returned as integer for sorting purposes
mutations/create_application_community_progress_report_data 2023-08-04T22:38:04Z Marcel Mueller <marcel@m2> # add mutation to create community progress data
tables/application_community_progress_report_data_001 2023-08-08T19:31:35Z Marcel Mueller <marcel@m2> # add update permissions
mutations/create_application_community_report_excel_data [mutations/[email protected] @1.93.1] 2023-08-09T21:56:56Z Marcel Mueller <marcel@m2> # add argument for old report id
tables/application_community_progress_report_data_002.sql 2023-08-09T22:24:14Z Marcel Mueller <marcel@m2> # add column excel_data_id
mutations/archive_application_community_progress_report 2023-08-10T17:18:29Z Marcel Mueller <marcel@m2> # mutations to archive community progress report form and excel data
@1.94.0 2023-08-11T19:28:01Z CCBC Service Account <[email protected]> # release v1.94.0
@1.94.1 2023-08-11T22:08:15Z CCBC Service Account <[email protected]> # release v1.94.1
functions/next_intake [functions/[email protected]] 2023-08-14T20:10:54Z Marcel Mueller <marcel@m2> # return only intakes where archived_at is null
functions/open_intake [functions/[email protected]] 2023-08-14T20:21:04Z Marcel Mueller <marcel@m2> # return only intakes where archived_at is null
functions/receive_applications [functions/[email protected]] 2023-08-14T21:26:26Z Marcel Mueller <marcel@m2> # select intake where archived at is null
mutations/update_application_form [mutations/[email protected]] 2023-08-14T20:22:39Z Tony Bushara <tonybushara@pop-os> # Increase the buffer time to 3 seconds
@1.95.0 2023-08-15T17:59:22Z CCBC Service Account <[email protected]> # release v1.95.0
@1.96.0 2023-08-16T23:11:14Z CCBC Service Account <[email protected]> # release v1.96.0
mutations/create_project_information [mutations/[email protected]] 2023-08-17T23:04:04Z Tony Bushara <tonybushara@pop-os> # Check if there is no file and archive sow data
mutations/create_change_request [mutations/[email protected]] 2023-08-18T14:39:12Z Tony Bushara <tonybushara@pop-os> # Archive relevant sow data if statementOfWork is removed
mutations/create_application_community_progress_report_data [mutations/[email protected]] 2023-08-18T16:22:50Z Tony Bushara <tonybushara@pop-os> # Create the community progress report data and archive old excel data if no file is present
mutations/update_intake 2023-08-15T19:56:30Z Marcel Mueller <[email protected]> # mutation to update an intake
@1.97.0 2023-08-18T22:52:11Z CCBC Service Account <[email protected]> # release v1.97.0
tables/application_claims_data 2023-08-18T21:23:37Z Marcel Mueller <marcel@m2> # add table to store claims form data
mutations/create_application_claims_data 2023-08-18T21:49:29Z Marcel Mueller <marcel@m2> # mutation to create application claims data
tables/application_claims_excel_data 2023-08-22T16:17:35Z Marcel Mueller <marcel@m2> # add table to store application claims excel data
mutations/create_application_claims_excel_data 2023-08-22T16:49:23Z Marcel Mueller <marcel@m2> # add mutation to create application claims excel data
mutations/archive_application_claims_data 2023-08-22T22:16:21Z Marcel Mueller <marcel@m2> # mutation to archive claims data and associated excel data
@1.98.0 2023-08-23T20:35:43Z CCBC Service Account <[email protected]> # release v1.98.0
extensions/application_community_progress_report 2023-08-19T17:52:32Z ,,, Vladimir <[email protected]> # enable audit for application_community_progress_report
import/application_community_progress_report 2023-08-19T17:56:56Z ,,, Vladimir <[email protected]> # backfill audit history for application_community_progress_report_data
backfill_application_cpr_history 2023-08-19T18:02:43Z ,,, Vladimir <[email protected]> # backfill application_community_progress_report_data audit history
computed_columns/application_history [computed_columns/[email protected]] 2023-08-19T18:09:03Z ,,, Vladimir <[email protected]> # add history of application_community_progress_report_data changes
tables/application_community_progress_report_data_003 2023-08-25T02:14:35Z ,,, Vladimir <[email protected]> # update table application_community_progress_report_data to track delete operation
mutations/delete_community_progress_report 2023-08-25T02:18:31Z ,,, Vladimir <[email protected]> # add delete commpunty progress report mutation
@1.99.0 2023-08-30T20:25:21Z CCBC Service Account <[email protected]> # release v1.99.0
@1.100.0 2023-08-31T16:22:05Z CCBC Service Account <[email protected]> # release v1.100.0
@1.101.0 2023-08-31T18:26:25Z CCBC Service Account <[email protected]> # release v1.101.0
@1.102.0 2023-09-05T21:25:38Z CCBC Service Account <[email protected]> # release v1.102.0
mutations/archive_application_community_progress_report [mutations/[email protected]] 2023-09-04T22:46:10Z ,,, Vladimir <[email protected]> # merge with delete_community_progress_report
tables/application_milestone_data 2023-09-07T20:54:15Z Marcel Mueller <marcel@m2> # table to store the application milestone form data
tables/application_milestone_excel_data 2023-09-07T21:09:27Z Marcel Mueller <marcel@m2> # add table to store milestone excel data
mutations/create_application_milestone_data 2023-09-07T21:13:57Z Marcel Mueller <marcel@m2> # mutation to create application milestone data
mutations/create_application_milestone_excel_data 2023-09-07T21:36:50Z Marcel Mueller <marcel@m2> # mutations to create application_milestone_excel_data
@1.103.0 2023-09-11T16:04:04Z CCBC Service Account <[email protected]> # release v1.103.0
@1.103.1 2023-09-11T16:23:54Z CCBC Service Account <[email protected]> # release v1.103.1
mutations/update_application_form [mutations/[email protected]] 2023-09-06T16:04:25Z Marcel Mueller <marcel@m2> # fix incorrect out of sync error
@1.104.0 2023-09-13T19:39:26Z CCBC Service Account <[email protected]> # release v1.104.0
tables/application_milestone_data_001 2023-09-12T17:52:00Z Marcel Mueller <marcel@m2> # add column history_operation
mutations/archive_application_milestone_data 2023-09-12T18:07:10Z Marcel Mueller <marcel@m2> # mutation to archive milestone data and associated excel data
@1.105.0 2023-09-15T20:46:03Z CCBC Service Account <[email protected]> # release v1.105.0
@1.106.0 2023-09-26T21:05:23Z CCBC Service Account <[email protected]> # release v1.106.0
@1.106.1 2023-09-26T22:05:33Z CCBC Service Account <[email protected]> # release v1.106.1
mutations/submit_application [mutations/[email protected]] 2023-09-26T21:09:06Z Rafael Solorzano <[email protected]> # update form schema id on application submission
computed_columns/form_data_is_editable [computed_columns/[email protected]] 2023-09-29T16:07:53Z Marcel Mueller <marcel@m2> # fix bug where applicants can edit received applications
tables/cbc_project 2023-09-26T21:27:57Z Marcel Mueller <marcel@m2> # table to store data imported from the CBC project spreadsheet
mutations/create_cbc_project 2023-09-26T21:54:55Z Marcel Mueller <marcel@m2> # mutation to create cbc_project data and archive previous one
@1.107.0 2023-10-03T18:42:12Z CCBC Service Account <[email protected]> # release v1.107.0
tables/application_002_add_internal_description 2023-10-03T17:21:27Z Marcel Mueller <marcel@m2> # add column internal_project_description
mutations/withdraw_application [mutations/[email protected]] 2023-10-03T21:09:05Z Marcel Mueller <marcel@m2> # add status checks for withdraw
tables/application_002_analyst_can_see_withdrawn 2023-10-04T15:10:26Z Anthony Bushara <[email protected]> # Change RLS to allow analysts to be able to see withdrawn applications
@1.108.0 2023-10-06T16:42:37Z CCBC Service Account <[email protected]> # release v1.108.0
tables/application_internal_description 2023-10-06T16:21:58Z Marcel Mueller <marcel@m2> # add table for application internal description
mutations/create_application_internal_description 2023-10-06T17:05:19Z Marcel Mueller <marcel@m2> # mutation to create application_internal_description and archive previous one
computed_columns/application_internal_description 2023-10-06T17:46:17Z Marcel Mueller <marcel@m2> # computed column to return the internal description associated with an application
@1.109.0 2023-10-10T20:48:37Z CCBC Service Account <[email protected]> # release v1.109.0
create_roles [[email protected]] 2023-10-05T21:31:05Z Rafael Solorzano <[email protected]> # add service account role
schemas/public [schemas/[email protected]] 2023-10-05T22:18:46Z Rafael Solorzano <[email protected]> # grant usage to service account role to ccbc_public
functions/session [functions/[email protected]] 2023-10-05T22:21:49Z Rafael Solorzano <[email protected]> # grant usage to service account
tables/ccbc_user_005_grant_service_account_permissions 2023-10-05T22:40:21Z Rafael Solorzano <[email protected]> # grant service accounts permissions to ccbc_user
tables/cbc_project_001_grant_service_account_permissions 2023-10-05T22:51:30Z Rafael Solorzano <[email protected]> # grant service account permissions cbc_project table
mutations/create_cbc_project [mutations/[email protected]] 2023-10-05T22:53:00Z Rafael Solorzano <[email protected]> # grant service account permissions
tables/application_status_type_007_add_analyst_withdrawn 2023-10-04T15:19:28Z Marcel Mueller <marcel@m2> # add analyst_withdrawn status
@1.110.0 2023-10-12T22:32:08Z CCBC Service Account <[email protected]> # release v1.110.0
tables/application_claims_data_001 2023-10-12T17:42:41Z Marcel Mueller <marcel@m2> # add column to track history operation
mutations/archive_application_claims_data [mutations/[email protected]] 2023-10-12T18:01:52Z Marcel Mueller <marcel@m2> # set history operation when archiving
mutations/create_application_claims_data [mutations/[email protected]] 2023-10-12T18:41:38Z Marcel Mueller <marcel@m2> # set history operation to 'updated' if there is a previous claim
computed_columns/application_history [computed_columns/[email protected]] 2023-10-12T20:25:06Z Marcel Mueller <marcel@m2> # update to return application_claims_data
@1.111.0 2023-10-17T18:45:05Z CCBC Service Account <[email protected]> # release v1.111.0
@1.112.0 2023-10-17T23:11:50Z CCBC Service Account <[email protected]> # release v1.112.0
computed_columns/application_history [computed_columns/[email protected]] 2023-10-17T20:40:41Z Rafael Solorzano <[email protected]> # add milestone data for history
mutations/create_application_milestone_data [mutations/[email protected]] 2023-10-17T22:58:21Z Rafael Solorzano <[email protected]> # add logic for updated
mutations/create_application_claims_excel_data [mutations/[email protected]] 2023-10-18T19:07:12Z Tony Bushara <tonybushara@pop-os> # Change logic to archive all previous claim numbers
@1.113.0 2023-10-18T23:13:32Z CCBC Service Account <[email protected]> # release v1.113.0
tables/intake_007_add_hidden_column 2023-10-10T20:07:15Z Anthony Bushara <[email protected]> # Add a hidden column for the intake table
functions/open_intake [functions/[email protected]] 2023-10-10T21:28:16Z Anthony Bushara <[email protected]> # Check if intake is hidden
functions/next_intake [functions/[email protected]] 2023-10-12T19:27:39Z Anthony Bushara <[email protected]> # Use hidden column when determining next intake
tables/intake_008_hidden_code_column 2023-10-13T15:21:38Z Anthony Bushara <[email protected]> # Adds the hidden code that is used to compare when accessing a hidden intake
functions/open_hidden_intake 2023-10-16T15:00:43Z Tony Bushara <tonybushara@pop-os> # Checks if there is an open hidden intake
mutations/create_application [mutations/[email protected]] 2023-10-16T20:36:13Z Tony Bushara <tonybushara@pop-os> # Rework to accept a code for a hidden intake
computed_columns/form_data_is_editable [computed_columns/[email protected]] 2023-10-16T21:15:33Z Tony Bushara <tonybushara@pop-os> # Check if a draft form has an associated open intake. Used for hidden intakes
mutations/submit_application [mutations/[email protected]] 2023-10-17T15:02:51Z Tony Bushara <tonybushara@pop-os> # Include hidden intake for submitting an application
mutations/create_intake [mutations/[email protected]] 2023-10-17T19:46:11Z Tony Bushara <tonybushara@pop-os> # Filter out hidden intakes
functions/create_hidden_intake 2023-10-18T14:11:08Z Tony Bushara <tonybushara@pop-os> # Helper function used to create a hidden intake
functions/receive_hidden_applications 2023-10-18T14:10:43Z Tony Bushara <tonybushara@pop-os> # Function used to receive hidden applications.
@1.114.0 2023-10-20T19:07:30Z CCBC Service Account <[email protected]> # release v1.114.0
@1.114.1 2023-10-24T17:20:57Z CCBC Service Account <[email protected]> # release v1.114.1
mutations/create_new_form_data [mutations/[email protected]] 2023-10-25T18:47:42Z Rafael Solorzano <[email protected]> # grant execute to auth_user
tables/application_status_type_008_change_approved 2023-10-20T20:59:45Z Marcel Mueller <marcel@m2> # change approved status description
@1.115.0 2023-10-26T17:26:41Z CCBC Service Account <[email protected]> # release v1.115.0
mutations/update_application_form [mutations/[email protected]] 2023-10-24T17:30:30Z Marcel Mueller <marcel@m2> # update handling of multiple tabs issue
@1.116.0 2023-10-30T19:00:34Z CCBC Service Account <[email protected]> # release v1.116.0
@1.117.0 2023-10-31T15:35:25Z CCBC Service Account <[email protected]> # release v1.117.0
@1.118.0 2023-10-31T17:49:23Z CCBC Service Account <[email protected]> # release v1.118.0
@1.119.0 2023-10-31T19:53:06Z CCBC Service Account <[email protected]> # release v1.119.0
@1.120.0 2023-10-31T21:20:21Z CCBC Service Account <[email protected]> # release v1.120.0
@1.121.0 2023-10-31T22:33:15Z CCBC Service Account <[email protected]> # release v1.121.0
@1.122.0 2023-10-31T23:33:42Z CCBC Service Account <[email protected]> # release v1.122.0
@1.122.1 2023-11-29T23:50:06Z CCBC Service Account <[email protected]> # release v1.122.1
mutations/submit_application [mutations/[email protected]] 2023-11-20T22:44:09Z Rafael Solorzano <[email protected]> # add custom handler for intake 99 ccbc id
mutations/create_intake [mutations/[email protected]] 2023-11-27T22:57:40Z Rafael Solorzano <[email protected]> # make all new intakes use same gapless counter
functions/create_hidden_intake [functions/[email protected]] 2023-11-28T18:21:23Z Rafael Solorzano <[email protected]> # update counter id creation to match create intake
@1.123.0 2023-12-01T21:23:31Z CCBC Service Account <[email protected]> # release v1.123.0
@1.124.0 2023-12-07T20:57:07Z CCBC Service Account <[email protected]> # release v1.124.0
@1.125.0 2023-12-08T14:44:21Z CCBC Service Account <[email protected]> # release v1.125.0
@1.126.0 2023-12-14T15:42:47Z CCBC Service Account <[email protected]> # release v1.126.0
@1.127.0 2023-12-15T20:03:37Z CCBC Service Account <[email protected]> # release v1.127.0
@1.128.0 2023-12-20T16:21:25Z CCBC Service Account <[email protected]> # release v1.128.0
functions/receive_applications [functions/[email protected]] 2023-12-19T20:55:31Z Tony Bushara <tonybushara@pop-os> # ignore hidden intakes
computed_columns/application_history [computed_columns/[email protected]] 2023-12-19T18:50:00Z Tony Bushara <tonybushara@pop-os> # Separate update and insert for RFI
@1.129.0 2023-12-21T16:29:36Z CCBC Service Account <[email protected]> # release v1.129.0
@1.130.0 2023-12-21T19:19:35Z CCBC Service Account <[email protected]> # release v1.130.0
@1.130.1 2023-12-27T16:00:51Z CCBC Service Account <[email protected]> # release v1.130.1
@1.131.0 2023-12-28T23:14:54Z CCBC Service Account <[email protected]> # release v1.131.0
@1.132.0 2023-12-30T19:14:00Z CCBC Service Account <[email protected]> # release v1.132.0
computed_columns/application_organization_name [computed_columns/[email protected]] 2024-01-02T20:26:18Z Anthony Bushara <[email protected]> # Include option for sow data org name
@1.133.0 2024-01-03T16:32:45Z CCBC Service Account <[email protected]> # release v1.133.0
@1.133.1 2024-01-05T15:04:11Z CCBC Service Account <[email protected]> # release v1.133.1
@1.133.2 2024-01-05T19:18:21Z CCBC Service Account <[email protected]> # release v1.133.2
@1.133.3 2024-01-05T20:38:13Z CCBC Service Account <[email protected]> # release v1.133.3
@1.133.4 2024-01-05T21:54:25Z CCBC Service Account <[email protected]> # release v1.133.4
@1.133.5 2024-01-09T19:35:40Z CCBC Service Account <[email protected]> # release v1.133.5
@1.134.0 2024-01-10T22:20:15Z CCBC Service Account <[email protected]> # release v1.134.0
tables/application_sow_data_002_give_read_applicant 2024-01-04T23:42:25Z Rafael Solorzano <[email protected]> # grant read to application sow data to applicant
@1.135.0 2024-01-11T19:16:05Z CCBC Service Account <[email protected]> # release v1.135.0
tables/application_project_type 2024-01-11T22:34:33Z Rafael Solorzano <[email protected]> # add application project type table
mutations/create_project_type 2024-01-12T17:32:58Z Rafael Solorzano <[email protected]> # add project type mutation
computed_columns/application_history [computed_columns/[email protected]] 2024-01-12T21:46:32Z Rafael Solorzano <[email protected]> # add application project type history
@1.136.0 2024-01-17T00:26:57Z CCBC Service Account <[email protected]> # release v1.136.0
computed_columns/application_history [computed_columns/[email protected]] 2024-01-18T18:01:35Z ,,, <ryohani89@NH504670> # fix get correct updated user
@1.136.1 2024-01-23T17:14:39Z CCBC Service Account <[email protected]> # release v1.136.1
@1.136.2 2024-01-24T19:00:46Z CCBC Service Account <[email protected]> # release v1.136.2
mutations/create_project_information [mutations/[email protected]] 2024-01-25T19:41:20Z ,,, <ryohani89@NH504670> # fix createProjectInformation function
@1.137.0 2024-01-26T15:17:30Z CCBC Service Account <[email protected]> # release v1.137.0
@1.138.0 2024-01-30T19:59:40Z CCBC Service Account <[email protected]> # release v1.138.0
@1.138.1 2024-01-30T22:59:06Z CCBC Service Account <[email protected]> # release v1.138.1
@1.138.2 2024-02-01T14:02:01Z CCBC Service Account <[email protected]> # release v1.138.2
@1.139.0 2024-02-05T16:57:55Z CCBC Service Account <[email protected]> # release v1.139.0
@1.140.0 2024-02-14T21:22:57Z CCBC Service Account <[email protected]> # release v1.140.0
@1.141.0 2024-02-21T16:22:51Z CCBC Service Account <[email protected]> # release v1.141.0
@1.142.0 2024-02-22T16:33:07Z CCBC Service Account <[email protected]> # release v1.142.0
@1.143.0 2024-02-26T17:48:27Z CCBC Service Account <[email protected]> # release v1.143.0
@1.144.0 2024-02-29T22:01:54Z CCBC Service Account <[email protected]> # release v1.144.0
@1.145.0 2024-03-05T17:38:53Z CCBC Service Account <[email protected]> # release v1.145.0
@1.146.0 2024-03-06T16:45:55Z CCBC Service Account <[email protected]> # release v1.146.0
@1.146.1 2024-03-11T19:10:23Z CCBC Service Account <[email protected]> # release v1.146.1
tables/application_status_type_009_change_complete.sql 2024-03-13T22:45:56Z ,,, <ryohani89@NH504670> # update complete status to reporting complete
@1.147.0 2024-03-18T14:29:22Z CCBC Service Account <[email protected]> # release v1.147.0
@1.148.0 2024-03-21T17:36:22Z CCBC Service Account <[email protected]> # release v1.148.0
@1.149.0 2024-03-26T15:14:26Z CCBC Service Account <[email protected]> # release v1.149.0
@1.150.0 2024-04-03T17:16:52Z CCBC Service Account <[email protected]> # release v1.150.0
tables/analyst_add_email 2024-04-08T17:55:49Z ,,, <ryohani89@NH504670> # add analyst email column
@1.151.0 2024-04-09T15:54:16Z CCBC Service Account <[email protected]> # release v1.151.0
@1.152.0 2024-04-11T16:53:36Z CCBC Service Account <[email protected]> # release v1.152.0
@1.153.0 2024-04-11T21:27:06Z CCBC Service Account <[email protected]> # release v1.153.0
@1.154.0 2024-04-15T17:09:11Z CCBC Service Account <[email protected]> # release v1.154.0
@1.155.0 2024-04-15T20:29:12Z CCBC Service Account <[email protected]> # release v1.155.0
@1.156.0 2024-04-19T15:14:50Z CCBC Service Account <[email protected]> # release v1.156.0
@1.157.0 2024-04-25T18:44:59Z CCBC Service Account <[email protected]> # release v1.157.0
tables/email_record 2024-04-19T17:24:25Z ,,, <ryohani89@NH504670> # add email record table
tables/notification 2024-04-18T19:54:33Z ,,, <ryohani89@NH504670> # add email notification table
mutations/create_email_notifications 2024-04-21T02:42:44Z ,,, <ryohani89@NH504670> # add create email notifications mutation
clean_application_status 2024-04-24T23:07:28Z Rafael Solorzano <[email protected]> # cleans application status table by setting archived_at to ones that are missing it
@1.158.0 2024-05-02T15:58:28Z CCBC Service Account <[email protected]> # release v1.158.0
tables/application_status_type_010_closed_to_not_selected 2024-05-01T15:54:58Z Anthony Bushara <[email protected]> # Change the description of closed to not selected
@1.159.0 2024-05-08T18:59:40Z CCBC Service Account <[email protected]> # release v1.159.0
@1.160.0 2024-05-09T19:58:52Z CCBC Service Account <[email protected]> # release v1.160.0
@1.160.1 2024-05-15T16:41:31Z CCBC Service Account <[email protected]> # release v1.160.1
tables/application_pending_change_request 2024-05-03T20:55:21Z ,,, <ryohani89@NH504670> # add application pending change request table
@1.161.0 2024-05-15T17:59:55Z CCBC Service Account <[email protected]> # release v1.161.0
tables/cbc 2024-05-08T17:56:10Z Rafael Solorzano <[email protected]> # add cbc projects table for individual cbc projects
tables/cbc_data 2024-05-08T18:08:06Z Rafael Solorzano <[email protected]> # table to hold the json data for individual cbc projects
mutations/create_pending_change_request 2024-05-22T16:44:01Z ,,, <ryohani89@NH504670> # add create application pending change request mutation
@1.162.0 2024-05-23T21:23:23Z CCBC Service Account <[email protected]> # release v1.162.0
@1.162.1 2024-05-30T16:25:42Z CCBC Service Account <[email protected]> # release v1.162.1
tables/application_gis_assessment_hh_001 2024-05-15T20:36:30Z Anthony Bushara <[email protected]> # gis hh has upsert columns
extensions/application_gis_assessment_hh_history 2024-05-15T19:51:28Z Anthony Bushara <[email protected]> # Enable audit tracking on gis assessment hh
computed_columns/application_history [computed_columns/[email protected]] 2024-05-15T19:31:39Z Anthony Bushara <[email protected]> # Rework to include updates to application_gis_data
tables/cbc_application_pending_change_request 2024-05-30T13:31:09Z ,,, <ryohani89@NH504670> # add cbc pending change request Table
mutations/create_cbc_pending_change_request 2024-05-30T13:49:25Z ,,, <ryohani89@NH504670> # add create_cbc_pending_change_request mutation
computed_columns/application_organization_name [computed_columns/[email protected]] 2024-05-30T18:09:08Z ,,, <ryohani89@NH504670> # fix: allow applicant to access organization name
create_roles [[email protected]] 2024-05-08T20:04:36Z Anthony Bushara <[email protected]> # Add cbc_admin role
tables/cbc_data_001_permissions 2024-05-10T15:14:19Z Anthony Bushara <[email protected]> # Add permissions to new table for users
@1.163.0 2024-06-03T22:07:04Z CCBC Service Account <[email protected]> # release v1.163.0
@1.164.0 2024-06-05T15:55:33Z CCBC Service Account <[email protected]> # release v1.164.0
tables/cbc_data_change_reason 2024-05-31T19:02:06Z Anthony Bushara <[email protected]> # Table to track change request reasons when updating cbc data
@1.165.0 2024-06-06T17:35:38Z CCBC Service Account <[email protected]> # release v1.165.0
@1.166.0 2024-06-18T17:34:45Z CCBC Service Account <[email protected]> # release v1.166.0
@1.166.1 2024-06-24T22:31:57Z CCBC Service Account <[email protected]> # release v1.166.1
@1.166.2 2024-06-26T18:05:15Z CCBC Service Account <[email protected]> # release v1.166.2
@1.166.3 2024-07-08T18:49:10Z CCBC Service Account <[email protected]> # release v1.166.3
@1.166.4 2024-07-08T21:04:20Z CCBC Service Account <[email protected]> # release v1.166.4
@1.166.5 2024-07-09T15:58:06Z CCBC Service Account <[email protected]> # release v1.166.5
@1.166.6 2024-07-09T17:17:11Z CCBC Service Account <[email protected]> # release v1.166.6
@1.167.0 2024-07-09T17:33:31Z CCBC Service Account <[email protected]> # release v1.167.0
@1.167.1 2024-07-09T18:00:55Z CCBC Service Account <[email protected]> # release v1.167.1
@1.167.2 2024-07-09T23:08:56Z CCBC Service Account <[email protected]> # release v1.167.2
tables/intake_009_add_rolling_intake_column 2024-06-26T21:40:13Z ,,, <ryohani89@NH504670> # Add rolling_intake column to intake table
mutations/submit_application [mutations/[email protected]] 2024-06-27T18:21:31Z ,,, <ryohani89@NH504670> # update submit application to go to recieve status
mutations/create_intake [mutations/[email protected]] 2024-06-28T14:03:53Z ,,, <ryohani89@NH504670> # change create intake mutation to accept rolling flag
mutations/update_intake [mutations/[email protected]] 2024-06-28T22:32:24Z ,,, <ryohani89@NH504670> # change update intake mutation to accept rolling flag
@1.168.0 2024-07-10T13:35:28Z CCBC Service Account <[email protected]> # release v1.168.0
tables/cbc_application_pending_change_request_001_service_account 2024-07-09T22:28:27Z Rafael Solorzano <[email protected]> # grant service account access to cbc application pending change request table
@1.168.1 2024-07-10T23:15:41Z CCBC Service Account <[email protected]> # release v1.168.1
@1.169.0 2024-07-15T16:45:30Z CCBC Service Account <[email protected]> # release v1.169.0
@1.170.0 2024-07-15T22:43:25Z CCBC Service Account <[email protected]> # release v1.170.0
@1.170.1 2024-07-16T16:43:02Z CCBC Service Account <[email protected]> # release v1.170.1
@1.170.2 2024-07-16T17:23:18Z CCBC Service Account <[email protected]> # release v1.170.2
@1.170.3 2024-07-16T20:42:51Z CCBC Service Account <[email protected]> # release v1.170.3
@1.170.4 2024-07-16T22:11:15Z CCBC Service Account <[email protected]> # release v1.170.4
tables/communities_source_data 2024-06-14T15:26:49Z ,,, <ryohani89@NH504670> # add communities source data Table
tables/cbc_project_communities 2024-06-14T16:27:57Z ,,, <ryohani89@NH504670> # add cbc project communities Table
@1.171.0 2024-07-16T22:33:19Z CCBC Service Account <[email protected]> # release v1.171.0
@1.171.1 2024-07-16T23:03:28Z CCBC Service Account <[email protected]> # release v1.171.1
@1.171.2 2024-07-17T13:56:50Z CCBC Service Account <[email protected]> # release v1.171.2
@1.172.0 2024-07-17T14:12:14Z CCBC Service Account <[email protected]> # release v1.172.0
computed_columns/application_history [computed_columns/[email protected]] 2024-06-10T21:11:06Z Anthony Bushara <[email protected]> # Add application sow data to history
@1.173.0 2024-07-18T17:55:13Z CCBC Service Account <[email protected]> # release v1.173.0
@1.173.1 2024-07-19T14:19:13Z CCBC Service Account <[email protected]> # release v1.173.1
@1.173.2 2024-07-19T15:08:32Z CCBC Service Account <[email protected]> # release v1.173.2
@1.174.0 2024-07-19T21:16:49Z CCBC Service Account <[email protected]> # release v1.174.0
tables/application_project_type_001_modify_check_constraint 2024-07-19T20:58:37Z Rafael Solorzano <[email protected]> # modify check constraint for project type
@1.175.0 2024-07-19T21:34:53Z CCBC Service Account <[email protected]> # release v1.175.0
@1.176.0 2024-07-24T22:40:30Z CCBC Service Account <[email protected]> # release v1.176.0
@1.177.0 2024-07-26T19:55:31Z CCBC Service Account <[email protected]> # release v1.177.0
tables/application_003_add_program 2024-07-19T16:40:06Z ,,, <ryohani89@NH504670> # add program column
@1.177.1 2024-07-26T21:30:05Z CCBC Service Account <[email protected]> # release v1.177.1
tables/reporting_gcpe 2024-06-10T18:04:18Z Rafael Solorzano <[email protected]> # create reporting table for gcpe reports
@1.178.0 2024-07-26T21:54:02Z CCBC Service Account <[email protected]> # release v1.178.0
create_roles [[email protected]] 2024-07-17T20:40:52Z Rafael Solorzano <[email protected]> # create super_admin role
grant_super_admin 2024-07-17T20:43:20Z Rafael Solorzano <[email protected]> # grants analyst, ccbc and cbc admin to super_user role
@1.179.0 2024-07-29T16:16:57Z CCBC Service Account <[email protected]> # release v1.179.0
tables/application_announced 2024-07-22T20:17:52Z ,,, <ryohani89@NH504670> # add application_announced table
mutations/create_application_announced_record 2024-07-22T22:22:54Z ,,, <ryohani89@NH504670> # add create_application_announced_record
computed_columns/application_announced 2024-07-24T18:07:20Z ,,, <ryohani89@NH504670> # add application_announced computed column
computed_columns/application_history [computed_columns/[email protected]] 2024-07-31T16:19:17Z ,,, <ryohani89@NH504670> # rework history to fetch application announced history
@1.180.0 2024-08-01T18:42:47Z CCBC Service Account <[email protected]> # release v1.180.0
@1.180.1 2024-08-06T22:10:01Z CCBC Service Account <[email protected]> # release v1.180.1
computed_columns/application_project_name [computed_columns/[email protected]] 2024-08-02T20:45:20Z ,,, <ryohani89@NH504670> # Include project name from sow data
@1.180.2 2024-08-19T21:51:41Z CCBC Service Account <[email protected]> # release v1.180.2
@1.180.3 2024-08-19T22:12:14Z CCBC Service Account <[email protected]> # release v1.180.3
@1.180.4 2024-08-19T22:41:47Z CCBC Service Account <[email protected]> # release v1.180.4
tables/cbc_add_fk_update_constraint 2024-07-11T20:32:11Z Rafael Solorzano <[email protected]> # add a foreign key update cascade constraint
@1.181.0 2024-08-20T20:20:29Z CCBC Service Account <[email protected]> # release v1.181.0
@1.181.1 2024-08-22T14:38:05Z CCBC Service Account <[email protected]> # release v1.181.1
@1.181.2 2024-08-22T16:09:35Z CCBC Service Account <[email protected]> # release v1.181.2
@1.182.0 2024-08-22T16:48:01Z CCBC Service Account <[email protected]> # release v1.182.0
@1.182.1 2024-08-22T17:30:53Z CCBC Service Account <[email protected]> # release v1.182.1
@1.182.2 2024-08-22T17:54:31Z CCBC Service Account <[email protected]> # release v1.182.2
@1.183.0 2024-08-22T18:35:35Z CCBC Service Account <[email protected]> # release v1.183.0
@1.184.0 2024-08-26T16:51:24Z CCBC Service Account <[email protected]> # release v1.184.0
@1.184.1 2024-08-26T19:57:58Z CCBC Service Account <[email protected]> # release v1.184.1
@1.184.2 2024-08-26T20:34:36Z CCBC Service Account <[email protected]> # release v1.184.2
@1.185.0 2024-08-26T22:26:30Z CCBC Service Account <[email protected]> # release v1.185.0
mutations/edit_cbc_project_communities 2024-08-21T15:16:56Z Anthony Bushara <[email protected]> # Add and delete project communities to a cbc project
@1.186.0 2024-08-27T20:55:46Z CCBC Service Account <[email protected]> # release v1.186.0
@1.186.1 2024-08-27T22:52:17Z CCBC Service Account <[email protected]> # release v1.186.1
@1.186.2 2024-08-28T15:58:56Z CCBC Service Account <[email protected]> # release v1.186.2
tables/communities_source_data_001_service_account 2024-08-28T16:32:48Z Rafael Solorzano <[email protected]> # grants service account to communities source data table
@1.186.3 2024-08-28T17:01:51Z CCBC Service Account <[email protected]> # release v1.186.3
@1.186.4 2024-08-29T17:49:49Z CCBC Service Account <[email protected]> # release v1.186.4
@1.187.0 2024-08-29T20:15:20Z CCBC Service Account <[email protected]> # release v1.187.0
@1.188.0 2024-08-30T17:51:56Z CCBC Service Account <[email protected]> # release v1.188.0
@1.189.0 2024-08-30T18:07:26Z CCBC Service Account <[email protected]> # release v1.189.0
@1.189.1 2024-09-03T15:49:04Z CCBC Service Account <[email protected]> # release v1.189.1
@1.190.0 2024-09-04T19:57:18Z CCBC Service Account <[email protected]> # release v1.190.0
@1.190.1 2024-09-04T20:58:06Z CCBC Service Account <[email protected]> # release v1.190.1
@1.190.2 2024-09-04T21:14:02Z CCBC Service Account <[email protected]> # release v1.190.2
@1.190.3 2024-09-04T21:29:58Z CCBC Service Account <[email protected]> # release v1.190.3
@1.190.4 2024-09-04T21:45:26Z CCBC Service Account <[email protected]> # release v1.190.4
@1.190.5 2024-09-04T22:11:54Z CCBC Service Account <[email protected]> # release v1.190.5
@1.190.6 2024-09-04T22:32:44Z CCBC Service Account <[email protected]> # release v1.190.6
@1.190.7 2024-09-04T22:50:09Z CCBC Service Account <[email protected]> # release v1.190.7
@1.190.8 2024-09-04T23:08:50Z CCBC Service Account <[email protected]> # release v1.190.8
@1.190.9 2024-09-06T20:13:21Z CCBC Service Account <[email protected]> # release v1.190.9
@1.190.10 2024-09-10T23:10:53Z CCBC Service Account <[email protected]> # release v1.190.10
computed_columns/application_assessment_notifications 2024-09-06T21:58:13Z ,,, <ryohani89@NH504670> # Add notifications by assessment type field
@1.190.11 2024-09-12T18:13:42Z CCBC Service Account <[email protected]> # release v1.190.11
@1.190.12 2024-09-12T20:48:11Z CCBC Service Account <[email protected]> # release v1.190.12
@1.191.0 2024-09-13T18:55:40Z CCBC Service Account <[email protected]> # release v1.191.0
@1.192.0 2024-09-13T20:33:44Z CCBC Service Account <[email protected]> # release v1.192.0
@1.192.1 2024-09-16T16:43:26Z CCBC Service Account <[email protected]> # release v1.192.1
tables/cbc_data_002_enable_audit 2024-09-03T17:37:22Z Anthony Bushara <[email protected]> # Enable history tracking for cbc_data table
tables/cbc_data_003_include_change_reason 2024-09-04T15:14:09Z Anthony Bushara <[email protected]> # Refactor to include change reason on cbc_data
computed_columns/cbc_history 2024-09-03T15:16:07Z Anthony Bushara <[email protected]> # Computed column to get application history on cbc project
@1.193.0 2024-09-16T23:48:28Z CCBC Service Account <[email protected]> # release v1.193.0
@1.193.1 2024-09-18T15:03:37Z CCBC Service Account <[email protected]> # release v1.193.1
@1.193.2 2024-09-26T16:15:41Z CCBC Service Account <[email protected]> # release v1.193.2
@1.193.3 2024-09-26T18:57:54Z CCBC Service Account <[email protected]> # release v1.193.3
@1.193.4 2024-09-26T20:12:39Z CCBC Service Account <[email protected]> # release v1.193.4
@1.193.5 2024-09-26T20:14:22Z CCBC Service Account <[email protected]> # release v1.193.5
@1.193.6 2024-09-26T21:30:05Z CCBC Service Account <[email protected]> # release v1.193.6
@1.193.7 2024-09-27T17:07:14Z CCBC Service Account <[email protected]> # release v1.193.7
@1.193.8 2024-10-01T14:54:44Z CCBC Service Account <[email protected]> # release v1.193.8
@1.193.9 2024-10-01T14:56:08Z CCBC Service Account <[email protected]> # release v1.193.9
@1.194.0 2024-10-01T15:59:19Z CCBC Service Account <[email protected]> # release v1.194.0
@1.194.1 2024-10-01T17:34:06Z CCBC Service Account <[email protected]> # release v1.194.1
@1.194.2 2024-10-01T17:35:28Z CCBC Service Account <[email protected]> # release v1.194.2
@1.195.0 2024-10-01T18:17:16Z CCBC Service Account <[email protected]> # release v1.195.0
@1.195.1 2024-10-01T19:32:15Z CCBC Service Account <[email protected]> # release v1.195.1
@1.195.2 2024-10-03T15:39:57Z CCBC Service Account <[email protected]> # release v1.195.2
@1.195.3 2024-10-03T15:51:06Z CCBC Service Account <[email protected]> # release v1.195.3
@1.195.4 2024-10-03T22:15:09Z CCBC Service Account <[email protected]> # release v1.195.4
@1.195.5 2024-10-04T20:22:04Z CCBC Service Account <[email protected]> # release v1.195.5
tables/application_er 2024-09-11T18:20:37Z Rafael Solorzano <[email protected]> # create application economic regions table
tables/application_rd 2024-09-11T18:21:13Z Rafael Solorzano <[email protected]> # create application regional district table
@1.196.0 2024-10-04T16:31:01Z CCBC Service Account <[email protected]> # release v1.196.0
@1.197.0 2024-10-04T21:12:28Z CCBC Service Account <[email protected]> # release v1.197.0
@1.197.1 2024-10-10T17:11:00Z CCBC Service Account <[email protected]> # release v1.197.1
@1.197.2 2024-10-10T22:07:55Z CCBC Service Account <[email protected]> # release v1.197.2
@1.197.3 2024-10-16T16:15:36Z CCBC Service Account <[email protected]> # release v1.197.3
clean_pre_cut_over_cbc_history 2024-10-15T23:26:47Z ,,, <ryohani89@NH504670> # Remove pre-cut-over cbc changes history
@1.197.4 2024-10-17T17:46:23Z CCBC Service Account <[email protected]> # release v1.197.4
@1.197.5 2024-10-17T18:43:02Z CCBC Service Account <[email protected]> # release v1.197.5
@1.198.0 2024-10-18T16:12:02Z CCBC Service Account <[email protected]> # release v1.198.0
@1.199.0 2024-10-18T16:28:05Z CCBC Service Account <[email protected]> # release v1.199.0
@1.200.0 2024-10-18T16:44:25Z CCBC Service Account <[email protected]> # release v1.200.0
tables/application_form_template_9_data 2024-09-25T22:50:17Z Rafael Solorzano <[email protected]> # create table for form template 9 data
@1.201.0 2024-10-18T23:20:23Z CCBC Service Account <[email protected]> # release v1.201.0
@1.201.1 2024-10-18T23:48:24Z CCBC Service Account <[email protected]> # release v1.201.1
@1.202.0 2024-10-21T21:32:01Z CCBC Service Account <[email protected]> # release v1.202.0
@1.202.1 2024-10-23T14:59:42Z CCBC Service Account <[email protected]> # release v1.202.1
@1.202.2 2024-10-23T20:54:15Z CCBC Service Account <[email protected]> # release v1.202.2
@1.203.0 2024-10-25T16:54:48Z CCBC Service Account <[email protected]> # release v1.203.0
@1.203.1 2024-10-28T19:01:53Z CCBC Service Account <[email protected]> # release v1.203.1
@1.203.2 2024-10-29T17:37:47Z CCBC Service Account <[email protected]> # release v1.203.2
@1.203.3 2024-10-29T21:17:39Z CCBC Service Account <[email protected]> # release v1.203.3
@1.203.4 2024-11-01T15:43:03Z CCBC Service Account <[email protected]> # release v1.203.4
mutations/archive_application_sow [mutations/[email protected]] 2024-10-24T19:57:11Z Anthony Bushara <[email protected]> # Add application ID to prevent archiving other applications
grant_read_access_to_service_account 2024-10-04T18:45:20Z Anthony Bushara <[email protected]> # Add read access to service account
@1.204.0 2024-11-05T20:41:06Z CCBC Service Account <[email protected]> # release v1.204.0
@1.205.0 2024-11-05T20:57:02Z CCBC Service Account <[email protected]> # release v1.205.0
@1.206.0 2024-11-07T16:34:36Z CCBC Service Account <[email protected]> # release v1.206.0
tables/application_form_template_9_data_001_add_missing_roles 2024-10-21T17:22:37Z Rafael Solorzano <[email protected]> # grant missing roles access to application template 9 table
@1.206.1 2024-11-07T22:41:03Z CCBC Service Account <[email protected]> # release v1.206.1
@1.207.0 2024-11-13T17:34:42Z CCBC Service Account <[email protected]> # release v1.207.0
@1.207.1 2024-11-15T19:50:22Z CCBC Service Account <[email protected]> # release v1.207.1
@1.207.2 2024-11-15T23:27:08Z CCBC Service Account <[email protected]> # release v1.207.2
@1.208.0 2024-11-18T17:06:11Z CCBC Service Account <[email protected]> # release v1.208.0
tables/cbc_project_communities_001_enable_tracking 2024-11-01T18:07:48Z ,,, <ryohani89@NH504670> # enable history tracking for cbc_project_communities table
computed_columns/cbc_history [computed_columns/[email protected]] 2024-11-13T22:48:20Z ,,, <ryohani89@NH504670> # combine communities data changes to cbc history
@1.209.0 2024-11-18T18:07:01Z CCBC Service Account <[email protected]> # release v1.209.0
@1.210.0 2024-11-18T22:56:15Z CCBC Service Account <[email protected]> # release v1.210.0
@1.211.0 2024-11-19T16:36:18Z CCBC Service Account <[email protected]> # release v1.211.0
@1.211.1 2024-11-19T17:21:02Z CCBC Service Account <[email protected]> # release v1.211.1
@1.211.2 2024-11-20T18:25:02Z CCBC Service Account <[email protected]> # release v1.211.2
@1.211.3 2024-11-21T16:51:48Z CCBC Service Account <[email protected]> # release v1.211.3
@1.212.0 2024-11-25T17:29:01Z CCBC Service Account <[email protected]> # release v1.212.0
@1.212.1 2024-11-26T16:42:04Z CCBC Service Account <[email protected]> # release v1.212.1
@1.212.2 2024-11-26T22:55:20Z CCBC Service Account <[email protected]> # release v1.212.2
tables/application_dependencies 2024-11-05T23:51:58Z Rafael Solorzano <[email protected]> # create application dependencies to hold crtc and connected coast
util_functions/migrate_dependencies 2024-11-06T23:05:23Z Rafael Solorzano <[email protected]> # create one time script to migrate crtc and connected coast dependencies
tables/history_item_002_add_created_by 2024-11-13T19:45:04Z Rafael Solorzano <[email protected]> # add created by to history item
computed_columns/application_history [computed_columns/[email protected]] 2024-11-07T00:23:15Z Rafael Solorzano <[email protected]> # add history for application dependencies
mutations/create_assessment_form [mutations/[email protected]] 2024-11-12T23:02:06Z Rafael Solorzano <[email protected]> # add case for application dependencies
@1.213.0 2024-11-27T00:06:15Z CCBC Service Account <[email protected]> # release v1.213.0
@1.213.1 2024-11-29T17:06:22Z CCBC Service Account <[email protected]> # release v1.213.1
@1.213.2 2024-11-29T19:45:41Z CCBC Service Account <[email protected]> # release v1.213.2
@1.213.3 2024-11-29T22:33:02Z CCBC Service Account <[email protected]> # release v1.213.3
@1.213.4 2024-12-03T16:39:29Z CCBC Service Account <[email protected]> # release v1.213.4
@1.214.0 2024-12-04T01:18:22Z CCBC Service Account <[email protected]> # release v1.214.0
@1.214.1 2024-12-04T03:24:26Z CCBC Service Account <[email protected]> # release v1.214.1
@1.214.2 2024-12-04T18:39:28Z CCBC Service Account <[email protected]> # release v1.214.2
@1.214.3 2024-12-04T21:21:10Z CCBC Service Account <[email protected]> # release v1.214.3
@1.215.0 2024-12-04T23:00:00Z CCBC Service Account <[email protected]> # release v1.215.0
@1.216.0 2024-12-09T21:27:31Z CCBC Service Account <[email protected]> # release v1.216.0
@1.216.1 2024-12-09T22:11:47Z CCBC Service Account <[email protected]> # release v1.216.1
@1.216.2 2024-12-09T23:35:46Z CCBC Service Account <[email protected]> # release v1.216.2
mutations/submit_application [mutations/[email protected]] 2024-12-09T22:24:03Z Rafael Solorzano <[email protected]> # insert TBD for dependencies on application submission
tables/application_dependencies_001_add_applicant_insert 2024-12-09T22:35:13Z Rafael Solorzano <[email protected]> # grant insert to application dependencies to applicant for submission
@1.217.0 2024-12-10T19:39:41Z CCBC Service Account <[email protected]> # release v1.217.0
@1.218.0 2024-12-10T21:09:25Z CCBC Service Account <[email protected]> # release v1.218.0
computed_columns/application_history [computed_columns/[email protected]] 2024-11-27T23:55:47Z Rafael Solorzano <[email protected]> # fix username in announcement history
@1.218.1 2024-12-18T17:53:16Z CCBC Service Account <[email protected]> # release v1.218.1
@1.218.2 2024-12-19T16:29:04Z CCBC Service Account <[email protected]> # release v1.218.2
@1.218.3 2024-12-24T20:06:08Z CCBC Service Account <[email protected]> # release v1.218.3
@1.219.0 2025-01-02T15:53:33Z CCBC Service Account <[email protected]> # release v1.219.0
@1.220.0 2025-01-02T19:26:33Z CCBC Service Account <[email protected]> # release v1.220.0
tables/coverages_upload 2024-12-19T21:24:55Z Rafael Solorzano <[email protected]> # create table to keep a record of coverages upload
@1.221.0 2025-01-03T19:56:42Z CCBC Service Account <[email protected]> # release v1.221.0
@1.221.1 2025-01-06T17:05:04Z CCBC Service Account <[email protected]> # release v1.221.1
@1.221.2 2025-01-06T18:33:09Z CCBC Service Account <[email protected]> # release v1.221.2
types/assessment_form_result 2024-12-20T14:51:59Z ,,, <ryohani89@NH504670> # add assessment_form_result type to get assessment and dependencies together
mutations/create_assessment_form [mutations/[email protected]] 2024-12-20T15:09:15Z ,,, <ryohani89@NH504670> # update create_assessment_form mutation
@1.221.3 2025-01-06T21:34:27Z CCBC Service Account <[email protected]> # release v1.221.3
@1.221.4 2025-01-06T22:46:18Z CCBC Service Account <[email protected]> # release v1.221.4
@1.222.0 2025-01-10T16:34:19Z CCBC Service Account <[email protected]> # release v1.222.0