1: <?php
 2: 
 3: use Illuminate\Database\Schema\Blueprint;
 4: use Illuminate\Database\Migrations\Migration;
 5: 
 6: class CreateAssetsTable extends Migration {
 7: 
 8:     /**
 9:      * Run the migrations.
10:      *
11:      * @access   public
12:      * @return   void
13:      */
14:     public function up()
15:     {
16:         if (!Schema::hasTable('_db_assets'))
17:         {
18:             Schema::create('_db_assets', function ($table)
19:                     {
20:                         $table->increments('id')->unique();
21:                         $table->string('url', 200);
22:                         $table->string('vendor', 100);
23:                         $table->integer('asset_type_id')->unsigned(); //links to _db_option_types
24:                         $table->string('type', 100); //scripts, styles, images, fonts, as a subfolder of the skin
25:                         $table->string('version', 20);
26:                         $table->string('position'); //top or bottom of the page
27:                         $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
28:                         $table->timestamp('updated_at')->default('0000-00-00 00:00:00');
29:                     });
30:         }
31:     }
32: 
33:     /**
34:      * Reverse the migrations.
35:      *
36:      * @access   public
37:      * @return   void
38:      */
39:     public function down()
40:     {
41:         Schema::dropIfExists('_db_events');
42:     }
43: 
44: }
45: