alter_3_1_4_to_3_2_0.sql

Diff Revision Date Message Lines Author Branch
1.20 08 Jun 06

OLAT-1557: merge branch-1557 into the HEAD database scripts moved to corresponding subdirectories Please check your server admin scripts not located in the CVS!

deleted cweisse MAIN
1.19 18 Apr 05

description attribut in o_noti_sub table no longer needed.

-1 schnider MAIN
1.18 18 Apr 05

Default value of IM presence set to false

+1 -1 mike MAIN
1.17 31 Mar 05

Fixed wrong text data types

+3 -3 mike MAIN
1.16 18 Mar 05

changed fieldname subtype to sub_type in 'create table o_note'-statement

+1 -1 Alexander Schneider MAIN
1.15 09 Mar 05

Description changed from varchar(255) to text(765)

+4 mike MAIN
1.14 08 Mar 05

Check for null values in length field checks

+1 -1 mike MAIN
1.13 08 Mar 05

Resized critical database fields to minimum necessary length

+9 mike MAIN
1.12 02 Mar 05

disable foreign key checks during upgrade procedure

+3 mike MAIN
1.11 01 Mar 05

adding missing index

+3 gnaegi MAIN
1.10 28 Feb 05

refactoring for speed improvements: replace group identifyer in properties table from varchar(255) to bigint(20), alter tables etc.

+3 gnaegi MAIN
1.9 25 Feb 05

changed blob to text

+1 -1 fjost MAIN
1.8 10 Feb 05

modified create o_noti_pub statement according to o_database.sql

+4 -5 Alexander Schneider MAIN
1.7 27 Jan 05

finishing context management some other stuff

+6 gnaegi MAIN
1.6 24 Jan 05

added alter-statements for some field names (upper to lower case changes)

+16 -6 Alexander Schneider MAIN
1.5 13 Jan 05

add new tables o_noti_pub and o_noti_sub

+39 Alexander Schneider MAIN
1.4 21 Dec 04

added duration of assement and item to excel-export of testresults

+8 -1 Alexander Schneider MAIN
1.3 13 Dec 04

- modified table o_note create-statement - owner-id -> null - resourceTypeName, resourceTypeId -> not null - added alter-statement to table o_property - modified name -> not null

+6 -3 Alexander Schneider MAIN
1.2 10 Dec 04

- alter to ascii-type

Alexander Schneider MAIN
1.1 10 Dec 04

added new table o_note

+24 Alexander Schneider MAIN
1.19.40.1 08 Jun 06

OLAT-1557: all mysql scripts moved to database/mysql

deleted cweisse OLAT-4_2_0-BPS-1557
1.19.34.1 09 Jun 06

merge HEAD into BRANCH-1530

deleted Alexander Schneider OLAT-4_2_0-UNIZH-1530
1.19.36.1 21 Jul 06

merges from HEAD

deleted gnaegi OLAT-4_2_0-goodsolutions-1232