@@ -146,7 +146,7 @@ |
||
| 146 | 146 | \DB::table('products')->truncate(); |
| 147 | 147 | \DB::statement('SET FOREIGN_KEY_CHECKS=1;'); |
| 148 | 148 | Product::create(['id' => 1, 'name' => 'default', 'type' => 1, 'group' => 1]); |
| 149 | - //Product::create(['id'=>2,'name'=>'none1','type'=>1,'group' =>1]); |
|
| 149 | + //Product::create(['id'=>2,'name'=>'none1','type'=>1,'group' =>1]); |
|
| 150 | 150 | } |
| 151 | 151 | } |
| 152 | 152 | |
@@ -5,33 +5,33 @@ |
||
| 5 | 5 | |
| 6 | 6 | class CreateTemplatesTable extends Migration { |
| 7 | 7 | |
| 8 | - /** |
|
| 9 | - * Run the migrations. |
|
| 10 | - * |
|
| 11 | - * @return void |
|
| 12 | - */ |
|
| 13 | - public function up() |
|
| 14 | - { |
|
| 15 | - Schema::create('templates', function(Blueprint $table) |
|
| 16 | - { |
|
| 17 | - $table->increments('id'); |
|
| 18 | - $table->string('name'); |
|
| 19 | - $table->integer('type')->unsigned()->index('templates_type_foreign'); |
|
| 20 | - $table->string('url'); |
|
| 21 | - $table->text('data', 16777215); |
|
| 22 | - $table->timestamps(); |
|
| 23 | - }); |
|
| 24 | - } |
|
| 8 | + /** |
|
| 9 | + * Run the migrations. |
|
| 10 | + * |
|
| 11 | + * @return void |
|
| 12 | + */ |
|
| 13 | + public function up() |
|
| 14 | + { |
|
| 15 | + Schema::create('templates', function(Blueprint $table) |
|
| 16 | + { |
|
| 17 | + $table->increments('id'); |
|
| 18 | + $table->string('name'); |
|
| 19 | + $table->integer('type')->unsigned()->index('templates_type_foreign'); |
|
| 20 | + $table->string('url'); |
|
| 21 | + $table->text('data', 16777215); |
|
| 22 | + $table->timestamps(); |
|
| 23 | + }); |
|
| 24 | + } |
|
| 25 | 25 | |
| 26 | 26 | |
| 27 | - /** |
|
| 28 | - * Reverse the migrations. |
|
| 29 | - * |
|
| 30 | - * @return void |
|
| 31 | - */ |
|
| 32 | - public function down() |
|
| 33 | - { |
|
| 34 | - Schema::drop('templates'); |
|
| 35 | - } |
|
| 27 | + /** |
|
| 28 | + * Reverse the migrations. |
|
| 29 | + * |
|
| 30 | + * @return void |
|
| 31 | + */ |
|
| 32 | + public function down() |
|
| 33 | + { |
|
| 34 | + Schema::drop('templates'); |
|
| 35 | + } |
|
| 36 | 36 | |
| 37 | 37 | } |
@@ -5,41 +5,41 @@ |
||
| 5 | 5 | |
| 6 | 6 | class CreateInvoiceItemsTable extends Migration { |
| 7 | 7 | |
| 8 | - /** |
|
| 9 | - * Run the migrations. |
|
| 10 | - * |
|
| 11 | - * @return void |
|
| 12 | - */ |
|
| 13 | - public function up() |
|
| 14 | - { |
|
| 15 | - Schema::create('invoice_items', function(Blueprint $table) |
|
| 16 | - { |
|
| 17 | - $table->increments('id'); |
|
| 18 | - $table->integer('invoice_id')->unsigned()->index('invoice_items_invoice_id_foreign'); |
|
| 19 | - $table->string('product_name'); |
|
| 20 | - $table->string('regular_price'); |
|
| 21 | - $table->string('quantity'); |
|
| 22 | - $table->string('discount'); |
|
| 23 | - $table->string('tax_name'); |
|
| 24 | - $table->string('tax_percentage'); |
|
| 25 | - $table->string('tax_code'); |
|
| 26 | - $table->string('discount_mode'); |
|
| 27 | - $table->string('subtotal', 225); |
|
| 28 | - $table->string('domain', 225); |
|
| 29 | - $table->integer('plan_id'); |
|
| 30 | - $table->timestamps(); |
|
| 31 | - }); |
|
| 32 | - } |
|
| 8 | + /** |
|
| 9 | + * Run the migrations. |
|
| 10 | + * |
|
| 11 | + * @return void |
|
| 12 | + */ |
|
| 13 | + public function up() |
|
| 14 | + { |
|
| 15 | + Schema::create('invoice_items', function(Blueprint $table) |
|
| 16 | + { |
|
| 17 | + $table->increments('id'); |
|
| 18 | + $table->integer('invoice_id')->unsigned()->index('invoice_items_invoice_id_foreign'); |
|
| 19 | + $table->string('product_name'); |
|
| 20 | + $table->string('regular_price'); |
|
| 21 | + $table->string('quantity'); |
|
| 22 | + $table->string('discount'); |
|
| 23 | + $table->string('tax_name'); |
|
| 24 | + $table->string('tax_percentage'); |
|
| 25 | + $table->string('tax_code'); |
|
| 26 | + $table->string('discount_mode'); |
|
| 27 | + $table->string('subtotal', 225); |
|
| 28 | + $table->string('domain', 225); |
|
| 29 | + $table->integer('plan_id'); |
|
| 30 | + $table->timestamps(); |
|
| 31 | + }); |
|
| 32 | + } |
|
| 33 | 33 | |
| 34 | 34 | |
| 35 | - /** |
|
| 36 | - * Reverse the migrations. |
|
| 37 | - * |
|
| 38 | - * @return void |
|
| 39 | - */ |
|
| 40 | - public function down() |
|
| 41 | - { |
|
| 42 | - Schema::drop('invoice_items'); |
|
| 43 | - } |
|
| 35 | + /** |
|
| 36 | + * Reverse the migrations. |
|
| 37 | + * |
|
| 38 | + * @return void |
|
| 39 | + */ |
|
| 40 | + public function down() |
|
| 41 | + { |
|
| 42 | + Schema::drop('invoice_items'); |
|
| 43 | + } |
|
| 44 | 44 | |
| 45 | 45 | } |
@@ -5,37 +5,37 @@ |
||
| 5 | 5 | |
| 6 | 6 | class CreateFrontendPagesTable extends Migration { |
| 7 | 7 | |
| 8 | - /** |
|
| 9 | - * Run the migrations. |
|
| 10 | - * |
|
| 11 | - * @return void |
|
| 12 | - */ |
|
| 13 | - public function up() |
|
| 14 | - { |
|
| 15 | - Schema::create('frontend_pages', function(Blueprint $table) |
|
| 16 | - { |
|
| 17 | - $table->increments('id'); |
|
| 18 | - $table->integer('parent_page_id'); |
|
| 19 | - $table->string('slug'); |
|
| 20 | - $table->string('name'); |
|
| 21 | - $table->text('content', 65535); |
|
| 22 | - $table->string('url'); |
|
| 23 | - $table->string('type', 225); |
|
| 24 | - $table->integer('publish'); |
|
| 25 | - $table->integer('hidden'); |
|
| 26 | - $table->timestamps(); |
|
| 27 | - }); |
|
| 28 | - } |
|
| 8 | + /** |
|
| 9 | + * Run the migrations. |
|
| 10 | + * |
|
| 11 | + * @return void |
|
| 12 | + */ |
|
| 13 | + public function up() |
|
| 14 | + { |
|
| 15 | + Schema::create('frontend_pages', function(Blueprint $table) |
|
| 16 | + { |
|
| 17 | + $table->increments('id'); |
|
| 18 | + $table->integer('parent_page_id'); |
|
| 19 | + $table->string('slug'); |
|
| 20 | + $table->string('name'); |
|
| 21 | + $table->text('content', 65535); |
|
| 22 | + $table->string('url'); |
|
| 23 | + $table->string('type', 225); |
|
| 24 | + $table->integer('publish'); |
|
| 25 | + $table->integer('hidden'); |
|
| 26 | + $table->timestamps(); |
|
| 27 | + }); |
|
| 28 | + } |
|
| 29 | 29 | |
| 30 | 30 | |
| 31 | - /** |
|
| 32 | - * Reverse the migrations. |
|
| 33 | - * |
|
| 34 | - * @return void |
|
| 35 | - */ |
|
| 36 | - public function down() |
|
| 37 | - { |
|
| 38 | - Schema::drop('frontend_pages'); |
|
| 39 | - } |
|
| 31 | + /** |
|
| 32 | + * Reverse the migrations. |
|
| 33 | + * |
|
| 34 | + * @return void |
|
| 35 | + */ |
|
| 36 | + public function down() |
|
| 37 | + { |
|
| 38 | + Schema::drop('frontend_pages'); |
|
| 39 | + } |
|
| 40 | 40 | |
| 41 | 41 | } |
@@ -5,31 +5,31 @@ |
||
| 5 | 5 | |
| 6 | 6 | class AddForeignKeysToTemplatesTable extends Migration { |
| 7 | 7 | |
| 8 | - /** |
|
| 9 | - * Run the migrations. |
|
| 10 | - * |
|
| 11 | - * @return void |
|
| 12 | - */ |
|
| 13 | - public function up() |
|
| 14 | - { |
|
| 15 | - Schema::table('templates', function(Blueprint $table) |
|
| 16 | - { |
|
| 17 | - $table->foreign('type')->references('id')->on('template_types')->onUpdate('RESTRICT')->onDelete('RESTRICT'); |
|
| 18 | - }); |
|
| 19 | - } |
|
| 8 | + /** |
|
| 9 | + * Run the migrations. |
|
| 10 | + * |
|
| 11 | + * @return void |
|
| 12 | + */ |
|
| 13 | + public function up() |
|
| 14 | + { |
|
| 15 | + Schema::table('templates', function(Blueprint $table) |
|
| 16 | + { |
|
| 17 | + $table->foreign('type')->references('id')->on('template_types')->onUpdate('RESTRICT')->onDelete('RESTRICT'); |
|
| 18 | + }); |
|
| 19 | + } |
|
| 20 | 20 | |
| 21 | 21 | |
| 22 | - /** |
|
| 23 | - * Reverse the migrations. |
|
| 24 | - * |
|
| 25 | - * @return void |
|
| 26 | - */ |
|
| 27 | - public function down() |
|
| 28 | - { |
|
| 29 | - Schema::table('templates', function(Blueprint $table) |
|
| 30 | - { |
|
| 31 | - $table->dropForeign('templates_type_foreign'); |
|
| 32 | - }); |
|
| 33 | - } |
|
| 22 | + /** |
|
| 23 | + * Reverse the migrations. |
|
| 24 | + * |
|
| 25 | + * @return void |
|
| 26 | + */ |
|
| 27 | + public function down() |
|
| 28 | + { |
|
| 29 | + Schema::table('templates', function(Blueprint $table) |
|
| 30 | + { |
|
| 31 | + $table->dropForeign('templates_type_foreign'); |
|
| 32 | + }); |
|
| 33 | + } |
|
| 34 | 34 | |
| 35 | 35 | } |
@@ -5,36 +5,36 @@ |
||
| 5 | 5 | |
| 6 | 6 | class CreateCcavenueTable extends Migration { |
| 7 | 7 | |
| 8 | - /** |
|
| 9 | - * Run the migrations. |
|
| 10 | - * |
|
| 11 | - * @return void |
|
| 12 | - */ |
|
| 13 | - public function up() |
|
| 14 | - { |
|
| 15 | - Schema::create('ccavenue', function(Blueprint $table) |
|
| 16 | - { |
|
| 17 | - $table->increments('id'); |
|
| 18 | - $table->string('merchant_id'); |
|
| 19 | - $table->string('access_code'); |
|
| 20 | - $table->string('working_key'); |
|
| 21 | - $table->string('currencies', 225); |
|
| 22 | - $table->string('redirect_url'); |
|
| 23 | - $table->string('cancel_url'); |
|
| 24 | - $table->string('ccavanue_url'); |
|
| 25 | - $table->timestamps(); |
|
| 26 | - }); |
|
| 27 | - } |
|
| 8 | + /** |
|
| 9 | + * Run the migrations. |
|
| 10 | + * |
|
| 11 | + * @return void |
|
| 12 | + */ |
|
| 13 | + public function up() |
|
| 14 | + { |
|
| 15 | + Schema::create('ccavenue', function(Blueprint $table) |
|
| 16 | + { |
|
| 17 | + $table->increments('id'); |
|
| 18 | + $table->string('merchant_id'); |
|
| 19 | + $table->string('access_code'); |
|
| 20 | + $table->string('working_key'); |
|
| 21 | + $table->string('currencies', 225); |
|
| 22 | + $table->string('redirect_url'); |
|
| 23 | + $table->string('cancel_url'); |
|
| 24 | + $table->string('ccavanue_url'); |
|
| 25 | + $table->timestamps(); |
|
| 26 | + }); |
|
| 27 | + } |
|
| 28 | 28 | |
| 29 | 29 | |
| 30 | - /** |
|
| 31 | - * Reverse the migrations. |
|
| 32 | - * |
|
| 33 | - * @return void |
|
| 34 | - */ |
|
| 35 | - public function down() |
|
| 36 | - { |
|
| 37 | - Schema::drop('ccavenue'); |
|
| 38 | - } |
|
| 30 | + /** |
|
| 31 | + * Reverse the migrations. |
|
| 32 | + * |
|
| 33 | + * @return void |
|
| 34 | + */ |
|
| 35 | + public function down() |
|
| 36 | + { |
|
| 37 | + Schema::drop('ccavenue'); |
|
| 38 | + } |
|
| 39 | 39 | |
| 40 | 40 | } |
@@ -5,33 +5,33 @@ |
||
| 5 | 5 | |
| 6 | 6 | class CreateWidgetsTable extends Migration { |
| 7 | 7 | |
| 8 | - /** |
|
| 9 | - * Run the migrations. |
|
| 10 | - * |
|
| 11 | - * @return void |
|
| 12 | - */ |
|
| 13 | - public function up() |
|
| 14 | - { |
|
| 15 | - Schema::create('widgets', function(Blueprint $table) |
|
| 16 | - { |
|
| 17 | - $table->increments('id'); |
|
| 18 | - $table->string('name'); |
|
| 19 | - $table->string('type'); |
|
| 20 | - $table->integer('publish'); |
|
| 21 | - $table->text('content', 65535); |
|
| 22 | - $table->timestamps(); |
|
| 23 | - }); |
|
| 24 | - } |
|
| 8 | + /** |
|
| 9 | + * Run the migrations. |
|
| 10 | + * |
|
| 11 | + * @return void |
|
| 12 | + */ |
|
| 13 | + public function up() |
|
| 14 | + { |
|
| 15 | + Schema::create('widgets', function(Blueprint $table) |
|
| 16 | + { |
|
| 17 | + $table->increments('id'); |
|
| 18 | + $table->string('name'); |
|
| 19 | + $table->string('type'); |
|
| 20 | + $table->integer('publish'); |
|
| 21 | + $table->text('content', 65535); |
|
| 22 | + $table->timestamps(); |
|
| 23 | + }); |
|
| 24 | + } |
|
| 25 | 25 | |
| 26 | 26 | |
| 27 | - /** |
|
| 28 | - * Reverse the migrations. |
|
| 29 | - * |
|
| 30 | - * @return void |
|
| 31 | - */ |
|
| 32 | - public function down() |
|
| 33 | - { |
|
| 34 | - Schema::drop('widgets'); |
|
| 35 | - } |
|
| 27 | + /** |
|
| 28 | + * Reverse the migrations. |
|
| 29 | + * |
|
| 30 | + * @return void |
|
| 31 | + */ |
|
| 32 | + public function down() |
|
| 33 | + { |
|
| 34 | + Schema::drop('widgets'); |
|
| 35 | + } |
|
| 36 | 36 | |
| 37 | 37 | } |
@@ -5,32 +5,32 @@ |
||
| 5 | 5 | |
| 6 | 6 | class CreateMailchimpSettingsTable extends Migration { |
| 7 | 7 | |
| 8 | - /** |
|
| 9 | - * Run the migrations. |
|
| 10 | - * |
|
| 11 | - * @return void |
|
| 12 | - */ |
|
| 13 | - public function up() |
|
| 14 | - { |
|
| 15 | - Schema::create('mailchimp_settings', function(Blueprint $table) |
|
| 16 | - { |
|
| 17 | - $table->increments('id'); |
|
| 18 | - $table->string('api_key'); |
|
| 19 | - $table->string('list_id'); |
|
| 20 | - $table->string('subscribe_status')->default('subscribed'); |
|
| 21 | - $table->timestamps(); |
|
| 22 | - }); |
|
| 23 | - } |
|
| 8 | + /** |
|
| 9 | + * Run the migrations. |
|
| 10 | + * |
|
| 11 | + * @return void |
|
| 12 | + */ |
|
| 13 | + public function up() |
|
| 14 | + { |
|
| 15 | + Schema::create('mailchimp_settings', function(Blueprint $table) |
|
| 16 | + { |
|
| 17 | + $table->increments('id'); |
|
| 18 | + $table->string('api_key'); |
|
| 19 | + $table->string('list_id'); |
|
| 20 | + $table->string('subscribe_status')->default('subscribed'); |
|
| 21 | + $table->timestamps(); |
|
| 22 | + }); |
|
| 23 | + } |
|
| 24 | 24 | |
| 25 | 25 | |
| 26 | - /** |
|
| 27 | - * Reverse the migrations. |
|
| 28 | - * |
|
| 29 | - * @return void |
|
| 30 | - */ |
|
| 31 | - public function down() |
|
| 32 | - { |
|
| 33 | - Schema::drop('mailchimp_settings'); |
|
| 34 | - } |
|
| 26 | + /** |
|
| 27 | + * Reverse the migrations. |
|
| 28 | + * |
|
| 29 | + * @return void |
|
| 30 | + */ |
|
| 31 | + public function down() |
|
| 32 | + { |
|
| 33 | + Schema::drop('mailchimp_settings'); |
|
| 34 | + } |
|
| 35 | 35 | |
| 36 | 36 | } |
@@ -5,39 +5,39 @@ |
||
| 5 | 5 | |
| 6 | 6 | class CreateOrdersTable extends Migration { |
| 7 | 7 | |
| 8 | - /** |
|
| 9 | - * Run the migrations. |
|
| 10 | - * |
|
| 11 | - * @return void |
|
| 12 | - */ |
|
| 13 | - public function up() |
|
| 14 | - { |
|
| 15 | - Schema::create('orders', function(Blueprint $table) |
|
| 16 | - { |
|
| 17 | - $table->increments('id'); |
|
| 18 | - $table->integer('number')->unique('number'); |
|
| 19 | - $table->integer('invoice_id'); |
|
| 20 | - $table->integer('invoice_item_id'); |
|
| 21 | - $table->integer('client')->unsigned()->index('orders_client_foreign'); |
|
| 22 | - $table->string('order_status'); |
|
| 23 | - $table->string('serial_key')->nullable(); |
|
| 24 | - $table->integer('product')->unsigned()->nullable()->index('orders_product_foreign'); |
|
| 25 | - $table->string('domain'); |
|
| 26 | - $table->string('price_override'); |
|
| 27 | - $table->string('qty'); |
|
| 28 | - $table->timestamps(); |
|
| 29 | - }); |
|
| 30 | - } |
|
| 8 | + /** |
|
| 9 | + * Run the migrations. |
|
| 10 | + * |
|
| 11 | + * @return void |
|
| 12 | + */ |
|
| 13 | + public function up() |
|
| 14 | + { |
|
| 15 | + Schema::create('orders', function(Blueprint $table) |
|
| 16 | + { |
|
| 17 | + $table->increments('id'); |
|
| 18 | + $table->integer('number')->unique('number'); |
|
| 19 | + $table->integer('invoice_id'); |
|
| 20 | + $table->integer('invoice_item_id'); |
|
| 21 | + $table->integer('client')->unsigned()->index('orders_client_foreign'); |
|
| 22 | + $table->string('order_status'); |
|
| 23 | + $table->string('serial_key')->nullable(); |
|
| 24 | + $table->integer('product')->unsigned()->nullable()->index('orders_product_foreign'); |
|
| 25 | + $table->string('domain'); |
|
| 26 | + $table->string('price_override'); |
|
| 27 | + $table->string('qty'); |
|
| 28 | + $table->timestamps(); |
|
| 29 | + }); |
|
| 30 | + } |
|
| 31 | 31 | |
| 32 | 32 | |
| 33 | - /** |
|
| 34 | - * Reverse the migrations. |
|
| 35 | - * |
|
| 36 | - * @return void |
|
| 37 | - */ |
|
| 38 | - public function down() |
|
| 39 | - { |
|
| 40 | - Schema::drop('orders'); |
|
| 41 | - } |
|
| 33 | + /** |
|
| 34 | + * Reverse the migrations. |
|
| 35 | + * |
|
| 36 | + * @return void |
|
| 37 | + */ |
|
| 38 | + public function down() |
|
| 39 | + { |
|
| 40 | + Schema::drop('orders'); |
|
| 41 | + } |
|
| 42 | 42 | |
| 43 | 43 | } |