Skip to content
NICOLAS Arnaud edited this page Jun 12, 2024 · 2 revisions
CREATE TABLE `main_uploads` (
  `id_upload` int(11) NOT NULL,
  `path_upload` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

CREATE TABLE `main_users` (
  `id_user` int(11) NOT NULL,
  `login_user` varchar(255) NOT NULL,
  `password_user` varchar(255) NOT NULL,
  `permissions_user` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `main_uploads`
  ADD PRIMARY KEY (`id_upload`);

ALTER TABLE `main_users`
  ADD PRIMARY KEY (`id_user`);

ALTER TABLE `main_uploads`
  MODIFY `id_upload` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `main_users`
  MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT;
Clone this wiki locally