Project

General

Profile

Bug #4725

Missing tables after upgrade

Added by Laurent Opprecht over 7 years ago. Updated over 7 years ago.

Status:
Bug resolved
Priority:
Normal
Category:
-
Target version:
Start date:
09/05/2012
Due date:
% Done:

100%

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

Description

A few tables are missing after the upgrade proces.
List below - note that the create table statements come from a DB compare, not from the application.

CREATE TABLE `shared_survey` (
`survey_id` int(10) unsigned NOT NULL auto_increment,
`code` varchar(20) default NULL,
`title` text default NULL,
`subtitle` text default NULL,
`author` varchar(250) default NULL,
`lang` varchar(20) default NULL,
`template` varchar(20) default NULL,
`intro` text default NULL,
`surveythanks` text default NULL,
`creation_date` datetime NOT NULL default '0000-00-00 00:00:00',
`course_code` varchar(40) NOT NULL,
UNIQUE INDEX `id` ( `survey_id` ),
PRIMARY KEY ( `survey_id` )
);

CREATE TABLE `shared_survey_question` (
`question_id` int(11) NOT NULL auto_increment,
`survey_id` int(11) NOT NULL default '0',
`survey_question` text NOT NULL,
`survey_question_comment` text NOT NULL,
`type` varchar(250) NOT NULL,
`display` varchar(10) NOT NULL,
`sort` int(11) NOT NULL default '0',
`code` varchar(40) NOT NULL,
`max_value` int(11) NOT NULL,
PRIMARY KEY ( `question_id` )
);

CREATE TABLE `skill` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`short_code` varchar(100) NOT NULL,
`description` text NOT NULL,
`access_url_id` int(11) NOT NULL,
`icon` varchar(255) NOT NULL,
PRIMARY KEY ( `id` )
);

CREATE TABLE `skill_profile` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`description` text NOT NULL,
PRIMARY KEY ( `id` )
);

CREATE TABLE `skill_rel_gradebook` (
`id` int(11) NOT NULL auto_increment,
`gradebook_id` int(11) NOT NULL,
`skill_id` int(11) NOT NULL,
`type` varchar(10) NOT NULL,
PRIMARY KEY ( `id` )
);

CREATE TABLE `skill_rel_profile` (
`id` int(11) NOT NULL auto_increment,
`skill_id` int(11) NOT NULL,
`profile_id` int(11) NOT NULL,
PRIMARY KEY ( `id` )
);

CREATE TABLE `skill_rel_skill` (
`skill_id` int(11) NOT NULL,
`parent_id` int(11) NOT NULL,
`relation_type` int(11) NOT NULL,
`level` int(11) NOT NULL,
PRIMARY KEY ( `skill_id`, `parent_id`, `relation_type` )
);

CREATE TABLE `skill_rel_user` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`skill_id` int(11) NOT NULL,
`acquired_skill_at` datetime NOT NULL default '0000-00-00 00:00:00',
`assigned_by` int(11) NOT NULL,
PRIMARY KEY ( `id` )
);

History

#1

Updated by Laurent Opprecht over 7 years ago

  • Assignee set to Laurent Opprecht
  • % Done changed from 0 to 90

I have added the skill related tables.
The others were likely the result of an old upgrade as they are already in migration scripts.

#2

Updated by Laurent Opprecht over 7 years ago

  • Status changed from New to Bug resolved
  • % Done changed from 90 to 100
#3

Updated by Yannick Warnier over 7 years ago

  • Target version set to 1.9 Beta

Please make sure everytime you close a report, you have a "Target version" set. Otherwise I can't take it into account when publishing the changelog before the stable release. In this case, as you are closing it and the next scheduled version is 1.9 Beta, just set it to 1.9 Beta and close it. I'll dot it now for the two others you've closed today.

Also available in: Atom PDF