Codice PHP:
CREATE TABLE groups(
`group_id` tinyint unsigned NOT NULL auto_increment,
`group_name` varchar(50) NOT NULL default '',
`group_desc` text default NULL,
-- --------------------------------------------------------
`image` varchar(255) default NULL,
`color` char(7) default '#000000',
`flood` int unsigned NOT NULL default '15',
-- --------------------------------------------------------
`can_post` tinyint unsigned NOT NULL default '1',
`can_read` tinyint unsigned NOT NULL default '1',
`can_replay` tinyint unsigned NOT NULL default '1',
`can_editpost` tinyint unsigned NOT NULL default '1',
`can_search` tinyint unsigned NOT NULL default '1',
`can_sendemail` tinyint unsigned NOT NULL default '1',
`can_viewprofiles` tinyint unsigned NOT NULL default '1',
`can_uploads` tinyint unsigned NOT NULL default '1',
-- --------------------------------------------------------
`close_topic` tinyint unsigned NOT NULL default '0',
`delete_topic` tinyint unsigned NOT NULL default '0',
`edit_topic` tinyint unsigned NOT NULL default '0',
`move_topic` tinyint unsigned NOT NULL default '0',
`pin_topic` tinyint unsigned NOT NULL default '0',
`delete_post` tinyint unsigned NOT NULL default '0',
`edit_post` tinyint unsigned NOT NULL default '0',
-- --------------------------------------------------------
`admin_cat` tinyint unsigned NOT NULL default '0',
`admin_forums` tinyint unsigned NOT NULL default '0',
`edit_users` tinyint unsigned NOT NULL default '0',
`admin_groups` tinyint unsigned NOT NULL default '0',
`admin_ranks` tinyint unsigned NOT NULL default '0',
`admin_options` tinyint unsigned NOT NULL default '0',
`admin_censoring` tinyint unsigned NOT NULL default '0',
`admin_bans` tinyint unsigned NOT NULL default '0',
`prune_forums` tinyint unsigned NOT NULL default '0',
PRIMARY KEY(`group_id`)
)TYPE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `mp`(
`mid` int unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`text` text,
`read` tinyint unsigned NOT NULL default '0',
`sender` varchar(25) NOT NULL default '',
`sender_id` smallint unsigned NOT NULL default '',
`receiver` varchar(25) NOT NULL default '',
`receiver_id` smallint unsigned NOT NULL default '0',
PRIMARY KEY(`mid`)
)TYPE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `online` (
`user_id` varchar(25) NOT NULL,
`time` mediumint NOT NULL default '0',
PRIMARY KEY(`user_id`)
)TYPE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `users`(
`user_id` smallint unsigned NOT NULL auto_increment,
`user_nick` varchar(25) NOT NULL default '',
`user_password` char(32) NOT NULL default '',
`user_email` varchar(40) NOT NULL default '',
-- --------------------------------------------------------
`activation` varchar(32) default NULL,
`reactivation` varchar(64) default NULL,
-- --------------------------------------------------------
`lastaction` varchar(50) default NULL,
`lastaccess` varchar(50) default NULL,
`registration` varchar(50) default NULL,
-- --------------------------------------------------------
`groups` tinyint unsigned NOT NULL default '0',
`posts` mediumint unsigned NOT NULL default '0',
-- --------------------------------------------------------
`language` varchar(20) default NULL,
`skins` varchar(20) default NULL,
-- --------------------------------------------------------
`timezone` tinyint unsigned NOT NULL default '1',
`visible_email` tinyint unsigned NOT NULL default '0',
-- --------------------------------------------------------
`name` varchar(50) default NULL,
`msn` varchar(30) default NULL,
`yahoo` varchar(30) default NULL,
`location` varchar(30) default NULL,
`birthdate` varchar(20) default NULL,
`website` varchar(100) default NULL,
`avatar` varchar(100) default NULL,
`signature` text default NULL,
-- --------------------------------------------------------
`show_emoticons` tinyint unsigned NOT NULL default '1',
`show_signature` tinyint unsigned NOT NULL default '1',
`show_avatar` tinyint unsigned NOT NULL default '1',
`show_img` tinyint unsigned NOT NULL default '1',
-- --------------------------------------------------------
`perm_pm` tinyint unsigned NOT NULL default '1',
`perm_email` tinyint unsigned NOT NULL default '0',
`disp_topics` tinyint unsigned NOT NULL default '30',
`disp_posts` tinyint unsigned NOT NULL default '20',
`notify_post` tinyint unsigned NOT NULL default '0',
PRIMARY KEY(`user_id`)
)TYPE=MyISAM DEFAULT CHARSET=utf8;
Rispondi quotando