OpenACS / openacs-4 / packages / ecommerce

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 17 Dec
Commits this week: 0
Total Lines of Code (LoC): 8,721
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 19 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 31 Jan 2002
7:41 am

bartt

More nextval cleanup. Removed ns_share.

Options
    • -3
    • +3
    ./postgresql/ecommerce-drop.sql
  2. … 46 more files in changeset.
Wednesday 09 Jan 2002
12:14 am

bartt

Fixed the OpenFTS search by renaming the impl name to ec_product (= the product type).

Options
    • -3
    • +3
    ./postgresql/ec-product-sc-create.sql
  2. … 1 more file in changeset.
Monday 07 Jan 2002
3:02 am

bartt

Fixed reference from ecommerce-x.sql to ec_produxt-sc-x.sql & removed spaces from datacontainer name.

Options
    • -3
    • +3
    ./postgresql/ec-product-sc-create.sql
    • -1
    • +1
    ./postgresql/ecommerce-create.sql
    • -1
    • +1
    ./postgresql/ecommerce-drop.sql
Sunday 06 Jan 2002
11:44 pm

bartt

Enabled the ecommerce products to the searched by the OpenFTS search.

Options
    • -0
    • +55
    ./postgresql/ec-product-sc-create.sql
    • -0
    • +13
    ./postgresql/ec-product-sc-drop.sql
  3. … 2 more files in changeset.
8:31 am

bartt

Added products to OpenFTS Search.

Options
    • -1
    • +3
    ./postgresql/ecommerce-create.sql
    • -0
    • +1
    ./postgresql/ecommerce-drop.sql
  3. … 1 more file in changeset.
Monday 22 Oct 2001
8:40 am

gilbertw

removed acs-geo-tables and added dependancy to ref-*

Options
    • -73
    • +0
    ./oracle/acs-geo-tables-create.sql
    • -37
    • +0
    ./oracle/acs-geo-tables-drop.sql
    • -53
    • +0
    ./oracle/acs_geo_parents.sql
    • -124
    • +0
    ./oracle/bboard-epa-regions-create.sql
    • -6602
    • +0
    ./oracle/counties-create.sql
    • -494
    • +0
    ./oracle/country-codes-create.sql
    • -335
    • +0
    ./oracle/currency-codes-create.sql
    • -7
    • +7
    ./oracle/ecommerce-create.sql
    • -149
    • +0
    ./oracle/states-create.sql
    • -73
    • +0
    ./postgresql/acs-geo-tables-create.sql
    • -37
    • +0
    ./postgresql/acs-geo-tables-drop.sql
    • -53
    • +0
    ./postgresql/acs_geo_parents.sql
    • -124
    • +0
    ./postgresql/bboard-epa-regions-create.sql
    • -6602
    • +0
    ./postgresql/counties-create.sql
    • -494
    • +0
    ./postgresql/country-codes-create.sql
  16. … 3 more files in changeset.
Saturday 25 Aug 2001
2:24 am

gilbertw

*** empty log message ***

Options
    • -1
    • +1
    ./postgresql/ecommerce-create.sql
Wednesday 22 Aug 2001
5:08 am

gilbertw

fixed trig_ec_order_state_after_tr

Options
    • -1
    • +1
    ./postgresql/ecommerce-create.sql
Tuesday 21 Aug 2001
6:43 am

gilbertw

changed number to numeric in one of the functions

Options
    • -2
    • +2
    ./postgresql/ecommerce-create.sql
Monday 20 Aug 2001
6:12 am

gilbertw

temporarily add acs-geo-tables to the ecommerce package. will remove after acs-references is completed

Options
    • -0
    • +73
    ./oracle/acs-geo-tables-create.sql
    • -0
    • +37
    ./oracle/acs-geo-tables-drop.sql
    • -0
    • +53
    ./oracle/acs_geo_parents.sql
    • -0
    • +124
    ./oracle/bboard-epa-regions-create.sql
    • -0
    • +6602
    ./oracle/counties-create.sql
    • -0
    • +494
    ./oracle/country-codes-create.sql
    • -0
    • +335
    ./oracle/currency-codes-create.sql
    • -0
    • +4
    ./oracle/ecommerce-create.sql
    • -0
    • +3
    ./oracle/ecommerce-drop.sql
    • -0
    • +149
    ./oracle/states-create.sql
6:04 am

gilbertw

added acs-geo-tables to the ecommerce package as a temporary solution until acs-references is completed

