• last updated 29 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Add default creation_date handling when passing null or 0 as value for that

Start postgres port

    • -0
    • +149
    ./wf-ticket-tracker/sql/postgresql/ticket-workflow-create.sql
    • -0
    • +103
    ./wf-ticket-tracker/sql/postgresql/wf-ticket-tracker-create.sql
    • -0
    • +9
    ./wf-ticket-tracker/sql/postgresql/wf-ticket-tracker-drop.sql
added more query files

    • -0
    • +46
    ./acs-workflow/www/admin/wizard/create-oracle.xql
    • -0
    • +49
    ./acs-workflow/www/admin/wizard/create-postgresql.xql
    • -0
    • +135
    ./acs-workflow/www/admin/wizard/create.xql
tested lob support for content-repository. converted photo upload in acs-subsite to use lobs instead of files

    • -11
    • +87
    ./acs-workflow/acs-workflow.info
  1. … 9 more files in changeset.
new query files

    • -0
    • +28
    ./acs-workflow/www/admin/arc-add.xql
    • -0
    • +17
    ./acs-workflow/www/admin/arc-delete.xql
    • -0
    • +20
    ./acs-workflow/www/admin/arc-edit-2.xql
    • -0
    • +46
    ./acs-workflow/www/admin/arc-edit.xql
    • -0
    • +24
    ./acs-workflow/www/admin/attribute-add-2-oracle.xql
    • -0
    • +28
    ./acs-workflow/www/admin/attribute-add-2-postgresql.xql
    • -0
    • +26
    ./acs-workflow/www/admin/attribute-add.xql
    • -0
    • +19
    ./acs-workflow/www/admin/attribute-delete-oracle.xql
    • -0
    • +17
    ./acs-workflow/www/admin/attribute-delete-postgresql.xql
    • -0
    • +29
    ./acs-workflow/www/admin/attribute-delete.xql
    • -0
    • +44
    ./acs-workflow/www/admin/attributes.xql
    • -0
    • +25
    ./acs-workflow/www/admin/case-debug-oracle.xql
    • -0
    • +25
    ./acs-workflow/www/admin/case-debug-postgresql.xql
    • -0
    • +55
    ./acs-workflow/www/admin/case-debug.xql
    • -0
    • +48
    ./acs-workflow/www/admin/cases.xql
  1. … 62 more files in changeset.
Port datamodel and add to .info file.

NB. string-package.sql has not been done, it uses user-defined types

as function parameters, and is only used in acs-notifications (once)

which is being rewritten anyway.

    • -0
    • +3
    ./acs-util/sql/postgresql/acs-util-create.sql
    • -0
    • +1
    ./acs-util/sql/postgresql/acs-util-drop.sql
    • -0
    • +71
    ./acs-util/sql/postgresql/acs-util-package.sql
    • -0
    • +116
    ./acs-util/sql/postgresql/string-package.sql
    • -0
    • +36
    ./acs-util/sql/postgresql/test/acs-util-test.sql

New info files with truncated rather than PG timestamps.

  1. … 2 more files in changeset.

Removed more of the "default '' not null" kludge.

    • -0
    • +120
    ./acs-content/sql/oracle/upgrade/upgrade-4.1-4.1.1.sql
    • -516
    • +0
    ./acs-workflow/sql/test/workflow-case-package-test.sql
  1. … 15 more files in changeset.
updated package spec to include new .xql files

1. Fixed apm_load_queries. Again? Yes, again. I fixed it real good this

time.

2. Added .xql files for acs-admin. APM .xql files have mostly but not

completely been ported. It sort of works though, cool!

1. Fixed apm_load_queries. Again? Yes, again. I fixed it real good this

time.

2. Added .xql files for acs-admin. APM .xql files have mostly but not

completely been ported. It sort of works though, cool!

    • -2
    • +2
    ./acs-workflow/tcl/workflow-procs-postgresql.xql
  1. … 60 more files in changeset.
query extraction and cleanup

    • -0
    • +50
    ./acs-workflow/tcl/display-procs-oracle.xql
    • -0
    • +50
    ./acs-workflow/tcl/display-procs-postgresql.xql
    • -0
    • +77
    ./acs-workflow/tcl/graph-procs.xql
    • -0
    • +296
    ./acs-workflow/tcl/workflow-procs-oracle.xql
    • -0
    • +281
    ./acs-workflow/tcl/workflow-procs-postgresql.xql
    • -0
    • +246
    ./acs-workflow/tcl/workflow-procs.xql
    • -0
    • +18
    ./acs-workflow/www/assign-add-postgresql.xql
    • -0
    • +35
    ./acs-workflow/www/assign-yourself-oracle.xql
    • -0
    • +31
    ./acs-workflow/www/assign-yourself-postgresql.xql
    • -0
    • +65
    ./acs-workflow/www/assign-yourself.xql
    • -0
    • +35
    ./acs-workflow/www/assignee-add-2-oracle.xql
    • -0
    • +31
    ./acs-workflow/www/assignee-add-2-postgresql.xql
    • -0
    • +53
    ./acs-workflow/www/assignee-add-2.xql
    • -0
    • +18
    ./acs-workflow/www/assignee-add-oracle.xql
    • -0
    • +18
    ./acs-workflow/www/assignee-add-postgresql.xql
  1. … 13 more files in changeset.

