1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-04-20 08:47:46 +03:00

611 Commits

Author SHA1 Message Date
drh
78100cc928 Add a "pk" column to the table_info pragma which is true for each column
that is part of the primary key.  Add a "foreign_key_list" pragma that gives
information about all foreign keys for a table.  Both changes are experimental. (CVS 1081)

FossilOrigin-Name: 5232b0665b84a9339a85918570093a376a0ea91f
2003-08-23 22:40:53 +00:00
drh
ed717fe3b2 Enhance the "PRAGMA integrity_check" command to verify that all indices are
correctly constructed.  New calls to integrity_check are made in the test
suite. These changes are intended to prevent any future problems such
as seen in ticket #334. (CVS 1024)

FossilOrigin-Name: c9734c27074d2039a1896a8c6965c08d03711b13
2003-06-15 23:42:24 +00:00
drh
5e8e1981dc Change the "database_list" pragma to return a third column containing the
filename of the underlying database file.  Always use an in-memory TEMP
database with an in-memory main database. (CVS 1003)

FossilOrigin-Name: f39100f5759d0d8b9c71e18d38a148dee4643020
2003-06-04 15:48:33 +00:00
jplyon
931634915d Removed 3rd (file) column from PRAGMA database_list until tests are fixed. (CVS 974)
FossilOrigin-Name: 4183cf97676e64d19978941a7c4a3fe521fcb1fb
2003-05-13 08:01:33 +00:00
jplyon
5ca89c3d28 Changed PRAGMA database_list to show the filename. (CVS 968)
FossilOrigin-Name: 3da10d2d02e331f136fcf857dc4c435c67ee7196
2003-05-11 20:09:19 +00:00
jplyon
f60482044d Removed never-used pragma "result_set_details". (CVS 964)
FossilOrigin-Name: bf558e79524c04339f1174dc935e39d47cb33457
2003-05-10 03:03:34 +00:00
drh
45a304ee8c Get VACUUM working again - with test cases. Some other minor cleanups. (CVS 931)
FossilOrigin-Name: 5afb88008fed253e6d1fc0ed5172370b61d3727b
2003-04-25 02:43:08 +00:00
drh
e22a334b78 Update the authorizer API so that it reports the database that table and
indices belong to and so that it reports when actions are taken in response
to a trigger. (CVS 928)

FossilOrigin-Name: c675a5504138f34cae6def782b5d3add2c67d2bc
2003-04-22 20:30:37 +00:00
drh
13bff81537 Change some variable names and comments in the new in-memory database file
implementation.  Partial (non-working) implementation of the VACUUM command. (CVS 904)

FossilOrigin-Name: e76787f877c456abdc8bc88bfefc50eaeed68744
2003-04-15 01:19:47 +00:00
paul
b0208ccaa3 Support in-memory databases for temp tables (CVS 903)
FossilOrigin-Name: 96336bffde6c441af197a521ee9e56fdfd7efff8
2003-04-13 18:26:49 +00:00
drh
c11d4f9360 Split the implementation of COPY, PRAGMA, and ATTACH into separate
source code files. (CVS 902)

FossilOrigin-Name: 73359037ea639abb066c74db9c19e84bf1104006
2003-04-06 21:08:24 +00:00