Mobilefish.com - DBDesigner4 HTML Report

Database Model plugin_tmp.xml

access

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
aid	TINYINT(10)	PK	NN
mask	VARCHAR(255)		NN
type	VARCHAR(255)		NN
status	TINYINT(2)		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	aid

accesslog

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
aid	INTEGER(10)	PK	NN
sid	VARCHAR(32)		NN
title	VARCHAR(255)
path	VARCHAR(255)
url	VARCHAR(255)
hostname	VARCHAR(128)
uid	INTEGER(10)			UNSIGNED
timer	INTEGER(10)		NN	UNSIGNED
timestamp	INTEGER(11)		NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	aid
accesslog_timestamp	Index	timestamp

aggregator_category

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
cid	INTEGER(10)	PK	NN
title	VARCHAR(255)		NN
description	LONGTEXT		NN
block	TINYINT(2)		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	cid
title	Index	title

aggregator_category_feed

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
fid	INTEGER(10)	PK	NN
cid	INTEGER(10)	PK	NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	fid cid

aggregator_category_item

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
iid	INTEGER(10)	PK	NN
cid	INTEGER(10)	PK	NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	iid cid

aggregator_feed

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
fid	INTEGER(10)	PK	NN
title	VARCHAR(255)		NN
url	VARCHAR(255)		NN
refresh	INTEGER(10)		NN
checked	INTEGER(10)		NN
link	VARCHAR(255)		NN
description	LONGTEXT		NN
image	LONGTEXT		NN
etag	VARCHAR(255)		NN
modified	INTEGER(10)		NN
block	TINYINT(2)		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	fid
link	Index	url
title	Index	title

aggregator_item

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
iid	INTEGER(10)	PK	NN
fid	INTEGER(10)		NN
title	VARCHAR(255)		NN
link	VARCHAR(255)		NN
author	VARCHAR(255)		NN
description	LONGTEXT		NN
timestamp	INTEGER(11)

IndexName	IndexType	Columns
PRIMARY	PRIMARY	iid

authmap

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
aid	INTEGER(10)	PK	NN	UNSIGNED
uid	INTEGER(10)		NN
authname	VARCHAR(128)		NN
module	VARCHAR(128)		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	aid
authname	Index	authname

blocks

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
module	VARCHAR(64)		NN
delta	VARCHAR(32)		NN
theme	VARCHAR(255)		NN
status	TINYINT(2)		NN
weight	TINYINT(1)		NN
region	VARCHAR(64)		NN		left
custom	TINYINT(2)		NN
throttle	TINYINT(1)		NN
visibility	TINYINT(1)		NN
pages	TEXT		NN

book

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
vid	INTEGER(10)	PK	NN	UNSIGNED
nid	INTEGER(10)		NN	UNSIGNED
parent	INTEGER(10)		NN
weight	TINYINT(3)		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	vid
nid	Index	nid
parent	Index	parent

boxes

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
bid	TINYINT(4)	PK	NN
title	VARCHAR(64)		NN
body	LONGTEXT
info	VARCHAR(128)		NN
format	INTEGER(4)		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	bid
info	Index	info

cache

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
cid	VARCHAR(255)	PK	NN
data	LONGBLOB
expire	INTEGER(11)		NN
created	INTEGER(11)		NN
headers	TEXT

IndexName	IndexType	Columns
PRIMARY	PRIMARY	cid
expire	Index	expire

client

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
cid	INTEGER(10)	PK	NN	UNSIGNED
link	VARCHAR(255)		NN
name	VARCHAR(128)		NN
mail	VARCHAR(128)		NN
slogan	LONGTEXT		NN
mission	LONGTEXT		NN
users	INTEGER(10)		NN
nodes	INTEGER(10)		NN
version	VARCHAR(35)		NN
created	INTEGER(11)		NN
changed	INTEGER(11)		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	cid

client_system

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
cid	INTEGER(10)	PK	NN
name	VARCHAR(255)	PK	NN
type	VARCHAR(255)		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	cid name

comments

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
cid	INTEGER(10)	PK	NN
pid	INTEGER(10)		NN
nid	INTEGER(10)		NN
uid	INTEGER(10)		NN
subject	VARCHAR(64)		NN
comment	LONGTEXT		NN
hostname	VARCHAR(128)		NN
timestamp	INTEGER(11)		NN
score	MEDIUMINT(9)		NN
status	TINYINT(3)		NN	UNSIGNED
format	INTEGER(4)		NN
thread	VARCHAR(255)		NN
users	LONGTEXT
name	VARCHAR(60)
mail	VARCHAR(64)
homepage	VARCHAR(255)

IndexName	IndexType	Columns
PRIMARY	PRIMARY	cid
lid	Index	nid

contact

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
cid	INTEGER(10)	PK	NN	UNSIGNED
category	VARCHAR(255)		NN
recipients	LONGTEXT		NN
reply	LONGTEXT		NN
weight	TINYINT(3)		NN
selected	TINYINT(1)		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	cid
category	Index	category

file_revisions

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
fid	INTEGER(10)	PK	NN	UNSIGNED
vid	INTEGER(10)	PK	NN	UNSIGNED
description	VARCHAR(255)		NN
list	TINYINT(1)		NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	fid vid

files

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
fid	INTEGER(10)	PK	NN	UNSIGNED
nid	INTEGER(10)		NN	UNSIGNED
filename	VARCHAR(255)		NN
filepath	VARCHAR(255)		NN
filemime	VARCHAR(255)		NN
filesize	INTEGER(10)		NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	fid

filter_formats

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
format	INTEGER(4)	PK	NN
name	VARCHAR(255)		NN
roles	VARCHAR(255)		NN
cache	TINYINT(2)		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	format
name	Index	name

filters

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
format	INTEGER(4)		NN
module	VARCHAR(64)		NN
delta	TINYINT(2)		NN
weight	TINYINT(2)		NN

IndexName	IndexType	Columns
weight	Index	weight

flood

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
event	VARCHAR(64)		NN
hostname	VARCHAR(128)		NN
timestamp	INTEGER(11)		NN

forum

ColumnName

DataType

PrimaryKey