• last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

changed triggers to after. if set to before, you sometimes cannot delete from the tables.

fixed ec_product__new function

fixed helper function timespan_days. use float instead of varchar.

added drop function for timespan_days.

added timespan_days helper function. from OpenACS 3.2.5.

Ported data models for PostgreSQL. The data model create and drop scripts load without errors. *-sws not ported because it is not loaded by ecommerce-create.sql.

    • -0
    • +86
    ./ec-product-package-create.sql
    • -0
    • +12
    ./ec-product-package-drop.sql
    • -0
    • +50
    ./ec-product-sws-drop.sql
    • -0
    • +288
    ./ec-product-sws-setup.sql
    • -0
    • +3344
    ./ecommerce-create.sql
    • -0
    • +266
    ./ecommerce-defaults.sql
    • -0
    • +267
    ./ecommerce-drop.sql
    • -0
    • +4
    ./pl-sql-utilities-drop.sql
    • -0
    • +77
    ./pl-sql-utilities.sql