Author:
antonivanov
Description: Таблица сообщения
Language: SQL
CREATE TABLE `techsup_messages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`to` int(10) unsigned NOT NULL,
`from` int(10) unsigned NOT NULL,
`is_read` enum('0','1') NOT NULL DEFAULT '0',
`name` varchar(30) DEFAULT NULL,
`email` varchar(30) DEFAULT NULL,
`message` varchar(300) DEFAULT NULL,
`send_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`read_date` timestamp NULL DEFAULT NULL,
`notify_sender` enum('on','off') DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=183 DEFAULT CHARSET=utf8;
|
Recent pastes:
biophreak (Plain Text)
Raik (PHP)
MUSbKA (Plain Text)
MUSbKA (Plain Text)
nekitozzz (C++)
nekitozzz (Plain Text)
nekitozzz (C++)
ksurent (Perl)
MUSbKA (C++)
stalin_alex (C++)
dzantiev (Plain Text)
unreal (C++)
eug2b (Plain Text)
|