lams / lams_tool_nb / db

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 11
Last Commit:
Commits this week: 0
Total Lines of Code (LoC): 264
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 a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 30 Aug 2005
1:25 pm

fmalikoff

Add the new tool identifier and version fields.

Options
    • -0
    • +4
    ./tool_insert.sql
Friday 26 Aug 2005
10:49 am

mtruong

*** empty log message ***

Options
    • -1
    • +1
    ./drop_lams_tool_nb.sql
  2. … 1 more file in changeset.
10:49 am

mtruong

the userId field is no longer specified to be unique.

"UNIQUE" keyword removed from create statement

Options
    • -1
    • +1
    ./create_lams_tool_nb.sql
    • -1
    • +1
    ./init_lams_tool_nb.sql
10:48 am

mtruong

removed the columns offline_instructions and online_instructions to suit the new table structure

Options
    • -4
    • +0
    ./activity_insert.sql
Thursday 11 Aug 2005
7:48 am

mtruong

removed the dbname when creating / dropping tables

Options
    • -4
    • +4
    ./create_lams_tool_nb.sql
    • -4
    • +4
    ./drop_lams_tool_nb.sql
    • -8
    • +8
    ./init_lams_tool_nb.sql
Wednesday 10 Aug 2005
2:54 pm

mtruong

*** empty log message ***

Options
    • -0
    • +84
    ./activity_insert.sql
    • -0
    • +20
    ./create_lams_tool_nb.sql
    • binary
    ./lams_tool_nb.sql
    • -0
    • +18
    ./library_insert.sql
    • -0
    • +56
    ./test_data_lams_tool_nb.sql
    • -0
    • +50
    ./tool_insert.sql
  7. … 1 more file in changeset.
Friday 05 Aug 2005
1:03 pm

mtruong

increased the filename field in attachment table to be varchar(255) instead of varchar(50).

Options
    • -1
    • +1
    ./create_lams_tool_nb.sql
    • -1
    • +1
    ./init_lams_tool_nb.sql
    • binary
    ./lams_tool_nb.sql
  4. … 2 more files in changeset.
Tuesday 02 Aug 2005
2:37 pm

mtruong

uuid is now a mandatory field

Options
    • -1
    • +1
    ./create_lams_tool_nb.sql
    • -1
    • +1
    ./init_lams_tool_nb.sql
    • binary
    ./lams_tool_nb.sql
  4. … 1 more file in changeset.
Friday 29 Jul 2005
12:59 pm

mtruong

renamed to lams_tool_nb.sql

Options
    • binary
    ./lams_tool_noticeboard.sql
12:33 pm

mtruong

*** empty log message ***

Options
    • -2
    • +2
    ./create_lams_tool_nb.sql
    • -2
    • +2
    ./init_lams_tool_nb.sql
    • binary
    ./lams_tool_nb.sql
  4. … 2 more files in changeset.
Thursday 28 Jul 2005
2:55 pm

mtruong

sql scripts which include the new table "attachments"

Options
    • -0
    • +14
    ./create_lams_tool_nb.sql
    • -0
    • +1
    ./drop_lams_tool_nb.sql
    • -0
    • +14
    ./init_lams_tool_nb.sql
    • binary
    ./lams_tool_noticeboard.sql
Thursday 14 Jul 2005
10:22 am

mtruong

*** empty log message ***

Options
    • -1
    • +1
    ./insert_lams_tool_nb_data.sql
  2. … 7 more files in changeset.
Tuesday 05 Jul 2005
2:46 pm

mtruong

new db model includes a user table, used for monitoring to get statistics for the users of noticeboard activity

Options
    • -1
    • +15
    ./create_lams_tool_nb.sql
    • -1
    • +1
    ./drop_lams_tool_nb.sql
    • -1
    • +15
    ./init_lams_tool_nb.sql
    • -1
    • +16
    ./insert_lams_tool_nb_data.sql
    • binary
    ./lams_tool_nb.sql
    • binary
    ./lams_tool_noticeboard.sql
  7. … 1 more file in changeset.
Wednesday 22 Jun 2005
2:34 pm

mtruong

Database model has changed to account for the unique identifier field uid, present in both content and session table.

The corresponding sql scripts have been updated to reflect this change as well.

Options
    • -9
    • +12
    ./create_lams_tool_nb.sql
    • -9
    • +12
    ./init_lams_tool_nb.sql
    • -43
    • +11
    ./insert_lams_tool_nb_data.sql
    • binary
    ./lams_tool_nb.sql
    • binary
    ./lams_tool_noticeboard.sql
  6. … 2 more files in changeset.
Tuesday 07 Jun 2005
1:50 pm

mtruong

*** empty log message ***

Options
    • -0
    • +25
    ./create_lams_tool_nb.sql
    • -0
    • +4
    ./drop_lams_tool_nb.sql
    • -0
    • +32
    ./init_lams_tool_nb.sql
    • -0
    • +71
    ./insert_lams_tool_nb_data.sql
    • binary
    ./lams_tool_noticeboard.sql
  6. … 122 more files in changeset.