lams-github / lams_tool_chat / db

sql

Clone Tools

Stats

Commits this week: 0
Total Committers: 12
Last Commit:
Commits this week: 0

Lines of code count not available

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 a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 23 Sep 2008
12:21 pm

jliew

LDEV-1916 adding autopatch to tools, including db_version_insert.sql script to tool deployer

Options
    • -0
    • +2
    ./db_version_insert.sql
  2. … 71 more files in changeset.
Thursday 14 Aug 2008
2:50 pm

jliew

2.1.1 version updates

Options
    • -0
    • +2
    ./updatescripts/updateTo20080813.sql
  2. … 2 more files in changeset.
Wednesday 11 Jun 2008
3:38 pm

lfoxton

LDEV-1511

This has been changed again to prevent the tool deployer code failing during the update

Now all innodb alterations and adding contraints required for LDEV-1511 are done in this one script, in lams common alter_21_engine.sql which is allowed to fail.

Options
    • -14
    • +0
    ./updatescripts/updateTo20080229.sql
  2. … 4 more files in changeset.
Wednesday 14 May 2008
9:08 am

jliew

LDEV-1511 use original constraint names for consistency, and so that we don't get multiple constraints on the same keys if the tables happen to already be innodb and have their constraints (i.e. script failure is ok in this case)

Options
    • -6
    • +8
    ./updatescripts/updateTo20080229.sql
  2. … 3 more files in changeset.
8:09 am

jliew

LDEV-1511 add foreign key constraints to innodb tables

Options
    • -0
    • +6
    ./updatescripts/updateTo20080229.sql
  2. … 4 more files in changeset.
Friday 29 Feb 2008
11:46 am

jliew

LDEV-1511 make tables created as MyISAM into InnoDB by modifying create table statements and creating update scripts.

Options
    • -5
    • +5
    ./create_lams_tool_chat.sql
    • -0
    • +8
    ./updatescripts/updateTo20080229.sql
  3. … 10 more files in changeset.
Wednesday 06 Jun 2007
8:34 am

lfoxton

made changes so this java class xcan communicate with the installer/updater

Options
    • -8
    • +44
    ./updatescripts/UpdateLAMS202Chat.java
Monday 28 May 2007
2:34 pm

asukkar

LDEV-1233. Script to update the database chat session table from version 2.02 to 2.03

Options
    • -0
    • +94
    ./updatescripts/UpdateLAMS202Chat.java
Thursday 24 May 2007
10:48 am

fmalikoff

Updated name of script so we have a consistent tool version number across all tools for 2.0.3 release.

Options
    • -4
    • +0
    ./updatescripts/updateTo20070504.sql
    • -0
    • +4
    ./updatescripts/updateTo20070524.sql
Thursday 17 May 2007
10:39 am

asukkar

Updated how jabber room names are allocated.

When a chat tool session is created, it is assigned a jabber room name.

A 'room_created' boolean field was added to the lachat11_session table. This indicated whether the room has been created on the jabber server.

Options
    • -5
    • +5
    ./create_lams_tool_chat.sql
    • -1
    • +1
    ./table-schema.sql
    • -0
    • +4
    ./updatescripts/updateTo20070504.sql
  4. … 3 more files in changeset.
Thursday 22 Mar 2007
1:21 pm

fmalikoff

Removing './' from jar name - added by the tool deployer

Options
    • -1
    • +1
    ./tool_insert.sql
  2. … 10 more files in changeset.
1:12 pm

lfoxton

Update scipts for nb and chat to allow the update fom 2.0 to 2.0.2, just the same as previous update scripts for 2.0.1 but with diff names

Options
    • -0
    • +4
    ./updatescripts/updateTo20070315.sql
  2. … 1 more file in changeset.
Thursday 08 Mar 2007
3:25 pm

lfoxton

Final changes for 2.0.1 installer Timestamp works, jsmath works, removes jbosss temp files, runs correctly

Options
    • -1
    • +1
    ./updatescripts/updateTo20070227.sql
  2. … 6 more files in changeset.
7:22 am

lfoxton

Change update scripts to have one lne commands instead of multi-line commands for the purposes of ant

Options
    • -5
    • +1
    ./updatescripts/updateTo20070227.sql
  2. … 10 more files in changeset.
