public function registerClass($className, $id)
{
self::getEavClasses();
self::$eavClasses[$className] = $id;
$schema = self::getSchemaInstance('EavObject');
$schema->registerField(new ARForeignKeyField(EavObject::getClassField($className), $className, "ID", null, ARInteger::instance()), false);
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryKeyField('ID', ARInteger::instance()));
$schema->registerField(new ARField('name', ARVarchar::instance(60)));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName("Role");
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance(10)));
$schema->registerField(new ARField("name", ARText::instance(150)));
}
/**
* Define database schema for Category model
*
* @param string $className Schema name
*/
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
parent::defineSchema($className);
$schema->registerField(new ARField("isEnabled", ARBool::instance()));
$schema->registerField(new ARField("isAnyRecord", ARBool::instance()));
$schema->registerField(new ARField("isAllSubconditions", ARBool::instance()));
$schema->registerField(new ARField("isActionCondition", ARBool::instance()));
$schema->registerField(new ARField("isFinal", ARBool::instance()));
$schema->registerField(new ARField("isReverse", ARBool::instance()));
$schema->registerField(new ARField("conditionClass", ARVarchar::instance(80)));
$schema->registerField(new ARField("recordCount", ARInteger::instance()));
$schema->registerField(new ARField("validFrom", ARDateTime::instance()));
$schema->registerField(new ARField("validTo", ARDateTime::instance()));
$schema->registerField(new ARField("subTotal", ARInteger::instance()));
$schema->registerField(new ARField("count", ARInteger::instance()));
$schema->registerField(new ARField("comparisonType", ARInteger::instance()));
$schema->registerField(new ARField("position", ARInteger::instance()));
$schema->registerField(new ARField("name", ARArray::instance()));
$schema->registerField(new ARField("description", ARArray::instance()));
$schema->registerField(new ARField("couponCode", ARVarchar::instance(100)));
$schema->registerField(new ARField("couponLimitCount", ARInteger::instance()));
$schema->registerField(new ARField("couponLimitType", ARInteger::instance()));
$schema->registerField(new ARField("serializedCondition", ARText::instance()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryForeignKeyField('categoryID', 'Category', 'ID', 'Category', ARInteger::instance()));
$schema->registerField(new ARPrimaryForeignKeyField('productID', 'Product', 'ID', 'Product', ARInteger::instance()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = parent::defineSchema($className);
$schema->setName("ProductRelationshipGroup");
$schema->registerField(new ARField("name", ARArray::instance()));
$schema->registerField(new ARField("type", ARInteger::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("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()));
}
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)));
}
public static function defineSchema($className)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryForeignKeyField(call_user_func(array($className, 'getOwnerIDColumnName')), call_user_func(array($className, 'getOwnerClass')), "ID", null, ARInteger::instance()));
$schema->registerField(new ARPrimaryForeignKeyField(call_user_func(array($className, 'getFieldIDColumnName')), call_user_func(array($className, 'getFieldClass')), "ID", null, ARInteger::instance()));
return $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("name", ARArray::instance()));
$schema->registerField(new ARField("position", ARInteger::instance(2)));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName("AccessControlAssociation");
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("roleID", "Role", "ID", "Role", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("userGroupID", "UserGroup", "ID", "UserGroup", ARInteger::instance()));
}
/**
* Define database schema
*/
public static function defineSchema($className)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("userID", "user", "ID", 'User', ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("userAddressID", "userAddress", "ID", 'UserAddress', ARInteger::instance()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("productID", "Product", "ID", null, ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("variationID", "ProductVariation", "ID", null, ARInteger::instance()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName("UserGroup");
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("eavObjectID", "eavObject", "ID", 'EavObject', ARInteger::instance()), false);
$schema->registerField(new ARField("name", ARVarchar::instance(60)));
$schema->registerField(new ARField("description", ARVarchar::instance(100)));
}
/**
* 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("orderID", "CustomerOrder", "ID", "CustomerOrder", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("discountConditionID", "DiscountCondition", "ID", "DiscountCondition", ARInteger::instance()));
$schema->registerField(new ARField("couponCode", ARVarchar::instance(255)));
}
/**
* 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("orderID", "CustomerOrder", "ID", "CustomerOrder", ARInteger::instance()));
$schema->registerField(new ARField("amount", ARFloat::instance()));
$schema->registerField(new ARField("description", ARText::instance()));
}
/**
* 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()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName(__CLASS__);
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("categoryID", "Category", "ID", null, ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("storeID", "ClonedStore", "ID", null, ARInteger::instance()));
$schema->registerField(new ARField("lastModifiedTime", ARDateTime::instance()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName(__CLASS__);
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARField("domain", ARVarchar::instance(100)));
$schema->registerField(new ARField("apiKey", ARVarchar::instance(100)));
$schema->registerField(new ARField("lastImport", ARDateTime::instance()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName("UserApnToken");
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARField("userID", ARInteger::instance()));
$schema->registerField(new ARField("token", ARVarchar::instance(256)));
$schema->registerField(new ARField("dateCreated", ARDateTime::instance()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryKeyField('ID', ARInteger::instance()));
$schema->registerField(new ARForeignKeyField('categoryID', 'Category', 'ID', null, ARInteger::instance()));
$schema->registerField(new ARField('name', ARArray::instance()));
$schema->registerField(new ARField('position', ARInteger::instance()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryForeignKeyField("productID", "Product", "ID", "Product", ARInteger::instance()));
$schema->registerField(new ARPrimaryForeignKeyField("relatedProductID", "Product", "ID", "Product", ARInteger::instance()));
$schema->registerField(new ARField("position", ARInteger::instance()));
$schema->registerField(new ARField("count", ARFloat::instance()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryKeyField("ID", ArChar::instance(32)));
$schema->registerField(new ARForeignKeyField("userID", "User", "ID", "User", ARInteger::instance()));
$schema->registerField(new ARField("lastUpdated", ArInteger::instance(12)));
$schema->registerField(new ARField("cacheUpdated", ArInteger::instance(12)));
$schema->registerField(new ARField("data", ArBinary::instance(0)));
}
/**
* 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("orderedItemID", "OrderedItem", "ID", "OrderedItem", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("productFileID", "ProductFile", "ID", "ProductFile", ARInteger::instance()));
$schema->registerField(new ARField("timesDownloaded", ARInteger::instance()));
$schema->registerField(new ARField("lastDownloadTime", ARDateTime::instance()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryKeyField('ID', ARInteger::instance()));
$schema->registerField(new ARForeignKeyField('productListID', 'ProductList', 'ID', null, ARInteger::instance()));
$schema->registerField(new ARForeignKeyField('productID', 'Product', 'ID', null, ARInteger::instance()));
$schema->registerField(new ARField('position', ARInteger::instance()));
$schema->registerAutoReference('productID');
}
/**
* 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)));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName(__CLASS__);
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("taxRateID", "TaxRate", "ID", "TaxRate", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("shipmentID", "Shipment", "ID", "Shipment", ARInteger::instance()));
$schema->registerField(new ARField("type", ARInteger::instance(2)));
$schema->registerField(new ARField("amount", ARFloat::instance()));
}
public static function defineSchema($className = __CLASS__)
{
$schema = self::getSchemaInstance($className);
$schema->setName($className);
$schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("messageID", "NewsletterMessage", "ID", null, ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("userID", "User", "ID", null, ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("subscriberID", "NewsletterSubscriber", "ID", null, ARInteger::instance()));
//$schema->registerField(new ARField("time", ARDateTime::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 ARForeignKeyField("addressID", "address", "ID", 'UserAddress', ARInteger::instance()));
$schema->registerField(new ARForeignKeyField("orderID", "order", "ID", 'CustomerOrder', ARInteger::instance()));
$schema->registerField(new ARField("method", ARVarchar::instance(40)));
$schema->registerField(new ARField("paymentData", ARText::instance()));
}
