pet-management

UNDER DEVELOPMENT

I searched but cannot find a solution to "maintain" my pets, especially the chickens. So I let build the software from ChatGPT. :-)

Install instructions at for exmample Ubuntu server 22.04

sudo apt update  
sudo apt install apache2 mariadb-server php php-mysql git

sudo mysql_secure_installation  
sudo systemctl start apache2  
sudo systemctl start mariadb  
sudo mysql -u root -p  

CREATE DATABASE haustierverwaltung;  
CREATE USER 'haustieruser'@'localhost' IDENTIFIED BY 'sicheres_passwort';  
GRANT ALL PRIVILEGES ON haustierverwaltung.* TO 'haustieruser'@'localhost';  
FLUSH PRIVILEGES;

Still in the mariadb executionwindow insert the table structur:

USE haustierverwaltung;

CREATE TABLE haustiere (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    geburtsdatum DATE NOT NULL,
    geschlecht VARCHAR(10) NOT NULL,
    letzteImpfung DATE,
    letzteImpfungBeschreibung VARCHAR(255),
    naechsteImpfung DATE,
    naechsteImpfungBeschreibung VARCHAR(255),
    tierart VARCHAR(50) NOT NULL,
    rasse VARCHAR(255),
    foto VARCHAR(255)
);

CREATE TABLE dokumente (
    id INT AUTO_INCREMENT PRIMARY KEY,
    haustier_id INT,
    dokument_name VARCHAR(255) NOT NULL,
    FOREIGN KEY (haustier_id) REFERENCES haustiere(id)
);

CREATE TABLE benutzer (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(255) NOT NULL UNIQUE
);

CREATE TABLE benutzer (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(255) NOT NULL UNIQUE
);

cd /var/www/html
git clone https://github.com/Schello805/pet-management.git
nano /etc/apache2/sites-enabled/000-default.conf

change the DocumentRoot to

/var/www/html/pet-management 
service apache2 restart