OpenACS / openacs-4 / packages / acs-mail-lite / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 05 Apr
Commits this week: 0
Total Lines of Code (LoC): 178
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 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 15 Feb 2022
7:06 pm

gustafn

Fixes for Oracle 19c: quick port of missing tables in acs-mail-lite from PostgreSQL

This is q quick port of the table available from PostgreSQL, which

assures that a new instance of OpenACS on Oracle can run without

spitting out frequent error messages. In essence, the sequence

handling was adjusted, and datatype "text" was replaced by

"varchar(4000)" and in one case by "clob". Probably, some of the

lengths and the update operations have to be adjusted.

Options
    • -1
    • +349
    ./acs-mail-lite-create.sql
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -2
    • +4
    ./acs-mail-lite-create.sql
    • -1
    • +3
    ./upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  3. … 7833 more files in changeset.
Friday 03 Mar 2017
9:55 am

gustafn

fix issiue #3304: oracle does not have Boolean datatype for tables

Options
    • -2
    • +4
    ./acs-mail-lite-create.sql
    • -1
    • +3
    ./upgrade/upgrade-5.8.1d3-5.8.1d4.sql
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -26
    • +28
    ./acs-mail-lite-create.sql
    • -0
    • +9
    ./upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  3. … 2546 more files in changeset.
Friday 25 Jul 2014
6:49 pm

antoniop

New feature: now one can send plain filesystem files as email attachments, instead than only those into file-storage

Options
    • -26
    • +28
    ./acs-mail-lite-create.sql
    • -0
    • +9
    ./upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  3. … 7 more files in changeset.
6:49 pm

antoniop

file upgrade-5.8.1d3-5.8.1d4.sql was initially added on branch oacs-5-8.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  2. … 1 more file in changeset.
Wednesday 18 Mar 2009
11:41 pm

emmar

Remove complex-send as agreed in TIP#127

Options
    • -3
    • +1
    ./acs-mail-lite-create.sql
    • -3
    • +1
    ./acs-mail-lite-drop.sql
    • -47
    • +0
    ./complex-create.sql
    • -9
    • +0
    ./complex-drop.sql
    • -44
    • +0
    ./upgrade/upgrade-5.4.0d1-5.4.0d2.sql
  6. … 16 more files in changeset.
Sunday 13 Jan 2008
12:25 pm

donb

Fixed oracle syntax - add doesn't allow "column", unlike PG

Options
    • -9
    • +9
    ./upgrade/upgrade-5.4.0d2-5.4.0d3.sql
Wednesday 09 Jan 2008
5:51 pm

emmar

Upgrade scripts and fix datamodel consistency

Options
    • -17
    • +27
    ./acs-mail-lite-create.sql
    • -0
    • +29
    ./upgrade/upgrade-5.4.0d2-5.4.0d3.sql
  3. … 5 more files in changeset.
4:29 pm

emmar

Join upgrade scripts into one with correct

version number.

Options
    • -4
    • +4
    ./acs-mail-lite-create.sql
    • -8
    • +0
    ./upgrade/upgrade-1.0b6-1.0b7.sql
    • -43
    • +0
    ./upgrade/upgrade-1.3b7-1.3b8.sql
    • -5
    • +0
    ./upgrade/upgrade-1.3b8-1.3b9.sql
    • -1
    • +0
    ./upgrade/upgrade-1.3b9-1.3b10.sql
    • -0
    • +59
    ./upgrade/upgrade-5.4.0d1-5.4.0d2.sql
  7. … 6 more files in changeset.
3:35 pm

emmar

Move complex stuff to separated scripts

Options
    • -40
    • +2
    ./acs-mail-lite-create.sql
    • -2
    • +3
    ./acs-mail-lite-drop.sql
    • -0
    • +47
    ./complex-create.sql
    • -0
    • +9
    ./complex-drop.sql
  5. … 4 more files in changeset.
Wednesday 29 Aug 2007
2:58 pm

maltes

Fixing Oracle

