diff options
| author | Zach DeCook <zachdecook@gmail.com> | 2018-12-26 12:29:49 -0500 |
|---|---|---|
| committer | Zach DeCook <zachdecook@gmail.com> | 2018-12-26 12:29:49 -0500 |
| commit | 83b5a599c9859dae70baf29fd57c8d5e19507ea9 (patch) | |
| tree | 3414718f8f8af399ccf7c95a6c7fb04210e70e01 /laravel/database/migrations | |
| parent | 97e82af677235e991b2f580794fe728358569b0a (diff) | |
| download | prosongsa-83b5a599c9859dae70baf29fd57c8d5e19507ea9.tar.gz | |
* Database: Allow songs to be imported from a textfile
Diffstat (limited to 'laravel/database/migrations')
| -rw-r--r-- | laravel/database/migrations/2018_12_26_145136_create_songs_table.php | 10 |
1 files changed, 5 insertions, 5 deletions
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(); }); |
