opariltay/simple-desk-booking

Easy-to-use desk booking software which allows users to reserve a full-day seat at the workplace.

About Simple Desk Booking

Simple Desk Booking is an easy-to-use desk booking software which allows users to reserve a full-day seat at the workplace.

         

Installation

1. Clone repository to your local machine (or production environment).

2. Create a new database for the application.

3. Create your .env file by cloning .env.example file.

4. Update .env file with database connection details and proper environment settings.

5. Run below command to install missing dependencies:

   composer install

6. Run below command to generate your app key:

   php artisan key:generate

7. Run below command to complete migrations on database:

   php artisan migrate

8. Run below command to create admin user (you must set credentials in .env file first):

   php artisan db:seed

9. Done. Now you can create locations for your company through admin panel and your users can register to start using the application.

Security Vulnerabilities

If you discover a security vulnerability within Simple Desk Booking, please create a new issue under Issues section. All security vulnerabilities will be promptly addressed.

License

Simple Desk Booking is open-sourced software licensed under the MIT license.

Donations

Simple Desk Booking is my first open source project and I'm going to contribute to other open source projects in the future.

If you think this project helped you in any way and you want to support me on my journey, please feel free to send any amount through below methods.

Channel	Detail
GitHub Sponsors
Bitcoin	1PVvDhjqkvYoiZQKbpUpgKYXHR4Dv29S5J
Ethereum	0x72c9f744fbc52462e3bcff81a4a536efef080639

simple-desk-booking's Issues

Error: Specified key length exceeds maximum limit during migration

Bug Description:

When attempting to create a migration for the personal_access_tokens table in Laravel, a "Specified key was too long" error occurs. This error arises because Laravel tries to create an index with a key length that exceeds the maximum allowed by the database engine (MySQL), causing the migration to fail.

Fixed Code:

The issue can be resolved by adjusting the migration code to specify a custom index name with a shorter key length for the tokenable_type column. Additionally, we explicitly define the tokenable_type as a string with the desired length and tokenable_id as an unsigned big integer. After defining the columns, we add the index separately to ensure it's created with the correct length.

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreatePersonalAccessTokensTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('personal_access_tokens', function (Blueprint $table) {
            $table->id();
            
            // Use a smaller index key length
            $table->string('tokenable_type', 191); // Adjust the length as needed
            $table->unsignedBigInteger('tokenable_id');
            
            $table->string('name');
            $table->string('token', 64)->unique();
            $table->text('abilities')->nullable();
            $table->timestamp('last_used_at')->nullable();
            $table->timestamps();

            // Add an index separately
            $table->index(['tokenable_type', 'tokenable_id']);
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('personal_access_tokens');
    }

}