Commits Explorer - Database Schema

Tables

• Commits
• Commits_index
• News

Commits Table

Field	Type	Null	Key	Default	Extra
ID	int(11)	NO	PRI		auto_increment
DATE	datetime	NO
YEAR	int(11)	YES	MUL
YEARMONTH	int(11)	YES	MUL
YEARMONTHDAY	int(11)	YES	MUL
TOPPROJECT	varchar(16)	YES	MUL
PROJECT	varchar(32)	YES	MUL
FILENAME	text	YES
FILETYPE	varchar(16)	YES	MUL
REVISION	text	YES
CHANGE_SIZE	int(11)	YES	MUL
MESSAGE_SIZE	int(11)	YES	MUL
LOGIN	varchar(16)	YES	MUL
COMPANY	varchar(32)	YES	MUL

Commits_index Table

Field	Type	Null	Key	Default	Extra
PROJECT	varchar(32)	YES	MUL
LOGIN	varchar(16)	YES
PERIOD	int(1)	NO		0
COUNT	decimal(32,0)	YES

News Table

Field	Type	Null	Key	Default	Extra
MESSAGEID	varchar(64)	NO
DATE	datetime	NO		0000-00-00 00:00:00
YEAR	int(11)	YES
YEARMONTH	int(11)	YES
YEARMONTHDAY	int(11)	YES
TOPPROJECT	varchar(16)	YES
PROJECT	varchar(32)	YES
EMAIL	varchar(64)	YES
NEWSGROUP	varchar(32)	YES
REPLYTOID	varchar(64)	YES
REPLYDAYS	int(11)	YES