Database structure
From MemHT Wiki
Contents |
Database Tables Reference
The following is a complete list of all MemHT database tables and their respective fields. Primary key fields are underlined.
memht_admin_notes
| Field | Type | Default | Description |
|---|---|---|---|
| id | int(10) | The auto-incrementing (identity) primary key identifier for this table. | |
| cat | int(10) | 0 | |
| nome | varchar(255) | ||
| testo | text | ||
| autore | varchar(30) | ||
| data | datetime | 0000-00-00 00:00:00 |
memht_admin_notes_cat
| Field | Type | Default | Description |
|---|---|---|---|
| id | int(10) | The auto-incrementing (identity) primary key identifier for this table. | |
| nome | varchar(255) |
memht_aggregator
| Field | Type | Default | Description |
|---|---|---|---|
| id | int(1) | The auto-incrementing (identity) primary key identifier for this table. | |
| whr | int(1) | ||
| argument | int(10) | ||
| author | varchar(255) | ||
| rssurl | varchar(255) | ||
| numfeeds | int(2) | ||
| enabled | int(1) |
memht_amministratori
| Field | Type | Default | Description |
|---|---|---|---|
| id | int(10) | The auto-incrementing (identity) primary key identifier for this table. | |
| user | varchar(30) | ||
| pass | varchar(32) | ||
| lastip | varchar(15) | ||
| lastlogin | datetime | 0000-00-00 00:00:00 | |
| superadmin | int(1) | ||
| enabled | int(1) |
memht_amministratori_privs
| Field | Type | Default | Description |
|---|---|---|---|
| admin | int(1) | 0 | |
| superadmin | int(1) | 0 | |
| administrators | int(1) | 0 | |
| aggregator | int(1) | 0 | |
| arguments | int(1) | 0 | |
| articles | int(1) | 0 | |
| banners | int(1) | 0 | |
| blocks | int(1) | 0 | |
| blog | int(1) | 0 | |
| configuration | int(1) | 0 | |
| comments | int(1) | 0 | |
| database_p | int(1) | 0 | |
| download | int(1) | 0 | |
| faq | int(1) | 0 | |
| forum | int(1) | 0 | |
| gallery | int(1) | 0 | |
| groups | int(1) | 0 | |
| guide | int(1) | 0 | |
| imageup | int(1) | 0 | |
| messagebox | int(1) | 0 | |
| messages | int(1) | 0 | |
| mylinks | int(1) | 0 | |
| mypage | int(1) | 0 | |
| news | int(1) | 0 | |
| newsletter | int(1) | 0 | |
| notes | int(1) | 0 | |
| pages | int(1) | 0 | |
| partners | int(1) | 0 | |
| security | int(1) | 0 | |
| statistics | int(1) | 0 | |
| surveys | int(1) | 0 | |
| users | int(1) | 0 |
 |
Languages | العربية • Bahasa Indonesia • Bosanski • Български • Dansk • Deutsch • English • Español • فارسی • Français • Galego • עברית • Italiano • Magyar • Македонски • Nederlands • Português • Русский • Српски/Srpski • Svenska • Türkçe • Українська • Tiếng Việt |
