Changes between Version 15 and Version 16 of notasVarias


Ignore:
Timestamp:
Sep 22, 2015, 1:42:59 PM (9 years ago)
Author:
aaraujo
Comment:

Revisión del script sql para la creación de la base de datos de estadísticas

Legend:

Unmodified
Added
Removed
Modified

  • notasVarias

    v15 v16  
    130130-- Dumped from database version 9.1.18
    131131-- Dumped by pg_dump version 9.1.18
    132 -- Started on 2015-09-16 14:47:26 VET
     132-- Started on 2015-09-22 13:27:07 VET
    133133
    134134SET statement_timeout = 0;
    … …  
    162162
    163163--
    164 -- TOC entry 162 (class 1259 OID 16920)
     164-- TOC entry 162 (class 1259 OID 17070)
    165165-- Dependencies: 5
    166166-- Name: signatures; Type: TABLE; Schema: public; Owner: aaraujo; Tablespace:
    … …  
    176176
    177177--
    178 -- TOC entry 166 (class 1259 OID 16936)
     178-- TOC entry 166 (class 1259 OID 17086)
    179179-- Dependencies: 5
    180180-- Name: signatures_error; Type: TABLE; Schema: public; Owner: aaraujo; Tablespace:
    … …  
    182182
    183183CREATE TABLE signatures_error (
    184     signature_error_id integer NOT NULL
     184    signature_error_id integer NOT NULL,
     185    type character(4) NOT NULL
    185186);
    186187
    … …  
    189190
    190191--
    191 -- TOC entry 165 (class 1259 OID 16934)
     192-- TOC entry 165 (class 1259 OID 17084)
    192193-- Dependencies: 166 5
    193194-- Name: signatures_error_signature_error_id_seq; Type: SEQUENCE; Schema: public; Owner: aaraujo
    … …  
    214215
    215216--
    216 -- TOC entry 161 (class 1259 OID 16918)
     217-- TOC entry 161 (class 1259 OID 17068)
    217218-- Dependencies: 5 162
    218219-- Name: signatures_signature_id_seq; Type: SEQUENCE; Schema: public; Owner: aaraujo
    … …  
    239240
    240241--
    241 -- TOC entry 164 (class 1259 OID 16928)
     242-- TOC entry 164 (class 1259 OID 17078)
    242243-- Dependencies: 5
    243244-- Name: verifications; Type: TABLE; Schema: public; Owner: aaraujo; Tablespace:
    … …  
    245246
    246247CREATE TABLE verifications (
    247     verification_id integer NOT NULL
     248    verification_id integer NOT NULL,
     249    type character(4) NOT NULL
    248250);
    249251
    … …  
    252254
    253255--
    254 -- TOC entry 163 (class 1259 OID 16926)
     256-- TOC entry 163 (class 1259 OID 17076)
    255257-- Dependencies: 164 5
    256258-- Name: verifications_verification_id_seq; Type: SEQUENCE; Schema: public; Owner: aaraujo
    … …  
    277279
    278280--
    279 -- TOC entry 1763 (class 2604 OID 16923)
     281-- TOC entry 1763 (class 2604 OID 17073)
    280282-- Dependencies: 162 161 162
    281283-- Name: signature_id; Type: DEFAULT; Schema: public; Owner: aaraujo
    … …  
    286288
    287289--
    288 -- TOC entry 1765 (class 2604 OID 16939)
     290-- TOC entry 1765 (class 2604 OID 17089)
    289291-- Dependencies: 165 166 166
    290292-- Name: signature_error_id; Type: DEFAULT; Schema: public; Owner: aaraujo
    … …  
    295297
    296298--
    297 -- TOC entry 1764 (class 2604 OID 16931)
     299-- TOC entry 1764 (class 2604 OID 17081)
    298300-- Dependencies: 164 163 164
    299301-- Name: verification_id; Type: DEFAULT; Schema: public; Owner: aaraujo
    … …  
    304306
    305307--
    306 -- TOC entry 1874 (class 0 OID 16920)
     308-- TOC entry 1874 (class 0 OID 17070)
    307309-- Dependencies: 162 1879
    308310-- Data for Name: signatures; Type: TABLE DATA; Schema: public; Owner: aaraujo
    … …  
    314316
    315317--
    316 -- TOC entry 1878 (class 0 OID 16936)
     318-- TOC entry 1878 (class 0 OID 17086)
    317319-- Dependencies: 166 1879
    318320-- Data for Name: signatures_error; Type: TABLE DATA; Schema: public; Owner: aaraujo
    319321--
    320322
    321 COPY signatures_error (signature_error_id) FROM stdin;
     323COPY signatures_error (signature_error_id, type) FROM stdin;
    322324\.
    323325
    … …  
    338340--
    339341
    340 SELECT pg_catalog.setval('signatures_signature_id_seq', 3, true);
    341 
    342 
    343 --
    344 -- TOC entry 1876 (class 0 OID 16928)
     342SELECT pg_catalog.setval('signatures_signature_id_seq', 1, false);
     343
     344
     345--
     346-- TOC entry 1876 (class 0 OID 17078)
    345347-- Dependencies: 164 1879
    346348-- Data for Name: verifications; Type: TABLE DATA; Schema: public; Owner: aaraujo
    347349--
    348350
    349 COPY verifications (verification_id) FROM stdin;
     351COPY verifications (verification_id, type) FROM stdin;
    350352\.
    351353
    … …  
    361363
    362364--
    363 -- TOC entry 1771 (class 2606 OID 16941)
     365-- TOC entry 1771 (class 2606 OID 17091)
    364366-- Dependencies: 166 166 1880
    365367-- Name: signatures_error_pkey; Type: CONSTRAINT; Schema: public; Owner: aaraujo; Tablespace:
    … …  
    371373
    372374--
    373 -- TOC entry 1767 (class 2606 OID 16925)
     375-- TOC entry 1767 (class 2606 OID 17075)
    374376-- Dependencies: 162 162 1880
    375377-- Name: signatures_pkey; Type: CONSTRAINT; Schema: public; Owner: aaraujo; Tablespace:
    … …  
    381383
    382384--
    383 -- TOC entry 1769 (class 2606 OID 16933)
     385-- TOC entry 1769 (class 2606 OID 17083)
    384386-- Dependencies: 164 164 1880
    385387-- Name: verifications_pkey; Type: CONSTRAINT; Schema: public; Owner: aaraujo; Tablespace:
    … …  
    402404
    403405
    404 -- Completed on 2015-09-16 14:47:26 VET
     406-- Completed on 2015-09-22 13:27:07 VET
    405407
    406408--
    … …  
    408410--
    409411
     412
    410413}}}
    411414