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

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 10
Last Commit: 20 Dec
Commits this week: 0
Total Lines of Code (LoC): 1,503
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 12 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./oracle/acs-mail-lite-create.sql
    • -0
    • +0
    ./postgresql/acs-mail-lite-create.sql
    • -0
    • +0
    ./postgresql/acs-mail-lite-drop.sql
  4. … 1462 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -1
    • +349
    ./oracle/acs-mail-lite-create.sql
    • -69
    • +66
    ./postgresql/acs-mail-lite-create.sql
    • -8
    • +3
    ./postgresql/acs-mail-lite-drop.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
    • -0
    • +8
    ./postgresql/upgrade/upgrade-5.10.0d10-5.10.0d11.sql
    • -0
    • +2
    ./postgresql/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
    • -0
    • +8
    ./postgresql/upgrade/upgrade-5.10.0d9-5.10.0d10.sql
  8. … 8093 more files in changeset.
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
    ./oracle/acs-mail-lite-create.sql
Monday 14 Dec 2020
10:31 am

antoniop

Index acs_mail_lite_queue(package_id)

Options
    • -1
    • +3
    ./postgresql/acs-mail-lite-create.sql
    • -0
    • +2
    ./postgresql/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
  3. … 1 more file in changeset.
10:31 am

antoniop

file upgrade-5.10.0d11-5.10.0d12.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
Sunday 25 Oct 2020
7:57 pm

gustafn

make packages in principle installable under PG 13+

Options
    • -2
    • +2
    ./postgresql/acs-mail-lite-create.sql
  2. … 19 more files in changeset.
Wednesday 12 Aug 2020
11:58 am

hectorr

Fix typo in description

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d9-5.10.0d10.sql
11:58 am

hectorr

Drop duplicate index 'acs_mail_lite_from_external_aml_email_id_idx'. Postgres creates automatically indexes for unique constraints and primary keys, this index duplicates 'acs_mail_lite_from_external_pkey'

Options
    • -3
    • +1
    ./postgresql/acs-mail-lite-create.sql
    • -2
    • +1
    ./postgresql/acs-mail-lite-drop.sql
    • -0
    • +8
    ./postgresql/upgrade/upgrade-5.10.0d10-5.10.0d11.sql
  4. … 1 more file in changeset.
11:58 am

hectorr

file upgrade-5.10.0d10-5.10.0d11.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d10-5.10.0d11.sql
11:45 am

hectorr

Whitespace changes

Options
    • -64
    • +64
    ./postgresql/acs-mail-lite-create.sql
    • -6
    • +3
    ./postgresql/acs-mail-lite-drop.sql
11:39 am

hectorr

Drop duplicate index 'acs_mail_lite_send_msg_id_map_msg_id_idx'. Postgres creates automatically indexes for unique constraints and primary keys, this index duplicates 'acs_mail_lite_send_msg_id_map_pkey'

Options
    • -4
    • +1
    ./postgresql/acs-mail-lite-create.sql
    • -2
    • +1
    ./postgresql/acs-mail-lite-drop.sql
    • -0
    • +8
    ./postgresql/upgrade/upgrade-5.10.0d9-5.10.0d10.sql
  4. … 1 more file in changeset.
11:39 am

hectorr

file upgrade-5.10.0d9-5.10.0d10.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d9-5.10.0d10.sql
Saturday 10 Aug 2019
4:45 pm

gustafn

improve spelling

Options
    • -2
    • +2
    ./postgresql/acs-mail-lite-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  3. … 8 more files in changeset.
Wednesday 05 Dec 2018
1:45 pm

gustafn

Speed up referential integrity by avoiding sequential scans

Options
    • -1
    • +9
    ./postgresql/acs-mail-lite-create.sql
    • -0
    • +24
    ./postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
  3. … 1 more file in changeset.
Thursday 29 Mar 2018
7:28 pm

hectorr

Fix typos

Options
    • -2
    • +2
    ./postgresql/acs-mail-lite-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  3. … 27 more files in changeset.
Tuesday 27 Mar 2018
2:22 pm

hectorr

Fix typos

Options
    • -2
    • +2
    ./postgresql/acs-mail-lite-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  3. … 61 more files in changeset.
1:17 pm

hectorr

Fix typos

Options
    • -2
    • +2
    ./postgresql/acs-mail-lite-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  3. … 41 more files in changeset.
