pgsql/update_tables_0.5.x-0.6.pgsql
branchv0.6.x
changeset 538 1f9ea5658627
parent 530 95dd123b552e
child 548 92ef34f07da3
equal deleted inserted replaced
537:9a23043b0530 538:1f9ea5658627
   169     destination varchar(320) NOT NULL,
   169     destination varchar(320) NOT NULL,
   170     CONSTRAINT  pkey_catchall PRIMARY KEY (gid, destination),
   170     CONSTRAINT  pkey_catchall PRIMARY KEY (gid, destination),
   171     CONSTRAINT  fkey_catchall_gid_domain_data FOREIGN KEY (gid)
   171     CONSTRAINT  fkey_catchall_gid_domain_data FOREIGN KEY (gid)
   172         REFERENCES domain_data (gid)
   172         REFERENCES domain_data (gid)
   173 );
   173 );
       
   174 
       
   175 -- ---
       
   176 -- Account/domain notes
       
   177 -- ---
       
   178 
       
   179 ALTER TABLE users ADD COLUMN note text NULL DEFAULT NULL;
       
   180 ALTER TABLE domain_data ADD COLUMN note text NULL DEFAULT NULL;
   174 
   181 
   175 -- ---
   182 -- ---
   176 -- Restore view
   183 -- Restore view
   177 -- ---
   184 -- ---
   178 CREATE VIEW vmm_domain_info AS
   185 CREATE VIEW vmm_domain_info AS