Options
    • -11
    • +11
    ./acs-mail-lite-create.sql
    • -2
    • +2
    ./upgrade/upgrade-1.0b6-1.0b7.sql
    • -1
    • +1
    ./upgrade/upgrade-1.3b8-1.3b9.sql
    • -1
    • +1
    ./upgrade/upgrade-1.3b9-1.3b10.sql
Friday 22 Dec 2006
8:57 am

maltes

Cleaning up. Removed the code for prefix handling as it does not work. Changed Oracle scripts and make them look nicer.

Options
    • -35
    • +38
    ./acs-mail-lite-create.sql
    • -2
    • +1
    ./acs-mail-lite-drop.sql
    • -7
    • +0
    ./upgrade/upgrade-1.3b5-1.3b6.sql
    • -32
    • +37
    ./upgrade/upgrade-1.3b7-1.3b8.sql
    • -1
    • +1
    ./upgrade/upgrade-1.3b9-1.3b10.sql
  6. … 10 more files in changeset.
Thursday 21 Dec 2006
9:48 pm

donb

Someone forgot to add this upgrade to the Oracle version

Options
    • -0
    • +1
    ./upgrade/upgrade-1.3b9-1.3b10.sql
Sunday 17 Dec 2006
9:11 pm

maltes

Added support for reply_to address

Options
    • -1
    • +2
    ./acs-mail-lite-create.sql
  2. … 7 more files in changeset.
6:04 pm

maltes

Added oracle scripts, continued with the move from user_id to party_id

Options
    • -7
    • +44
    ./acs-mail-lite-create.sql
    • -1
    • +6
    ./acs-mail-lite-drop.sql
    • -0
    • +8
    ./upgrade/upgrade-1.0b6-1.0b7.sql
    • -0
    • +7
    ./upgrade/upgrade-1.3b5-1.3b6.sql
    • -0
    • +38
    ./upgrade/upgrade-1.3b7-1.3b8.sql
    • -0
    • +5
    ./upgrade/upgrade-1.3b8-1.3b9.sql
  7. … 6 more files in changeset.
Wednesday 16 Jun 2004
4:17 pm

andrewg

fixing alter table syntax for Oracle; this fix committed initially on the 5.1 branch

Options
    • -2
    • +2
    ./upgrade/acs-mail-lite-upgrade-0.1d-0.2a.sql
4:08 pm

andrewg

fixing alter table syntax for Oracle

Options
    • -2
    • +2
    ./upgrade/acs-mail-lite-upgrade-0.1d-0.2a.sql
Wednesday 21 Jan 2004
3:51 pm

maltes

Approved Dirk's changes (thanks a lot) and put them into the upgrade scripts as well. I did not test the upgrade, maybe someone with a running Oracle installation can do.

Options
    • -4
    • +1
    ./acs-mail-lite-create.sql
    • -3
    • +4
    ./upgrade/acs-mail-lite-upgrade-0.1d-0.2a.sql
12:43 pm

dirkg

Fixed the create table statements, so that the tables are being created under Oracle. Not sure about the semantics, needs to be double-checked by Malte (see #1393)

Options
    • -4
    • +9
    ./acs-mail-lite-create.sql
Friday 16 Jan 2004
10:46 pm

maltes

Changed type text to clob or varchar(400) for the to_addr.

Options
    • -5
    • +5
    ./acs-mail-lite-create.sql
Wednesday 14 Jan 2004
6:34 pm

maltes

New Version of Acs-Mail-Lite with support for bounce management

Options
    • -5
    • +42
    ./acs-mail-lite-create.sql
    • -0
    • +36
    ./upgrade/acs-mail-lite-upgrade-0.1d-0.2a.sql
  3. … 6 more files in changeset.
Saturday 04 May 2002
8:27 pm

yon

first version of this simple mail queue

Options
    • -0
    • +20
    ./acs-mail-lite-create.sql
    • -0
    • +9
    ./acs-mail-lite-drop.sql
  3. … 7 more files in changeset.