- composer require laravel/ui
- php artisan ui bootstrap --auth
- npm install
- npm run dev
-
git clone
-
cd project name
-
cp .env.example
.env -
open .env and update DB_DATABASE (database details)
-
run :
composer install -
run :
php artisan key:generate -
run :
php artisan migrate:fresh --seed -
run :
php artisan serve -
run :
npm run dev -
run :
npm install -
Best of luck
CREATE TABLE buildings (
id int NOT NULL,
building_no varchar(10) DEFAULT NULL,
street_no varchar(10) DEFAULT NULL,
citizen_name varchar(50) DEFAULT NULL,
event_name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
citizen_id varchar(10) DEFAULT NULL,
event_count int DEFAULT NULL,
floors_count int DEFAULT NULL,
event_category varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
latitude varchar(20) DEFAULT NULL,
longitude varchar(20) DEFAULT NULL,
created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP,
updated timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE citizens (
id int NOT NULL,
resident_name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
building_id int NOT NULL,
citizen_status varchar(30) NOT NULL,
floor int DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
حول ال id ال AI