test.sql - main - alesu1543/practPerl

test.sql
55 строк2 KB
Alexey Subbotin
import sql
13 авг 2022, 10:28
13 авг 2022, 10:2807b6674
-- The file for creating the table for the case study, called practPerl

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

CREATE DATABASE IF NOT EXISTS test;

CREATE TABLE `files` (
  `id_file` int(11) NOT NULL,
  `id_my` int(11) NOT NULL,
  `description` text NOT NULL,
  `name_origin` text NOT NULL,
  `path` text NOT NULL,
  `date_upload` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;

INSERT INTO `files` (`id_file`, `id_my`, `description`, `name_origin`, `path`, `date_upload`) VALUES
(16, 17, 'Закачка из менеджера', 'Стратегии в виртуальном футболе.pdf', 'files/Стратегии в виртуальном футболе.pdf', '16-03-2022  08:41:22');

CREATE TABLE `myarttable` (
  `id` int(11) NOT NULL,
  `text` text NOT NULL,
  `description` text NOT NULL,
  `keywords` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;

INSERT INTO `myarttable` (`id`, `text`, `description`, `keywords`) VALUES
(17, 'Baranov', 'Engeneer', 'Ivanov'),
(20, 'Fedorov', 'Cpp, Delphi, PHP, JS', '3t'),
(92, 'Daniel', 'Artist', 'Theater Saturday'),
(93, 'Andrew', 'Poet', 'First Electrotechnical University'),
(94, 'Nikita', 'Student', 'Technological Institute'),
(95, 'Ilya', 'Salesman', 'Hypermarket'),
(96, 'Matvey', 'Programmer', 'Metropolitan College'),
(97, 'Fedor', 'Loader', 'St. Petersburg State University'),
(98, 'Ivan', 'Student', 'LETI'),
(99, 'Alexey', 'Engineer', 'ITMO');

ALTER TABLE `files`
  ADD PRIMARY KEY (`id_file`),
  ADD KEY `id_my` (`id_my`);

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

ALTER TABLE `files`
  MODIFY `id_file` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

ALTER TABLE `myarttable`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;

ALTER TABLE `files`
  ADD CONSTRAINT `files_ibfk_1` FOREIGN KEY (`id_my`) REFERENCES `myarttable` (`id`);
COMMIT;