Is it possible to get documentation for the database tables

Doyle · Guest

Hi,

Can you provide any documentation for your database tables and their connections. I am looking for something like Web Calendar does at:

http://cvs.sourceforge.net/viewcvs.py/*checkout*/webcalendar/webcalendar/docs/WebCalendar-Database.html?rev=HEAD&content-type=text/html

Thanks.

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Hi Doyle,

I can't provide info for all the tables at this time. If you have a specific question about one of the tables or how something works, I'd be happy to answer it.

Doyle · Guest

Hi,

What we'd like to do with our system is create a default calendar for certain types of our members. Can you tell me which tables I need to modify in order to programatically create calendars for users? If the column names in these tables do not make the use of the column completely obvious, please explain the column's purpose. (For example cid is simple to type, but calendar_id would make the column's purpose obvious.)

Our system has groups, certain of these groups will be able to view the calendars we create. Additionally, each of them will have particular event categories, will enable event request, allow multiple categories per event, will have strict event security turned off.

Thanks

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Doyle,

I've created some very loose documentation for you here:

http://www.extrosoft.com/products/thyme/updates/1.2/tables.html

I will clean it up as time permits. Let me know if you have any questions at all.

joomlamoves · Guest

the database is fairly easy to work out. my suggestion is to add some groups, calendars, etc the way you want it and to look at what rows have been added to the tables.

in terms of adding groups with sql, ian has provided some generic SQL for this in some posts that i posted in these forums. i have successfully added code in the user class file (in includes/classes) to recognize groups from joomla and to add groups / calendars / module views for users.

once the project is done in the next few weeks, i will post some of this code / ideas in the hacks section.

good luck

joomlamoves