Forgot to define binary files before importing, so .gifs were messed up.

    • -0
    • +0
    ./bboard/sql/oracle/bboard-packages.sql
    • -0
    • +0
    ./bboard/sql/oracle/upgrade-4.0-4.0.1.sql
    • -0
    • +0
    ./bboard/sql/oracle/upgrade-4.0.2b3-4.0.2b4.sql
    • -0
    • +0
    ./bboard/sql/oracle/upgrade-4.0.2b5-4.0.2b6.sql
    • -0
    • +0
    ./bboard/sql/oracle/upgrade-4.0b-4.0.sql
  1. … 2465 more files in changeset.
Initial revision

    • -0
    • +116
    ./bboard/ChangeLog
    • -0
    • +116
    ./bboard/bboard.info
    • -0
    • +453
    ./bboard/sql/oracle/bboard-create.sql
    • -0
    • +144
    ./bboard/sql/oracle/bboard-drop.sql
    • -0
    • +571
    ./bboard/sql/oracle/bboard-packages.sql
    • -0
    • +34
    ./bboard/sql/oracle/bboard-views.sql
    • -0
    • +11
    ./bboard/sql/oracle/index_sync.sql
    • -0
    • +139
    ./bboard/sql/oracle/upgrade-4.0-4.0.1.sql
    • -0
    • +163
    ./bboard/sql/oracle/upgrade-4.0.1-4.0.2.sql
    • -0
    • +55
    ./bboard/sql/oracle/upgrade-4.0.2b3-4.0.2b4.sql
    • -0
    • +11
    ./bboard/sql/oracle/upgrade-4.0.2b5-4.0.2b6.sql
    • -0
    • +152
    ./bboard/sql/oracle/upgrade-4.0b-4.0.sql
    • -0
    • +11
    ./bboard/tcl/bboard-init.tcl
    • -0
    • +1010
    ./bboard/tcl/bboard-procs.tcl
    • -0
    • +16
    ./bboard/www/attachment-delete.tcl
  1. … 2465 more files in changeset.
added comments for default parameters

  1. … 9 more files in changeset.
added postgresql files to package info file and commented out notifications calls until notifications is ported

adding test directory to repository

    • -0
    • +587
    ./acs-workflow/sql/postgresql/test/workflow-case-package-test.sql
cleanup of dir structure

    • -346
    • +0
    ./acs-workflow/sql/upgrade/upgrade-4.0-4.0.1.sql
    • -190
    • +0
    ./acs-workflow/sql/upgrade/upgrade-4.0.1-4.1b.sql
cleanup of unused functions

cleanup of usused functions

fixed up some incompatiblities

finished porting test script

work on test script

1. Ran APM on acs-tcl.info

2. Fixed two typos by Dan in the acs-workflow datamodel.

  1. … 1 more file in changeset.
more porting

more porting

    • -0
    • +210
    ./acs-workflow/sql/postgresql/load-workflow.sql
    • -0
    • +230
    ./acs-workflow/sql/postgresql/sample-article-create.sql
    • -0
    • +20
    ./acs-workflow/sql/postgresql/sample-article-drop.sql
    • -0
    • +20
    ./acs-workflow/sql/postgresql/sample-expenses-drop.sql
applied patch from Steve Woodcock

  1. … 2 more files in changeset.
more porting

    • -0
    • +277
    ./acs-workflow/sql/postgresql/sample-expenses-create.sql
more porting

    • -0
    • +78
    ./acs-workflow/sql/postgresql/wf-core-drop.sql
more porting

    • -0
    • +18
    ./acs-workflow/sql/postgresql/acs-workflow-drop.sql
    • -0
    • +71
    ./acs-workflow/sql/postgresql/wf-callback-package.sql
    • -0
    • +647
    ./acs-workflow/sql/postgresql/workflow-package.sql
setup directory structure correctly

    • -346
    • +0
    ./acs-workflow/sql/upgrade-4.0-4.0.1.sql
    • -68
    • +0
    ./acs-workflow/sql/wf-callback-package.sql
    • -809
    • +0
    ./acs-workflow/sql/wf-core-create.sql
    • -76
    • +0
    ./acs-workflow/sql/wf-core-drop.sql
    • -1952
    • +0
    ./acs-workflow/sql/workflow-case-package.sql
    • -532
    • +0
    ./acs-workflow/sql/workflow-package.sql