php-personal/backend/users/users.sql.php

<?php
/*
   SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
   START TRANSACTION;
   SET time_zone = "+00:00";

   CREATE TABLE `users` (
   `id` int(11) NOT NULL,
   `rol` tinyint(1) NOT NULL DEFAULT 1 COMMENT '[0 = ''superuser'', 1 = ''user'' ]',
   `name` varchar(255) DEFAULT NULL,
   `password` varchar(255) DEFAULT NULL,
   `softDelete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '[1 = ''ELIMINADO'']',
   `createdAt` datetime NOT NULL DEFAULT current_timestamp()
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

   ALTER TABLE `users`
   ADD PRIMARY KEY (`id`);

   ALTER TABLE `users`
   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
   COMMIT;
*/
?>