From 83b5a599c9859dae70baf29fd57c8d5e19507ea9 Mon Sep 17 00:00:00 2001 From: Zach DeCook Date: Wed, 26 Dec 2018 12:29:49 -0500 Subject: * Database: Allow songs to be imported from a textfile --- .../migrations/2018_12_26_145136_create_songs_table.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'laravel/database/migrations') diff --git a/laravel/database/migrations/2018_12_26_145136_create_songs_table.php b/laravel/database/migrations/2018_12_26_145136_create_songs_table.php index 7208806..0fbee13 100644 --- a/laravel/database/migrations/2018_12_26_145136_create_songs_table.php +++ b/laravel/database/migrations/2018_12_26_145136_create_songs_table.php @@ -15,11 +15,11 @@ class CreateSongsTable extends Migration { Schema::create('songs', function (Blueprint $table) { $table->increments('id'); - $table->string('number', 5); - $table->string('title'); - $table->string('author'); - $table->string('verse'); - $table->string('key', 5); + $table->string('number', 5)->unique(); + $table->string('title', 191)->default(''); + $table->string('author', 191)->nullable(); + $table->string('verse', 191)->nullable(); + $table->string('key', 5)->nullable(); $table->text('text'); $table->timestamps(); }); -- cgit 1.4.1