Lionel Laffineur
7c9722aa44
Added function DISTINCT to db supporting it
2023-07-18 16:50:14 +02:00
Jakub Vrana
60ad161178
PostgreSQL: Fix parsing of foreign keys with non-ASCII column names (thanks to Tomas Pecina)
2021-05-14 06:21:09 +02:00
Jakub Vrana
7f8c93a6f1
SQLite: Fix displayed types (bug #784 )
2021-02-15 18:33:19 +01:00
Jakub Vrana
50ed4f7ce7
Prepare for moving drivers to plugins
2021-02-08 19:35:22 +01:00
Jakub Vrana
cde988853d
SQLite: Set busy_timeout to 500
2021-02-06 18:01:39 +01:00
Jakub Vrana
3b056fe308
SQLite: Skip renaming when recreating table if not necessary
2019-08-21 12:06:32 +02:00
Jakub Vrana
d6ec4ca0b3
SQLite: Preserve auto increment when recreating table
2019-08-21 11:54:07 +02:00
Jakub Vrana
903de0e889
SQLite: Allow setting auto increment for empty tables
2019-08-21 11:46:38 +02:00
Jakub Vrana
48f33f6255
Remove extra space in alter table command
2019-08-21 11:28:33 +02:00
Jakub Vrana
1b33729110
SQLite: Handle error in altering table (bug #697 )
2019-08-21 11:21:17 +02:00
Jakub Vrana
5bebb439a1
MySQL: Descending indexes in MySQL 8 (bug #643 )
2018-10-27 20:05:04 +02:00
Jakub Vrana
60d1b7b3b4
Disallow using password-less databases
2018-05-04 16:52:41 +02:00
Jakub Vrana
67c2a91c67
Remove unused argument
2018-03-09 18:19:14 +01:00
Jakub Vrana
b4392b3f91
Use single \ in ' strings
2018-02-20 16:27:40 +01:00
Jakub Vrana
cddd61c214
Add more system tables help links
2018-02-08 11:21:33 +01:00
Jakub Vrana
718f9d3791
SQLite: Support ` in PRIMARY KEY
2018-02-07 16:43:21 +01:00
Jakub Vrana
66e7ec56bb
SQLite: Allow deleting PRIMARY KEY from tables with auto increment
2018-02-07 14:47:29 +01:00
Jakub Vrana
02cd416093
Delete unused functions
2018-02-06 16:33:47 +01:00
Jakub Vrana
89ceb06208
Use primary key instead of LIMIT 1 if available
2018-02-05 11:21:19 +01:00
Jakub Vrana
685bf29abc
Use separator in limit1
2018-02-01 18:53:53 +01:00
Jakub Vrana
0866c79afb
SQLite: Limit rows in data manipulation without unique key
2018-02-01 18:47:57 +01:00
Jakub Vrana
52d98e16fa
PostgreSQL: Limit rows in data manipulation without unique key
2018-02-01 16:58:01 +01:00
Jakub Vrana
f4625da53d
Use Oid as the name of the column
2018-02-01 16:15:36 +01:00
Jakub Vrana
dc94b2ec38
Save bytes
2018-02-01 16:00:40 +01:00
Jakub Vrana
993dce398d
PostgreSQL: Export DROP SEQUENCE if dropping table
2018-01-22 14:33:21 +01:00
Jakub Vrana
ce17b6cf46
Ignore removed CREATE+ALTER mode in trigger_sql()
2018-01-22 14:14:42 +01:00
Jakub Vrana
34b03ef835
SQLite: Enable foreign key checks
2018-01-19 14:57:58 +01:00
David Grudl
a6ebd4a3e0
uses PHP 5 constructors
2015-11-01 11:08:46 -08:00
Jakub Vrana
8dde91b2a1
SQLite: Use EXPLAIN QUERY PLAN in SQL query (bug #443 )
2015-03-06 10:02:45 -08:00
Jakub Vrana
2f881b2674
Load UPDATE OF triggers
2014-03-15 13:13:18 -07:00
Jakub Vrana
46bb56cab9
SQLite: Support UPDATE OF triggers
2014-03-15 11:02:14 -07:00
Jakub Vrana
3e2288eee5
SQLite: Display auto-created unique indexes
2014-02-04 09:50:31 -08:00
Jakub Vrana
d5a2afeef7
SQLite: Fix creating table and altering primary key (bug #373 )
2014-01-30 09:39:15 -08:00
Jakub Vrana
91bb94eda6
MongoDB: Prepare for alter index
2014-01-11 19:22:44 -08:00
Jakub Vrana
64af68a30b
Support triggers on views
2013-12-20 16:30:22 -08:00
Jakub Vrana
7d330a2d4b
SQLite: Allow working with INSTEAD OF triggers
2013-12-20 16:12:42 -08:00
Jakub Vrana
f4d2794c9c
SQLite: Search trigger name only among triggers
2013-12-20 16:12:26 -08:00
Jakub Vrana
3d0605a8e7
Handle exception when creating SQLite database
2013-12-20 15:37:39 -08:00
Jakub Vrana
3736f2229f
SQLite: Read information about collation
2013-08-28 08:54:23 -07:00
Jakub Vrana
c1b9a9a46c
SQLite: Don't mark multi-column primary key as auto_increment
2013-08-28 08:40:09 -07:00
Jakub Vrana
8a1b8910c1
SQLite: Allow editing foreign keys
2013-08-09 15:16:15 -07:00
Jakub Vrana
145a8c62ff
SQLite: Fix primary key handling
2013-08-08 19:20:27 -07:00
Jakub Vrana
f6e24b1646
SQLite: Detect auto_increment primary key
2013-08-08 19:09:43 -07:00
Jakub Vrana
bc725959e6
SQLite: Fix changing primary key
2013-08-08 19:07:18 -07:00
Jakub Vrana
6664b0fb7e
SQLite: Allow editing primary key
2013-08-08 15:32:36 -07:00
Jakub Vrana
646fb067ca
MongoDB: database list, table list, indexes, basic select
2013-08-08 13:54:06 -07:00
Jakub Vrana
114aaec91e
SQLite: Respect column order and DESC in primary key
...
Also respect DESC indexes in altering table.
2013-08-08 13:52:23 -07:00
Jakub Vrana
33236f7a83
SQLite: Don't treat multi-column primary key as auto_increment
2013-08-08 13:52:23 -07:00
Jakub Vrana
3cf3560a20
SQLite: Show primary key when altering indexes
2013-08-05 18:35:20 -07:00
Jakub Vrana
e8c6ef04d2
Replace ereg*() by preg_*()
...
ereg() triggers deprecated error which is sent to custom error handlers.
It is also faster.
There are no more deprecated functions except mysql_connect().
2013-07-24 16:26:41 -07:00
