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: 14 Nov
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 38 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 25 Oct 2020
7:57 pm

gustafn

make packages in principle installable under PG 13+

Options
    • -3
    • +3
    ./postgresql/ec-product-sc-create.sql
    • -36
    • +36
    ./postgresql/ecommerce-create.sql
  3. … 18 more files in changeset.
Saturday 09 May 2009
8:38 pm

torbenb

adding batch process controls

Options
    • -0
    • +11
    ./postgresql/ecds-create.sql
    • -0
    • +2
    ./postgresql/ecds-drop.sql
Thursday 12 Feb 2009
7:26 am

torbenb

working, scalable version of CacheProductAsFile that requires a new table, also some minor other changes

Options
    • -0
    • +14
    ./postgresql/ecds-create.sql
    • -0
    • +3
    ./postgresql/ecds-drop.sql
    • -0
    • +13
    ./postgresql/upgrade/upgrade-5.14-5.15.sql
  4. … 4 more files in changeset.
Sunday 07 Sep 2008
11:23 pm

torbenb

adding proper quoting to html to not confuse template::adp_compile

Options
    • -1
    • +1
    ./oracle/ecommerce-defaults.sql
    • -1
    • +1
    ./postgresql/ecommerce-defaults.sql
Thursday 28 Aug 2008
1:15 pm

torbenb

fixingdrop order

Options
    • -0
    • +1
    ./postgresql/ecommerce-drop.sql
12:46 pm

torbenb

removing least function definition because it is now in pg by default

Options
    • -13
    • +1
    ./postgresql/ecommerce-create.sql
    • -1
    • +1
    ./postgresql/ecommerce-drop.sql
Sunday 10 Aug 2008
4:52 am

torbenb

activating ecds-drop.sql with the rest

Options
    • -1
    • +1
    ./postgresql/ecommerce-drop.sql
Saturday 09 Aug 2008
9:24 pm

torbenb

adding missing function, and reference to ecds file

Options
    • -0
    • +18
    ./postgresql/ecommerce-create.sql
9:19 pm

torbenb

adding sql for ecds-* procs

Options
    • -0
    • +108
    ./postgresql/ecds-create.sql
    • -0
    • +20
    ./postgresql/ecds-drop.sql
Sunday 27 Apr 2008
3:38 am

marka

begun refactor of image support:

* created new ecommerce::resource package and moved eg. thumbnail creation there from various places

* added support for two sizes of thumbnail

* added smaller thumbnail to category-browse page

* changed default product template to use larger thumbnail and use new ::resource procs

* fixed bulk image importing page

Options
    • -1
    • +7
    ./oracle/ecommerce-defaults.sql
    • -1
    • +7
    ./postgresql/ecommerce-defaults.sql
  3. … 13 more files in changeset.
Wednesday 23 Jan 2008
8:05 pm

donb

Remove "least" declaration, which is now included in PG

Options
    • -17
    • +0
    ./postgresql/ecommerce-create.sql
Monday 08 Mar 2004
8:46 pm

alfredw

Bulk update fix incorporating changes from alfredw, torbenb and bartt. Fix for bug 487.

Options
    • -0
    • +2
    ./postgresql/ecommerce-defaults.sql
  2. … 108 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -5
    • +5
    ./oracle/ec-product-package-create.sql
  2. … 275 more files in changeset.
Saturday 17 May 2003
12:26 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -1
    • +1
    ./postgresql/ec-product-package-create.sql
    • -115
    • +115
    ./postgresql/ecommerce-create.sql
    • -1
    • +1
    ./postgresql/pl-sql-utilities-drop.sql
    • -1
    • +1
    ./postgresql/pl-sql-utilities.sql
  5. … 32 more files in changeset.
Sunday 02 Mar 2003
11:42 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -1
    • +1
    ./postgresql/ec-product-package-create.sql
    • -115
    • +115
    ./postgresql/ecommerce-create.sql
    • -1
    • +1
    ./postgresql/pl-sql-utilities-drop.sql
    • -1
    • +1
    ./postgresql/pl-sql-utilities.sql
  5. … 36 more files in changeset.
Tuesday 10 Dec 2002
9:05 pm

bartt

Bug fix for 1959. And global update of my e-mail address.

Options
    • -1
    • +1
    ./postgresql/ecommerce-create.sql
  2. … 117 more files in changeset.
Saturday 30 Nov 2002
6:22 pm

jeffd

merge from oacs-4-6

Options
    • -115
    • +115
    ./postgresql/ecommerce-create.sql
  2. … 130 more files in changeset.
Saturday 19 Oct 2002
9:50 pm

bartt

More timestamp to timestamp(0) replacements.

Options
    • -78
    • +78
    ./postgresql/ecommerce-create.sql
9:31 pm

bartt

Changed timestamp to timestamp(0) which isn't subsecond precise.

Options
    • -37
    • +37
    ./postgresql/ecommerce-create.sql
Saturday 21 Sep 2002
4:50 am

bartt

Bug fixes.

Options
    • -0
    • +1
    ./oracle/ecommerce-create.sql
  2. … 1 more file in changeset.
Sunday 26 May 2002
7:09 am

bartt

*** empty log message ***

Options
    • -3159
    • +0
    ./oracle/ecommerce-create.sql.sans.acs.objects
    • -641
    • +0
    ./oracle/ecommerce-plsql.sql.txt
    • -2546
    • +0
    ./oracle/ecommerce.sql.txt
  4. … 130 more files in changeset.
6:36 am

bartt

Major overhaul:

- Replaced CyberCash with Payment Service Contract interface.

- Added Shipping Service Contract.

- Many(!) bug fixes.

- Added soft good (goods that don't require shipping) handling capacity.

- And more..

Options
    • -55
    • +22
    ./oracle/ecommerce-create.sql
    • -9
    • +3
    ./oracle/ecommerce-defaults.sql
    • -3
    • +2
    ./oracle/ecommerce-drop.sql
    • -65
    • +30
    ./postgresql/ecommerce-create.sql
    • -9
    • +3
    ./postgresql/ecommerce-defaults.sql
    • -3
    • +2
    ./postgresql/ecommerce-drop.sql
    • -42
    • +24
    ./postgresql/pl-sql-utilities.sql
  8. … 269 more files in changeset.
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