app
| Field | Description | Type | Null | Key | Default |
|---|---|---|---|---|---|
| id | generated index | int(11) | NO | PRI | NULL |
| app_id | hash identifying this app | char(191) | NO | MUL | |
| app_sig | currently unused | char(191) | NO | ||
| app_author | xchan_hash of app creator | char(191) | NO | ||
| app_name | name of app | char(191) | NO | MUL | |
| app_desc | optional description of app | text | NO | ||
| app_url | target_url | char(191) | NO | MUL | |
| app_photo | app icon | char(191) | NO | MUL | |
| app_version | version of app | char(191) | 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(191) | NO | ||
| app_price | free-form price field | char(191) | NO | MUL | |
| app_page | currently unused | char(191) | NO | ||
| app_requires | access rules | char(191) | NO | ||
| app_deleted | 1 = deleted, 0 = normal | int(11) | NO | MUL | 0 |
| app_system | 1 = imported system app, 0 = member created app | int(11) | NO | MUL | 0 |
| app_plugin | char(191) | NO | |||
| app_options | int(11) | NO | 0 | ||
| app_created | datetime of app creation | datetime | NO | MUL | 0001-01-01 00:00:00 |
| app_edited | datetime of last app edit | datetime | NO | MUL | 0001-01-01 00:00:00 |
Storage for personal apps