Example #1
0
 $DataType->createTable();
 /*
  * PriceRule Table
  *
  * A pricing rule (i.e. frosh discount) for a particular event.
  *
  * pricerules_id [INTEGER]  Unique identifier for this pricing rule
  * event_id [INTEGER]  Event identifier used to identify event associated with the pricing rule.
  * priceruletypes_id [INTEGER]  Identifies the price rule type of the particular rule
  * pricerules_desc [STRING]  Description of the pricing rule
  * fields_id [INTEGER]  If not zero, refers to a form field identifier that affects the price for the event.
  * pricerules_value [STRING]  A value that is used to determine when the price rule is applied (i.e. a date or a volume total, etc.)
  * pricerules_discount [INTEGER]  The actual discount to be applied to the price based on this price rule.
  */
 $PriceRule = new RowManager_PriceRuleManager();
 $PriceRule->dropTable();
 $PriceRule->createTable();
 /*
  * EventAdminCampusAssignment Table
  *
  * Assigns the event admin privileges of some user to a particular campus.
  *
  * campusaccess_id [INTEGER]  Identifier for a particular campus assignment to some event admin
  * eventadmin_id [INTEGER]  Identifier of the event admin who will be assigned a campus
  * campus_id [INTEGER]  The unique identifier that describes a particular university campus
  */
 $EventAdminCampusAssignment = new RowManager_EventAdminCampusAssignmentManager();
 $EventAdminCampusAssignment->dropTable();
 $EventAdminCampusAssignment->createTable();
 /*
  * CashTransaction Table