PHP RowManager_LocationManager::createTable示例

示例#1

文件： tool_setup.php 项目： andrewroth/c4c_intranet

 $StatsRegion->createTable();
 /*
  * Location Table
  *
  * A location associated with a ministry-division-region
  *
  * location_id [INTEGER]  unique identifier of this Location
  * location_name [STRING]  the Location's name
  * location_desc [STRING]  the description of the Location
  * region_id [INTEGER]  the id of the Region associated with this Location
  * division_id [INTEGER]  the id of the associated Division
  * ministry_id [INTEGER]  the id of the Ministry associated with this Location
  */
 $Location = new RowManager_LocationManager();
 $Location->dropTable();
 $Location->createTable();
 /*
  * FrequencyType Table
  *
  * Defines a frequency type (i.e. 'weekly')
  *
  * freq_id [INTEGER]  unique id of freq. type
  * freq_name [STRING]  The name of the frequency type
  * freq_desc [STRING]  The description of the freq. type
  * freq_parent_date_field_index [INTEGER]  The field index of the date field corresponding to this frequency type's parent value (i.e. parent of 'weekly' is 'monthly' ==> index 2 of YYYY-MM-DD HH:min:SS)
  * freq_parent_date_field_name [STRING]  the name of the date field corresponding to the parent frequency (i.e. 'year' for index 1 of YYYY-MM-DD HH:min:SS)
  * freq_parent_freq_id [INTEGER]  The frequency type id associated with the parent frequency (may be case that no freq specified - i.e. 'yearly' is at top and has no parent freq)
  */
 $FrequencyType = new RowManager_FreqTypeManager();
 $FrequencyType->dropTable();
 $FrequencyType->createTable();