![]()
|
|||||||
CONSTRAINT FK_results_students_idStudent FOREIGN KEY (idStudent)CONSTRAINT FK_results_students_idStudent FOREIGN KEY (idStudent) REFERENCES students(idStudent) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT FK_results_subjects_idSubject FOREIGN KEY (idSubject) REFERENCES subjects(idSubject) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT FK_results_teachers_idTeacher FOREIGN KEY (idTeacher) REFERENCES teachers(idTeacher) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;
-- -- Описание для таблицы sessions -- DROP TABLE IF EXISTS sessions; CREATE TABLE sessions ( NumGroup INT(11) NOT NULL, NumSemestr INT(11) NOT NULL, idSubject INT(11) NOT NULL, idTeacher INT(11) NOT NULL, Zach_Exam VARCHAR(7) NOT NULL, PRIMARY KEY (NumGroup, NumSemestr, idSubject, idTeacher), CONSTRAINT FK_sessions_subjects_idSubject FOREIGN KEY (idSubject) REFERENCES subjects(idSubject) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT FK_sessions_teachers_idTeacher FOREIGN KEY (idTeacher) REFERENCES teachers(idTeacher) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;
-- -- секция для команд вставки данных из таблиц -- -- -- Включение внешних ключей -- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
В PostgreSQL резервную копию можно создать с помощью пункта контекстного меню «Резервная копия» для элемента дерева, соответствующего копируемой базе данных. В результате будет сгенерирован следующий SQL-код:
-- -- PostgreSQL database dump -- -- Dumped from database version 9.3.5 -- Dumped by pg_dump version 9.3.5 -- Started on 2014-08-04 23:54:32
SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; -- -- TOC entry 177 (class 3079 OID 11750) -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: --
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
-- -- TOC entry 1991 (class 0 OID 0) -- Dependencies: 177 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: --
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- TOC entry 171 (class 1259 OID 16397) -- Name: Departments; Type: TABLE; Schema: public; Owner: postgres; Tablespace: --
CREATE TABLE "Departments" ( "idDepartment" oid NOT NULL, "TitleDepartment" text NOT NULL,
|
|||||||
|