de database tabellen

#
# Table structure for table `pm`
#

CREATE TABLE `pm` (
`id` int(11) NOT NULL auto_increment,
`from` varchar(255) NOT NULL default '',
`ipsender` varchar(15) NOT NULL default '',
`to` varchar(255) NOT NULL default '',
`date` varchar(10) NOT NULL default '',
`time` varchar(8) NOT NULL default '',
`sub` varchar(255) NOT NULL default '',
`mes` longtext NOT NULL,
`read` char(2) NOT NULL default '0',
`alerted` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `pmoptions`
#

CREATE TABLE `pmoptions` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(255) NOT NULL default '',
`alert` int(1) NOT NULL default '1',
`buddys` longtext NOT NULL,
`blocked` longtext NOT NULL,
`dwd` varchar(6) NOT NULL default 'trash',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

« Lees de omschrijving en reacties