Options
    • -0
    • +73
    ./postgresql/acs-geo-tables-create.sql
    • -0
    • +37
    ./postgresql/acs-geo-tables-drop.sql
    • -0
    • +53
    ./postgresql/acs_geo_parents.sql
    • -0
    • +124
    ./postgresql/bboard-epa-regions-create.sql
    • -0
    • +6602
    ./postgresql/counties-create.sql
    • -0
    • +494
    ./postgresql/country-codes-create.sql
    • -0
    • +335
    ./postgresql/currency-codes-create.sql
    • -0
    • +4
    ./postgresql/ecommerce-create.sql
    • -0
    • +1
    ./postgresql/ecommerce-drop.sql
    • -0
    • +149
    ./postgresql/states-create.sql
Sunday 22 Jul 2001
9:06 am

gilbertw

fixed trigger for address_id insert

Options
    • -1
    • +1
    ./postgresql/ecommerce-create.sql
7:20 am

gilbertw

fixed date calculation for one_if_within_n_days

Options
    • -1
    • +1
    ./postgresql/pl-sql-utilities.sql
7:09 am

gilbertw

fixed trigger for credit card. it needs to be before updates to the ec_financial_tranactions table.

Options
    • -1
    • +1
    ./postgresql/ecommerce-create.sql
6:42 am

gilbertw

fixed ec_order_cost plpgsql function

Options
    • -0
    • +2
    ./postgresql/ecommerce-create.sql
Friday 20 Jul 2001
9:00 am

gilbertw

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

Options
    • -34
    • +34
    ./postgresql/ecommerce-create.sql
Wednesday 18 Jul 2001
7:39 am

gilbertw

fixed ec_product__new function

Options
    • -21
    • +16
    ./postgresql/ec-product-package-create.sql
Monday 16 Jul 2001
10:08 pm

gilbertw

fixed helper function timespan_days. use float instead of varchar.

Options
    • -2
    • +3
    ./postgresql/ecommerce-create.sql
    • -1
    • +1
    ./postgresql/ecommerce-drop.sql
8:33 pm

gilbertw

added drop function for timespan_days.

Options
    • -0
    • +1
    ./postgresql/ecommerce-drop.sql
8:32 pm

gilbertw

added timespan_days helper function. from OpenACS 3.2.5.

Options
    • -0
    • +11
    ./postgresql/ecommerce-create.sql
Tuesday 10 Jul 2001
1:44 am

gilbertw

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.

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

gilbertw

oops, I accidently committed the PostgreSQL version of this file into the Oracle sql directory. This commit is to fix my error.

Options
    • -1486
    • +1326
    ./oracle/ecommerce-create.sql
1:28 am

gilbertw

ported to PostgreSQL, loads without error, not tested in any other way

Options
    • -1326
    • +1486
    ./oracle/ecommerce-create.sql
Friday 20 Apr 2001
10:51 pm

donb

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

Options
    • -0
    • +0
    ./oracle/ec-product-package-create.sql
    • -0
    • +0
    ./oracle/ec-product-package-drop.sql
    • -0
    • +0
    ./oracle/ec-product-sws-drop.sql
    • -0
    • +0
    ./oracle/ec-product-sws-setup.sql
    • -0
    • +0
    ./oracle/ecommerce-create.sql
    • -0
    • +0
    ./oracle/ecommerce-create.sql.sans.acs.objects
    • -0
    • +0
    ./oracle/ecommerce-defaults.sql
    • -0
    • +0
    ./oracle/ecommerce-drop.sql
    • -0
    • +0
    ./oracle/ecommerce-plsql.sql.txt
    • -0
    • +0
    ./oracle/ecommerce.sql.txt
    • -0
    • +0
    ./oracle/pl-sql-utilities-drop.sql
    • -0
    • +0
    ./oracle/pl-sql-utilities.sql
  13. … 2468 more files in changeset.
10:51 pm

donb

Initial revision

Options
    • -0
    • +120
    ./oracle/ec-product-package-create.sql
    • -0
    • +11
    ./oracle/ec-product-package-drop.sql
    • -0
    • +50
    ./oracle/ec-product-sws-drop.sql
    • -0
    • +288
    ./oracle/ec-product-sws-setup.sql
    • -0
    • +3184
    ./oracle/ecommerce-create.sql
    • -0
    • +3159
    ./oracle/ecommerce-create.sql.sans.acs.objects
    • -0
    • +266
    ./oracle/ecommerce-defaults.sql
    • -0
    • +161
    ./oracle/ecommerce-drop.sql
    • -0
    • +641
    ./oracle/ecommerce-plsql.sql.txt
    • -0
    • +2546
    ./oracle/ecommerce.sql.txt
    • -0
    • +3
    ./oracle/pl-sql-utilities-drop.sql
    • -0
    • +75
    ./oracle/pl-sql-utilities.sql
  13. … 2468 more files in changeset.