a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";N;s:4:"name";s:20:"subscription_package";s:8:"fullName";s:20:"subscription_package";s:10:"primaryKey";a:1:{i:0;s:2:"id";}s:12:"sequenceName";s:0:"";s:11:"foreignKeys";a:0:{}s:7:"columns";a:25:{s:2:"id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:2:"id";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:12:"int unsigned";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:1;s:13:"autoIncrement";b:1;s:8:"unsigned";b:1;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:7:"shop_id";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:7:"shop_id";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:4:"name";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:4:"name";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:11:"description";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"description";s:9:"allowNull";b:1;s:4:"type";s:4:"text";s:7:"phpType";s:6:"string";s:6:"dbType";s:4:"text";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:8:"sessions";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"sessions";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";s:12:"defaultValue";i:1;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:33:"number of pre-paid sessions (>=1)";s:18:"disableJsonSupport";b:0;}s:13:"validity_days";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"validity_days";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";s:12:"defaultValue";i:30;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:34:"days the sessions stay valid (>=1)";s:18:"disableJsonSupport";b:0;}s:17:"per_session_price";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:17:"per_session_price";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(12,2)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:12;s:9:"precision";i:12;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:32:"derived round2(price / sessions)";s:18:"disableJsonSupport";b:0;}s:5:"price";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:5:"price";s:9:"allowNull";b:0;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(12,2)";s:12:"defaultValue";s:4:"0.00";s:10:"enumValues";N;s:4:"size";i:12;s:9:"precision";i:12;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:46:"effective (after-discount) VAT-inclusive price";s:18:"disableJsonSupport";b:0;}s:12:"price_before";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:12:"price_before";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(12,2)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:12;s:9:"precision";i:12;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:26:"list price before discount";s:18:"disableJsonSupport";b:0;}s:8:"discount";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"discount";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(12,2)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:12;s:9:"precision";i:12;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:33:"discount value (percent or fixed)";s:18:"disableJsonSupport";b:0;}s:13:"discount_type";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:13:"discount_type";s:9:"allowNull";b:1;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:7:"tinyint";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:28:"1=percentage, 2=fixed amount";s:18:"disableJsonSupport";b:0;}s:10:"vat_amount";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"vat_amount";s:9:"allowNull";b:1;s:4:"type";s:7:"decimal";s:7:"phpType";s:6:"string";s:6:"dbType";s:13:"decimal(12,2)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:12;s:9:"precision";i:12;s:5:"scale";i:2;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:44:"VAT portion split out of the inclusive price";s:18:"disableJsonSupport";b:0;}s:10:"auto_renew";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"auto_renew";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:10:"tinyint(1)";s:12:"defaultValue";i:0;s:10:"enumValues";N;s:4:"size";i:1;s:9:"precision";i:1;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:26:"0=one-off, 1=auto-renewing";s:18:"disableJsonSupport";b:0;}s:14:"billing_period";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:14:"billing_period";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:11:"varchar(20)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:20;s:9:"precision";i:20;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:57:"monthly|six_months|twelve_months (only when auto_renew=1)";s:18:"disableJsonSupport";b:0;}s:6:"status";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:6:"status";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:10:"tinyint(1)";s:12:"defaultValue";i:1;s:10:"enumValues";N;s:4:"size";i:1;s:9:"precision";i:1;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:20:"1=active, 0=archived";s:18:"disableJsonSupport";b:0;}s:6:"hidden";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:6:"hidden";s:9:"allowNull";b:0;s:4:"type";s:7:"tinyint";s:7:"phpType";s:7:"integer";s:6:"dbType";s:10:"tinyint(1)";s:12:"defaultValue";i:0;s:10:"enumValues";N;s:4:"size";i:1;s:9:"precision";i:1;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:53:"visible-in-app flag; app shows when active && !hidden";s:18:"disableJsonSupport";b:0;}s:10:"created_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"created_at";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:10:"updated_at";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"updated_at";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:10:"created_by";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"created_by";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:10:"updated_by";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"updated_by";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:3:"int";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:0:"";s:18:"disableJsonSupport";b:0;}s:5:"image";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:5:"image";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:37:"NVG-BEA-008: package cover image path";s:18:"disableJsonSupport";b:0;}s:7:"name_ar";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:7:"name_ar";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:12:"varchar(255)";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";i:255;s:9:"precision";i:255;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:49:"NVG-BEA-008: Arabic name; English stays in `name`";s:18:"disableJsonSupport";b:0;}s:11:"active_days";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:11:"active_days";s:9:"allowNull";b:1;s:4:"type";s:4:"json";s:7:"phpType";s:5:"array";s:6:"dbType";s:4:"json";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:69:"NVG-BEA-008: JSON array of weekday ints (0=Sun..6=Sat); NULL=all days";s:18:"disableJsonSupport";b:0;}s:10:"start_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:10:"start_date";s:9:"allowNull";b:1;s:4:"type";s:4:"date";s:7:"phpType";s:6:"string";s:6:"dbType";s:4:"date";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:46:"NVG-BEA-008: package availability window start";s:18:"disableJsonSupport";b:0;}s:8:"end_date";O:25:"yii\db\mysql\ColumnSchema":15:{s:4:"name";s:8:"end_date";s:9:"allowNull";b:1;s:4:"type";s:4:"date";s:7:"phpType";s:6:"string";s:6:"dbType";s:4:"date";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:44:"NVG-BEA-008: package availability window end";s:18:"disableJsonSupport";b:0;}}}s:12:"cacheVersion";i:1;}i:1;O:25:"yii\caching\TagDependency":3:{s:4:"data";a:1:{s:32:"8acc260eb18a90ef8e1e2ac3ed1a4e99";s:21:"0.57577100 1781039815";}s:8:"reusable";b:0;s:4:"tags";s:32:"8be6b63a26b15c2f12d384a84f8beb8c";}}