/** * 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 = parent::defineSchema($className); $schema->setName("ProductRelationshipGroup"); $schema->registerField(new ARField("name", ARArray::instance())); $schema->registerField(new ARField("type", 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 ARField("name", ARArray::instance())); $schema->registerField(new ARField("position", ARInteger::instance(2))); }
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 ARPrimaryKeyField("ID", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("typeID", "ProductVariationType", "ID", null, ARInteger::instance())); $schema->registerField(new ARField("name", ARArray::instance())); $schema->registerField(new ARField("position", ARInteger::instance(4))); }
public static function defineSchema($className = __CLASS__) { $schema = self::getSchemaInstance($className); $schema->setName("ProductOptionChoice"); $schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("optionID", "ProductOption", "ID", "ProductOption", ARInteger::instance())); $schema->registerField(new ARField("priceDiff", ARFloat::instance(4))); $schema->registerField(new ARField("hasImage", ARBool::instance())); $schema->registerField(new ARField("position", ARInteger::instance(4))); $schema->registerField(new ARField("name", ARArray::instance())); $schema->registerCircularReference('Option', 'ProductOption'); }
/** * Define FilterGroup database schema */ public static function defineSchema() { $schema = self::getSchemaInstance(__CLASS__); $schema->setName(__CLASS__); $schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("specFieldID", "SpecField", "ID", "SpecField", ARInteger::instance())); $schema->registerField(new ARField("name", ARArray::instance())); $schema->registerField(new ARField("position", ARInteger::instance())); $schema->registerField(new ARField("isEnabled", ARInteger::instance(1))); $schema->registerField(new ARField("displayStyle", ARInteger::instance())); $schema->registerField(new ARField("displayLocation", 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 ARField("isEnabled", ARBool::instance())); $schema->registerField(new ARField("position", ARInteger::instance())); $schema->registerField(new ARField("time", ARDateTime::instance())); $schema->registerField(new ARField("title", ARArray::instance())); $schema->registerField(new ARField("text", ARArray::instance())); $schema->registerField(new ARField("moreText", ARArray::instance())); }
public static function defineSchema() { $schema = self::getSchemaInstance(__CLASS__); $schema->setName(__CLASS__); $schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("productID", "Product", "ID", null, ARInteger::instance())); $schema->registerField(new ARField("position", ARInteger::instance())); $schema->registerField(new ARField("periodType", ARInteger::instance())); $schema->registerField(new ARField("periodLength", ARInteger::instance())); $schema->registerField(new ARField("rebillCount", ARInteger::instance())); $schema->registerField(new ARField("name", ARArray::instance())); $schema->registerField(new ARField("description", ARArray::instance())); }
public static function defineSchema($className = __CLASS__) { $schema = parent::defineSchema($className); $schema->registerField(new ARForeignKeyField("productID", "Product", "ID", "Product", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("productFileGroupID", "ProductFileGroup", "ID", "ProductFileGroup", ARInteger::instance())); $schema->registerField(new ARField("isPublic", ARBool::instance())); $schema->registerField(new ARField("isEmbedded", ARBool::instance())); $schema->registerField(new ARField("title", ARArray::instance())); $schema->registerField(new ARField("description", ARArray::instance())); $schema->registerField(new ARField("position", ARInteger::instance())); $schema->registerField(new ARField("allowDownloadDays", ARInteger::instance())); $schema->registerField(new ARField("allowDownloadCount", ARInteger::instance())); }
public static function defineSchema($className = __CLASS__) { $schema = self::getSchemaInstance($className); $schema->setName("ProductPrice"); $schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("productID", "Product", "ID", null, ARInteger::instance())); $schema->registerField(new ARForeignKeyField("currencyID", "Currency", "ID", null, ARChar::instance(3))); $schema->registerField(new ARForeignKeyField("recurringID", "RecurringProductPeriod", "ID", "RecurringProductPeriod", ARInteger::instance())); $schema->registerField(new ARField("price", ARFloat::instance(16))); $schema->registerField(new ARField("listPrice", ARFloat::instance(16))); $schema->registerField(new ARField("type", ARInteger::instance())); $schema->registerField(new ARField("serializedRules", ARArray::instance())); }
/** * Define Filter schema */ public static function defineSchema() { $schema = self::getSchemaInstance(__CLASS__); $schema->setName(__CLASS__); $schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("filterGroupID", "FilterGroup", "ID", "FilterGroup", ARInteger::instance())); $schema->registerField(new ARField("name", ARArray::instance())); $schema->registerField(new ARField("position", ARInteger::instance(2))); $schema->registerField(new ARField("rangeStart", ARFloat::instance(40))); $schema->registerField(new ARField("rangeEnd", ARFloat::instance(40))); $schema->registerField(new ARField("rangeDateStart", ARDate::instance())); $schema->registerField(new ARField("rangeDateEnd", ARDate::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("parentID", "StaticPage", "ID", null, ARInteger::instance())); $schema->registerField(new ARField("handle", ARVarchar::instance(255))); $schema->registerField(new ARField("title", ARArray::instance())); $schema->registerField(new ARField("text", ARArray::instance())); $schema->registerField(new ARField("metaDescription", ARArray::instance())); $schema->registerField(new ARField("menu", ARArray::instance())); $schema->registerField(new ARField("position", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("eavObjectID", "eavObject", "ID", 'EavObject', ARInteger::instance()), false); }
/** * 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("userID", "user", "ID", "User", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("orderID", "order", "ID", 'CustomerOrder', ARInteger::instance())); $schema->registerField(new ARField("type", ARInteger::instance())); $schema->registerField(new ARField("action", ARInteger::instance())); $schema->registerField(new ARField("time", ARDateTime::instance())); $schema->registerField(new ARField("oldTotal", ARFloat::instance())); $schema->registerField(new ARField("newTotal", ARFloat::instance())); $schema->registerField(new ARField("oldValue", ARArray::instance())); $schema->registerField(new ARField("newValue", ARArray::instance())); }
public static function defineSchema($className = __CLASS__) { $schema = self::getSchemaInstance($className); $schema->setName("ShippingService"); $schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("deliveryZoneID", "DeliveryZone", "ID", "DeliveryZone", ARInteger::instance())); $schema->registerField(new ARField("isFinal", ARBool::instance())); $schema->registerField(new ARField("name", ARArray::instance())); $schema->registerField(new ARField("position", ARInteger::instance(10))); $schema->registerField(new ARField("rangeType", ARInteger::instance(1))); $schema->registerField(new ARField("description", ARArray::instance())); $schema->registerField(new ARField("deliveryTimeMinDays", ARInteger::instance(10))); $schema->registerField(new ARField("deliveryTimeMaxDays", ARInteger::instance(10))); $schema->registerField(new ARForeignKeyField("eavObjectID", "eavObject", "ID", 'EavObject', ARInteger::instance()), false); }
public static function defineSchema($className = __CLASS__) { $schema = self::getSchemaInstance($className); $schema->setName("ShippingRate"); $schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("shippingServiceID", "ShippingService", "ID", "ShippingService", ARInteger::instance())); $schema->registerField(new ARField("weightRangeStart", ARFloat::instance())); $schema->registerField(new ARField("weightRangeEnd", ARFloat::instance())); $schema->registerField(new ARField("subtotalRangeStart", ARFloat::instance())); $schema->registerField(new ARField("subtotalRangeEnd", ARFloat::instance())); $schema->registerField(new ARField("flatCharge", ARFloat::instance())); $schema->registerField(new ARField("perItemCharge", ARFloat::instance())); $schema->registerField(new ARField("subtotalPercentCharge", ARFloat::instance())); $schema->registerField(new ARField("perKgCharge", ARFloat::instance())); $schema->registerField(new ArField("perItemChargeClass", ARArray::instance())); }
/** * Define database schema for Category model * * @param string $className Schema name */ public static function defineSchema($className = __CLASS__) { $schema = self::getSchemaInstance($className); $schema->setName("Category"); parent::defineSchema($className); $schema->registerField(new ARForeignKeyField("defaultImageID", "categoryImage", "ID", 'CategoryImage', ARInteger::instance())); $schema->registerField(new ARForeignKeyField("eavObjectID", "eavObject", "ID", 'EavObject', ARInteger::instance()), false); $schema->registerField(new ARField("name", ARArray::instance())); $schema->registerField(new ARField("description", ARArray::instance())); $schema->registerField(new ARField("keywords", ARArray::instance())); $schema->registerField(new ARField("pageTitle", ARArray::instance())); $schema->registerField(new ARField("isEnabled", ARBool::instance())); $schema->registerField(new ARField("availableProductCount", ARInteger::instance())); $schema->registerField(new ARField("activeProductCount", ARInteger::instance())); $schema->registerField(new ARField("totalProductCount", 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("productID", "Product", "ID", "Product", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("customerOrderID", "CustomerOrder", "ID", "CustomerOrder", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("shipmentID", "Shipment", "ID", "Shipment", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("parentID", "OrderedItem", "ID", "OrderedItem", ARInteger::instance())); $schema->registerField(new ARField("price", ARFloat::instance())); $schema->registerField(new ARField("count", ARFloat::instance())); $schema->registerField(new ARField("reservedProductCount", ARFloat::instance())); $schema->registerField(new ARField("dateAdded", ARDateTime::instance())); $schema->registerField(new ARField("isSavedForLater", ARInteger::instance())); $schema->registerField(new ARField("name", ARArray::instance())); }
public static function defineSchema($className = __CLASS__) { $schema = self::getSchemaInstance($className); $schema->setName("Product"); $schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("categoryID", "Category", "ID", null, ARInteger::instance())); $schema->registerField(new ARForeignKeyField("manufacturerID", "Manufacturer", "ID", null, ARInteger::instance())); $schema->registerField(new ARForeignKeyField("defaultImageID", "ProductImage", "ID", null, ARInteger::instance())); $schema->registerField(new ARForeignKeyField("parentID", "Product", "ID", null, ARInteger::instance())); $schema->registerField(new ARForeignKeyField("shippingClassID", "ShippingClass", "ID", null, ARInteger::instance())); $schema->registerField(new ARForeignKeyField("taxClassID", "TaxClass", "ID", null, ARInteger::instance())); $schema->registerField(new ARField("isEnabled", ARBool::instance())); $schema->registerField(new ARField("sku", ARVarchar::instance(20)))->validate('required', 'IsUniqueSkuCheck'); $schema->registerField(new ARField("name", ARArray::instance()))->validate('required'); $schema->registerField(new ARField("shortDescription", ARArray::instance())); $schema->registerField(new ARField("longDescription", ARArray::instance())); $schema->registerField(new ARField("keywords", ARText::instance())); $schema->registerField(new ARField("pageTitle", ARArray::instance())); $schema->registerField(new ARField("dateCreated", ARDateTime::instance())); $schema->registerField(new ARField("dateUpdated", ARDateTime::instance())); $schema->registerField(new ARField("URL", ARVarchar::instance(256))); $schema->registerField(new ARField("isFeatured", ARBool::instance())); $schema->registerField(new ARField("type", ARInteger::instance(4))); $schema->registerField(new ArField("ratingSum", ARInteger::instance())); //->protect(); $schema->registerField(new ArField("ratingCount", ARInteger::instance())); $schema->registerField(new ArField("rating", ARFloat::instance(8))); $schema->registerField(new ArField("reviewCount", ARInteger::instance())); $schema->registerField(new ArField("minimumQuantity", ARFloat::instance(8))); $schema->registerField(new ArField("shippingSurchargeAmount", ARFloat::instance(8))); $schema->registerField(new ArField("isSeparateShipment", ARBool::instance())); $schema->registerField(new ArField("isFreeShipping", ARBool::instance())); $schema->registerField(new ArField("isBackOrderable", ARBool::instance())); $schema->registerField(new ArField("isFractionalUnit", ARBool::instance())); $schema->registerField(new ArField("isUnlimitedStock", ARBool::instance())); $schema->registerField(new ArField("shippingWeight", ARFloat::instance(8))); $schema->registerField(new ArField("stockCount", ARFloat::instance(8))); $schema->registerField(new ArField("reservedCount", ARFloat::instance(8))); $schema->registerField(new ArField("salesRank", ARInteger::instance())); $schema->registerField(new ArField("childSettings", ARText::instance())); $schema->registerField(new ArField("fractionalStep", ARFloat::instance(8))); $schema->registerField(new ArField("position", ARInteger::instance())); $schema->registerField(new ArField("categoryIntervalCache", ARText::instance())); $schema->registerField(new ArField("isRecurring", ARBool::instance())); }
public static function defineSchema($className = __CLASS__) { $schema = self::getSchemaInstance($className); $schema->setName("User"); $schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("defaultShippingAddressID", "defaultShippingAddress", "ID", 'ShippingAddress', ARInteger::instance())); $schema->registerField(new ARForeignKeyField("defaultBillingAddressID", "defaultBillingAddress", "ID", 'BillingAddress', ARInteger::instance())); $schema->registerField(new ARForeignKeyField("userGroupID", "UserGroup", "ID", "UserGroup", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("eavObjectID", "eavObject", "ID", 'EavObject', ARInteger::instance()), false); $schema->registerField(new ARField("locale", ARVarchar::instance(4))); $schema->registerField(new ARField("email", ARVarchar::instance(60))); $schema->registerField(new ARField("password", ARVarchar::instance(32))); $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("dateCreated", ARDateTime::instance())); $schema->registerField(new ARField("isEnabled", ARBool::instance())); $schema->registerField(new ARField("preferences", ARArray::instance())); }
/** * Define database schema */ public static function defineSchema($className) { $schema = self::getSchemaInstance($className); $schema->setName($className); $schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance())); $group = $className . 'Group'; $schema->registerField(new ARForeignKeyField(strtolower(substr($group, 0, 1)) . substr($group, 1) . 'ID', $group, "ID", $group, ARInteger::instance())); $schema->registerField(new ARField("name", ARArray::instance())); $schema->registerField(new ARField("description", ARArray::instance())); $schema->registerField(new ARField("type", ARInteger::instance(2))); $schema->registerField(new ARField("dataType", ARInteger::instance(2))); $schema->registerField(new ARField("position", ARInteger::instance(2))); $schema->registerField(new ARField("handle", ARVarchar::instance(40))); $schema->registerField(new ARField("isMultiValue", ARBool::instance())); $schema->registerField(new ARField("isRequired", ARBool::instance())); $schema->registerField(new ARField("isDisplayed", ARBool::instance())); $schema->registerField(new ARField("isDisplayedInList", ARBool::instance())); $schema->registerField(new ARField("valuePrefix", ARArray::instance())); $schema->registerField(new ARField("valueSuffix", ARArray::instance())); return $schema; }
public static function defineSchema($className = __CLASS__) { $schema = self::getSchemaInstance($className); $schema->setName("ProductOption"); $schema->registerField(new ARPrimaryKeyField("ID", ARInteger::instance())); $schema->registerField(new ARForeignKeyField("productID", "Product", "ID", null, ARInteger::instance())); $schema->registerField(new ARForeignKeyField("categoryID", "Category", "ID", null, ARInteger::instance())); $schema->registerField(new ARForeignKeyField("defaultChoiceID", "ProductOptionChoice", "ID", "ProductOptionChoice", ARInteger::instance())); $schema->registerField(new ARField("name", ARArray::instance())); $schema->registerField(new ARField("description", ARArray::instance())); $schema->registerField(new ARField("selectMessage", ARArray::instance())); $schema->registerField(new ARField("type", ARInteger::instance(4))); $schema->registerField(new ARField("displayType", ARInteger::instance(4))); $schema->registerField(new ARField("isRequired", ARBool::instance())); $schema->registerField(new ARField("isDisplayed", ARBool::instance())); $schema->registerField(new ARField("isDisplayedInList", ARBool::instance())); $schema->registerField(new ARField("isDisplayedInCart", ARBool::instance())); $schema->registerField(new ARField("isPriceIncluded", ARBool::instance())); $schema->registerField(new ARField("position", ARInteger::instance(4))); $schema->registerField(new ARField("maxFileSize", ARInteger::instance(4))); $schema->registerField(new ARField("fileExtensions", ARVarchar::instance(100))); $schema->registerCircularReference('DefaultChoice', 'ProductOptionChoice'); }
public static function defineSchema($className = __CLASS__) { $schema = parent::defineSchema($className); $schema->registerField(new ARField("value", ARArray::instance())); }