Activity OpenACS/openacs-4/packages/acs-mail-lite/sql/oracle/acs-mail-lite-create.sql

Tree
Accordion

Stats

Commits this week: 0

Total Committers:	7
Last Commit:	05 Apr
Commits this week:	0
Total Lines of Code (LoC):	74
Net change in LoC this week:	0

Commit Activity

last updated 23 hours ago

Constraints

Constraints: committers

Committer:

Log Comment:

Constraints: files

File Extension:

File Name:

Constraints: dates

Start Date:

End Date:

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.

- -1
- +349
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql

Tuesday 08 Aug 2017

1:47 am

gustafn

More
MAIN:gustafn:20170807234743
changed 7835 files
MAIN

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

- -2
- +4
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 7834 more files in changeset.

Friday 03 Mar 2017

9:55 am

gustafn

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

- -2
- +4
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 1 more file in changeset.

Monday 27 Oct 2014

5:38 pm

victorg

More
MAIN:victorg:20141027163849
changed 2548 files
MAIN

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

- -26
- +28
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 2547 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

- -26
- +28
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 8 more files in changeset.

Wednesday 18 Mar 2009

11:41 pm

emmar

More
MAIN:emmar:20090318224115
changed 21 files
MAIN

Remove complex-send as agreed in TIP#127

- -3
- +1
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 20 more files in changeset.

Wednesday 09 Jan 2008

5:51 pm

emmar

More
MAIN:emmar:20080109165129
changed 7 files
MAIN

Upgrade scripts and fix datamodel consistency

- -17
- +27
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 6 more files in changeset.

4:29 pm

emmar

More
MAIN:emmar:20080109152912
changed 12 files
MAIN

Join upgrade scripts into one with correct

version number.

- -4
- +4
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 11 more files in changeset.

3:35 pm

emmar

More
MAIN:emmar:20080109143512
changed 8 files
MAIN

Move complex stuff to separated scripts

- -40
- +2
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 7 more files in changeset.

Wednesday 29 Aug 2007

2:58 pm

maltes

More
MAIN:maltes:20070829125851
changed 4 files
MAIN

Fixing Oracle

- -11
- +11
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 3 more files in changeset.

Friday 22 Dec 2006

8:57 am

maltes

More
MAIN:maltes:20061222075742
changed 15 files
MAIN

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

- -35
- +38
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 14 more files in changeset.

Sunday 17 Dec 2006

9:11 pm

maltes

More
MAIN:maltes:20061217201154
changed 8 files
MAIN

Added support for reply_to address

- -1
- +2
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 7 more files in changeset.

6:04 pm

maltes

More
MAIN:maltes:20061217170409
changed 12 files
MAIN

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

- -7
- +44
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 11 more files in changeset.

Wednesday 21 Jan 2004

3:51 pm

maltes

More
MAIN:maltes:20040121145149
changed 2 files
MAIN

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.

- -4
- +1
./acs-mail-lite-create.sql
- History
- Source
- Diff
./acs-mail-lite-create.sql
… 1 more file in changeset.

12:43 pm

dirkg

More
MAIN:dirkg:20040121114320
changed 1 file
MAIN

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)