Tricho

Directory layout

admin

This is the admin interface. The all-important tables.xml file lives here too.

admin/advice

You can put your own files in here, which contain short explanations of what your tables are about, or how to use them. This advice is then displayed at the top of the admin interface.

admin/css

Self-explanatory; the CSS for the admin area is in here.

admin/images

Self-explanatory; the images used in the admin area are in here.

admin/setup

This is the setup interface, which lets you modify the database structure and its metadata, which is stored in admin/tables.xml.

admin/setup/help

Files that provide the online help for the setup area.

admin/temp

Stores temporary files, such as files which are generated and then downloaded.

css

CSS files for the front-end.

tricho

Some core functions and classes.

tricho/ajax

An AJAX queue and various handler methods. This will probably be at least partially replaced by jQuery or some other JavaScript library fairly soon.

tricho/config

Your configuration files go here.

tricho/config/examples

Self-explanatory; these are example config files.

tricho/data

This is where the XML files for front-end forms etc. go

tricho/db

The classes for various database backends go here, as well as a very rudimentary SQL parser which is used in a few places.

tricho/db_interface

These files drive the administrative interface.

tricho/ext

Your extensions, including your custom Column classes go here.

tricho/images

Some more images. These are also used in the admin area.

tricho/install

Files used by the install script (tricho/install.php)

tricho/meta_xml

The meta-data stored in the tables.xml file. In particular, the Database, Table, and various Column classes.

tricho/old_tests

The 'old' should indicate that these are pretty useless. Any new tests should be written to work with PHPUnit.

tricho/query

Classes used to represent SQL queries and their components, which can then be used to modify the content of a query.