createdatabase.sql

Gibphone is CSharp Program, it can tell you how to design p2p chat.

Create Table Gibs(
	GibID int, 
	Alias char(255) not null, 
	GroupID int not null, 
	DefaultAccount int default 0,
	Status char(255) 
);
Create Table Groups(
	GroupID int,
	ParentGroup int default -1,
	Alias char(255) not null
);
Create Table Accounts(
	AccountID int, 
	GibID int not null, 
	Username char(255) not null, 
	ProtocolType char(255) not null,
	DefaultProtocol int default -1,
	Status char(255) default 'offline',
	LastActivity TimeStamp,
	Profile blob sub_type Text
);
Create Table ProtocolAccounts(
	AccountID int not null, 
	ProtocolID int not null
);
Create Table Protocols (
	ProtocolID int, 
	Username char(255) not null, 
	Pass char(255) default '',
	ProtocolType char(255) not null,
	Phone int default 0,
	Vocoder char(255) default '',
	Network char(255) default '', 
	AutoLoad int default 0, 
	OtherInformation blob,
	ProtocolString char(512) Computed by (Username || '