Re: [ErrorSystem-devel] RE: PHP developpers for ErrorSystem

[<son...@ss...>]

One slight problem: MySQL nor SQLite supports Foregin key. What I
recommend doing is to put an LanguageID on each language in ES-language,
and then have a simlar field in ES-main to link it. I'm setting up the
MySQL tables now, I'll get a schema up. As for the DB layor, I'm currently
doing it as a class, but at this point I can change that without much
effort.

> I transfer your mail to the ES-devel mailing-list so the others can share
> your idears. I hope I will have more time today to answer more, and to
> McTails so, but it is a big day here. On the other hand, it's going to be
> a
> very long day, so I *may* have some time.
>
> Have fun,
>
> Stephane
>
>> -----Message d'origine-----
>> De : nw [mailto:bi...@ra...]
>> Envoyé : lundi 15 décembre 2003 10:00
>> À : bro...@fr...
>> Objet : Re: PHP developpers for ErrorSystem
>>
>>
>> Hello.
>> I've visited design page. Following is an example MySql database
>> structure as i see it:
>>
>> ES-Main table
>> _____________
>> System ID (i think that errorsystem server should can manage not only
>> one system. This field can be unique key for every system)
>> System Name (that you have described)
>> AdminMail (that you have described)
>> DefLg (that you have described)
>>
>> ES-Languages table (good error system should support more than 2
>> languages, let the user manage any number of languages. This table
>> only define system languages but not errors text)
>> __________________
>> SystemID (foreign key to associate with specific system from ES-Main)
>> LanguageShortName (fr, eng, ru or another - used as primary key)
>> LanguageFullName (France, English, Russian or another. This field
>> maybe must contain native name of language - Deutsch, Ðóññêèé, English
>> or another)
>>
>> ES-Errors table (contain special info about errors)
>> ________________
>> ErrorNum (used as index and primary key)
>> ErrorLevel (foreign key to asscociate with following ES-ErrorLevels
>> table)
>> InternalCode
>> (In this table i have some doubts about errorName to use by special
>> action and SpecialMsg to use by special action)
>>
>>
>> ES-ErrorLevels table
>> ____________________
>> ErrorLevel (number of level, used as primary key)
>> ErrorLevelDescription (like "stop the execution of the software")
>>
>>
>> ES-Messages table (contain messages table for every language, defined
>> in ES-Languages table)
>> _________________
>> LanguageShortName (used to make relation with language from
>> ES-Languages table)
>> ErrorNum (used foreign key to make relation with ES-Errors table)
>> ErrorName (in this language)
>> ShortDesc
>> LongDesc
>> HTMLDesc
>> XMLDesc
>>
>> This way structured database is able to manage any numbers of error
>> systems in one database (became error system server), is able to use
>> any numbers of user defined languages.
>>
>> I think so.
>> Best Regards.
>> nw.
>>
>> On Thu, 11 Dec 2003 16:35:01 +0100
>>   "BrokenClock" <bro...@fr...> wrote:
>> >Hi,
>> >
>> >I've already add you as a developer.
>> >I was just working on an update of the design page when i received
>> >your
>> >mail. What will I say on this page in about one hour? That, as
>> >McTails
>> >suggested, we better planed to use SQLite (www.sqlite.com) instead of
>> >flat
>> >files. SQLite will be implemented in PHP5, which should be published
>> >very
>> >soon. Waiting, we will use MySQL. I think we should not have a lot of
>> >work
>> >to add the code for SQLite, using SQL requests.
>> >Check the page when it is up to date, and we will re-talk about it.
>> >
>> >Regards,
>> >
>> >Stephane
>> >
>> >> -----Message d'origine-----
>> >> De : nw [mailto:bi...@ra...]
>> >> Envoyé : jeudi 11 décembre 2003 16:23
>> >> À : bro...@fr...
>> >> Objet : Re: PHP developpers for ErrorSystem
>> >>
>> >>
>> >> Hello.
>> >> I've read project information at project homepage and subscribed
>> >> error-devel mailing-list. And about Unix name, maybe you mean my
>> >> Sourceforge login? It's biznw.
>> >> I think that ErrorSystem is an interesting idea. On my mind, system
>> >> will be more flexible and powerfull with MySQL, but you are right
>> >> about synchronous development of both (db and files-driven). I
>> >>expect
>> >> from this project better knowlege of php and expierense of team
>> >> working. Now? you can pose a problem(s)!
>> >>
>> >> On Thu, 11 Dec 2003 15:04:56 +0100
>> >>   "BrokenClock" <bro...@fr...> wrote:
>> >> >OK, so read the home page : http://errorsystem.sourceforge.net/
>> >> >Subscribe the error-devel mailing-list.
>> >> >Send me your Unix name (your account name on SourceForge, you must
>> >> >have
>> >> >one), so I can had you as a developper.
>> >> >And tell me what you think about this project, your suggestion and
>> >> >all.
>> >> >
>> >> >Pleased to have you with us.
>> >> >
>> >> >Stephane
>> >> >
>> >> >> -----Message d'origine-----
>> >> >> De : Andrew [mailto:bi...@us...]
>> >> >> Envoyé : mardi 9 décembre 2003 15:20
>> >> >> À : bro...@us...
>> >> >> Objet : RE: PHP developpers for ErrorSystem
>> >> >>
>> >> >>
>> >> >> Hello!
>> >> >>
>> >> >> I have some expierence in php programming and want to learn
>> >> >>
>> >> >> more. Will be glad to share workload!
>> >> >>
>> >> >
>> >>
>> >>
>> >
>>
>>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: IBM Linux Tutorials.
> Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
> Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
> Click now! http://ads.osdn.com/?ad_id78&alloc_id371&op¿ick
> _______________________________________________
> ErrorSystem-devel mailing list
> Err...@li...
> https://lists.sourceforge.net/lists/listinfo/errorsystem-devel
>