← Back to branch summary

~ubuntu-branches/ubuntu/karmic/apgdiff/karmic

« back to all changes in this revision

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