o_database.sql

Diff Revision Date Message Lines Author Branch
1.76 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.75 07 Jun 06

OLAT-1233:Fix : no uppercase-characters in db-column-names.

+2 -2 guretzki MAIN
1.74 01 Jun 06

OLAT-1233:New feature waiting-list in enroll BB. Merge Branch-1233 back into HEAD.

+3 guretzki MAIN
1.73 02 Feb 06

OLAT-1347 - Changed affected data type precisions. - Alter statements only necessary when upgrading from MySQL pre 5.x to 5.x. - Change in hbm.xml has no effect on bindings, so this should work with MySQL pre 5.x

+3 -3 mike MAIN
1.72 25 Jul 05

add new column for subscription: latestEmailSent

+1 fjost MAIN
1.71 25 Jul 05

*** empty log message ***

-1 fjost MAIN
1.70 25 Jul 05

field definition updates

+1 -2 mike MAIN
1.69 31 Mar 05

Fixed wrong text data types

+4 -4 mike MAIN
1.68 09 Mar 05

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

+3 -4 mike MAIN
1.67 08 Mar 05

Check for null values in length field checks

+1 -1 mike MAIN
1.66 08 Mar 05

Resized critical database fields to minimum necessary length

+8 -8 mike MAIN
1.65 01 Mar 05

*** empty log message ***

-37 Alexander Schneider MAIN
1.64 01 Mar 05

adding missing index

+38 -1 gnaegi MAIN
1.63 28 Feb 05

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

+1 -1 gnaegi MAIN
1.62 25 Feb 05

notifications via rss and more

+2 -2 fjost MAIN
1.61 10 Feb 05

changes for notifications

+7 -10 fjost MAIN
1.60 27 Jan 05

finishing context management some other stuff

+2 gnaegi MAIN
1.59 24 Jan 05

upper to lower case in fieldnames: o_property resourceTypeName -> resourcetypename resourceTypeId -> resourcetypeid o_catentry externalURL -> externalurl o_note resourceTypeName -> resourcetypename resourceTypeId -> resourcetypeid noteTitle -> notetitle noteText -> notetext o_user presenceMessagesPublic -> presencemessagespublic o_repositoryentry initialAuthor -> initialauthor canLaunch -> canlaunch canDownload -> candownload canCopy -> cancopy launchCounter -> launchcounter

+20 -19 Alexander Schneider MAIN
1.58 13 Jan 05

corrected, since the last commit was the DatabaseSetup generated one, without any preperations

+39 -39 Alexander Schneider MAIN
1.57 12 Jan 05

changed upper case to lower case letters (table o_noti_sub, fields: transResId -> transresid, transSubidentifier -> transsubidentifier)

+41 -42 Alexander Schneider MAIN
1.56 07 Jan 05

notifications core version 0.8

+5 -5 fjost MAIN
1.55 21 Dec 04

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

+2 Alexander Schneider MAIN
1.54 13 Dec 04

modified table o_note and o_property create-statement

+4 -4 Alexander Schneider MAIN
1.53 10 Dec 04

added new table o_note

+19 -6 Alexander Schneider MAIN
1.52 01 Dec 04

new user preference added for instant messaging

+1 schnider MAIN
1.51 18 Nov 04

3.1.4 merges from BRANCH

+1 gnaegi MAIN
1.50 29 Oct 04

added some more fields to data

+168 -167 fjost MAIN
1.49 21 Oct 04

added version 0.2 of notifications

+67 -27 fjost MAIN
1.48 19 Oct 04

adding index on users firstname / lastname

+2 gnaegi MAIN
1.47 19 Oct 04

http://bugzilla.olat.org/show_bug.cgi?id=1045

+1 mike MAIN
1.46 08 Oct 04

The Catalog

+7 -7 Patrick Brunner MAIN
1.45 09 Sep 04

changes to match update from 3.0.1 to 3.1

+1 -1 schnider MAIN
1.44 08 Sep 04

- refactored group context to course relation to not be limited to courses (no real code changes, only renaming and moving of code) - now group contexts can be related to any olat resource, eg. a portal, a course etc

+11 -11 gnaegi MAIN
1.43 07 Sep 04

adding some indexes

+3 -1 gnaegi MAIN
1.42 31 Aug 04

adding min max size to business group

+36 -3 gnaegi MAIN
1.41 26 Aug 04

Added missing index

+5 -37 mike MAIN
1.40 23 Aug 04

- removed learning groups from alter statements - adding group areas

+205 -192 gnaegi MAIN
1.39 22 Aug 04

fixing mysql entry bug and added catalog table

+154 -184 fjost MAIN
1.38 19 Aug 04

tests and contextmanager impls

+42 -6 gnaegi MAIN
1.37 19 Aug 04

BuddyGroup -> BusinessGroup

+5 -38 Patrick Brunner MAIN
1.36 19 Aug 04

adding context

+205 -151 gnaegi MAIN
1.35 10 Aug 04

- AAI post-processing workflow - refactored SecurityManager to refer to credential instead of hashed password

+2 -5 mike MAIN
1.34 05 Aug 04

Multimandantenfähigkeit.

+6 -3 mike MAIN
1.33 04 Aug 04

index on description not possible, as description is a blob column

-1 Patrick Brunner MAIN
1.32 03 Aug 04

