Changeset 263


Ignore:
Timestamp:
Nov 11, 2009, 2:02:54 PM (11 years ago)
Author:
maarten
Message:

fixed DB bugs

Location:
sql
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • sql/clear.sql

    r177 r263  
    1 -DROP DATABASE ibidas_test_nieuw2;
    2 CREATE DATABASE ibidas_test_nieuw2 WITH ENCODING 'UTF8';
    3 \c ibidas_test_nieuw2
     1DROP DATABASE ibidas_test_nieuw;
     2CREATE DATABASE ibidas_test_nieuw WITH ENCODING 'UTF8';
     3\c ibidas_test_nieuw
    44\i preimport.sql
  • sql/preimport.sql

    r258 r263  
    320320    start_pos BIGINT NOT NULL,
    321321    end_pos BIGINT NOT NULL,
    322     strand CHAR(1) NOT NULL
     322    strand BOOLEAN NOT NULL
    323323) INHERITS (prop);
    324324
     
    696696END;
    697697' LANGUAGE 'plpgsql';
    698 CREATE TRIGGER set_group AFTER INSERT ON set FOR EACH ROW EXECUTE PROCEDURE add_to_set_pg_group();
     698--CREATE TRIGGER set_group AFTER INSERT ON set FOR EACH ROW EXECUTE PROCEDURE add_to_set_pg_group();
Note: See TracChangeset for help on using the changeset viewer.