From 840c15258a02fff57b6f271da8ca4eee62627336 Mon Sep 17 00:00:00 2001 From: Andrea Zagli Date: Sat, 16 Feb 2013 15:16:26 +0100 Subject: [PATCH] Aggiunto il file dello schema del db. --- docs/messi.sql | 62 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 62 insertions(+) create mode 100644 docs/messi.sql diff --git a/docs/messi.sql b/docs/messi.sql new file mode 100644 index 0000000..b38b95a --- /dev/null +++ b/docs/messi.sql @@ -0,0 +1,62 @@ +-- +-- PostgreSQL database dump +-- + +-- Dumped from database version 9.1.8 +-- Dumped by pg_dump version 9.1.8 +-- Started on 2013-02-16 15:15:33 CET + +SET statement_timeout = 0; +SET client_encoding = 'LATIN9'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +-- +-- TOC entry 162 (class 3079 OID 11649) +-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: - +-- + +CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; + + +-- +-- TOC entry 1863 (class 0 OID 0) +-- Dependencies: 162 +-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: - +-- + +COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; + + +SET search_path = public, pg_catalog; + +SET default_with_oids = false; + +-- +-- TOC entry 161 (class 1259 OID 18085) +-- Dependencies: 6 +-- Name: atti; Type: TABLE; Schema: public; Owner: - +-- + +CREATE TABLE atti ( + id integer NOT NULL +); + + +-- +-- TOC entry 1856 (class 2606 OID 18089) +-- Dependencies: 161 161 1858 +-- Name: atti_pkey; Type: CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY atti + ADD CONSTRAINT atti_pkey PRIMARY KEY (id); + + +-- Completed on 2013-02-16 15:15:33 CET + +-- +-- PostgreSQL database dump complete +-- + -- 2.49.0