My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 1: Create the SQL-file for filling of a database with test data
1 person starred this issue and may be notified of changes. Back to list
Status:  Done
Owner:  prostoge...@gmail.com


 
Project Member Reported by yermoche...@gmail.com, Feb 24, 2015
SQL-scripts has to fill with information all tables in a database. File has to have name "5_fill_tables.sql". All primary keys in tables has to be ranging from 5000 to 5999.
Feb 27, 2015
Project Member #1 prostoge...@gmail.com
(No comment was entered for this change.)
Status: Started
Feb 27, 2015
Project Member #4 prostoge...@gmail.com
(No comment was entered for this change.)
Status: Started
Feb 28, 2015
Project Member #5 prostoge...@gmail.com
(No comment was entered for this change.)
Status: Done
Mar 20, 2015
Project Member #6 yermoche...@gmail.com
1. Module 5004 belong to project 5002. Its submodule 5005 belong to other project 5001. I think that all modules are to belong to one project (5001). But I'm not sure. Check this again.
2. There are different relations between use cases in table "use_cases_relation", but they have no sense. It was possible not to fill in this table. But if you want, you can, if information have sense.
3. You have to fill in table "actor_use_case_relation".
4. One and only one field in table "requirement" ("use_case_id" or "module_id") has to be not empty. Requirement can belong to some use case (which belongs to some module) or to some module.
5. In table "tasks_category" category "User Interface" belong to category "Front-end". But why categories "Data Base" and "Business logic" not belong to category "Back-end"?
6. One and only one field in table "task" ("requirement_id" or "module_id") has to be not empty. Task can belong to some requirement (which belongs to some module or some project) or to some module.
7. Add some tasks with status NEW (0) and empty field "employee".
8. You use incorrect date format in table "task". Compare your dates and dates in table after execution of query.
Status: Renew
Mar 21, 2015
Project Member #7 prostoge...@gmail.com
(No comment was entered for this change.)
Status: Started
Mar 21, 2015
Project Member #8 prostoge...@gmail.com
(No comment was entered for this change.)
Status: Done

Powered by Google Project Hosting