new commands documented on project page

[Jak Sprats]

Hi All,

the new commands have been (poorly) documented here:
http://code.google.com/p/alchemydatabase/wiki/CommandReference

Summary: (and yes I suck at documentation)
* CREATE INDEX cust_grp_age_ind ON customer (group_id, age); - Compund
Indexes
* ALTER TABLE customer ADD COLUMN state INT - "Alter Table" is
instantaneous, does not physically change rows
* REPLACE INTO customer VALUES (1,300,’John Doe’,’703-387-7777’,30)
* INSERT INTO customer VALUES (1,300,’John Doe’,’703-387-7777’,30) ON
DUPLICATE KEY UPDATE SET phone = ’703-387-7777’
* INSERT INTO customer VALUES (1,300,’John Doe’,’301-933-1891’,30)
(2,300,’Jane Smith’,’301-946-2222’,22) (1,300,’John Doe’,’202-933-444’,
55) - Bulk Insert
* INSERT INTO customer (id, name, phone) VALUES (1,’John
Doe’,’301-933-1891’); - Partial Insert, Alchemy rows are streams, so
only the data in the row will be stored, no bytes for NULL
placeholders
* EXPLAIN SELECT customer.name, group.slogan FROM customer, group
WHERE customer.group_id = group.id AND group.id BETWEEN 300 AND = 400
* LUA getuserdata 'session_777' 'user_123' 'last_login'
* CREATE LUATRIGGER lt_cap ON tbl add_cap(fk1)
* CREATE LRUINDEX ON tbl

lots of cleanup in the works, just an FYI post (all new functionality
only available via github repo until release)

- Jak