Files

 main

/

examples

/

Copy path

Directory actions

More options

Directory actions

More options

Latest commit

kvch

Improve create_index operation with extra index element settings (#697

Feb 28, 2025

7b383dc · Feb 28, 2025

History

History

/

examples

/

Top

Folders and files

Name		Name	Last commit message	Last commit date
parent directory ..
.ledger		.ledger	Improve create_index operation with extra index element settings (#697	Feb 28, 2025
01_create_tables.json		01_create_tables.json	Add support for composite keys in create table statements (#413)	Oct 18, 2024
02_create_another_table.json		02_create_another_table.json	Format the examples with jq (#21)	Jul 6, 2023
03_add_column.json		03_add_column.json	Implement Start for adding columns with NOT NULL and no DEFAULT (…	Jul 21, 2023
04_rename_table.json		04_rename_table.json	Rename table op (#23)	Jul 11, 2023
05_sql.json		05_sql.json	Add raw SQL operation (#43)	Aug 30, 2023
06_add_column_to_sql_table.json		06_add_column_to_sql_table.json	Add raw SQL operation (#43)	Aug 30, 2023
07_drop_table.json		07_drop_table.json	Implement the drop table operation (#45)	Aug 17, 2023
08_create_fruits_table.json		08_create_fruits_table.json	New option for columns: generated (#605)	Jan 22, 2025
09_drop_column.json		09_drop_column.json	Implement 'drop column' migrations (#48)	Aug 17, 2023
10_create_index.json		10_create_index.json	Improve create_index operation with extra index element settings (#697	Feb 28, 2025
11_drop_index.json		11_drop_index.json	Make index name mandatory on create index operation (#59)	Aug 18, 2023
12_create_employees_table.json		12_create_employees_table.json	Add support for creating tables and columns with comments (#224)	Jan 10, 2024
13_rename_column.json		13_rename_column.json	Add OpRenameColumn for renaming columns (#602)	Jan 17, 2025
14_add_reviews_table.json		14_add_reviews_table.json	Implement the set column NOT NULL operation (#63)	Aug 29, 2023
15_set_column_unique.json		15_set_column_unique.json	Make set_unique operations respect the contract for old schema vers…	Sep 22, 2023
16_set_nullable.json		16_set_nullable.json	Always surround up and down clauses in parentheses (#481)	Nov 22, 2024
17_add_rating_column.json		17_add_rating_column.json	Implement the 'change column type' operation (#74)	Sep 1, 2023
18_change_column_type.json		18_change_column_type.json	Add 'alter column' operation to combine some existing operations (#91)	Sep 12, 2023
19_create_orders_table.json		19_create_orders_table.json	Make naming FOREIGN KEY constraints mandatory (#100)	Sep 15, 2023
20_create_posts_table.json		20_create_posts_table.json	Add support for adding a foreign key constraint to an existing column (…	Sep 11, 2023
21_add_foreign_key_constraint.json		21_add_foreign_key_constraint.json	Always surround up and down clauses in parentheses (#481)	Nov 22, 2024
22_add_check_constraint.json		22_add_check_constraint.json	Always surround up and down clauses in parentheses (#481)	Nov 22, 2024
23_drop_check_constraint.json		23_drop_check_constraint.json	Always surround up and down clauses in parentheses (#481)	Nov 22, 2024
24_drop_foreign_key_constraint.json		24_drop_foreign_key_constraint.json	Always surround up and down clauses in parentheses (#481)	Nov 22, 2024
25_add_table_with_check_constraint.json		25_add_table_with_check_constraint.json	Allow columns with CHECK constraints in create table operations (#108)	Sep 19, 2023
26_add_column_with_check_constraint.json		26_add_column_with_check_constraint.json	Allow columns with CHECK constraints on add column operations (#109)	Sep 20, 2023
27_drop_unique_constraint.json		27_drop_unique_constraint.json	Remove Column field from DropConstraint (#431)	Nov 6, 2024
28_different_defaults.json		28_different_defaults.json	Stop quoting column default values (#200)	Nov 6, 2023
29_set_replica_identity.json		29_set_replica_identity.json	Use original table name without prefix when processing create table (#…	Jan 8, 2025
30_add_column_simple_up.json		30_add_column_simple_up.json	Add support for creating tables and columns with comments (#224)	Jan 10, 2024
31_unset_not_null.json		31_unset_not_null.json	Always surround up and down clauses in parentheses (#481)	Nov 22, 2024
32_sql_on_complete.json		32_sql_on_complete.json	Add SQL onComplete flag, allow sql migration to run with others (#…	Feb 12, 2024
33_rename_check_constraint.json		33_rename_check_constraint.json	Add rename_constraint operation (#293)	Mar 1, 2024
34_create_events_table.json		34_create_events_table.json	Add a 'set comment' sub-operation to 'alter column' (#344)	Apr 29, 2024
35_alter_column_multiple.json		35_alter_column_multiple.json	Add OpRenameColumn for renaming columns (#602)	Jan 17, 2025
36_set_comment_to_null.json		36_set_comment_to_null.json	Add OpRenameColumn for renaming columns (#602)	Jan 17, 2025
37_create_partial_index.json		37_create_partial_index.json	Improve create_index operation with extra index element settings (#697	Feb 28, 2025
38_create_hash_index_with_fillfactor.json		38_create_hash_index_with_fillfactor.json	Improve create_index operation with extra index element settings (#697	Feb 28, 2025
39_add_column_with_multiple_pk_in_table.json		39_add_column_with_multiple_pk_in_table.json	Support multiple PKs during backfilling (#426)	Oct 30, 2024
40_create_enum_type.json		40_create_enum_type.json	Add enum column examples (#444)	Oct 31, 2024
41_add_enum_column.json		41_add_enum_column.json	Add enum column examples (#444)	Oct 31, 2024
42_create_unique_index.json		42_create_unique_index.json	Improve create_index operation with extra index element settings (#697	Feb 28, 2025
43_create_tickets_table.json		43_create_tickets_table.json	Support dropping default for a column (#478)	Nov 21, 2024
44_add_table_unique_constraint.json		44_add_table_unique_constraint.json	New operation: create_constraint and support unique constraints wit…	Nov 13, 2024
45_add_table_check_constraint.json		45_add_table_check_constraint.json	Always surround up and down clauses in parentheses (#481)	Nov 22, 2024
46_alter_column_drop_default.json		46_alter_column_drop_default.json	Support dropping default for a column (#478)	Nov 21, 2024
47_add_table_foreign_key_constraint.json		47_add_table_foreign_key_constraint.json	Add support for creating foreign key constraints using `create_constr…	Nov 22, 2024
48_drop_tickets_check.json		48_drop_tickets_check.json	Add a drop_multicolumn_constraint operation (#487)	Nov 26, 2024
49_unset_not_null_on_indexed_column.json		49_unset_not_null_on_indexed_column.json	Add missing indexes to duplicated columns (#570)	Jan 8, 2025
50_create_table_with_table_constraint.json		50_create_table_with_table_constraint.json	Add support for foreign key constraints in create_table operation (#…	Jan 23, 2025
51_create_table_with_table_foreign_key_constraint.json		51_create_table_with_table_foreign_key_constraint.json	Add support for foreign key constraints in create_table operation (#…	Jan 23, 2025
52_create_table_with_exclusion_constraint.json		52_create_table_with_exclusion_constraint.json	Add support for exclusion constraints in create_table operation (#624)	Jan 28, 2025
53_add_column_with_volatile_default.json		53_add_column_with_volatile_default.json	Add columns with volatile DEFAULTs without an ACCESS_EXCLUSIVE ta…	Feb 23, 2025
54_create_index_with_opclass.json		54_create_index_with_opclass.json	Improve create_index operation with extra index element settings (#697	Feb 28, 2025
View all files