--
-- Structure de la table `myMedia`
--
DROP TABLE IF EXISTS `xs2511_mymedia`;
CREATE TABLE IF NOT EXISTS `xs2511_mymedia` (
`id` int NOT NULL AUTO_INCREMENT,
`pid` int UNSIGNED DEFAULT '0',
`uid` int UNSIGNED DEFAULT '1',
`datesub` int UNSIGNED NOT NULL DEFAULT '1033141070',
`subject` varchar(255) DEFAULT NULL,
`informations` text,
`nohtml` tinyint UNSIGNED DEFAULT '0',
`nosmiley` tinyint UNSIGNED DEFAULT '0',
`noxcode` tinyint UNSIGNED DEFAULT '0',
`notitle` tinyint UNSIGNED DEFAULT '0',
`nologo` tinyint UNSIGNED DEFAULT '0',
`nomain` tinyint UNSIGNED DEFAULT '0',
`noblock` tinyint UNSIGNED DEFAULT '0',
`counter` int UNSIGNED DEFAULT '0',
`offline` tinyint UNSIGNED DEFAULT '1',
`media` varchar(255) NOT NULL DEFAULT '',
`media_url` varchar(255) NOT NULL DEFAULT '',
`media_size` varchar(10) NOT NULL DEFAULT '',
`cancomment` tinyint UNSIGNED DEFAULT '1',
`artimage` varchar(255) NOT NULL DEFAULT 'blank.gif',
`groups` varchar(255) NOT NULL DEFAULT '',
`hidden` tinyint UNSIGNED DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;
