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

« back to all changes in this revision

Viewing changes to src/test/resources/cz/startnet/utils/pgdiff/loader/schema_3.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

files added:

build.xml

license.txt

nbactions.xml

pom.xml

profiles.xml

src/main

src/main/assemblies

src/main/assemblies/netbeans-run.xml

src/main/java

src/main/java/cz

src/main/java/cz/startnet

src/main/java/cz/startnet/utils

src/main/java/cz/startnet/utils/pgdiff

src/main/java/cz/startnet/utils/pgdiff/Main.java

src/main/java/cz/startnet/utils/pgdiff/PgDiff.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffArguments.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffConstraints.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffFunctions.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffIndexes.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffSequences.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffTables.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffTriggers.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffUtils.java

src/main/java/cz/startnet/utils/pgdiff/PgDiffViews.java

src/main/java/cz/startnet/utils/pgdiff/loader

src/main/java/cz/startnet/utils/pgdiff/loader/FileException.java

src/main/java/cz/startnet/utils/pgdiff/loader/PgDumpLoader.java

src/main/java/cz/startnet/utils/pgdiff/loader/package-info.java

src/main/java/cz/startnet/utils/pgdiff/package-info.java

src/main/java/cz/startnet/utils/pgdiff/parsers

src/main/java/cz/startnet/utils/pgdiff/parsers/AlterTableParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateFunctionParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateIndexParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateSchemaParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateSequenceParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateTableParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateTriggerParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/CreateViewParser.java

src/main/java/cz/startnet/utils/pgdiff/parsers/ParserException.java

src/main/java/cz/startnet/utils/pgdiff/parsers/ParserUtils.java

src/main/java/cz/startnet/utils/pgdiff/parsers/package-info.java

src/main/java/cz/startnet/utils/pgdiff/schema

src/main/java/cz/startnet/utils/pgdiff/schema/PgColumn.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgColumnUtils.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgConstraint.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgDatabase.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgFunction.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgIndex.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgSchema.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgSequence.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgTable.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgTrigger.java

src/main/java/cz/startnet/utils/pgdiff/schema/PgView.java

src/main/java/cz/startnet/utils/pgdiff/schema/package-info.java

src/main/resources

src/main/resources/cz

src/main/resources/cz/startnet

src/main/resources/cz/startnet/utils

src/main/resources/cz/startnet/utils/pgdiff

src/main/resources/cz/startnet/utils/pgdiff/build_info

src/main/resources/cz/startnet/utils/pgdiff/usage.txt

src/site

src/site/apt

src/site/site.xml

src/site/xdoc

src/site/xdoc/index.xml

src/test

src/test/java

src/test/java/cz

src/test/java/cz/startnet

src/test/java/cz/startnet/utils

src/test/java/cz/startnet/utils/pgdiff

src/test/java/cz/startnet/utils/pgdiff/PgDiffTest.java

src/test/java/cz/startnet/utils/pgdiff/loader

src/test/java/cz/startnet/utils/pgdiff/loader/PgDumpLoaderTest.java

src/test/resources

src/test/resources/cz

src/test/resources/cz/startnet

src/test/resources/cz/startnet/utils

src/test/resources/cz/startnet/utils/pgdiff

src/test/resources/cz/startnet/utils/pgdiff/add_cluster_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_cluster_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_cluster_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_column_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_column_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_column_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_constraint_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_constraint_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_constraint_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_default_value_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_default_value_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_default_value_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_defaults_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_defaults_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_defaults_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_args2_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_args2_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_args2_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_args_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_args_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_args_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_noargs_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_noargs_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_noargs_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_similar_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_similar_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_function_similar_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_index_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_index_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_index_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_inherits_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_inherits_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_inherits_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_not_null_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_not_null_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_not_null_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_sequence_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_sequence_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_sequence_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_statistics_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_statistics_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_statistics_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_table_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_table_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_table_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_transaction_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_transaction_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_transaction_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_trigger_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_trigger_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_trigger_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_unique_constraint_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_unique_constraint_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_unique_constraint_original.sql

src/test/resources/cz/startnet/utils/pgdiff/add_view_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/add_view_new.sql

