Tul xxx Tul

Viewing: create_table.php

<?php
require_once 'c:\xampp\htdocs\vendefacilmaylor\config\Config.php';
$conn = new mysqli(HOST, USER, PASS, DBNAME);
if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); }

$sql = "CREATE TABLE IF NOT EXISTS entradas_salidas (
    id int(11) NOT NULL AUTO_INCREMENT,
    id_producto int(11) NOT NULL,
    tipo varchar(50) NOT NULL COMMENT 'Entrada, Salida',
    cantidad int(11) NOT NULL,
    motivo text,
    id_usuario int(11) NOT NULL,
    id_sucursal int(11) NOT NULL,
    fecha timestamp NOT NULL DEFAULT current_timestamp(),
    PRIMARY KEY (id)
)";

if ($conn->query($sql) === TRUE) { 
    echo "Tabla 'entradas_salidas' creada correctamente.\n"; 
} else { 
    echo "Error: " . $conn->error . "\n"; 
}

$conn->close();
?>

User / IP	: 216.73.216.217
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64