45 Commits

Author SHA1 Message Date
davidf84
770b2f20ac
Fixed issue with bigincrements not working with composite primary key in MySQL - #5341 (#5343)
Co-authored-by: David Farrugia <david.farrugia@sagossgroup.com>
2023-11-29 02:10:12 +02:00
Kyler Nelson
82f43d53ab
Support Object Names Greater than 30 Characters for Oracle DB Versions 12.2 and Greater (#5197)
Co-authored-by: Drew Royster <drew.124@gmail.com>
Co-authored-by: Kendra Bryant <kendraa@utahcounty.gov>
Co-authored-by: Matt Bailey <bailey.matthewr@gmail.com>
2023-10-17 02:31:38 +03:00
André Ricardo
440fe50a1e
Add uuid helper function (#5617) 2023-07-08 14:54:15 +02:00
Andy Wooldridge
2da5822fe4
fix: creating a unique index in postgres using the index method (#5601) 2023-07-04 12:59:17 +02:00
ian
8ea5690bac
Use implicit check on json fields for OracleDB (#5478) 2023-03-29 23:45:19 +02:00
abal
864530cd67
feat: support partial unique indexes (#5316) 2022-09-02 00:18:05 +03:00
Hasnae
97fccdff7d
Explicit jsonb support for custom pg clients (#5201)
Co-authored-by: Igor Savin <iselwin@gmail.com>
2022-08-31 22:16:17 +03:00
Lucas Bickel
8b0dd49700
feat: inline primary key creation for postgres flavours (#5233) 2022-06-30 16:09:25 +03:00
Lucas Bickel
0918bf9bde
fix(postgresql): add primaryKey option for uuid (#5212) 2022-06-08 11:41:43 +03:00
Pedro Ramos
e308184988
MSSQL: Fix .hasTable result when using .withSchema (#5176) 2022-05-22 15:56:53 +03:00
Dominic Vonk
a4df3e3540
Implement extendable builders (#5041)
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-05-17 13:07:26 +03:00
Dmitry Kudryavtsev
e2516cd058
Refresh materialized view concurrently for PostgreSQL (#5166) 2022-05-08 20:15:43 +02:00
Daniel Lockyer
affb883960
Fixed primary keys being created separately on MySQL (#5017) 2022-02-10 19:06:23 +02:00
TJ (Thomas J.) Biddle
c4a3abc42d
Do not use sys.tables to find if a table exists (#2328)
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-02-01 14:54:46 +01:00
Olivier Cavadenti
2e1016e662
Add alterType and update index.d.ts for alter function (#4967)
Co-authored-by: intech <ru31337@gmail.com>
2022-01-27 13:34:23 +01:00
Igor N. Dultsev
3ee6d0f022
Alter nullable constraint when alterNullable is set to true (#4730) 2022-01-24 20:22:04 +01:00
Marek Brenčič
3f0ec9f84e
Fix for createViewOrReplace and its support for sqlite3 (#4856)
Co-authored-by: Marek "foxie" Brenčič <marek@brencic.sk>
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-01-14 11:15:03 +02:00
Olivier Cavadenti
4494113187
Checks Constraints Support (#4874)
Co-authored-by: Ivan Zhuravlev <intech@users.noreply.github.com>
2022-01-06 14:44:16 +01:00
Olivier Cavadenti
b6775d9b00
Create multiple PKs with increments (#4903) 2022-01-03 20:55:24 +01:00
Ferris
bb7de096dc
Add CI support for Oracle 18c (resolves #4888) (#4889)
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2021-12-15 14:57:23 +02:00
Marat Levit
b612cdc0b1
Added support for MSSQL unique constraint (#4887) 2021-12-13 10:41:46 +01:00
Olivier Cavadenti
2763e47129
Add camel case to timestamps method (#4803) 2021-12-09 15:24:32 +01:00
Ben Lambert
2bd181171b
Support for better-sqlite3 Driver (#4871)
Signed-off-by: blam <ben@blam.sh>

Co-authored-by: Igor Savin <iselwin@gmail.com>
2021-12-09 16:19:37 +02:00
Olivier Cavadenti
d813edfc7b
Add binary uuid option (#4836) 2021-12-07 16:38:03 +01:00
Olivier Cavadenti
84bc2d9177
Set comment size warning limit to 1024 in MySQL (#4867) 2021-12-05 22:09:24 +01:00
Marius
44dbbca524
Make view columns optional in create view like (#4829) 2021-11-16 19:31:43 +01:00
Olivier Cavadenti
27ade6f881
Add columns in create table like #4821 2021-11-10 21:24:34 +01:00
Olivier Cavadenti
a431485aa6
Zero precision in timestamp/datetime #4784 (#4786) 2021-10-30 23:28:21 +02:00
Olivier Cavadenti
ace439d5c7
Implement partial index support (#4768) 2021-10-26 00:37:26 +03:00
Olivier Cavadenti
d463284349
Add storage engine index Type support to MySQL index() and unique() schema (#4756)
Co-authored-by: Elan Ruusamäe <glen@delfi.ee>
2021-10-21 01:20:56 +03:00
Olivier Cavadenti
60db2d25a2
View support (#1626) (#4748) 2021-10-20 23:23:29 +03:00
Olivier Cavadenti
7c52de9f23
Create table like support (#1373) (#4728) 2021-10-15 16:57:46 +03:00
Nicola Krumschmidt
00cbd00631
Clean up SQLite DDL handling and move all operations to the parser-based approach (#4648) 2021-08-25 17:30:44 +03:00
Igor Savin
124107e0ec
Fix autoincrement for Oracle with schema (#4594) 2021-07-29 17:07:22 +03:00
zeotuan
45916f97ee
Add deferrable support for constraint (#4584) 2021-07-25 10:23:17 +03:00
zeotuan
55eadcf7ad
Fixing posgres datetime and timestamp column created with wrong format (#4578) 2021-07-21 01:23:20 +03:00
Nicola Krumschmidt
3e6176ac0c
SQLite parser improvements (#4333) 2021-03-03 00:42:43 +02:00
Daniel Hensby
d807832b3b
mssql: schema builder - attempt to drop default constraints when changing default value on columns (#4321) 2021-02-28 19:27:48 +02:00
Daniel Hensby
c0d8c5c247
mssql: schema builder - add predictable constraint names for default values (#4319) 2021-02-28 01:08:15 +02:00
Nicola Krumschmidt
9e28a72aca
Add support for altering columns to SQLite (#4322) 2021-02-26 22:36:46 +02:00
Daniel Hensby
7db2d18877
fix mssql alter column must have its own query (#4317) 2021-02-25 19:34:22 +02:00
Nicola Krumschmidt
1ec7a664ea
Recreate indices when altering a table in SQLite (#4277) 2021-02-05 16:35:30 +02:00
George Petrov
57184acd63
Primary keys improvements (#4266) 2021-02-03 14:47:32 +02:00
Morgan Zolob
92907e80e2
Add check to only create native enum once (#3658)
Co-authored-by: Morgan Zolob <morgan.zolob@ingrooves.com>
2021-01-16 16:16:00 +02:00
Igor Savin
2aec21ed5e
Try to introduce some organization into how files are grouped (#4178) 2020-12-28 16:55:08 +02:00