Anope IRC Services

Anope.org => Anope General => Topic started by: CrazyCat on August 21, 2008, 01:02:40 PM

Title: Anope MySQL structure
Post by: CrazyCat on August 21, 2008, 01:02:40 PM

Hello there,

I'm looking for a schema of the mysql structure of anope. I've well get all the tables with indexes, but I'm not sure of relations between tables and then, it's quite hard to create my requests for a PHP website.

I hope some of you have this :)

Regards,
CrazyCat

Title: Re: Anope MySQL structure
Post by: Jan Milants on August 21, 2008, 02:54:50 PM

there s a document on the wiki that explains the most important field.... the wiki s offline though...

Title: Re: Anope MySQL structure
Post by: CrazyCat on August 21, 2008, 03:10:55 PM

That's what I was affraid of :D

Any idea about an coming back of the wiki?

Regards

Title: Re: Anope MySQL structure
Post by: Jan Milants on August 23, 2008, 11:36:56 AM

http://anope.info

Title: Re: Anope MySQL structure
Post by: Charles Kingsley on August 23, 2008, 11:45:40 AM

Specifically http://anope.info/wiki/Technical_Documents:MySQL:Scheme

Title: Re: Anope MySQL structure
Post by: CrazyCat on August 23, 2008, 03:39:48 PM

Yes, I've seen the wiki was back, and found the specifications.
I'm currently working on complete definition of fields and adding "logical foreign keys" on table, you can see it at http://www.eggdrop.fr/Anope_MySQL . It's the copy of anope'wiki page, with what I understand (not complete yet)