Tables/modules
From Joomla! Documentation
Usage
Description
modules Table (#__modules)
| Field |
Type |
Nullable |
Default |
Key |
Extra |
Comments
|
| id |
int(11) |
NOT NULL |
|
PK |
AUTO_INCREMENT |
|
| title |
varchar(100) |
NOT NULL |
|
|
|
|
| note |
varchar(255) |
NOT NULL |
|
|
|
|
| content |
text |
NOT NULL |
|
|
|
|
| ordering |
int(11) |
NOT NULL |
0 |
|
|
|
| position |
varchar(50) |
|
NULL |
|
|
|
| checked_out |
int(10) unsigned |
NOT NULL |
0 |
|
|
|
| checked_out_time |
datetime |
NOT NULL |
'0000-00-00 00:00:00' |
|
|
|
| publish_up |
datetime |
NOT NULL |
'0000-00-00 00:00:00' |
|
|
|
| publish_down |
datetime |
NOT NULL |
'0000-00-00 00:00:00' |
|
|
|
| published |
tinyint(1) |
NOT NULL |
0 |
|
|
|
| module |
varchar(50) |
|
NULL |
|
|
|
| access |
tinyint(3) unsigned |
NOT NULL |
0 |
|
|
|
| showtitle |
tinyint(3) unsigned |
NOT NULL |
1 |
|
|
|
| params |
varchar(5120) |
NOT NULL |
|
|
|
|
| client_id |
tinyint(4) |
NOT NULL |
0 |
|
|
|
| language |
char(7) |
NOT NULL |
|
|
|
|
Notes
Indices
| Index Name |
Column(s) |
Unique?
|
| published |
published, access |
No
|
| newsfeeds |
module, published |
No
|
| idx_language |
language |
No
|
- Default character set: utf8