/**
* Define database schema used by this active record instance
*
* @param string $className Schema name
*/
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("parentTransactionID", "Transaction", "ID", "Transaction", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("orderID", "CustomerOrder", "ID", "CustomerOrder", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("currencyID", "currency", "ID", 'Currency', ARChar::instance(3)));
$schema->registerField(new ARForeignKeyField("realCurrencyID", "realCurrency", "ID", 'Currency', ARChar::instance(3)));
$schema->registerField(new ARForeignKeyField("userID", "user", "ID", 'User', ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("eavObjectID", "eavObject", "ID", 'EavObject', ARInteger::instance()), false);
$schema->registerField(new ARField("amount", ARFloat::instance()));
$schema->registerField(new ARField("realAmount", ARFloat::instance()));
$schema->registerField(new ARField("time", ARDateTime::instance()));
$schema->registerField(new ARField("method", ARVarchar::instance(40)));
$schema->registerField(new ARField("gatewayTransactionID", ARVarchar::instance(40)));
$schema->registerField(new ARField("type", ARInteger::instance()));
$schema->registerField(new ARField("methodType", ARInteger::instance()));
$schema->registerField(new ARField("isCompleted", ARBool::instance()));
$schema->registerField(new ARField("isVoided", ARBool::instance()));
$schema->registerField(new ARField("ccExpiryYear", ARInteger::instance()));
$schema->registerField(new ARField("ccExpiryMonth", ARInteger::instance()));
$schema->registerField(new ARField("ccLastDigits", ARVarchar::instance(40)));
$schema->registerField(new ARField("ccType", ARVarchar::instance(40)));
$schema->registerField(new ARField("ccName", ARVarchar::instance(100)));
$schema->registerField(new ARField("ccCVV", ARVarchar::instance(80)));
$schema->registerField(new ARField("comment", ARText::instance()));
$schema->registerField(new ARField("serializedData", ARText::instance()));
}
/**
* Define database schema used by this active record instance
*
* @param string $className Schema name
*/
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("parentID", "CustomerOrder", "ID", "CustomerOrder", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("userID", "User", "ID", "User", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("shippingAddressID", "shippingAddress", "ID", 'UserAddress', ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("billingAddressID", "billingAddress", "ID", 'UserAddress', ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("currencyID", "currency", "ID", 'Currency', ARChar::instance(3)));
$schema->registerField(new ARForeignKeyField("eavObjectID", "eavObject", "ID", 'EavObject', ARInteger::instance()), false);
$schema->registerField(new ARField("invoiceNumber", ARVarchar::instance(40)));
$schema->registerField(new ARField("checkoutStep", ARInteger::instance()));
$schema->registerField(new ARField("dateCreated", ARDateTime::instance()));
$schema->registerField(new ARField("dateCompleted", ARDateTime::instance()));
$schema->registerField(new ARField("dateDue", ARDateTime::instance()));
$schema->registerField(new ARField("startDate", ARDateTime::instance()));
// including (first day of period)
$schema->registerField(new ARField("endDate", ARDateTime::instance()));
// including (last day of period)
$schema->registerField(new ARField("totalAmount", ARFloat::instance()));
$schema->registerField(new ARField("capturedAmount", ARFloat::instance()));
$schema->registerField(new ARField("isMultiAddress", ARBool::instance()));
$schema->registerField(new ARField("isFinalized", ARBool::instance()));
$schema->registerField(new ARField("isPaid", ARBool::instance()));
$schema->registerField(new ARField("isCancelled", ARBool::instance()));
$schema->registerField(new ARField("isRecurring", ARBool::instance()));
$schema->registerField(new ARField("status", ARInteger::instance()));
$schema->registerField(new ARField("shipping", ARText::instance()));
$schema->registerField(new ARField("rebillsLeft", ARInteger::instance()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName("DeliveryZoneCityMask");
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("deliveryZoneID", "DeliveryZone", "ID", "DeliveryZone", ARInteger::instance()));
$schema->registerField(new ARField("mask", ARChar::instance(60)));
}
/**
* Languages schema definition
* @param string $className
* @todo code must be Unique
*/
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName("Language");
$schema->registerField(new ARPrimaryKeyField("ID", ARChar::instance(2)));
$schema->registerField(new ARField("isEnabled", ARBool::instance()));
$schema->registerField(new ARField("isDefault", ARBool::instance()));
$schema->registerField(new ARField("position", ARInteger::instance()));
}
/**
* Define database schema
*/
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARField("countryID", ARChar::instance(2)));
$schema->registerField(new ARField("code", ARVarchar::instance(40)));
$schema->registerField(new ARField("name", ARVarchar::instance(100)));
$schema->registerField(new ARField("subdivisionType", ARVarchar::instance(60)));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName("ProductPrice");
$schema->registerField(new ARPrimaryForeignKeyField("productID", "Product", "ID", null, ARInteger::instance()));
$schema->registerField(new ARPrimaryForeignKeyField("currencyID", "Currency", "ID", null, ARChar::instance(3)));
$schema->registerField(new ARField("price", ARFloat::instance(16)));
$schema->registerField(new ARField("listPrice", ARFloat::instance(16)));
$schema->registerField(new ARField("serializedRules", ARText::instance(16)));
}
/**
* Define database schema
*/
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("stateID", "State", "ID", 'State', ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("eavObjectID", "eavObject", "ID", 'EavObject', ARInteger::instance()), false);
$schema->registerField(new ARField("firstName", ARVarchar::instance(60)));
$schema->registerField(new ARField("lastName", ARVarchar::instance(60)));
$schema->registerField(new ARField("companyName", ARVarchar::instance(60)));
$schema->registerField(new ARField("address1", ARVarchar::instance(255)));
$schema->registerField(new ARField("address2", ARVarchar::instance(255)));
$schema->registerField(new ARField("city", ARVarchar::instance(255)));
$schema->registerField(new ARField("stateName", ARVarchar::instance(255)));
$schema->registerField(new ARField("postalCode", ARVarchar::instance(50)));
$schema->registerField(new ARField("countryID", ARChar::instance(2)));
$schema->registerField(new ARField("phone", ARVarchar::instance(100)));
$schema->registerAutoReference('stateID');
}
