MantisBT - TestLink
View Issue Details
0007528TestLinkDatabase MySQLpublic2016-05-03 03:552016-09-08 15:12
ericli 
fman 
normalmajoralways
closedfixed 
1.9.15 (2015 Q4) 
1.9.15 (2015 Q4) 
MySQL
Chrome
5.4
READY FOR TESTING
0007528: Missing creationsof two new tables for MySQL in alter_tables
Following two tables can be found in newly installation file:
testlink_create_tables.sql

However, cannot find in the upgrade package under \alter_tables folder:
db_schema_update.sql

CREATE TABLE /*prefix*/req_notify_assignments (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `testproject_id` int(11) NOT NULL,
  `field_id` int(10) NOT NULL,
  `field_value` varchar(64) NOT NULL,
  `assigned_user_id` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE /*prefix*/req_monitor (
  `req_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `testproject_id` int(11) NOT NULL,
  PRIMARY KEY (`req_id`,`user_id`)
) DEFAULT CHARSET=utf8;
Without those two tables, access to "requirement" got database error messages
Cannot found in alter_tables folder since DB1.9.11
No tags attached.
child of 0007262closed fman Availables hot-fixes for 1.9.14 & How To get full fixed package from GitHub 
Issue History
2016-05-03 03:55ericliNew Issue
2016-05-07 08:31fmanQA Team - Task Workflow Status => TBD
2016-05-07 08:31fmanProduct Version1.9.14 (2015 Q3) => 1.9.15 (2015 Q4)
2016-05-07 08:31fmanFixed in Version => 1.9.15 (2015 Q4)
2016-05-07 08:32fmanRelationship addedchild of 0007262
2016-05-07 08:32fmanQA Team - Task Workflow StatusTBD => READY FOR TESTING
2016-05-07 08:32fmanStatusnew => resolved
2016-05-07 08:32fmanResolutionopen => fixed
2016-05-07 08:32fmanAssigned To => fman
2016-09-08 15:12fmanNote Added: 0025248
2016-09-08 15:12fmanStatusresolved => closed

Notes
(0025248)
fman   
2016-09-08 15:12   
1.9.15 Released - 2016-09-08