{"id":1417,"date":"2026-01-28T14:23:35","date_gmt":"2026-01-28T13:23:35","guid":{"rendered":"https:\/\/ahassan.inscastellbisbal.net\/?page_id=1417"},"modified":"2026-04-08T09:42:04","modified_gmt":"2026-04-08T07:42:04","slug":"dissenyar-les-taules-que-ha-de-contenir-la-bbdd","status":"publish","type":"page","link":"https:\/\/ahassan.inscastellbisbal.net\/?page_id=1417","title":{"rendered":"Dissenyar les taules que ha de contenir la BBDD"},"content":{"rendered":"\n

Donar permisos sudo<\/code> al teu usuari<\/h2>\n\n\n\n

A Debian, per defecte, l’usuari normal no est\u00e0 al fitxer sudoers<\/code>.<\/p>\n\n\n\n

    \n
  1. Entra com a superusuari (root):<\/strong><\/li>\n<\/ol>\n\n\n\n
    Bash<\/strong>: su -<\/code><\/pre>\n\n\n\n
         2. Instal\u00b7la el paquet sudo (si no el tens):<\/strong><\/p>\n\n\n\n
    Bash<\/strong>: apt update && apt install sudo -y<\/code><\/pre>\n\n\n\n
         3. Surt de root i tanca la terminal:<\/strong><\/p>\n\n\n\n
    Bash<\/strong>: exit<\/code><\/pre>\n\n\n\n
    Proc\u00e9s:<\/h2>\n\n\n\n
    \n
    Vaig demanar els comandos<\/strong> de terminal<\/strong> del Linux<\/strong> per crear la base de dades a la IA<\/strong>,<\/p>\n\n\n\n
    1: Actualitza i instal\u00b7la: <\/h2>\n\n\n\n
      Bash<\/strong>:sudo apt update\n  Bash<\/strong>:sudo apt install mariadb-server -y<\/code><\/pre>\n\n\n\n
    \"\"<\/figure>\n<\/blockquote>\n\n\n\n
    Crear la BBDD de la LAN Party:<\/h2>\n\n\n\n
    \n
    1: Entra a MariaDB:<\/strong><\/p>\n\n\n\n
    per entrar en la MariaDB<\/strong> hem de posar aquestes comandas<\/strong>:<\/p>\n\n\n\n
    Bash<\/strong>:sudo mariadb -u root -p<\/code><\/pre>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    2: Crea i selecciona la base de dades:<\/strong><\/p>\n\n\n\n
    SQL<\/strong>:CREATE DATABASE lan_party;\nUSE lan_party;<\/code><\/pre>\n\n\n\n
    3: Crea la taula d’Usuaris (el “cor” de la intranet):<\/strong><\/p>\n\n\n\n
    SQL<\/strong>:CREATE TABLE usuaris (\n    id_usuari INT AUTO_INCREMENT PRIMARY KEY,\n    nick VARCHAR(30) NOT NULL UNIQUE,\n    email VARCHAR(100) NOT NULL UNIQUE,\n    password_hash VARCHAR(255) NOT NULL,\n    rol ENUM('admin', 'user') DEFAULT 'user'\n);<\/code><\/pre>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    4: Crea la taula de Seients (per gestionar el lloc de cadasc\u00fa):<\/strong><\/p>\n\n\n\n
    SQL<\/strong>:CREATE TABLE seients (\n    id_seient INT PRIMARY KEY,\n    fila CHAR(1),\n    columna INT,\n    id_usuari INT UNIQUE,\n    FOREIGN KEY (id_usuari) REFERENCES usuaris(id_usuari)\n);<\/code><\/pre>\n\n\n\n
    5: Comprova que tot est\u00e0 b\u00e9:<\/strong><\/p>\n\n\n\n
    SQL<\/strong>:SHOW TABLES;\nDESCRIBE usuaris;<\/code><\/pre>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    6: Surt de la base de dades:<\/strong><\/p>\n\n\n\n
    SQL<\/strong>:EXIT;<\/code><\/pre>\n<\/blockquote>\n\n\n\n
    Resum de comandaments \u00fatils per a la teva tasca:<\/h3>\n\n\n\n