Tuesday 27 Feb 2007
10:32 am

fmalikoff

Added context application and classpath columns

Options
    • -1
    • +7
    ./tool_insert.sql
    • -0
    • +8
    ./updatescripts/updateTo20070227.sql
  3. … 25 more files in changeset.
Tuesday 13 Feb 2007
8:48 am

lfoxton

Changes to build, so the tool deployer can put the tool_version in the deploy.xml when the tool is build.

Now, the tool_version in tool_insert.sql must be replaced by @tool_version@, and the actual tool version goes in the buld.properties under tool.version

Options
    • -1
    • +1
    ./tool_insert.sql
  2. … 2 more files in changeset.
Tuesday 31 Oct 2006
12:22 pm

asukkar

Updated default content.

Options
    • -2
    • +26
    ./create_lams_tool_chat.sql
  2. … 3 more files in changeset.
Monday 18 Sep 2006
12:57 pm

fmalikoff

Appying correct category (so that it will be coloured correctly in authoring).

Options
    • -1
    • +1
    ./activity_insert.sql
  2. … 3 more files in changeset.
Friday 08 Sep 2006
1:12 pm

mseaton

tool db update - help url

Options
    • -0
    • +2
    ./tool_insert.sql
  2. … 9 more files in changeset.
Monday 04 Sep 2006
10:20 am

fmalikoff

Force tables to be INNODB tables

Options
    • -5
    • +5
    ./create_lams_tool_chat.sql
  2. … 2 more files in changeset.
Wednesday 09 Aug 2006
9:12 am

asukkar

Added reflect on chat.

Options
    • -3
    • +3
    ./create_lams_tool_chat.sql
    • -1
    • +1
    ./table-schema.sql
  3. … 26 more files in changeset.
Monday 26 Jun 2006
3:11 pm

asukkar

Change the field 'body' to use text instead of varchar in message table.

Options
    • -63
    • +6
    ./create_lams_tool_chat.sql
    • -64
    • +7
    ./table-schema.sql
  3. … 1 more file in changeset.
Wednesday 21 Jun 2006
12:31 pm

asukkar

Updated define_later_url to point to correct location.

Options
    • -1
    • +1
    ./tool_insert.sql
Thursday 15 Jun 2006
7:47 am

asukkar

Updated the column names from_user_id and to_user_id to from_user_uid and to_user_uid respectively

Options
    • -4
    • +4
    ./create_lams_tool_chat.sql
    • -6
    • +6
    ./table-schema.sql
  3. … 1 more file in changeset.
Friday 09 Jun 2006
5:54 pm

asukkar

Changed the nickname used to join the jabber chat group from the users login name to the user full name. The nickname is constructed by taking the users first name and last name followed by an optional number to ensure the nickname is unique for each session.

Options
    • -0
    • +1
    ./create_lams_tool_chat.sql
    • -0
    • +1
    ./table-schema.sql
  3. … 10 more files in changeset.
8:20 am

asukkar

Added finishedActivity flag to ChatUser, updated corresponding db tables.

Options
    • -0
    • +1
    ./create_lams_tool_chat.sql
    • -0
    • +1
    ./table-schema.sql
  3. … 1 more file in changeset.
Thursday 08 Jun 2006
9:41 am

asukkar

Modified chat model to including filtering fields. Modified message model to include send date, hidden, and chat session fields.

Options
    • -4
    • +10
    ./create_lams_tool_chat.sql
    • -3
    • +10
    ./table-schema.sql
  3. … 1 more file in changeset.
Tuesday 23 May 2006
12:10 pm

asukkar

Added message table to chat data model.

Options
    • -1
    • +11
    ./create_lams_tool_chat.sql
    • -0
    • +13
    ./table-schema.sql
  3. … 4 more files in changeset.
Monday 08 May 2006
12:38 pm

asukkar

Added new fields in session and user to store the jabber room and jabber id.

Options
    • -62
    • +54
    ./create_lams_tool_chat.sql
  2. … 2 more files in changeset.
Friday 05 May 2006
8:22 am

asukkar

Sql schema produced by xdoclet. Generated from chat model classes.

Options
    • -0
    • +57
    ./table-schema.sql