added index for buddygroup name, description

+2 Patrick Brunner MAIN
1.31 02 Aug 04

http://bugzilla.olat.org/cgi-bin/bugzilla/show_bug.cgi?id=882

+106 -135 mike MAIN
1.30 29 Jul 04

initial start with BuddyGroups, no GUI exists at the moment, but an olat.buddygroup.BuddyGroupManagerImplTest !!! NEW DATABASESETUP IS NEEDED IF YOU RUN olat.test.AllTests.java - database changes see o_database.sql and alter_3_0_0_to_3_0_1.sql - new package ..olat.buddygroup containing buddy group related classes - olat.persistence.DatabaseSetup adapted to generate the Buddy Group Tables - olat.test.AllTests adapted to start the BuddyGroupManagerImplTest - various classes under olat.buddygroup

+33 -17 Patrick Brunner MAIN
1.29 22 Jul 04

fixing broken timestamp

+1 -1 schuer MAIN
1.28 13 Jul 04

learninggroup and learning area name not null

+17 -17 fjost MAIN
1.27 13 Jul 04

Disable foreign constraint checks on dbsetup

+4 mike MAIN
1.26 12 Jul 04

restrict olatresource's type name to 50 chars (org.olat.admin.user.UserChangePasswordController has 48 chars.)

+1 -1 fjost MAIN
1.25 12 Jul 04

new field fontsize added for stylesheet preferences

+2 schnider MAIN
1.24 12 Jul 04

Added index on repositoryentry

+4 -4 mike MAIN
1.23 12 Jul 04

Added index on repositoryentry

+6 mike MAIN
1.22 12 Jul 04

foreign constraints do not work if alter command comes after the constraints! (windows xp/mysql)

+25 fjost MAIN
1.21 12 Jul 04

fixing wrong unique key for learning group right

+1 -1 gnaegi MAIN
1.20 08 Jul 04

property category is now 33 chars long

+1 -1 gnaegi MAIN
1.19 08 Jul 04

Bookmarks are now set to the repository entry directly, which acts as a olat resourceable.

+4 -3 mike MAIN
1.18 02 Jul 04

*** empty log message ***

+19 -15 gnaegi MAIN
1.17 01 Jul 04

uniform creationdate und timestamp (lastmodified) in all hbm files except for qtiresult und metadataelement

+33 -33 fjost MAIN
1.16 30 Jun 04

Repository entries carry a softkey which is virtually global unique. References in courses refer to this softkey. (enables import/export of courses from/to olat installations based on soft references)

+16 -14 mike MAIN
1.15 29 Jun 04

prefix groupmanagement tables with o_gm_*

+78 -78 kapp MAIN
1.14 25 Jun 04

Implemented new access rights concept as discussed with customers -> includes guest access privileges.

+15 -16 mike MAIN
1.13 24 Jun 04

dont use right as column name in mysql.

+2 -2 kapp MAIN
1.12 24 Jun 04

add rights table.

+13 kapp MAIN
1.11 22 Jun 04

new unique key in o_bs_policy

+1 -1 fjost MAIN
1.10 22 Jun 04

spelling.

+1 -1 kapp MAIN
1.9 18 Jun 04

fix columname

+3 -3 kapp MAIN
1.8 17 Jun 04

rename table.field

+4 -5 kapp MAIN
1.7 10 Jun 04

remove set mappings from org.olat.group.*. pleases update your db config.

-8 kapp MAIN
1.6 08 Jun 04

table to support group-area navigation without Hibernate sets.

+18 -4 kapp MAIN
1.5 28 May 04

- new cours editor structure - new publish process (not yet active) - references implementation - ref check on deletes

+2 -3 mike MAIN
1.4 27 May 04

Reference management

+13 mike MAIN
1.3 24 May 04

initial version, intermediate save

+45 -35 Alexander Schneider MAIN
1.2 17 May 04

*** keyword substitution change ***

+281 -281 mike MAIN
1.1 17 May 04

Fresh, clean checkin

+281 mike MAIN
1.46.2.3 17 Nov 04

adding longvalue support to property

+1 gnaegi OLAT-3-1-x-BRANCH
1.46.2.2 19 Oct 04

backport from head: index on user

+2 gnaegi OLAT-3-1-x-BRANCH
1.46.2.1 19 Oct 04

backport: authors course copy security problem

+1 gnaegi OLAT-3-1-x-BRANCH
1.74.2.2 08 Jun 06

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

deleted cweisse OLAT-4_2_0-BPS-1557
1.74.2.1 08 Jun 06

OLAT-1557: merge HEAD into branch-1557

+2 -2 cweisse OLAT-4_2_0-BPS-1557
1.73.12.1 09 May 06

OLAT-1233: Work in progress, Add new db attribute for waiting list

+3 guretzki OLAT-4_2_0-UNIZH-1233
1.73.20.2 09 Jun 06

merge HEAD into BRANCH-1530

deleted Alexander Schneider OLAT-4_2_0-UNIZH-1530
1.73.20.1 02 Jun 06

merge HEAD into BRANCH-1530

+3 Alexander Schneider OLAT-4_2_0-UNIZH-1530
1.73.22.1 21 Jul 06

merges from HEAD

deleted gnaegi OLAT-4_2_0-goodsolutions-1232