src/test/resources/cz/startnet/utils/pgdiff/add_view_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_cluster_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_cluster_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_cluster_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_column_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_column_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_column_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_constraint_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_constraint_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_constraint_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_default_value_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_default_value_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_default_value_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_args2_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_args2_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_args2_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_args_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_args_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_args_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_noargs_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_noargs_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_noargs_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_similar_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_similar_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_function_similar_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_index_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_index_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_index_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_index_with_cluster_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_index_with_cluster_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_index_with_cluster_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_not_null_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_not_null_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_not_null_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_sequence_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_sequence_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_sequence_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_statistics_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_statistics_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_statistics_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_table_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_table_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_table_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_trigger_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_trigger_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_trigger_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_view_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_view_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_view_original.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_with_oids_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_with_oids_new.sql

src/test/resources/cz/startnet/utils/pgdiff/drop_with_oids_original.sql

src/test/resources/cz/startnet/utils/pgdiff/function_equal_whitespace_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/function_equal_whitespace_new.sql

src/test/resources/cz/startnet/utils/pgdiff/function_equal_whitespace_original.sql

src/test/resources/cz/startnet/utils/pgdiff/inherited_tables_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/loader

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_1.sql

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_2.sql

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_3.sql

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_4.sql

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_5.sql

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_6.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_cluster_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_cluster_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_cluster_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_column_type_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_column_type_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_column_type_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_constraint_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_constraint_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_constraint_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_default_value_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_default_value_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_default_value_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_args2_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_args2_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_args2_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_args_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_args_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_args_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_noargs_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_noargs_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_noargs_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_similar_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_similar_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_function_similar_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_index_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_index_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_index_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_inherits_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_inherits_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_inherits_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cache_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cache_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cache_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cycle_off_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cycle_off_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cycle_off_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cycle_on_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cycle_on_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_cycle_on_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_increment_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_increment_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_increment_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_maxvalue_set_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_maxvalue_set_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_maxvalue_set_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_maxvalue_unset_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_maxvalue_unset_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_maxvalue_unset_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_minvalue_set_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_minvalue_set_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_minvalue_set_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_minvalue_unset_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_minvalue_unset_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_minvalue_unset_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_start_ignore_off_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_start_ignore_off_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_start_ignore_off_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_start_ignore_on_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_start_ignore_on_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_sequence_start_ignore_on_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_statistics_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_statistics_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_statistics_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_trigger_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_trigger_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_trigger_original.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_view_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_view_new.sql

src/test/resources/cz/startnet/utils/pgdiff/modify_view_original.sql

src/test/resources/cz/startnet/utils/pgdiff/multiple_schemas_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/multiple_schemas_new.sql

src/test/resources/cz/startnet/utils/pgdiff/multiple_schemas_original.sql

src/test/resources/cz/startnet/utils/pgdiff/read_inherits_diff.sql

src/test/resources/cz/startnet/utils/pgdiff/read_inherits_new.sql

src/test/resources/cz/startnet/utils/pgdiff/read_inherits_original.sql

Show diffs side-by-side

added added

removed removed

src/test/resources/cz/startnet/utils/pgdiff/loader/schema_3.sql

-- TOC Entry ID 2 (OID 605638)

-- Name: admins_aid_seq Type: SEQUENCE Owner: xxxx

CREATE SEQUENCE "admins_aid_seq" start 1 increment 1 maxvalue 1000000000 minvalue 1 cache 1;

-- TOC Entry ID 108 (OID 605640)

-- Name: admins Type: TABLE Owner: enki

CREATE TABLE "admins" (

"aid" integer DEFAULT nextval('"admins_aid_seq"'::text) NOT NULL,

"companyid" integer DEFAULT 0 NOT NULL,

"groupid" integer DEFAULT 0 NOT NULL,

"username" character varying NOT NULL,

"password" character varying(40) NOT NULL,

"superuser" boolean DEFAULT 'f'::bool NOT NULL,

"name" character varying(40),

"surname" character varying(40),

"email" character varying(100) NOT NULL,

"tel" character varying(40),

"mobile" character varying(40),

"enabled" boolean DEFAULT 't'::bool NOT NULL,

"lastlogints" timestamp with time zone DEFAULT now() NOT NULL,

"expirienced" boolean DEFAULT 'f'::bool,

Constraint "admins_pkey" Primary Key ("aid")

);

b'\\ No newline at end of file'

Older »