search

vigneshkum / projects-management

Automatically exported from code.google.com/p/projects-management
0 stars 1 forks source link

Create the SQL-file for filling of a database with test data #1

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
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.

Original issue reported on code.google.com by yermoche...@gmail.com on 24 Feb 2015 at 12:15

GoogleCodeExporter commented 9 years ago

Original comment by prostoge...@gmail.com on 27 Feb 2015 at 10:27

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago

Original comment by prostoge...@gmail.com on 27 Feb 2015 at 3:41

GoogleCodeExporter commented 9 years ago

Original comment by prostoge...@gmail.com on 28 Feb 2015 at 7:01

GoogleCodeExporter commented 9 years ago 
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.

Original comment by yermoche...@gmail.com on 20 Mar 2015 at 1:31