$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(); /* * FrequencyValue Table * * Stores a specific frequency value (i.e. 'January 2008'. * * freqvalue_id [INTEGER] the unique identifier * freq_id [INTEGER] the id of the parent frequency type * freqvalue_value [DATE] the actual frequency value (in date-time form) * freqvalue_desc [STRING] The user-friendly description of the frequency value (i.e. 'January 2008' for '2008-01-01 00:00:00') */ $FrequencyValue = new RowManager_FreqValueManager(); $FrequencyValue->dropTable(); $FrequencyValue->createTable(); /*
