Lines Matching refs:opt
19 my ( $opt, $usage ) = describe_options(
32 print( $usage->text ), exit if $opt->help or !$opt->dsn;
38 if ( $opt->dsn =~ m/db2/i ) {
39 $schema_attributes->{db2_set_schema} = $opt->schema
44 = DBI->connect( $opt->dsn, $opt->user, $opt->pass, $schema_attributes )
47 DBI->trace(1) if $opt->trace;
54 if ( $opt->execute ) {
103 if ( $opt->db_version && $opt->db_version =~ /8\.?/ ) {
107 'DROP INDEX "' . ($opt->schema) . '"."AL_CS_IDX_U"',
108 'DROP INDEX "' . ($opt->schema) . '"."AL_A_IDX_AT"',
109 'DROP INDEX "' . ($opt->schema) . '"."AL_A_IDX_CS"',
110 'DROP INDEX "' . ($opt->schema) . '"."AL_C_IDX_A"',
111 'DROP INDEX "' . ($opt->schema) . '"."AL_C_IDX_F"',
112 'DROP INDEX "' . ($opt->schema) . '"."AL_F_IDX_AT"',
116 … 'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGESET" DROP FOREIGN KEY "AL_CS_FK_U"',
117 … 'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_ACTION" DROP FOREIGN KEY "AL_A_FK_AT"',
118 … 'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_ACTION" DROP FOREIGN KEY "AL_A_FK_CS"',
119 … 'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE" DROP FOREIGN KEY "AL_C_FK_A"',
120 … 'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE" DROP FOREIGN KEY "AL_C_FK_F"',
121 … 'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_FIELD" DROP FOREIGN KEY "AL_F_FK_AT"',
125 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGESET" RENAME COLUMN "USER" TO "USER…
126 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGESET" RENAME COLUMN "TIMESTAMP" TO "CREA…
127 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_ACTION" RENAME COLUMN "CHANGESET" TO "CHAN…
128 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_ACTION" RENAME COLUMN "AUDITED_TABLE" TO "AUDI…
129 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_ACTION" RENAME COLUMN "TYPE" TO "ACTI…
130 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE" RENAME COLUMN "ACTION" TO "ACTI…
131 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE" RENAME COLUMN "FIELD" TO "FIEL…
132 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_FIELD" RENAME COLUMN "AUDITED_TABLE" TO "AUDI…
137 …'CREATE INDEX "' . ($opt->schema) . '"."AUDIT_LOG_CHANGESET_IDX_USER" ON "' . ($opt->schema)…
138 …'CREATE INDEX "' . ($opt->schema) . '"."AUDIT_LOG_FIELD_IDX_AUDITED_TABLE" ON "' . ($opt->schema)…
139 …'CREATE INDEX "' . ($opt->schema) . '"."AUDIT_LOG_ACTION_IDX_AUDITED_TABLE" ON "' . ($opt->schema)…
140 …'CREATE INDEX "' . ($opt->schema) . '"."AUDIT_LOG_ACTION_IDX_CHANGESET" ON "' . ($opt->schema)…
141 …'CREATE INDEX "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE_IDX_ACTION" ON "' . ($opt->schema)…
142 …'CREATE INDEX "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE_IDX_FIELD" ON "' . ($opt->schema)…
145 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGESET" ADD CONSTRAINT AUDIT_LOG_CHANGESET_FK_…
146 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_FIELD" ADD CONSTRAINT AUDIT_LOG_FIELD_FK_AUDI…
147 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_ACTION" ADD CONSTRAINT AUDIT_LOG_ACTION_FK_AUD…
148 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_ACTION" ADD CONSTRAINT AUDIT_LOG_ACTION_FK_CHA…
149 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE" ADD CONSTRAINT AUDIT_LOG_CHANGE_FK_ACT…
150 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE" ADD CONSTRAINT AUDIT_LOG_CHANGE_FK_FIE…
157 'DROP INDEX "' . ($opt->schema) . '"."AUDIT_LOG_CHANGESET_IDX_USER"',
158 'DROP INDEX "' . ($opt->schema) . '"."AUDIT_LOG_ACTION_IDX_AUDITED_TABLE"',
159 'DROP INDEX "' . ($opt->schema) . '"."AUDIT_LOG_ACTION_IDX_CHANGESET"',
160 'DROP INDEX "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE_IDX_ACTION"',
161 'DROP INDEX "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE_IDX_FIELD"',
162 'DROP INDEX "' . ($opt->schema) . '"."AUDIT_LOG_FIELD_IDX_AUDITED_TABLE"',
166 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGESET" DROP FOREIGN KEY "AUDIT_LOG_CHANGESET_…
167 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_ACTION" DROP FOREIGN KEY "AUDIT_LOG_ACTION_FK_…
168 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_ACTION" DROP FOREIGN KEY "AUDIT_LOG_ACTION_FK_…
169 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE" DROP FOREIGN KEY "AUDIT_LOG_CHANGE_FK_…
170 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE" DROP FOREIGN KEY "AUDIT_LOG_CHANGE_FK_…
171 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_FIELD" DROP FOREIGN KEY "AUDIT_LOG_FIELD_FK_A…
175 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGESET" RENAME COLUMN "USER" TO "USER…
176 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGESET" RENAME COLUMN "TIMESTAMP" TO "CREA…
177 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_ACTION" RENAME COLUMN "CHANGESET" TO "CHAN…
178 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_ACTION" RENAME COLUMN "AUDITED_TABLE" TO "AUDI…
179 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_ACTION" RENAME COLUMN "TYPE" TO "ACTI…
180 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE" RENAME COLUMN "ACTION" TO "ACTI…
181 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE" RENAME COLUMN "FIELD" TO "FIEL…
182 …'ALTER TABLE "' . ($opt->schema) . '"."AUDIT_LOG_FIELD" RENAME COLUMN "AUDITED_TABLE" TO "AUDI…
187 …'CREATE INDEX "' . ($opt->schema) . '"."AUDIT_LOG_CHANGESET_IDX_USER" ON "' . ($opt->schema)…
188 …'CREATE INDEX "' . ($opt->schema) . '"."AUDIT_LOG_FIELD_IDX_AUDITED_TABLE" ON "' . ($opt->schema)…
189 …'CREATE INDEX "' . ($opt->schema) . '"."AUDIT_LOG_ACTION_IDX_AUDITED_TABLE" ON "' . ($opt->schema)…
190 …'CREATE INDEX "' . ($opt->schema) . '"."AUDIT_LOG_ACTION_IDX_CHANGESET" ON "' . ($opt->schema)…
191 …'CREATE INDEX "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE_IDX_ACTION" ON "' . ($opt->schema)…
192 …'CREATE INDEX "' . ($opt->schema) . '"."AUDIT_LOG_CHANGE_IDX_FIELD" ON "' . ($opt->schema)…
195 … . ($opt->schema) . '"."AUDIT_LOG_CHANGESET" ADD CONSTRAINT AUDIT_LOG_CHANGESET_FK_USER FORE…
196 … . ($opt->schema) . '"."AUDIT_LOG_FIELD" ADD CONSTRAINT AUDIT_LOG_FIELD_FK_AUDITED_TABLE FORE…
197 … . ($opt->schema) . '"."AUDIT_LOG_ACTION" ADD CONSTRAINT AUDIT_LOG_ACTION_FK_AUDITED_TABLE FORE…
198 … . ($opt->schema) . '"."AUDIT_LOG_ACTION" ADD CONSTRAINT AUDIT_LOG_ACTION_FK_CHANGESET FORE…
199 … . ($opt->schema) . '"."AUDIT_LOG_CHANGE" ADD CONSTRAINT AUDIT_LOG_CHANGE_FK_ACTION FORE…
200 … . ($opt->schema) . '"."AUDIT_LOG_CHANGE" ADD CONSTRAINT AUDIT_LOG_CHANGE_FK_FIELD FORE…