/** * 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'); }