A few things that I noticed so far:
1. In some cases you use "modify", "remove" words in the procedures names,
in others - "update", "delete". Is there any reason for that?
2. IMO keyword_update(modify) procedure may be needed for keywords_list.
3. solution_signature and problem_solutions tables have no procedures. Is
it on purpose or you are going to add it in the next update?
> I have added most of the stored procedures to the database schema and
> committed it to SVN. It needs some polishing that I'd do within next
> of days.
> I need to know your opinion about the set of the procedures, procedure
> names, parameter names, etc. In ideal case, the usage of the stored
> procedure should be understood from its declaration.
> Alexey Parshin,
Authoright © Total Knowledge: 2001-2008