Database Table Reference for CAT 1.3.4pr3
Go to Development Reference
Primary key fields are bold.
tbl.Users
Field |
Type |
Default |
Description |
| id |
int(3) |
|
The auto-incrementing (identity) primary key identifier for this table. |
| username |
varchar(25) |
|
The username. |
| password |
varchar(255) |
|
The password. |
| admin |
int(1) |
0 |
0 = normal user 1 = Head admin |
tbl.Script
Field |
Type |
Default |
Description |
| version |
varchar(10) |
|
Contains the version that is installed. Primary key. |
| installdate |
varchar(15) |
|
The date when the CMS was installed. |
tbl.motd
Field |
Type |
Default |
Description |
| id |
int(3) |
|
The auto-incrementing (identity) primary key identifier for this table. |
| dates |
varchar(50) |
|
Contains the date when the MOTD was last changed. |
| username |
varchar(25) |
|
Contains the user that posted the MOTD. |
| motd |
text |
|
Contains the MOTD text. |
tbl.members
Field |
Type |
Default |
Description |
| id |
int(3) |
|
The auto-incrementing (identity) primary key identifier for this table. |
| name |
varchar(50) |
|
Contains the members real name. |
| nickname |
varchar(25) |
|
Contains the members nickname. |
| picture |
varchar(255) |
|
Contains the url to the picture of the member. |
| age |
char(2) |
|
Contains the members age. Can't be longer then 2chars |
| position |
varchar(45) |
|
Contains the members position in the clan. |
| work |
varchar(255) |
|
Contains the members IRL work. |
| resolution |
varchar(15) |
|
Contains the members screen resolution. |
| sex |
varchar(5) |
|
Contains the members gender. |
| quote |
varchar(25) |
|
Contains a quote from the member. |
| location |
varchar(255) |
|
Contains the members geographical location.. |
| cpu |
varchar(15) |
|
Contains the members CPU info. |
| mouse |
varchar(55) |
|
Contains the members mouse info. |
| gfx |
varchar(255) |
|
Contains the members graphic card info. |
| mousepad |
varchar(15) |
|
Contains the members mousepad info. |
| memory |
varchar(15) |
|
Contains the members memory info in MB. |
| os |
varchar(15) |
|
Contains the members OS info. |
| hdd |
varchar(15) |
|
Contains the members hdd info. |
| screen |
varchar(15) |
|
Contains the members screen info. |
| mail |
varchar(255) |
|
Contains the members mail adress. |
tbl.game
Field |
Type |
Default |
Description |
| id |
int(3) |
|
The auto-incrementing (identity) primary key identifier for this table. |
| dates |
varchar(50) |
|
Contains the date when the report was added. |
| team1 |
varchar(25) |
|
Contains the name of team1. |
| team2 |
varchar(25) |
|
Contains the name of team2. |
| point1 |
varchar(15) |
|
Contains the points of team1. |
| point2 |
varchar(15) |
|
Contains the points of team2. |
| type |
varchar(25) |
|
Contains the type of game played. |
| map |
varchar(25) |
|
Contains the map(s) played. |
| lineup |
varchar(255) |
|
Contains the lineup who played the game. |
| report |
text |
|
Contains the game report. |
tbl.comments
Field |
Type |
Default |
Description |
| id |
int(3) |
|
The auto-incrementing (identity) primary key identifier for this table. |
| pid |
int(4) |
0 |
Contains the id to the commented newspost. |
| names |
varchar(100) |
|
Contains the name of the person that commented. |
| email |
varchar(255) |
|
Contains the mail of the person that commented. |
| comment |
text |
|
Contains the comment. |
| date |
varchar(20) |
|
Contains the date. |
| ip |
varchar(15) |
|
Contains the IP. |
tbl.reported
Field |
Type |
Default |
Description |
| id |
int(3) |
|
The auto-incrementing (identity) primary key identifier for this table. |
| rid |
int(3) |
0 |
Contains the id to the reported comment. |
| names |
varchar(100) |
|
Contains the name of the person that commented. |
| email |
varchar(255) |
|
Contains the mail of the person that commented. |
| comment |
text |
|
Contains the reported comment. |
| date |
varchar(20) |
|
Contains the date. |
| ip |
varchar(15) |
|
Contains the IP of the person who made the reported comment. |
tbl.news
Field |
Type |
Default |
Description |
| id |
int(3) |
|
The auto-incrementing (identity) primary key identifier for this table. |
| dates |
varchar(50) |
|
Contains the date when the newspost was created. |
| nickname |
varchar(25) |
|
Contains the name of the person that made the newspost. |
| topic |
varchar(50) |
|
Contains the newspost topic. |
| newspost |
text |
|
Contains the newspost. |
| newstype |
varchar(15) |
|
Contains the type of newspost. |
tbl.spons
Field |
Type |
Default |
Description |
| id |
int(3) |
|
The auto-incrementing (identity) primary key identifier for this table. |
| spons_cat |
int(3) |
|
Contains the sponsor category ID. |
| spons_name |
varchar(252) |
|
Contains the name of the sponsor. |
| spons_info |
text |
|
Contains the info about the sponsor. |
tbl.spons_cat
Field |
Type |
Default |
Description |
| spons_cat |
int(3) |
|
The auto-incrementing (identity) primary key identifier for this table. |
| spons_type |
varchar(255) |
|
Contains the sponsor category. |
written 2005-04-21
