modules/dba/README.txt

Overview:
--------
The dba module provides Drupal administrators with direct access to their
Drupal database tables from within the standard Drupal user interface.

WARNING:  If a user is granted (or manages to aquire) 'dba adminster database'
permissions, they are able to directly alter the database.  At minimum, they
are able to modify data, and possibly to drop tables.  Depending on how you
have defined your database permissions, the user may also be able to modify
other databases unrelated to your Drupal installation.  Use at your own risk!


Features:
--------
 - support for MySQL and PostgreSQL
 - ability to execute sql scripts and see the resulting output
 - overview listing all tables and total row counts for each
 - ability to backup one or more tables from database
 - ability to view table data
 - ability to view table description
 - ability to delete all data from one ore more tables
 - ability to edit a specific row (using simple form)
 - ability to delete a specific row
 - in MySQL, ability to check and repair one or more tables
 - two permissions: 'dba view database' and 'dba administer database'


Comments:
--------
The ability to edit or delete a specific row will only be available if the
given table has a primary key.  If the table does not have a primary key,
we can't safely modify a single row, so the options are not available.
Examples of tables that don't have a primary key include: accesslog, blocks,
filters and search_index.

Installation and configuration:
------------------------------
Installation is as simple as copying the module into your 'modules' directory,
then enabling the module at 'administer >> modules'.  If using a MySQL database,
you can optionally configure default values for the check and repair
functionality at 'adminsiter >> settings >> dba'.

If using a PEAR database (only PostgreSQL is supported at this time), you will
need to follow the additional directions found in README.pgsql prior to
enabling this module.


Credits:
-------
 - Written by Jeremy Andrews <jeremy@kerneltrap.org>
 - PostgreSQL support provided by AAM <aam@ugpl.de>
 - Co-maintained for a while by Derek Wright [http://drupal.org/user/46549]
1	Overview:
2	--------
3	The dba module provides Drupal administrators with direct access to their
4	Drupal database tables from within the standard Drupal user interface.
5
6	WARNING: If a user is granted (or manages to aquire) 'dba adminster database'
7	permissions, they are able to directly alter the database. At minimum, they
8	are able to modify data, and possibly to drop tables. Depending on how you
9	have defined your database permissions, the user may also be able to modify
10	other databases unrelated to your Drupal installation. Use at your own risk!
11
12
13	Features:
14	--------
15	- support for MySQL and PostgreSQL
16	- ability to execute sql scripts and see the resulting output
17	- overview listing all tables and total row counts for each
18	- ability to backup one or more tables from database
19	- ability to view table data
20	- ability to view table description
21	- ability to delete all data from one ore more tables
22	- ability to edit a specific row (using simple form)
23	- ability to delete a specific row
24	- in MySQL, ability to check and repair one or more tables
25	- two permissions: 'dba view database' and 'dba administer database'
26
27
28	Comments:
29	--------
30	The ability to edit or delete a specific row will only be available if the
31	given table has a primary key. If the table does not have a primary key,
32	we can't safely modify a single row, so the options are not available.
33	Examples of tables that don't have a primary key include: accesslog, blocks,
34	filters and search_index.
35
36	Installation and configuration:
37	------------------------------
38	Installation is as simple as copying the module into your 'modules' directory,
39	then enabling the module at 'administer >> modules'. If using a MySQL database,
40	you can optionally configure default values for the check and repair
41	functionality at 'adminsiter >> settings >> dba'.
42
43	If using a PEAR database (only PostgreSQL is supported at this time), you will
44	need to follow the additional directions found in README.pgsql prior to
45	enabling this module.
46
47
48	Credits:
49	-------
50	- Written by Jeremy Andrews <jeremy@kerneltrap.org>
51	- PostgreSQL support provided by AAM <aam@ugpl.de>
52	- Co-maintained for a while by Derek Wright [http://drupal.org/user/46549]