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: 13:09
Commits this week: 0
Total Lines of Code (LoC): 358
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 mins 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
    ./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.
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: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.
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.