Changeset 940

Show
Ignore:
Timestamp:
08/07/08 14:00:50 (4 months ago)
Author:
stavros
Message:

fix errors in psql schema

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/DataBase/psql/UPDATE-a2billing-v1.3.0-to-v1.4.0-pgsql.sql

    r939 r940  
    668668    ADD CONSTRAINT cc_call_archive_pkey PRIMARY KEY (id); 
    669669 
    670 CREATE INDEX cc_call_username_ind ON cc_call_archive USING btree (username); 
    671 CREATE INDEX cc_call_starttime_ind ON cc_call_archive USING btree (starttime); 
    672 CREATE INDEX cc_call_terminatecause_ind ON cc_call_archive USING btree (terminatecause); 
    673 CREATE INDEX cc_call_calledstation_ind ON cc_call_archive USING btree (calledstation); 
     670CREATE INDEX cc_call_username_arc_ind ON cc_call_archive USING btree (username); 
     671CREATE INDEX cc_call_starttime_arc_ind ON cc_call_archive USING btree (starttime); 
     672CREATE INDEX cc_call_terminatecause_arc_ind ON cc_call_archive USING btree (terminatecause); 
     673CREATE INDEX cc_call_calledstation_arc_ind ON cc_call_archive USING btree (calledstation); 
    674674 
    675675 
    …… 
    797797-- Support / Ticket section 
    798798 
     799CREATE TABLE cc_ticket 
     800( 
     801  id bigserial NOT NULL, 
     802  id_component integer NOT NULL, 
     803  title character varying(100) NOT NULL, 
     804  description text, 
     805  priority integer NOT NULL DEFAULT 0, 
     806  creationdate timestamp without time zone NOT NULL DEFAULT now(), 
     807  creator bigserial NOT NULL, 
     808  status integer NOT NULL DEFAULT 0, 
     809  CONSTRAINT cc_ticket_pkey PRIMARY KEY (id) 
     810); 
     811 
    799812CREATE TABLE cc_ticket_comment 
    800813( 
    …… 
    811824); 
    812825 
    813 CREATE TABLE cc_ticket 
    814 ( 
    815   id bigserial NOT NULL, 
    816   id_component integer NOT NULL, 
    817   title character varying(100) NOT NULL, 
    818   description text, 
    819   priority integer NOT NULL DEFAULT 0, 
    820   creationdate timestamp without time zone NOT NULL DEFAULT now(), 
    821   creator bigserial NOT NULL, 
    822   status integer NOT NULL DEFAULT 0, 
    823   CONSTRAINT cc_ticket_pkey PRIMARY KEY (id) 
    824 ); 
    825826 
    826827 


Google