Saturday 24 Mar 2018
1:14 am

hectorr

Fix even more typos

Options
    • -2
    • +2
    ./postgresql/acs-mail-lite-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  3. … 28 more files in changeset.
Thursday 08 Mar 2018
12:09 pm

antoniop

*** empty log message ***

Options
    • -4
    • +7
    ./postgresql/acs-mail-lite-create.sql
    • -0
    • +15
    ./postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  3. … 1 more file in changeset.
Saturday 17 Feb 2018
6:08 pm

gustafn

merge with changes from https://github.com/tekbasse/acs-mail-lite/tree/master/tcl

in essence, these changes provide support for handling email with attachments based on nsIMAP.

see https://openacs.org/forums/message-view?message_id=5378972 for more background

Options
    • -1
    • +358
    ./postgresql/acs-mail-lite-create.sql
    • -2
    • +42
    ./postgresql/acs-mail-lite-drop.sql
    • -0
    • +356
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  4. … 69 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -2
    • +4
    ./oracle/acs-mail-lite-create.sql
    • -1
    • +3
    ./oracle/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
    ./oracle/acs-mail-lite-create.sql
    • -1
    • +3
    ./oracle/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
    ./oracle/acs-mail-lite-create.sql
    • -0
    • +9
    ./oracle/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
    • -22
    • +24
    ./postgresql/acs-mail-lite-create.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  5. … 2544 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
    ./oracle/acs-mail-lite-create.sql
    • -0
    • +9
    ./oracle/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
    • -22
    • +24
    ./postgresql/acs-mail-lite-create.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  5. … 5 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
    ./oracle/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
Wednesday 18 Mar 2009
11:41 pm

emmar

Remove complex-send as agreed in TIP#127

Options
    • -3
    • +1
    ./oracle/acs-mail-lite-create.sql
    • -3
    • +1
    ./oracle/acs-mail-lite-drop.sql
    • -47
    • +0
    ./oracle/complex-create.sql
    • -9
    • +0
    ./oracle/complex-drop.sql
    • -44
    • +0
    ./oracle/upgrade/upgrade-5.4.0d1-5.4.0d2.sql
    • -3
    • +1
    ./postgresql/acs-mail-lite-create.sql
    • -3
    • +1
    ./postgresql/acs-mail-lite-drop.sql
    • -39
    • +0
    ./postgresql/complex-create.sql
    • -9
    • +0
    ./postgresql/complex-drop.sql
    • -36
    • +0
    ./postgresql/upgrade/upgrade-5.4.0d1-5.4.0d2.sql
  11. … 11 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
    ./oracle/upgrade/upgrade-5.4.0d2-5.4.0d3.sql
Wednesday 09 Jan 2008
6:25 pm

emmar

Forgot to rename a column in my previous commit

Options
    • -0
    • +1
    ./postgresql/upgrade/upgrade-5.4.0d2-5.4.0d3.sql
5:51 pm

emmar

Upgrade scripts and fix datamodel consistency

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

emmar

Join upgrade scripts into one with correct

version number.

Options
    • -4
    • +4
    ./oracle/acs-mail-lite-create.sql
    • -8
    • +0
    ./oracle/upgrade/upgrade-1.0b6-1.0b7.sql
    • -43
    • +0
    ./oracle/upgrade/upgrade-1.3b7-1.3b8.sql
    • -5
    • +0
    ./oracle/upgrade/upgrade-1.3b8-1.3b9.sql
    • -1
    • +0
    ./oracle/upgrade/upgrade-1.3b9-1.3b10.sql
    • -0
    • +59
    ./oracle/upgrade/upgrade-5.4.0d1-5.4.0d2.sql
    • -4
    • +4
    ./postgresql/acs-mail-lite-create.sql
    • -8
    • +0
    ./postgresql/upgrade/upgrade-1.0b6-1.0b7.sql
    • -38
    • +0
    ./postgresql/upgrade/upgrade-1.3b7-1.3b8.sql
    • -5
    • +0
    ./postgresql/upgrade/upgrade-1.3b8-1.3b9.sql
    • -1
    • +0
    ./postgresql/upgrade/upgrade-1.3b9-1.3b10.sql
    • -0
    • +51
    ./postgresql/upgrade/upgrade-5.4.0d1-5.4.0d2.sql