Home Projects Jobs Clientele Contact


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Latest DB schema

1) Fixing to all have modify and delete
2) Disagree. Keywords are references from the actual text words.
3) Going to add within next to-three days, with the rest of missing (if any) procs.

2006/11/14, sergey@total-knowledge.com <sergey@total-knowledge.com>:
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
> couple
> 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,
> http://www.sptk.net

Alexey Parshin,

Authoright © Total Knowledge: 2001-2008