List of tables: +--------------------+ | Tables_in_matslets | +--------------------+ | accounts | | announcements | | autopayinstances | | autopaymenttypes | | currencies | | mapslets | | members | | peopleskills | | system_messages | | transactions | | transactiontypes | | transports | +--------------------+ Table name: accounts +-------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+----------------+ | id | int(5) | NO | PRI | NULL | auto_increment | | accountname | varchar(25) | NO | | | | | createdtime | int(11) | NO | | 0 | | +-------------+-------------+------+-----+---------+----------------+ Table name: announcements +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | id | int(5) | NO | PRI | NULL | auto_increment | | subject | text | NO | | | | | content | varchar(250) | NO | | | | | postedbyid | int(5) | NO | | 0 | | | public | int(1) | NO | | 0 | | | mailshot | int(1) | NO | | 0 | | | skilltypeid | int(2) | NO | | | | | timestamp | int(11) | NO | | 0 | | | expiry | int(10) | NO | | 0 | | +-------------+--------------+------+-----+---------+----------------+ Table name: autopayinstances +------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+---------+------+-----+---------+-------+ | instanceid | int(11) | NO | PRI | | | | payerid | int(11) | NO | | | | | paymentid | int(11) | NO | | | | +------------+---------+------+-----+---------+-------+ Table name: autopaymenttypes +----------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+-------------+------+-----+---------+----------------+ | id | int(5) | NO | PRI | NULL | auto_increment | | name | varchar(30) | NO | | | | | explanation | text | NO | | | | | quantity | int(5) | NO | | | | | ispercent | int(1) | NO | | | | | currencyid | int(3) | NO | | | | | frequency | varchar(10) | NO | | | | | roundedup | int(1) | NO | | | | | minimum | int(5) | NO | | | | | maximum | int(5) | NO | | | | | destinationaccountid | int(11) | NO | | | | | directly | int(1) | NO | | | | | universal | int(1) | NO | | | | | active | int(1) | NO | | | | +----------------------+-------------+------+-----+---------+----------------+ Table name: currencies +-------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------------+------+-----+---------+----------------+ | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(15) | NO | UNI | | | | color | varchar(6) | NO | | | | | convertible | int(11) | NO | | 0 | | | tradable | int(1) | NO | | 1 | | | value | float | NO | | 0 | | | min | varchar(3) | YES | | NULL | | | max | varchar(3) | YES | | NULL | | +-------------+---------------------+------+-----+---------+----------------+ Table name: mapslets +----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------+------+-----+---------+-------+ | postcode | varchar(8) | NO | PRI | | | | lat | float | NO | | | | | lon | float | NO | | | | +----------+------------+------+-----+---------+-------+ Table name: members +-------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------+-------+ | id | int(11) | NO | PRI | | | | fullname | varchar(128) | YES | | NULL | | | trading_name | varchar(128) | YES | | NULL | | | password | varchar(32) | NO | | | | | address1 | varchar(30) | NO | | | | | address2 | varchar(30) | NO | | | | | address3 | text | NO | | | | | address4 | varchar(30) | YES | | NULL | | | postcode | varchar(8) | NO | | | | | latitude | float | YES | | NULL | | | longitude | float | YES | | NULL | | | email | varchar(128) | YES | | NULL | | | contact_method1 | varchar(128) | YES | | NULL | | | contact1 | varchar(30) | NO | | | | | contact_method2 | varchar(128) | YES | | NULL | | | contact2 | varchar(30) | NO | | | | | homeurl | varchar(100) | NO | | | | | reference | varchar(128) | YES | | NULL | | | aboutme | text | NO | | | | | dob_year | int(11) | YES | | NULL | | | gender | varchar(128) | YES | | NULL | | | smoking | varchar(128) | YES | | NULL | | | diet | varchar(128) | YES | | NULL | | | employment_status | varchar(128) | YES | | NULL | | | transportid | varchar(128) | YES | | NULL | | | special_needs | varchar(128) | YES | | NULL | | | computer_skills | varchar(128) | YES | | NULL | | | origin | varchar(128) | YES | | NULL | | | ethnicity | varchar(128) | YES | | NULL | | | language | varchar(128) | YES | | NULL | | | other_info | varchar(128) | YES | | NULL | | | availability | varchar(128) | YES | | NULL | | | privilege | varchar(128) | YES | | NULL | | | active | int(1) | NO | | 1 | | | responsibility | text | YES | | NULL | | | lastlogin | int(10) | NO | | 0 | | +-------------------+--------------+------+-----+---------+-------+ Table name: peopleskills +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | id | int(5) | NO | PRI | NULL | auto_increment | | personid | int(5) | NO | | 0 | | | description | varchar(150) | NO | | | | | skilltypeid | int(2) | NO | | 0 | | +-------------+--------------+------+-----+---------+----------------+ Table name: system_messages +---------------+---------------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+-------------------+----------------+ | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | poster_id | int(11) | NO | | | | | receiver_id | int(11) | NO | | | | | msg | varchar(200) | YES | | NULL | | | creation_time | timestamp | NO | | CURRENT_TIMESTAMP | | +---------------+---------------------+------+-----+-------------------+----------------+ Table name: transactions +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | id | int(7) | NO | PRI | NULL | auto_increment | | transtypeid | int(1) | NO | | | | | fromid | int(5) | NO | | 0 | | | toid | int(5) | NO | | 0 | | | quant | float | NO | | 0 | | | currencyid | int(2) | NO | | 1 | | | comment | varchar(250) | NO | | | | | skilltypeid | int(2) | NO | | 0 | | | visible | int(1) | NO | | 0 | | | time | int(11) | NO | | | | | completed | int(1) | NO | | 0 | | | dependson | int(7) | NO | | | | +-------------+--------------+------+-----+---------+----------------+ Table name: transactiontypes +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | id | int(11) | NO | PRI | | | | noun | varchar(12) | NO | | | | | verb | varchar(12) | NO | | | | | participle | varchar(12) | NO | | | | | push | int(11) | NO | | | | | confirm | int(11) | NO | | | | | public | int(11) | NO | | | | +------------+-------------+------+-----+---------+-------+ Table name: transports +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | id | int(11) | NO | PRI | | | | means | text | NO | | | | +-------+---------+------+-----+---------+-------+