[prev in list] [next in list] [prev in thread] [next in thread] 

List:       nextgen-online
Subject:    [Nextgen-online] Database tables
From:       dkeats () uwc ! ac ! za (Derek Keats)
Date:       2004-07-27 10:46:38
Message-ID: s106355f.018 () Services-02 ! uwc ! ac ! za
[Download RAW message or body]

Hi Jonathan,
State of flux is OK, and code that is in CVS appears on kngforge, and your code \
should be in CVS. However,  there is no reason to create myIsam tables as it is too \
easy to forget and then leave them. Cheers
Derek

> > > joabrahams@uwc.ac.za 07/27/04 09:14AM >>>
Hi Derek, 

The tables marked are mine. They are being used in the permissions system, which is \
in a state of flux, and should really not be on kngforge. I will make ammends.

Jonathan

> > > dkeats@uwc.ac.za 07/27/04 07:26 AM >>>
The following tables in my database are Type MyISAM.

tbl_studentadmin                 MyISAM
tbl_actions                      MyISAM  <<-- Jonathan
tbl_archivedcourses              MyISAM
tbl_arolist                      MyISAM  <<-- Jonathan
tbl_diary                        MyISAM
tbl_content                      MyISAM
tbl_context                      MyISAM
tbl_contextnodes                 MyISAM
tbl_faq                          MyISAM
tbl_kng_modules_owned_tables     MyISAM 
tbl_studentadmin                 MyISAM

and several do not have comments. These presumably came about when I ran your \
creation scripts or register. Please, can everyone check your database tables and \
make sure that they are InnoDb tables and that they have a comment saying what they \
are for.

I also notice some tables with no relationship defined, and no referential integrity. \
This is incorrect, and a major source of bugs in KEWL. We do not want to introduce \
the same kind of bugs in NextGen.

Once all this is done, I think we should drop all non core tables from the database, \
generate the SQL to create the core tables, and then get all the other tables back by \
using register. Hence, if you have a database table, please make sure that you have a \
register script, that the SQL in it includes the script for creating the \
relationships and referential integrity. Also make sure that the comment for the \
table is filled in.

Lastly, tables should be named tbl_modulecode_tablename (e.g. tbl_blog_comments) to \
make it easy for a DBA to know which module owns which table. We may have suggested \
some other convention before, but as we move beyond the early days we need to \
stabilize this convention (or propose an alternative now now). /me is guilty of not \
publicizing this and also guilty of not following naming conventions so I will fix \
all my stuff tonight. Can everyone else please check, and I will add this to the \
framework manual unless there are objections.

Cheers
Derek

_______________________________________________
Nextgen-online mailing list
Nextgen-online@avoir.uwc.ac.za 
http://avoir.uwc.ac.za/mailman/listinfo/nextgen-online 


_______________________________________________
Nextgen-online mailing list
Nextgen-online@avoir.uwc.ac.za 
http://avoir.uwc.ac.za/mailman/listinfo/nextgen-online


[prev in list] [next in list] [prev in thread] [next in thread]