Contents
| Field | Description | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|---|
| id | generated index | int(11) | NO | PRI | NULL | auto_increment |
| app_id | hash identifying this app | char(255) | NO | MUL | ||
| app_sig | currently unused | char(255) | NO | |||
| app_author | xchan_hash of app creator | char(255) | NO | |||
| app_name | name of app | char(255) | NO | MUL | ||
| app_desc | optional description of app | text | NO | NULL | ||
| app_url | target_url | char(255) | NO | MUL | ||
| app_photo | app icon | char(255) | NO | MUL | ||
| app_version | version of app | char(255) | NO | MUL | ||
| app_channel | channel_id owning this instance of the app | int(11) | NO | MUL | 0 | |
| app_addr | reddress/webbie of app creator | char(255) | NO | |||
| app_price | free-form price field | char(255) | NO | MUL | ||
| app_page | currently unused | char(255) | NO | |||
| app_requires | access rules | char(255) | NO | |||
| app_created | datetime of app creation | datetime | NO | |||
| app_edited | datetime of last app edit | datetime | NO | |||
| app_deleted | 1 = deleted, 0 = normal | int(11) | NO | |||
| app_system | 1 = imported system app, 0 = member created app | int(11) | NO |
Storage for personal apps
Return to database documentation