[Tutos-commits] CVS: tutos/php/checklist mtable.pinc,1.3,1.4

[Gero K. <gok...@us...>]

Update of /cvsroot/tutos/tutos/php/checklist
In directory usw-pr-cvs1:/tmp/cvs-serv8315/php/checklist

Modified Files:
	mtable.pinc 
Log Message:
Major Database updates !!
Please Backup before running update.php

Added creator/creation for most classes/tables
Changed ACL Perm from string to int (in order to support more DB types

All changes should happen automagically when running update.php



Index: mtable.pinc
===================================================================
RCS file: /cvsroot/tutos/tutos/php/checklist/mtable.pinc,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- mtable.pinc	18 Oct 2002 21:30:11 -0000	1.3
+++ mtable.pinc	30 Oct 2002 19:37:38 -0000	1.4
@@ -13,17 +13,17 @@
 $table['checklists'] = array(
   name => "checklists",
   Desc => "TUTOS chechlists",
-  array( column  => "id",          type => "ID_TYPE",     constraints => "PK",  Desc => "Object ID"),
-  array( column  => "link_id",     type => "ID_TYPE",     constraints => "NN",  Desc => "id of linked object"),
-  array( column  => "name",        type => "varchar(40)", constraints => "",    Desc => "name of checklist"),
-  array( column  => "description", type => "varchar(60)", constraints => "",    Desc => "description"),
-  array( column  => "cl_type",     type => "ID_TYPE",     constraints => "NN",  Desc => "type of checklist (templ, class, instance,...)"),
-  array( column  => "class_id",    type => "ID_TYPE",     constraints => "NN",  Desc => "id of checklist-class"),
-  array( column  => "creator",     type => "ID_TYPE",     constraints => "NN",  Desc => "creator ID"),
-  array( column  => "creation",    type => "TS_TYPE",     constraints => "NN",  Desc => "creation date"),
-  array( column  => "modificator", type => "ID_TYPE",     constraints => "",    Desc => "midificator ID"),
-  array( column  => "modification",type => "TS_TYPE",     constraints => "",    Desc => "modification date"),
-  array( column  => "deleted",     type => "TS_TYPE",     constraints => "",    Desc => "deleted at date or NULL")
+  "id"           => array(type => "ID_TYPE",     constraints => "PK",  Desc => "Object ID"),
+  "link_id"      => array(type => "ID_TYPE",     constraints => "NN",  Desc => "id of linked object"),
+  "name"         => array(type => "varchar(40)", constraints => "",    Desc => "name of checklist"),
+  "description"  => array(type => "varchar(60)", constraints => "",    Desc => "description"),
+  "cl_type"      => array(type => "ID_TYPE",     constraints => "NN",  Desc => "type of checklist (templ, class, instance,...)"),
+  "class_id"     => array(type => "ID_TYPE",     constraints => "NN",  Desc => "id of checklist-class"),
+  "creator"      => array(type => "ID_TYPE",     constraints => "NN",  Desc => "creator ID"),
+  "creation"     => array(type => "TS_TYPE",     constraints => "NN",  Desc => "creation date"),
+  "modificator"  => array(type => "ID_TYPE",     constraints => "",    Desc => "midificator ID"),
+  "modification" => array(type => "TS_TYPE",     constraints => "",    Desc => "modification date"),
+  "deleted"      => array(type => "TS_TYPE",     constraints => "",    Desc => "deleted at date or NULL")
 );
 
 $tableidx['checklists1'] = array(
@@ -49,21 +49,21 @@
 $table['checkfields'] = array(
   name => "checkfields",
   Desc => "TUTOS chechlists fields",
-  array( column  => "id",          type => "ID_TYPE",     constraints => "PK",  Desc => "Object ID"),
-  array( column  => "cl_id",       type => "ID_TYPE",     constraints => "NN",  Desc => "id of  checklist"),
-  array( column  => "fidinclass",  type => "ID_TYPE",     constraints => "NN",  Desc => "id of field in checklist-class"),
-  array( column  => "name",        type => "varchar(40)", constraints => "",    Desc => "name of checklist-field"),
-  array( column  => "text",        type => "TX_TYPE",     constraints => "",    Desc => "text of checklist-field"),
-  array( column  => "help",        type => "TX_TYPE",     constraints => "",    Desc => "helptext of checklist-field"),
-  array( column  => "f_type",      type => "ID_TYPE",     constraints => "NN",  Desc => "type of checklist-field (checkbox, boolean,...)"),
-  array( column  => "f_val_n",     type => "ID_TYPE",     constraints => "NN",  Desc => "number-value of checklist-field"),
-  array( column  => "f_val_max",   type => "ID_TYPE",     constraints => "NN",  Desc => "max-value of number-value"),
-  array( column  => "f_val_t",     type => "TX_TYPE",     constraints => "NN",  Desc => "text-value of checklist-field"),
-  array( column  => "creator",     type => "ID_TYPE",     constraints => "NN",  Desc => "creator ID"),
-  array( column  => "creation",    type => "TS_TYPE",     constraints => "NN",  Desc => "creation date"),
-  array( column  => "modificator", type => "ID_TYPE",     constraints => "",    Desc => "midificator ID"),
-  array( column  => "modification",type => "TS_TYPE",     constraints => "",    Desc => "modification date"),
-  array( column  => "deleted",     type => "TS_TYPE",     constraints => "",    Desc => "deleted at date or NULL")
+  "id"           => array(type => "ID_TYPE",     constraints => "PK",  Desc => "Object ID"),
+  "cl_id"        => array(type => "ID_TYPE",     constraints => "NN",  Desc => "id of  checklist"),
+  "fidinclass"   => array(type => "ID_TYPE",     constraints => "NN",  Desc => "id of field in checklist-class"),
+  "name"         => array(type => "varchar(40)", constraints => "",    Desc => "name of checklist-field"),
+  "text"         => array(type => "TX_TYPE",     constraints => "",    Desc => "text of checklist-field"),
+  "help"         => array(type => "TX_TYPE",     constraints => "",    Desc => "helptext of checklist-field"),
+  "f_type"       => array(type => "ID_TYPE",     constraints => "NN",  Desc => "type of checklist-field (checkbox, boolean,...)"),
+  "f_val_n"      => array(type => "ID_TYPE",     constraints => "NN",  Desc => "number-value of checklist-field"),
+  "f_val_max"    => array(type => "ID_TYPE",     constraints => "NN",  Desc => "max-value of number-value"),
+  "f_val_t"      => array(type => "TX_TYPE",     constraints => "NN",  Desc => "text-value of checklist-field"),
+  "creator"      => array(type => "ID_TYPE",     constraints => "NN",  Desc => "creator ID"),
+  "creation"     => array(type => "TS_TYPE",     constraints => "NN",  Desc => "creation date"),
+  "modificator"  => array(type => "ID_TYPE",     constraints => "",    Desc => "midificator ID"),
+  "modification" => array(type => "TS_TYPE",     constraints => "",    Desc => "modification date"),
+  "deleted"      => array(type => "TS_TYPE",     constraints => "",    Desc => "deleted at date or NULL")
 );
 
 $tableidx['checkfields1'] = array(