جدول الاعضاء
كود:
CREATE TABLE `user` (
`u_id` tinyint(2) unsigned zerofill NOT NULL auto_increment,
`user_name` varchar(10) binary NOT NULL default '',
`first_name` varchar(25) binary NOT NULL default '',
`last_name` varchar(15) binary NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`email` varchar(30) NOT NULL default '0',
`subjects` varchar(17) NOT NULL default '',
`class` tinyint(2) unsigned zerofill NOT NULL default '00',
`mobile` int(10) unsigned NOT NULL default '0',
`address` varchar(60) binary NOT NULL default 'غير معروف',
`admin` set('0','1','2') NOT NULL default '0',
`catch_mail` set('0','1','2','1+2') NOT NULL default '0',
`active` set('0','1') NOT NULL default '0',
PRIMARY KEY (`u_id`),
UNIQUE KEY `user_name` (`user_name`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;
جدول الرسائل
كود:
CREATE TABLE `message` (
`sender_id` tinyint(2) unsigned zerofill NOT NULL default
'00',
`receiver_id` tinyint(2) unsigned zerofill NOT NULL default
'00',
`send_date` timestamp(10) NOT NULL,
`read` set('0','1') NOT NULL default '0',
`topic` varchar(20) NOT NULL default '',
`the_message` varchar(255) binary NOT NULL default '',
`imp` set('0','1','2','3') NOT NULL default '0',
`is_junk` set('0','1') NOT NULL default '0',
`is_trash` set('0','1') NOT NULL default '0'
) TYPE=MyISAM;