database.sql

邮箱加即时聊天

CREATE TABLE `user_base_information` (
  `user_id` int(10) unsigned NOT NULL auto_increment,
  `user_name` varchar(16) NOT NULL default '',
  `password` varchar(16) NOT NULL default '',
  `nickname` varchar(32) NOT NULL default '',
  `question` varchar(32) NOT NULL default '',
  `answer` varchar(32) NOT NULL default '',
  `sex` char(1) NOT NULL default 'M',
  `information_storage` tinyint(11) NOT NULL default '20',
  `net_storage` int(32) default '10485760',
  `born_date` date NOT NULL default '0000-00-00',
  `grade` int(11) NOT NULL default '0',
  `near_login_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `online_statement` char(1) NOT NULL default 'N',
  `replay_state` char(1) NOT NULL default 'N',
  `reg_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_name` (`user_name`)
) 



CREATE TABLE `user_extend_information` (
  `user_id` int(10) NOT NULL,
  `email` varchar(50) default NULL,
  `QQ` varchar(13) default NULL,
  `introducer` varchar(16) default NULL,
  `id_card` varchar(18) default NULL,
  `firstname` varchar(30) default NULL,
  PRIMARY KEY  (`user_id`)
) 


CREATE TABLE `contact_man` (
  `local_id` int(10) NOT NULL,
  `contact_id` int(10) NOT NULL,
  `relation` varchar(30) character set gb2312 default NULL
)


CREATE TABLE `message` (
  `message_id` int(10) NOT NULL auto_increment,
  `sender_id` int(10) NOT NULL,
  `receiver_id` int(10) NOT NULL,
  `content_path` varchar(150) NOT NULL,
  `annex_path` varchar(50) NOT NULL,
  `send_time` int(11) default NULL,
  `sender_delete_statement` tinyint(4) NOT NULL default '2',
  `receiver_delete_statement` tinyint(4) NOT NULL default '2',
  `message_flag` smallint(6) default '1',
  `size` int(10) NOT NULL,
  `subject` varchar(30) NOT NULL,
  PRIMARY KEY  (`message_id`)
) 



CREATE TABLE `online` (
  `user` varchar(16) NOT NULL,
  `last_access` int(11) default NULL
)

CREATE TABLE `short_message` (
  `content` varchar(50) default NULL,
  `sender` varchar(16) default NULL,
  `receiver` varchar(16) default NULL,
  `isRead` tinyint(1) default NULL
)