Starting transaction...
Preparing query: ALTER TABLE tableacroiser DROP CONSTRAINT TableaCroiser_pk
Prepare time: 0.063s
Plan not available.
Executing...
Done.
322 fetches, 5 marks, 12 reads, 0 writes.
0 inserts, 1 updates, 3 deletes, 41 index, 24 seq.
Delta memory: 109320 bytes.
RDB$INDEX_SEGMENTS: 1 deletes.
RDB$INDICES: 1 deletes.
RDB$RELATIONS: 1 updates.
RDB$RELATION_CONSTRAINTS: 1 deletes.
Total execution time: 0.110s
Preparing query:
ALTER TABLE tableacroiser DROP PK
Prepare time: 0.000s
Plan not available.
Executing...
Done.
495 fetches, 10 marks, 20 reads, 0 writes.
0 inserts, 1 updates, 4 deletes, 56 index, 14 seq.
Delta memory: 217480 bytes.
RDB$FIELDS: 1 deletes.
RDB$RELATION_FIELDS: 1 deletes.
RDB$RELATIONS: 1 updates.
RDB$RELATION_CONSTRAINTS: 1 deletes.
RDB$CHECK_CONSTRAINTS: 1 deletes.
Total execution time: 0.032s
Preparing query:
DROP GENERATOR g_tableacroiser
Prepare time: 0.000s
Plan not available.
Executing...
Done.
41 fetches, 1 marks, 0 reads, 0 writes.
0 inserts, 0 updates, 1 deletes, 3 index, 7 seq.
Delta memory: 6320 bytes.
RDB$GENERATORS: 1 deletes.
Total execution time: 0.015s
Commiting transaction...
Done.
Starting transaction...
Preparing query:
ALTER TABLE tableacroiser ADD pk INTEGER NOT NULL
Prepare time: 0.000s
Plan not available.
Executing...
Done.
150 fetches, 17 marks, 1 reads, 0 writes.
4 inserts, 1 updates, 0 deletes, 24 index, 0 seq.
Delta memory: 70864 bytes.
RDB$FIELDS: 1 inserts.
RDB$RELATION_FIELDS: 1 inserts.
RDB$RELATIONS: 1 updates.
RDB$RELATION_CONSTRAINTS: 1 inserts.
RDB$CHECK_CONSTRAINTS: 1 inserts.
Total execution time: 0.016s
Preparing query:
CREATE GENERATOR g_tableacroiser
Prepare time: 0.000s
Plan not available.
Executing...
Done.
16 fetches, 5 marks, 0 reads, 0 writes.
1 inserts, 0 updates, 0 deletes, 0 index, 0 seq.
Delta memory: 12960 bytes.
RDB$GENERATORS: 1 inserts.
Total execution time: 0.015s
Commiting transaction...
Done.
Starting transaction...
Preparing query:
UPDATE tableacroiser SET pk = GEN_ID(g_tableacroiser, 1)
Prepare time: 0.000s
PLAN (TABLEACROISER NATURAL)
Executing...
Done.
122 fetches, 15 marks, 2 reads, 0 writes.
0 inserts, 5 updates, 0 deletes, 19 index, 5 seq.
Delta memory: 13984 bytes.
TABLEACROISER: 5 updates.
5 rows affected directly.
Total execution time: 0.000s
Commiting transaction...
Done.
Starting transaction...
Preparing query:
ALTER TABLE tableacroiser ADD CONSTRAINT tableacroiser_pk
PRIMARY KEY (pk)
Prepare time: 0.016s
Plan not available.
Executing...
Done.
137 fetches, 12 marks, 0 reads, 0 writes.
3 inserts, 1 updates, 0 deletes, 14 index, 0 seq.
Delta memory: 80776 bytes.
RDB$INDEX_SEGMENTS: 1 inserts.
RDB$INDICES: 1 inserts.
RDB$RELATIONS: 1 updates.
RDB$RELATION_CONSTRAINTS: 1 inserts.
Total execution time: 0.016s
Script execution finished.
Commiting transaction...
Done.
Starting transaction...
Preparing query: ALTER TABLE tableacroiser DROP CONSTRAINT TableaCroiser_pk
Prepare time: 0.031s
Plan not available.
Preparing query:
ALTER TABLE tableacroiser DROP PK
Prepare time: 0.000s
Plan not available.
Preparing query:
DROP GENERATOR g_tableacroiser
Prepare time: 0.015s
Plan not available.
Commiting transaction...
Done.
Starting transaction...
Preparing query:
ALTER TABLE tableacroiser ADD pk INTEGER NOT NULL
Prepare time: 0.016s
Plan not available.
Preparing query:
CREATE GENERATOR g_tableacroiser
Prepare time: 0.000s
Plan not available.
Commiting transaction...
Done.
Starting transaction...
Preparing query:
UPDATE tableacroiser SET pk = GEN_ID(g_tableacroiser, 1)
Prepare time: 0.000s
PLAN (TABLEACROISER NATURAL)
Commiting transaction...
Done.
Starting transaction...
Preparing query:
ALTER TABLE tableacroiser ADD CONSTRAINT tableacroiser_pk
PRIMARY KEY (pk)
Prepare time: 0.000s
Plan not available.
Script execution finished.
Partager