1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| DROP TABLE IF EXISTS `th_text`;
CREATE TABLE IF NOT EXISTS `th_text` (
`old_id` int(8) unsigned NOT NULL auto_increment,
`old_namespace` tinyint(2) unsigned NOT NULL default '0',
`old_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`old_text` mediumtext NOT NULL,
`old_comment` tinyblob NOT NULL,
`old_user` int(5) unsigned NOT NULL default '0',
`old_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
`old_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
`old_minor_edit` tinyint(1) NOT NULL default '0',
`old_flags` tinyblob NOT NULL,
`inverse_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
PRIMARY KEY (`old_id`),
KEY `old_timestamp` (`old_timestamp`),
KEY `name_title_timestamp` (`old_namespace`,`old_title`,`inverse_timestamp`),
KEY `user_timestamp` (`old_user`,`inverse_timestamp`),
KEY `usertext_timestamp` (`old_user_text`,`inverse_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7551 ;
--
-- Contenu de la table `th_text`
--
INSERT DELAYED INTO `th_text` (`old_id`, `old_namespace`, `old_title`, `old_text`, `old_comment`, `old_user`, `old_user_text`, `old_timestamp`, `old_minor_edit`, `old_flags`, `inverse_timestamp`) VALUES (1, 0, 0x4163637565696c, 'Logiciel Thesis installé.\n\nPlease see [http://meta.wikipedia.org/wiki/MediaWiki_i18n documentation on customizing the interface]\nand the [http://meta.wikipedia.org/wiki/MediaWiki_User%27s_Guide User''s Guide] for usage and configuration help.', '', 0, 0x4d6564696157696b692064656661756c74, |