cartitas

installation
composer create-project laravel/laravel cards (copy installation in "cards" folder) 
composer require laravel/breeze 
php artisan breeze:install vue 
npm install
npm run dev

create database
create database cards; create user cards@localhost identified by 'cards'; grant all privileges on cards.* to cards@localhost; flush privileges;

set .env
(set data connection) php artisan migrate:fresh --seed php artisan storage:link

mailtrap
MAIL_MAILER=smtp
MAIL_HOST=sandbox.smtp.mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=74a6cfb22834cd
MAIL_PASSWORD=0a9bd99af7ca03
MAIL_ENCRYPTION=null
MAIL_FROM_ADDRESS="cards.elgato.work@elgato.work"
MAIL_FROM_NAME="${APP_NAME}"


fast db restore
after php artisan migrate:fresh --seed


INSERT INTO `collections` VALUES (1,1,4,'Premier League Legends','active','Premier League Legends',NULL,'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcSiMZUmuRl_TvV4sDrySd59nWK8ByGjSLf-qSkBPcwbs8xL1-5vkr-sA7MAztfbVX6UmLE&usqp=CAU','2024-06-22 07:55:11','2024-06-22 08:13:18',NULL),(2,1,10,'NieR Reincarnation Art Gallery','active','NieR Reincarnation Art Gallery',NULL,'https://www.creativeuncut.com/gallery-40/art/nr-9s.jpg','2024-06-22 08:35:18','2024-06-22 08:48:38',NULL);


INSERT INTO `user_collections` VALUES (1,1,1,'inactive','2024-06-22 08:18:03','2024-06-22 08:18:03',NULL),(2,1,2,'inactive','2024-06-22 08:48:45','2024-06-22 08:48:45',NULL);

