Project

General

Profile

Feature #6061

Moving db_main.sql into a new version folder + adding a db_course.sql

Added by Julio Montoya over 6 years ago. Updated over 5 years ago.

Status:
Feature implemented
Priority:
Normal
Assignee:
-
Category:
-
Target version:
Start date:
29/03/2013
Due date:
% Done:

100%

Estimated time:
Complexity:
Normal
SCRUM pts - complexity:
?

Description

Example for version 1.10 a new folder will be created:

main/install/1.10.0
db_course.sql
db_main.sql
db_stats.sql
db_user.sql

instead of having everything in the main/install folder.

This means also that a new file db_course.sql with the c_* tables will be added (Right now we create the course tables via a php function)

This way we could easily compare/test/install databases from different versions. For example:

Clean the chamilo folder:

app/console.php chamilo:setup

Install a fresh Chamilo 1.8.8

app/console.php chamilo:install 1.8.8

Migrate to 1.9.0

app/console.php chamilo:upgrade 1.9.0

Migrate to 1.10.0

app/console.php chamilo:upgrade 1.10.0

For Chamilo 1.11 we could use Doctrine migrations in order to use up/down changes. Another task could be created.

See also https://task.beeznest.com/issues/5572

Associated revisions

Revision 62697665 (diff)
Added by Julio Montoya over 6 years ago

Moving db files into the a new folder see #6061

History

#1

Updated by Julio Montoya over 6 years ago

  • Description updated (diff)
  • Target version set to 2.0
#2

Updated by Julio Montoya over 6 years ago

  • Status changed from New to Feature implemented
  • % Done changed from 0 to 100
#3

Updated by Yannick Warnier over 6 years ago

Technically, you could take the opportunity to join all these SQL files into one single file. There's no need to split them anymore, it just adds to the confusion. Instead, use SQL comments inside the (single) file to indicate that the following tables refer to the stats tables, or something like that.

#4

Updated by Julio Montoya over 6 years ago

  • Description updated (diff)
#5

Updated by Julio Montoya over 6 years ago

  • Status changed from Feature implemented to Assigned
  • % Done changed from 100 to 90

Yannick Warnier wrote:

Technically, you could take the opportunity to join all these SQL files into one single file. There's no need to split them anymore, it just adds to the confusion. Instead, use SQL comments inside the (single) file to indicate that the following tables refer to the stats tables, or something like that.

yes, you're right this applies for version >= 1.9

#6

Updated by Julio Montoya over 5 years ago

  • Status changed from Assigned to Feature implemented
  • Assignee deleted (Julio Montoya)
  • % Done changed from 90 to 100

The sql files were moved to the Chash app and the files are separetad per version.

Also available in: Atom PDF