← Back to branch summary

~ubuntu-branches/ubuntu/raring/apgdiff/raring

« back to all changes in this revision

Viewing changes to src/test/resources/cz/startnet/utils/pgdiff/multiple_schemas_diff.sql

  • Committer: Bazaar Package Importer
  • Author(s): Christoph Berg
  • Date: 2008-09-09 15:42:54 UTC
  • Revision ID: james.westby@ubuntu.com-20080909154254-458sv7ew1rczdal1
Tags: upstream-1.2
Import upstream version 1.2

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/test/resources/cz/startnet/utils/pgdiff/multiple_schemas_diff.sql
 
1
 
 
2
DROP SCHEMA testschema1 CASCADE;
 
3
 
 
4
CREATE SCHEMA testschema2;
 
5
 
 
6
SET search_path = public, pg_catalog;
 
7
 
 
8
DROP SEQUENCE testtable2_id_seq;
 
9
 
 
10
CREATE SEQUENCE testtable3_id_seq
 
11
        START WITH 1
 
12
        INCREMENT BY 1
 
13
        NO MAXVALUE
 
14
        NO MINVALUE
 
15
        CACHE 1;
 
16
 
 
17
DROP TABLE testtable2;
 
18
 
 
19
CREATE TABLE testtable3 (
 
20
        id bigint DEFAULT nextval('testtable3_id_seq'::regclass) NOT NULL
 
21
);
 
22
 
 
23
SET search_path = testschema2, pg_catalog;
 
24
 
 
25
CREATE SEQUENCE testtable1_id_seq
 
26
        START WITH 1
 
27
        INCREMENT BY 1
 
28
        NO MAXVALUE
 
29
        NO MINVALUE
 
30
        CACHE 1;
 
31
 
 
32
CREATE TABLE testtable1 (
 
33
        id integer DEFAULT nextval('testtable1_id_seq'::regclass) NOT NULL
 
34
);