INSERT INTO `cards` VALUES (1,1,'Ruud van Nistelrooy','https://i2-prod.mirror.co.uk/incoming/article1285420.ece/ALTERNATES/s1200b/Ruud%20van%20Nistelrooy',3,1,48980,'none','none',NULL,'horizontal','2024-06-22 07:56:34','2024-06-22 08:13:08',NULL),(2,1,'Wayne Rooney','https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcSerm0gWg_0np3u9P24wKT6d01xD_DG4GprCg&s',2,2,7420,'none','none',NULL,'horizontal','2024-06-22 07:57:17','2024-06-22 08:13:08',NULL),(3,1,'Ashley Cole','https://images.news18.com/ibnlive/uploads/2023/10/copy-of-sports-2023-10-28t182307.159-2023-10-aed039eb3f982e0827c1aafc08b8c54f.jpg?impolicy=website&width=640&height=480',2,3,6880,'none','none',NULL,'horizontal','2024-06-22 07:58:24','2024-06-22 08:13:08',NULL),(4,1,'Cristiano Ronaldo','https://assets.manutd.com/AssetPicker/images/0/0/10/126/687707/Legends-Profile_Cristiano-Ronaldo1523460877263.jpg',4,4,68740,'none','none',NULL,'circle','2024-06-22 07:59:16','2024-06-22 08:13:08',NULL),(5,1,'Gareth Bale','https://img.bleacherreport.net/img/images/photos/002/267/669/hi-res-161706478_crop_exact.jpg?w=1200&h=1200&q=75',1,5,3760,'none','none',NULL,'center','2024-06-22 08:00:26','2024-06-22 08:13:08',NULL),(6,1,'Robert Pires','https://brandesautographs.com/cdn/shop/products/robert-pires-autograph-in-person-signed-photograph-27192141054101.jpg?v=1631912421',1,6,3710,'none','none',NULL,'vertical','2024-06-22 08:01:08','2024-06-22 08:13:08',NULL),(7,1,'Steven Gerrar','https://i.pinimg.com/474x/2f/88/f2/2f88f2d5e58799408bd8ba893e8c3178.jpg',5,7,276010,'none','none',NULL,'vertical','2024-06-22 08:02:07','2024-06-22 08:13:08',NULL),(8,1,'Patrice Vieira','https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRYk093BFLcnT0_WQap4nV8u25TAujEJz0BkA&s',2,8,8760,'none','none',NULL,'horizontal','2024-06-22 08:04:33','2024-06-22 08:13:08',NULL),(9,1,'Rio Ferdinand','https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRxJmb2K4Z39kBgBWzV0kIEvQIVBBWErz7t3Q&s',1,9,2690,'none','none',NULL,'horizontal','2024-06-22 08:05:19','2024-06-22 08:13:08',NULL),(10,1,'Didier Drogba','https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcSsqMnWu_Fvd9T9ew8fKNRyfvqBmO5xEwHE9A&s',3,10,13950,'none','none',NULL,'horizontal','2024-06-22 08:05:56','2024-06-22 08:13:08',NULL),(11,1,'Luka Modric','https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcSiMZUmuRl_TvV4sDrySd59nWK8ByGjSLf-qSkBPcwbs8xL1-5vkr-sA7MAztfbVX6UmLE&usqp=CAU',1,11,1440,'none','none',NULL,'center','2024-06-22 08:06:54','2024-06-22 08:13:08',NULL),(12,1,'Edwin van Der Sar','https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTLOLl3-Sqz_-hORGn9VyQ_2xyFIqg14MDMUA&s',1,12,1770,'none','none',NULL,'horizontal','2024-06-22 08:08:54','2024-06-22 08:13:08',NULL),(13,1,'Michael Ballack','https://i2-prod.mirror.co.uk/incoming/article385470.ece/ALTERNATES/s615b/E261CE7E-C5EE-014E-62752673851C683F.jpg',3,13,32830,'none','none',NULL,'horizontal','2024-06-22 08:10:48','2024-06-22 08:13:08',NULL),(14,1,'Jermain Defoe','https://m.media-amazon.com/images/S/pv-target-images/f3395c311e5254393bf9c9f10c9882a44ee5f58166c7800579bdbca4caf0b741.jpg',2,14,5270,'none','none',NULL,'vertical','2024-06-22 08:11:40','2024-06-22 08:13:08',NULL),(15,2,'NieR Reincarnation Logo','https://www.creativeuncut.com/gallery-40/art/nr-logo.jpg',1,1,2690,'none','none',NULL,'horizontal','2024-06-22 08:35:43','2024-06-22 08:48:27',NULL),(16,2,'Fio, the Girl of Light Art','https://www.creativeuncut.com/gallery-40/art/nr-fio-the-girl-of-light.jpg',1,2,1860,'none','none',NULL,'vertical','2024-06-22 08:36:13','2024-06-22 08:48:27',NULL),(17,2,'Mama Art','https://www.creativeuncut.com/gallery-40/art/nr-mama.jpg',1,3,4930,'none','none',NULL,'circle','2024-06-22 08:36:33','2024-06-22 08:48:27',NULL),(18,2,'Next Picture Levania, Dark Monster Art','https://www.creativeuncut.com/gallery-40/art/nr-dark-monster.jpg',1,4,2810,'none','none',NULL,'center','2024-06-22 08:36:55','2024-06-22 08:48:27',NULL),(19,2,'Rion, the Wanderer Art','https://www.creativeuncut.com/gallery-40/art/nr-rion-the-wanderer.jpg',2,5,7740,'none','none',NULL,'vertical','2024-06-22 08:37:20','2024-06-22 08:48:27',NULL),(20,2,'Gayle, the Prosthetic Hunter Art','https://www.creativeuncut.com/gallery-40/art/nr-frenlyse-the-prosthetic-hunter.jpg',3,6,47550,'none','none',NULL,'vertical','2024-06-22 08:37:53','2024-06-22 08:48:27',NULL),(21,2,'Dimos, the Clockwork Soldier','https://www.creativeuncut.com/gallery-40/art/nr-dimis-the-clockwork-soldier.jpg',3,7,20650,'none','none',NULL,'vertical','2024-06-22 08:38:17','2024-06-22 08:48:27',NULL),(22,2,'Akeha, the Assassin','https://www.creativeuncut.com/gallery-40/art/nr-akeha-the-assassin.jpg',4,8,65590,'none','none',NULL,'vertical','2024-06-22 08:38:42','2024-06-22 08:48:27',NULL),(23,2,'Argo','https://www.creativeuncut.com/gallery-40/art/nr-argo-one-who-continues-to-challenge-the-mountains.jpg',2,9,6750,'none','none',NULL,'center','2024-06-22 08:39:04','2024-06-22 08:48:27',NULL),(24,2,'063y','https://www.creativeuncut.com/gallery-40/art/nr-063y-the-man-in-white.jpg',3,10,28590,'none','none',NULL,'vertical','2024-06-22 08:39:25','2024-06-22 08:48:27',NULL),(25,2,'F66x','https://www.creativeuncut.com/gallery-40/art/nr-f66x-the-woman-in-white.jpg',1,11,1850,'none','none',NULL,'vertical','2024-06-22 08:39:49','2024-06-22 08:48:27',NULL),(26,2,'Carrier','https://www.creativeuncut.com/gallery-40/art/nr-courier.jpg',1,12,3110,'none','none',NULL,'center','2024-06-22 08:40:08','2024-06-22 08:48:27',NULL),(27,2,'Lars','https://www.creativeuncut.com/gallery-40/art/nr-lars-the-vengeful-boy-soldier.jpg',2,13,5550,'none','none',NULL,'vertical','2024-06-22 08:40:24','2024-06-22 08:48:27',NULL),(28,2,'Griff','https://www.creativeuncut.com/gallery-40/art/nr-glyph-the-regretful-young-soldier.jpg',2,14,6970,'none','none',NULL,'vertical','2024-06-22 08:40:53','2024-06-22 08:48:27',NULL),(29,2,'Noelle','https://www.creativeuncut.com/gallery-40/art/nr-noel-the-sealed-girl.jpg',1,15,1080,'none','none',NULL,'vertical','2024-06-22 08:41:25','2024-06-22 08:48:27',NULL),(30,2,'Nier','https://www.creativeuncut.com/gallery-40/art/nr-nier-the-man-who-destroyed-the-world.jpg',1,16,4320,'none','none',NULL,'vertical','2024-06-22 08:41:50','2024-06-22 08:48:27',NULL),(31,2,'2B','https://www.creativeuncut.com/gallery-40/art/nr-2b.jpg',5,17,217070,'none','none',NULL,'vertical','2024-06-22 08:42:09','2024-06-22 08:48:27',NULL),(32,2,'9S','https://www.creativeuncut.com/gallery-40/art/nr-9s.jpg',2,18,8690,'none','none',NULL,'vertical','2024-06-22 08:42:26','2024-06-22 08:48:27',NULL),(33,2,'A2','https://www.creativeuncut.com/gallery-40/art/nr-a2.jpg',4,19,76730,'none','none',NULL,'vertical','2024-06-22 08:42:43','2024-06-22 08:48:27',NULL),(34,2,'Kaine','https://www.creativeuncut.com/gallery-40/art/nr-kaine.jpg',3,20,31520,'none','none',NULL,'vertical','2024-06-22 08:42:59','2024-06-22 08:48:27',NULL),(35,2,'Rion','https://www.creativeuncut.com/gallery-40/art/nr-rion-alt-costume-2.jpg',2,21,7440,'none','none',NULL,'center','2024-06-22 08:43:35','2024-06-22 08:48:27',NULL),(36,2,'Dimos','https://www.creativeuncut.com/gallery-40/art/nr-dimis-alt-costume-1.jpg',4,22,67540,'none','none',NULL,'center','2024-06-22 08:44:38','2024-06-22 08:48:27',NULL),(37,2,'Marie','https://www.creativeuncut.com/gallery-40/art/nr-marie-fractured-songstress.jpg',5,23,184310,'none','none',NULL,'circle','2024-06-22 08:46:01','2024-06-22 08:48:27',NULL);