OpenACS / openacs-4 / packages / acs-templating / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 6
Last Commit: 24 Dec
Commits this week: 0
Total Lines of Code (LoC): 534
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 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -1
    • +1
    ./acs-templating-create.sql
  2. … 8099 more files in changeset.
Sunday 26 Jun 2022
1:06 pm

gustafn

removed code factored out to the separate "captcha" package

Options
    • -2
    • +1
    ./acs-templating-create.sql
    • -12
    • +0
    ./captcha-create.sql
    • -13
    • +0
    ./upgrade/upgrade-5.10.1d0-5.10.1d1.sql
  4. … 9 more files in changeset.
Thursday 17 Feb 2022
4:20 pm

gustafn

Fixes for Oracle 19c: fix data types and interval calculation

Options
    • -8
    • +6
    ./captcha-create.sql
3:17 pm

antoniop

Don't use expressions for the default value, apparently a nono in Oracle

See e.g. https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj30540.html#rrefsqlj30540__sqlj64478

Options
    • -2
    • +7
    ./captcha-create.sql
    • -2
    • +1
    ./upgrade/upgrade-5.10.1d0-5.10.1d1.sql
Wednesday 26 Jan 2022
5:06 pm

antoniop

A simple image captcha implementation:

a random text is converted to a distorted image, its checksum, together with the expected text are stored in a lookup table. Upon validation, the text input by the user is matched against the checksum to determine if the captcha is correct.

Plan is to use it downstream on certain publicly available contact forms.

Options
    • -1
    • +2
    ./acs-templating-create.sql
    • -0
    • +9
    ./captcha-create.sql
    • -0
    • +14
    ./upgrade/upgrade-5.10.1d0-5.10.1d1.sql
  4. … 6 more files in changeset.
5:06 pm

antoniop

file captcha-create.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./captcha-create.sql
  2. … 1 more file in changeset.
5:06 pm

antoniop

file upgrade-5.10.1d0-5.10.1d1.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.10.1d0-5.10.1d1.sql
  2. … 1 more file in changeset.
Tuesday 26 Sep 2006
5:13 pm

byronl

Correction of name constraint

Options
    • -1
    • +2
    ./demo-create.sql
  2. … 5 more files in changeset.
Friday 10 Feb 2006
3:12 am

jiml

Turn on the data model loading under oracle. (yes, BOLD move :)

Options
    • -3
    • +3
    ./demo-create.sql
12:00 am

hughb

fix Oracle bug (procedure cannot return a value)

Options
    • -1
    • +1
    ./template-demo-notes-sample.sql
Thursday 09 Feb 2006
2:58 pm

jiml

for oracle it's sysdate, not now()... corrected those.

Options
    • -20
    • +20
    ./template-demo-notes-sample.sql
1:28 am

hughb

fix typos

Options
    • -2
    • +2
    ./template-demo-notes-create.sql
1:25 am

jiml

fix silly typos

Options
    • -3
    • +3
    ./template-demo-notes-create.sql
12:52 am

jiml

arrange to load sample data; commented out for now

Options
    • -1
    • +3
    ./demo-create.sql
12:34 am

jiml

create listbuilder sample data for oracle

Options
    • -0
    • +302
    ./template-demo-notes-sample.sql
Monday 06 Feb 2006
4:54 pm

jiml

disabled loading the renamed notes package, as it's untested on oracle

Options
    • -1
    • +2
    ./demo-create.sql
2:06 pm

jiml

add column "color" to template_demo_notes table; add display for it in list2,

add html row for list3 to the demo/index file

Options
    • -4
    • +17
    ./template-demo-notes-create.sql
  2. … 7 more files in changeset.
Saturday 04 Feb 2006
2:54 am

jiml

notes-like data model for templating demo page to facilitate listbuilder tut

Options
    • -0
    • +2
    ./demo-create.sql
    • -1
    • +3
    ./demo-drop.sql
    • -0
    • +150
    ./template-demo-notes-create.sql
    • -0
    • +4
    ./template-demo-notes-drop.sql
  5. … 6 more files in changeset.
Thursday 05 Apr 2001
8:23 pm

donb

Big 'ole update to implement multi-db aware packages. Don't try this yet,

I can't *possibly* have gotten all the right files added and removed in

one fell swoop!

Options
    • -0
    • +12
    ./acs-templating-create.sql
    • -0
    • +9
    ./acs-templating-drop.sql
    • -0
    • +26
    ./demo-create.sql
    • -0
    • +10
    ./demo-drop.sql
  5. … 115 more files in changeset.