USER - Shop for Rubies

[Xety]

Shop

Can be disabled/enabled in admin setting.

Xeticons

Small icons that can be bought and display acros the website.
Display on the Discuss (limited to 2 choosen in Account setting) and Profile (all Xeticons)

• Has categories.
• Can be time limited buyable.
• Can have limited quantities.
• Can have discount.
• Can be display/hidden.

Schema::create('shop_categories', function (Blueprint $table) {
  $table->increments('id')->unsigned();
  $table->string('title');
  $table->string('slug')->unique()->index();
  $table->text('description');
  $table->integer('shop_item_count')->unsigned()->default(0);
  $table->boolean('is_display')->default(true);
  $table->timestamps();
});


Schema::create('shop_items', function (Blueprint $table) {
  $table->increments('id')->unsigned();
  $table->integer('shop_category_id')->unsigned()->index();
  $table->string('title');
  $table->string('slug')->unique()->index();
  $table->longText('content')->nullable();
  $table->smallInteger('price')->default(0);
  $table->smallInteger('discount')->default(0);
  $table->smallInteger('quantity')->default(-1); //-1=Unlimited | 0=Sold out | 1+=Remaining
  $table->boolean('is_display')->default(true);
  $table->timestamp('start_at')->nullable();
  $table->timestamp('end_at')->nullable();
  $table->timestamps();
});