/
alesu1543
/
practR
Обзор
Документация
Войти
/
alesu1543
/
practR
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
import_test.sql
52 строки
2 KB
Alexey Subbotin
add db include
28 май 2023, 15:36
Не верифицирован
28 май 2023, 15:36
3f0771f
Код
Авторство
О чём код?
-- Creation of a test base... CREATE DATABASE test; USE 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, 'Закачка из менеджера', 'test file 1.pdf', 'files/test_file1.pdf', '31-03-2023 20:07:59'); 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);