-- phpMyAdmin SQL Dump -- version 2.6.1 -- http://www.phpmyadmin.net -- -- Serveur: localhost -- Généré le : Samedi 10 Novembre 2007 à 22:12 -- Version du serveur: 4.1.9 -- Version de PHP: 4.3.10 -- -- Base de données: `joomlascol20` -- -- -------------------------------------------------------- -- -- Structure de la table `cpg143_albums` -- CREATE TABLE `cpg143_albums` ( `aid` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `description` text NOT NULL, `visibility` int(11) NOT NULL default '0', `uploads` enum('YES','NO') NOT NULL default 'NO', `comments` enum('YES','NO') NOT NULL default 'YES', `votes` enum('YES','NO') NOT NULL default 'YES', `pos` int(11) NOT NULL default '0', `category` int(11) NOT NULL default '0', `thumb` int(11) NOT NULL default '0', `keyword` varchar(50) default NULL, `alb_password` varchar(32) default NULL, `alb_password_hint` text, PRIMARY KEY (`aid`), KEY `alb_category` (`category`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; -- -- Contenu de la table `cpg143_albums` -- INSERT DELAYED IGNORE INTO `cpg143_albums` (`aid`, `title`, `description`, `visibility`, `uploads`, `comments`, `votes`, `pos`, `category`, `thumb`, `keyword`, `alb_password`, `alb_password_hint`) VALUES (1, 'album1', '', 0, 'NO', 'YES', 'YES', 1, 0, 0, NULL, NULL, NULL), (2, 'album1', '', 0, 'NO', 'YES', 'YES', 1, 0, 0, NULL, NULL, NULL), (3, 'album2', '', 0, 'NO', 'YES', 'YES', 2, 0, 0, NULL, NULL, NULL), (4, 'album3', '', 0, 'NO', 'YES', 'YES', 3, 0, 0, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Structure de la table `cpg143_banned` -- CREATE TABLE `cpg143_banned` ( `ban_id` int(11) NOT NULL auto_increment, `user_id` int(11) default NULL, `ip_addr` tinytext, `expiry` datetime default NULL, `brute_force` tinyint(5) NOT NULL default '0', PRIMARY KEY (`ban_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Contenu de la table `cpg143_banned` -- -- -------------------------------------------------------- -- -- Structure de la table `cpg143_bridge` -- CREATE TABLE `cpg143_bridge` ( `name` varchar(40) NOT NULL default '0', `value` varchar(255) NOT NULL default '', UNIQUE KEY `name` (`name`) ) TYPE=MyISAM; -- -- Contenu de la table `cpg143_bridge` -- INSERT DELAYED IGNORE INTO `cpg143_bridge` (`name`, `value`) VALUES ('short_name', ''), ('license_number', ''), ('db_database_name', ''), ('db_hostname', ''), ('db_username', ''), ('db_password', ''), ('full_forum_url', ''), ('relative_path_of_forum_from_webroot', ''), ('relative_path_to_config_file', ''), ('logout_flag', ''), ('use_post_based_groups', ''), ('cookie_prefix', ''), ('table_prefix', ''), ('user_table', ''), ('session_table', ''), ('group_table', ''), ('group_relation_table', ''), ('group_mapping_table', ''), ('use_standard_groups', '1'), ('validating_group', ''), ('guest_group', ''), ('member_group', ''), ('admin_group', ''), ('banned_group', ''), ('global_moderators_group', ''), ('recovery_logon_failures', '0'), ('recovery_logon_timestamp', ''); -- -------------------------------------------------------- -- -- Structure de la table `cpg143_categories` -- CREATE TABLE `cpg143_categories` ( `cid` int(11) NOT NULL auto_increment, `owner_id` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `pos` int(11) NOT NULL default '0', `parent` int(11) NOT NULL default '0', `thumb` int(11) NOT NULL default '0', PRIMARY KEY (`cid`), KEY `cat_parent` (`parent`), KEY `cat_pos` (`pos`), KEY `cat_owner_id` (`owner_id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `cpg143_categories` -- INSERT DELAYED IGNORE INTO `cpg143_categories` (`cid`, `owner_id`, `name`, `description`, `pos`, `parent`, `thumb`) VALUES (1, 0, 'User galleries', 'This category contains albums that belong to Coppermine users.', 0, 0, 0); -- -------------------------------------------------------- -- -- Structure de la table `cpg143_comments` -- CREATE TABLE `cpg143_comments` ( `pid` mediumint(10) NOT NULL default '0', `msg_id` mediumint(10) NOT NULL auto_increment, `msg_author` varchar(25) NOT NULL default '', `msg_body` text NOT NULL, `msg_date` datetime NOT NULL default '0000-00-00 00:00:00', `msg_raw_ip` tinytext, `msg_hdr_ip` tinytext, `author_md5_id` varchar(32) NOT NULL default '', `author_id` int(11) NOT NULL default '0', PRIMARY KEY (`msg_id`), KEY `com_pic_id` (`pid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Contenu de la table `cpg143_comments` -- -- -------------------------------------------------------- -- -- Structure de la table `cpg143_config` -- CREATE TABLE `cpg143_config` ( `name` varchar(40) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`name`) ) TYPE=MyISAM; -- -- Contenu de la table `cpg143_config` -- INSERT DELAYED IGNORE INTO `cpg143_config` (`name`, `value`) VALUES ('albums_per_page', '12'), ('album_list_cols', '2'), ('display_pic_info', '0'), ('alb_list_thumb_size', '50'), ('allowed_mov_types', 'ALL'), ('allowed_doc_types', 'ALL'), ('allowed_snd_types', 'ALL'), ('allowed_img_types', 'ALL'), ('allow_private_albums', '1'), ('allow_user_registration', '0'), ('allow_unlogged_access', '1'), ('allow_duplicate_emails_addr', '0'), ('caption_in_thumbview', '1'), ('views_in_thumbview', '1'), ('charset', 'utf-8'), ('cookie_name', 'cpg143'), ('cookie_path', '/'), ('debug_mode', '0'), ('debug_notice', '0'), ('default_dir_mode', '0755'), ('default_file_mode', '0644'), ('default_sort_order', 'na'), ('ecards_more_pic_target', 'http://localhost/cpg143/'), ('home_target', 'index.php'), ('custom_lnk_name', ''), ('custom_lnk_url', ''), ('enable_smilies', '1'), ('filter_bad_words', '0'), ('forbiden_fname_char', '$/\\\\:*?"''<>|` &'), ('fullpath', 'albums/'), ('gallery_admin_email', 'admin@ici.fr'), ('gallery_description', 'Your online photo album'), ('gallery_name', 'Coppermine Photo Gallery'), ('im_options', '-antialias'), ('impath', ''), ('jpeg_qual', '80'), ('keep_votes_time', '30'), ('lang', 'english'), ('main_page_layout', 'breadcrumb/catlist/alblist/random,2/lastup,2'), ('main_table_width', '100%'), ('make_intermediate', '1'), ('max_com_lines', '10'), ('max_com_size', '512'), ('max_com_wlength', '38'), ('max_img_desc_length', '512'), ('max_tabs', '12'), ('max_upl_size', '1024'), ('max_upl_width_height', '2048'), ('auto_resize', '0'), ('min_votes_for_rating', '1'), ('normal_pfx', 'normal_'), ('offline', '0'), ('picture_table_width', '600'), ('picture_width', '400'), ('read_exif_data', '0'), ('reg_requires_valid_email', '1'), ('subcat_level', '2'), ('theme', 'core'), ('thumbcols', '4'), ('thumbrows', '3'), ('thumb_method', 'gd2'), ('thumb_pfx', 'thumb_'), ('thumb_width', '100'), ('userpics', 'userpics/'), ('vanity_block', '1'), ('user_profile1_name', 'Location'), ('user_profile2_name', 'Interests'), ('user_profile3_name', 'Website'), ('user_profile4_name', 'Occupation'), ('user_profile5_name', ''), ('user_profile6_name', 'Biography'), ('user_field1_name', ''), ('user_field2_name', ''), ('user_field3_name', ''), ('user_field4_name', ''), ('display_comment_count', '0'), ('show_private', '0'), ('first_level', '1'), ('display_film_strip', '1'), ('display_film_strip_filename', '0'), ('max_film_strip_items', '5'), ('thumb_use', 'any'), ('read_iptc_data', '0'), ('reg_notify_admin_email', '0'), ('disable_comment_flood_protect', '0'), ('upl_notify_admin_email', '0'), ('display_uploader', '0'), ('display_filename', '0'), ('language_list', '0'), ('language_flags', '0'), ('theme_list', '0'), ('language_reset', '1'), ('theme_reset', '1'), ('allow_memberlist', '0'), ('display_faq', '0'), ('show_bbcode_help', '1'), ('log_ecards', '0'), ('email_comment_notification', '0'), ('enable_zipdownload', '1'), ('slideshow_interval', '5000'), ('log_mode', '0'), ('media_autostart', '1'), ('enable_encrypted_passwords', '1'), ('time_offset', '0'), ('ban_private_ip', '0'), ('smtp_host', ''), ('smtp_username', ''), ('smtp_password', ''), ('enable_plugins', '1'), ('enable_help', '2'), ('categories_alpha_sort', '0'), ('login_threshold', '5'), ('login_expiry', '10'), ('allow_email_change', '0'), ('clickable_keyword_search', '1'), ('users_can_edit_pics', '0'), ('show_which_exif', '|0|0|0|0|0|0|0|0|1|0|1|1|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|1|0|0|0|1|1|0|0|0|0|1|0|0|0|1|0|0|1|1|0|0|0|0|0|1|0|1|1'), ('alb_desc_thumb', '1'), ('link_pic_count', '0'), ('bridge_enable', '0'), ('language_fallback', '1'), ('vote_details', '0'), ('hit_details', '0'), ('browse_batch_add', '1'), ('custom_header_path', ''), ('custom_footer_path', ''), ('comments_sort_descending', '0'), ('report_post', '0'), ('comments_anon_pfx', 'Guest_'), ('admin_activation', '0'); -- -------------------------------------------------------- -- -- Structure de la table `cpg143_dict` -- CREATE TABLE `cpg143_dict` ( `keyId` bigint(20) NOT NULL auto_increment, `keyword` varchar(60) NOT NULL default '', PRIMARY KEY (`keyId`) ) TYPE=MyISAM COMMENT='Holds the keyword dictionary' AUTO_INCREMENT=1 ; -- -- Contenu de la table `cpg143_dict` -- -- -------------------------------------------------------- -- -- Structure de la table `cpg143_ecards` -- CREATE TABLE `cpg143_ecards` ( `eid` int(11) NOT NULL auto_increment, `sender_name` varchar(50) NOT NULL default '', `sender_email` text NOT NULL, `recipient_name` varchar(50) NOT NULL default '', `recipient_email` text NOT NULL, `link` text NOT NULL, `date` tinytext NOT NULL, `sender_ip` tinytext NOT NULL, PRIMARY KEY (`eid`) ) TYPE=MyISAM COMMENT='Used to log ecards' AUTO_INCREMENT=1 ; -- -- Contenu de la table `cpg143_ecards` -- -- -------------------------------------------------------- -- -- Structure de la table `cpg143_exif` -- CREATE TABLE `cpg143_exif` ( `filename` varchar(255) NOT NULL default '', `exifData` text NOT NULL, UNIQUE KEY `filename` (`filename`) ) TYPE=MyISAM; -- -- Contenu de la table `cpg143_exif` -- -- -------------------------------------------------------- -- -- Structure de la table `cpg143_favpics` -- CREATE TABLE `cpg143_favpics` ( `user_id` int(11) NOT NULL default '0', `user_favpics` text NOT NULL, PRIMARY KEY (`user_id`) ) TYPE=MyISAM COMMENT='Stores the server side favourites'; -- -- Contenu de la table `cpg143_favpics` -- -- -------------------------------------------------------- -- -- Structure de la table `cpg143_filetypes` -- CREATE TABLE `cpg143_filetypes` ( `extension` varchar(7) NOT NULL default '', `mime` varchar(30) default NULL, `content` varchar(15) default NULL, `player` varchar(5) default NULL, PRIMARY KEY (`extension`) ) TYPE=MyISAM COMMENT='Used to store the file extensions'; -- -- Contenu de la table `cpg143_filetypes` -- INSERT DELAYED IGNORE INTO `cpg143_filetypes` (`extension`, `mime`, `content`, `player`) VALUES ('jpg', 'image/jpg', 'image', ''), ('jpeg', 'image/jpeg', 'image', ''), ('jpe', 'image/jpe', 'image', ''), ('gif', 'image/gif', 'image', ''), ('png', 'image/png', 'image', ''), ('bmp', 'image/bmp', 'image', ''), ('jpc', 'image/jpc', 'image', ''), ('jp2', 'image/jp2', 'image', ''), ('jpx', 'image/jpx', 'image', ''), ('jb2', 'image/jb2', 'image', ''), ('swc', 'image/swc', 'image', ''), ('iff', 'image/iff', 'image', ''), ('asf', 'video/x-ms-asf', 'movie', 'WMP'), ('asx', 'video/x-ms-asx', 'movie', 'WMP'), ('mpg', 'video/mpeg', 'movie', 'WMP'), ('mpeg', 'video/mpeg', 'movie', 'WMP'), ('wmv', 'video/x-ms-wmv', 'movie', 'WMP'), ('swf', 'application/x-shockwave-flash', 'movie', 'SWF'), ('avi', 'video/avi', 'movie', 'WMP'), ('mov', 'video/quicktime', 'movie', 'QT'), ('mp3', 'audio/mpeg3', 'audio', 'WMP'), ('midi', 'audio/midi', 'audio', 'WMP'), ('mid', 'audio/midi', 'audio', 'WMP'), ('wma', 'audio/x-ms-wma', 'audio', 'WMP'), ('wav', 'audio/wav', 'audio', 'WMP'), ('ogg', 'audio/ogg', 'audio', ''), ('psd', 'image/psd', 'image', ''), ('ram', 'audio/x-pn-realaudio', 'document', 'RMP'), ('ra', 'audio/x-realaudio', 'document', 'RMP'), ('rm', 'audio/x-realmedia', 'document', 'RMP'), ('tiff', 'image/tiff', 'document', ''), ('tif', 'image/tif', 'document', ''), ('doc', 'application/msword', 'document', ''), ('txt', 'text/plain', 'document', ''), ('rtf', 'text/richtext', 'document', ''), ('pdf', 'application/pdf', 'document', ''), ('xls', 'application/excel', 'document', ''), ('pps', 'application/powerpoint', 'document', ''), ('ppt', 'application/powerpoint', 'document', ''), ('zip', 'application/zip', 'document', ''), ('rar', 'application/rar', 'document', ''), ('gz', 'application/gz', 'document', ''), ('mdb', 'application/msaccess', 'document', ''); -- -------------------------------------------------------- -- -- Structure de la table `cpg143_hit_stats` -- CREATE TABLE `cpg143_hit_stats` ( `sid` int(11) NOT NULL auto_increment, `pid` varchar(100) NOT NULL default '', `ip` varchar(20) NOT NULL default '', `search_phrase` varchar(255) NOT NULL default '', `sdate` bigint(20) NOT NULL default '0', `referer` text NOT NULL, `browser` varchar(255) NOT NULL default '', `os` varchar(50) NOT NULL default '', PRIMARY KEY (`sid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Contenu de la table `cpg143_hit_stats` -- -- -------------------------------------------------------- -- -- Structure de la table `cpg143_pictures` -- CREATE TABLE `cpg143_pictures` ( `pid` int(11) NOT NULL auto_increment, `aid` int(11) NOT NULL default '0', `filepath` varchar(255) NOT NULL default '', `filename` varchar(255) NOT NULL default '', `filesize` int(11) NOT NULL default '0', `total_filesize` int(11) NOT NULL default '0', `pwidth` smallint(6) NOT NULL default '0', `pheight` smallint(6) NOT NULL default '0', `hits` int(10) NOT NULL default '0', `mtime` datetime NOT NULL default '0000-00-00 00:00:00', `ctime` int(11) NOT NULL default '0', `owner_id` int(11) NOT NULL default '0', `owner_name` varchar(40) NOT NULL default '', `pic_rating` int(11) NOT NULL default '0', `votes` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `caption` text NOT NULL, `keywords` varchar(255) NOT NULL default '', `approved` enum('YES','NO') NOT NULL default 'NO', `galleryicon` int(11) NOT NULL default '0', `user1` varchar(255) NOT NULL default '', `user2` varchar(255) NOT NULL default '', `user3` varchar(255) NOT NULL default '', `user4` varchar(255) NOT NULL default '', `url_prefix` tinyint(4) NOT NULL default '0', `pic_raw_ip` tinytext, `pic_hdr_ip` tinytext, `lasthit_ip` tinytext, `position` int(11) NOT NULL default '0', PRIMARY KEY (`pid`), KEY `owner_id` (`owner_id`), KEY `pic_hits` (`hits`), KEY `pic_rate` (`pic_rating`), KEY `aid_approved` (`aid`,`approved`), KEY `pic_aid` (`aid`), FULLTEXT KEY `search` (`title`,`caption`,`keywords`,`filename`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Contenu de la table `cpg143_pictures` -- -- -------------------------------------------------------- -- -- Structure de la table `cpg143_plugins` -- CREATE TABLE `cpg143_plugins` ( `plugin_id` int(10) unsigned NOT NULL auto_increment, `name` varchar(64) NOT NULL default '', `path` varchar(128) NOT NULL default '', `priority` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`plugin_id`), UNIQUE KEY `name` (`name`), UNIQUE KEY `path` (`path`) ) TYPE=MyISAM COMMENT='Stores the plugins' AUTO_INCREMENT=1 ; -- -- Contenu de la table `cpg143_plugins` -- -- -------------------------------------------------------- -- -- Structure de la table `cpg143_sessions` -- CREATE TABLE `cpg143_sessions` ( `session_id` varchar(40) NOT NULL default '', `user_id` int(11) default '0', `time` int(11) default NULL, `remember` int(1) default '0', PRIMARY KEY (`session_id`) ) TYPE=MyISAM COMMENT='Used to store sessions'; -- -- Contenu de la table `cpg143_sessions` -- INSERT DELAYED IGNORE INTO `cpg143_sessions` (`session_id`, `user_id`, `time`, `remember`) VALUES ('7c3d76707a3b451bb3b15a6288e0c8f8', 1, 1142760579, 0); -- -------------------------------------------------------- -- -- Structure de la table `cpg143_temp_data` -- CREATE TABLE `cpg143_temp_data` ( `unique_ID` varchar(8) NOT NULL default '', `encoded_string` blob NOT NULL, `timestamp` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`unique_ID`) ) TYPE=MyISAM COMMENT='Holds temporary file data for multiple file uploads'; -- -- Contenu de la table `cpg143_temp_data` -- -- -------------------------------------------------------- -- -- Structure de la table `cpg143_usergroups` -- CREATE TABLE `cpg143_usergroups` ( `group_id` int(11) NOT NULL auto_increment, `group_name` varchar(255) NOT NULL default '', `group_quota` int(11) NOT NULL default '0', `has_admin_access` tinyint(4) NOT NULL default '0', `can_rate_pictures` tinyint(4) NOT NULL default '0', `can_send_ecards` tinyint(4) NOT NULL default '0', `can_post_comments` tinyint(4) NOT NULL default '0', `can_upload_pictures` tinyint(4) NOT NULL default '0', `can_create_albums` tinyint(4) NOT NULL default '0', `pub_upl_need_approval` tinyint(4) NOT NULL default '1', `priv_upl_need_approval` tinyint(4) NOT NULL default '1', `upload_form_config` tinyint(4) NOT NULL default '3', `custom_user_upload` tinyint(4) NOT NULL default '0', `num_file_upload` tinyint(4) NOT NULL default '5', `num_URI_upload` tinyint(4) NOT NULL default '3', PRIMARY KEY (`group_id`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; -- -- Contenu de la table `cpg143_usergroups` -- INSERT DELAYED IGNORE INTO `cpg143_usergroups` (`group_id`, `group_name`, `group_quota`, `has_admin_access`, `can_rate_pictures`, `can_send_ecards`, `can_post_comments`, `can_upload_pictures`, `can_create_albums`, `pub_upl_need_approval`, `priv_upl_need_approval`, `upload_form_config`, `custom_user_upload`, `num_file_upload`, `num_URI_upload`) VALUES (1, 'Administrators', 0, 1, 1, 1, 1, 1, 1, 0, 0, 3, 0, 5, 3), (2, 'Registered', 1024, 0, 1, 1, 1, 1, 1, 1, 0, 3, 0, 5, 3), (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3), (4, 'Banned', 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3); -- -------------------------------------------------------- -- -- Structure de la table `cpg143_users` -- CREATE TABLE `cpg143_users` ( `user_id` int(11) NOT NULL auto_increment, `user_group` int(11) NOT NULL default '2', `user_active` enum('YES','NO') NOT NULL default 'NO', `user_name` varchar(25) NOT NULL default '', `user_password` varchar(40) NOT NULL default '', `user_lastvisit` datetime NOT NULL default '0000-00-00 00:00:00', `user_regdate` datetime NOT NULL default '0000-00-00 00:00:00', `user_group_list` varchar(255) NOT NULL default '', `user_email` varchar(255) NOT NULL default '', `user_profile1` varchar(255) NOT NULL default '', `user_profile2` varchar(255) NOT NULL default '', `user_profile3` varchar(255) NOT NULL default '', `user_profile4` varchar(255) NOT NULL default '', `user_profile5` varchar(255) NOT NULL default '', `user_profile6` text NOT NULL, `user_actkey` varchar(32) NOT NULL default '', PRIMARY KEY (`user_id`), UNIQUE KEY `user_name` (`user_name`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `cpg143_users` -- INSERT DELAYED IGNORE INTO `cpg143_users` (`user_id`, `user_group`, `user_active`, `user_name`, `user_password`, `user_lastvisit`, `user_regdate`, `user_group_list`, `user_email`, `user_profile1`, `user_profile2`, `user_profile3`, `user_profile4`, `user_profile5`, `user_profile6`, `user_actkey`) VALUES (1, 1, 'YES', 'admin', '21232f297a57a5a743894a0e4a801fc3', '2006-03-19 10:28:28', '2006-03-19 10:28:03', '', 'admin@ici.fr', '', '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Structure de la table `cpg143_vote_stats` -- CREATE TABLE `cpg143_vote_stats` ( `sid` int(11) NOT NULL auto_increment, `pid` varchar(100) NOT NULL default '', `rating` smallint(6) NOT NULL default '0', `ip` varchar(20) NOT NULL default '', `sdate` bigint(20) NOT NULL default '0', `referer` text NOT NULL, `browser` varchar(255) NOT NULL default '', `os` varchar(50) NOT NULL default '', PRIMARY KEY (`sid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Contenu de la table `cpg143_vote_stats` -- -- -------------------------------------------------------- -- -- Structure de la table `cpg143_votes` -- CREATE TABLE `cpg143_votes` ( `pic_id` mediumint(9) NOT NULL default '0', `user_md5_id` varchar(32) NOT NULL default '', `vote_time` int(11) NOT NULL default '0', PRIMARY KEY (`pic_id`,`user_md5_id`) ) TYPE=MyISAM; -- -- Contenu de la table `cpg143_votes` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_asv_kalenda_cats` -- CREATE TABLE `jos_asv_kalenda_cats` ( `id` int(11) NOT NULL auto_increment, `titre` text NOT NULL, `description_courte` mediumtext, `description_longue` mediumtext, `icone` text, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `jos_asv_kalenda_cats` -- INSERT DELAYED IGNORE INTO `jos_asv_kalenda_cats` (`id`, `titre`, `description_courte`, `description_longue`, `icone`) VALUES (1, 'Default', NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Structure de la table `jos_asv_kalenda_dates` -- CREATE TABLE `jos_asv_kalenda_dates` ( `did` int(11) NOT NULL auto_increment, `eid` int(11) NOT NULL default '0', `debut` datetime NOT NULL default '0000-00-00 00:00:00', `fin` datetime default NULL, `lieu` int(11) default NULL, `published` tinyint(1) NOT NULL default '0', PRIMARY KEY (`did`), KEY `eid` (`eid`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `jos_asv_kalenda_dates` -- INSERT DELAYED IGNORE INTO `jos_asv_kalenda_dates` (`did`, `eid`, `debut`, `fin`, `lieu`, `published`) VALUES (1, 1, '2007-11-05 08:00:01', '2007-11-22 00:00:00', NULL, 1); -- -------------------------------------------------------- -- -- Structure de la table `jos_asv_kalenda_events` -- CREATE TABLE `jos_asv_kalenda_events` ( `id` int(11) NOT NULL auto_increment, `titre` text NOT NULL, `description_courte` mediumtext, `description_longue` mediumtext, `image` text, `cat` int(11) NOT NULL default '0', `lieu` int(11) default NULL, `attribut` tinytext, `published` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `jos_asv_kalenda_events` -- INSERT DELAYED IGNORE INTO `jos_asv_kalenda_events` (`id`, `titre`, `description_courte`, `description_longue`, `image`, `cat`, `lieu`, `attribut`, `published`) VALUES (1, 'Réunion 1', '', '', '', 1, 0, NULL, 1); -- -------------------------------------------------------- -- -- Structure de la table `jos_asv_kalenda_lieux` -- CREATE TABLE `jos_asv_kalenda_lieux` ( `id` int(11) NOT NULL auto_increment, `titre` text NOT NULL, `description_courte` mediumtext, `description_longue` mediumtext, `icone` text, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `jos_asv_kalenda_lieux` -- INSERT DELAYED IGNORE INTO `jos_asv_kalenda_lieux` (`id`, `titre`, `description_courte`, `description_longue`, `icone`) VALUES (1, 'Default', NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Structure de la table `jos_banner` -- CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(10) NOT NULL default 'banner', `name` varchar(50) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Contenu de la table `jos_banner` -- INSERT DELAYED IGNORE INTO `jos_banner` (`bid`, `cid`, `type`, `name`, `imptotal`, `impmade`, `clicks`, `imageurl`, `clickurl`, `date`, `showBanner`, `checked_out`, `checked_out_time`, `editor`, `custombannercode`) VALUES (1, 1, 'banner', 'OSM 1', 0, 108, 0, 'osmbanner1.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 0, '2000-00-00 00:00:00', NULL, NULL), (2, 1, 'banner', 'OSM 2', 0, 107, 0, 'osmbanner2.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 0, '2000-00-00 00:00:00', NULL, NULL); -- -------------------------------------------------------- -- -- Structure de la table `jos_bannerclient` -- CREATE TABLE `jos_bannerclient` ( `cid` int(11) NOT NULL auto_increment, `name` varchar(60) NOT NULL default '', `contact` varchar(60) NOT NULL default '', `email` varchar(60) NOT NULL default '', `extrainfo` text NOT NULL, `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` time default NULL, `editor` varchar(50) default NULL, PRIMARY KEY (`cid`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `jos_bannerclient` -- INSERT DELAYED IGNORE INTO `jos_bannerclient` (`cid`, `name`, `contact`, `email`, `extrainfo`, `checked_out`, `checked_out_time`, `editor`) VALUES (1, 'Open Source Matters', 'Administrator', 'admin@opensourcematters.org', '', 0, '00:00:00', NULL); -- -------------------------------------------------------- -- -- Structure de la table `jos_bannerfinish` -- CREATE TABLE `jos_bannerfinish` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(10) NOT NULL default '', `name` varchar(50) NOT NULL default '', `impressions` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(50) NOT NULL default '', `datestart` datetime default NULL, `dateend` datetime default NULL, PRIMARY KEY (`bid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Contenu de la table `jos_bannerfinish` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_categories` -- CREATE TABLE `jos_categories` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) NOT NULL default '0', `title` varchar(50) NOT NULL default '', `name` varchar(255) NOT NULL default '', `image` varchar(100) NOT NULL default '', `section` varchar(50) NOT NULL default '', `image_position` varchar(10) NOT NULL default '', `description` text NOT NULL, `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `ordering` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `cat_idx` (`section`,`published`,`access`), KEY `idx_section` (`section`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`) ) TYPE=MyISAM AUTO_INCREMENT=24 ; -- -- Contenu de la table `jos_categories` -- INSERT DELAYED IGNORE INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (1, 0, 'Latest', 'Latest News', 'taking_notes.jpg', '1', 'left', 'The latest news from the Joomla! Team', 1, 0, '0000-00-00 00:00:00', '', 0, 0, 1, ''), (2, 0, 'Joomla!', 'Joomla!', 'clock.jpg', 'com_weblinks', 'left', 'A selection of links that are all related to the Joomla! Project.', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''), (3, 0, 'Newsflash', 'Newsflash', '', '2', 'left', '', 1, 0, '0000-00-00 00:00:00', '', 0, 0, 0, ''), (4, 0, 'Joomla!', 'Joomla!', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, ''), (5, 0, 'Business: general', 'Business: general', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, ''), (7, 0, 'Examples', 'Example FAQs', 'key.jpg', '3', 'left', 'Here you will find an example set of FAQs.', 0, 0, '0000-00-00 00:00:00', NULL, 0, 0, 2, ''), (9, 0, 'Finance', 'Finance', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 5, 0, 0, ''), (10, 0, 'Linux', 'Linux', '', 'com_newsfeeds', 'left', '
\r\n', 1, 0, '0000-00-00 00:00:00', NULL, 6, 0, 0, ''), (11, 0, 'Internet', 'Internet', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 7, 0, 0, ''), (12, 0, 'Contacts', 'Contacts', '', 'com_contact_details', 'left', 'Contact Details for this website', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''), (23, 0, 'Divers', 'Divers', '', 'com_eventcal', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, 'autopublish=false\ncolor=#333399'), (15, 0, 'Expositions', 'Expositions', '', '10', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, ''), (17, 0, 'Arts plastiques', 'Arts plastiques', '', '7', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, ''), (16, 0, 'Edito', 'Edito', '', '4', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 3, 0, 0, ''), (18, 0, 'Educ. musicale', 'Educ. musicale', '', '7', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, ''), (19, 0, 'Divers', 'Divers', '', '10', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, ''), (20, 0, 'Restaurant scolaire', 'Restaurant scolaire', '', '4', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, ''), (21, 0, 'Emplois du temps', 'Emplois du temps', '', '4', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, ''); -- -------------------------------------------------------- -- -- Structure de la table `jos_components` -- CREATE TABLE `jos_components` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `link` varchar(255) NOT NULL default '', `menuid` int(11) unsigned NOT NULL default '0', `parent` int(11) unsigned NOT NULL default '0', `admin_menu_link` varchar(255) NOT NULL default '', `admin_menu_alt` varchar(255) NOT NULL default '', `option` varchar(50) NOT NULL default '', `ordering` int(11) NOT NULL default '0', `admin_menu_img` varchar(255) NOT NULL default '', `iscore` tinyint(4) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=110 ; -- -- Contenu de la table `jos_components` -- INSERT DELAYED IGNORE INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (1, 'Banners', '', 0, 0, '', 'Banner Management', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, ''), (2, 'Manage Banners', '', 0, 1, 'option=com_banners', 'Active Banners', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, ''), (3, 'Manage Clients', '', 0, 1, 'option=com_banners&task=listclients', 'Manage Clients', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, ''), (4, 'Web Links', 'option=com_weblinks', 0, 0, '', 'Manage Weblinks', 'com_weblinks', 0, 'js/ThemeOffice/globe2.png', 0, ''), (5, 'Weblink Items', '', 0, 4, 'option=com_weblinks', 'View existing weblinks', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, ''), (6, 'Weblink Categories', '', 0, 4, 'option=categories§ion=com_weblinks', 'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, ''), (7, 'Contacts', 'option=com_contact', 0, 0, '', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/user.png', 1, ''), (8, 'Manage Contacts', '', 0, 7, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, ''), (9, 'Contact Categories', '', 0, 7, 'option=categories§ion=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, ''), (10, 'FrontPage', 'option=com_frontpage', 0, 0, '', 'Manage Front Page Items', 'com_frontpage', 0, 'js/ThemeOffice/component.png', 1, ''), (11, 'Polls', 'option=com_poll', 0, 0, 'option=com_poll', 'Manage Polls', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, ''), (12, 'News Feeds', 'option=com_newsfeeds', 0, 0, '', 'News Feeds Management', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, ''), (13, 'Manage News Feeds', '', 0, 12, 'option=com_newsfeeds', 'Manage News Feeds', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, ''), (14, 'Manage Categories', '', 0, 12, 'option=com_categories§ion=com_newsfeeds', 'Manage Categories', '', 2, 'js/ThemeOffice/categories.png', 0, ''), (15, 'Login', 'option=com_login', 0, 0, '', '', 'com_login', 0, '', 1, ''), (16, 'Search', 'option=com_search', 0, 0, '', '', 'com_search', 0, '', 1, ''), (17, 'Syndicate', '', 0, 0, 'option=com_syndicate&hidemainmenu=1', 'Manage Syndication Settings', 'com_syndicate', 0, 'js/ThemeOffice/component.png', 0, ''), (18, 'Mass Mail', '', 0, 0, 'option=com_massmail&hidemainmenu=1', 'Send Mass Mail', 'com_massmail', 0, 'js/ThemeOffice/mass_email.png', 0, ''), (76, 'JCE Admin', 'option=com_jce', 0, 0, 'option=com_jce', 'JCE Admin', 'com_jce', 0, 'js/ThemeOffice/component.png', 0, ''), (77, 'JCE Configuration', '', 0, 76, 'option=com_jce&task=config', 'JCE Configuration', 'com_jce', 0, 'js/ThemeOffice/controlpanel.png', 0, ''), (78, 'JCE Languages', '', 0, 76, 'option=com_jce&task=lang', 'JCE Languages', 'com_jce', 1, 'js/ThemeOffice/language.png', 0, ''), (79, 'JCE Plugins', '', 0, 76, 'option=com_jce&task=showplugins', 'JCE Plugins', 'com_jce', 2, 'js/ThemeOffice/install.png', 0, ''), (80, 'JCE Layout', '', 0, 76, 'option=com_jce&task=editlayout', 'JCE Layout', 'com_jce', 3, 'js/ThemeOffice/tux.png', 0, ''), (75, 'zOOm Media Gallery', 'option=com_zoom', 0, 0, 'option=com_zoom', 'zOOm Media Gallery', 'com_zoom', 0, '../administrator/components/com_zoom/images/zoom_menu.png', 0, ''), (59, 'Custom QuickIcons', 'option=com_customquickicons', 0, 0, 'option=com_customquickicons', 'Custom QuickIcons', 'com_customquickicons', 0, 'js/ThemeOffice/component.png', 0, ''), (101, 'JCal Pro', 'option=com_jcalpro', 0, 0, 'option=com_jcalpro', 'JCal Pro', 'com_jcalpro', 0, '../components/com_jcalpro/images/calendar_icon_16x16.png', 0, ''), (102, 'Edit Settings', '', 0, 101, 'option=com_jcalpro&task=editSettings', 'Edit Settings', 'com_jcalpro', 0, 'js/ThemeOffice/config.png', 0, ''), (103, 'Manage Event Categories', '', 0, 101, 'option=com_jcalpro&task=showCategories', 'Manage Event Categories', 'com_jcalpro', 1, 'js/ThemeOffice/categories.png', 0, ''), (104, 'Manage Events', '', 0, 101, 'option=com_jcalpro§ion=events', 'Manage Events', 'com_jcalpro', 2, 'js/ThemeOffice/component.png', 0, ''), (107, 'Import', '', 0, 101, 'option=com_jcalpro&task=import', 'Import', 'com_jcalpro', 5, 'js/ThemeOffice/backup.png', 0, ''), (105, 'Show Themes', '', 0, 101, 'option=com_jcalpro&task=showthemes', 'Show Themes', 'com_jcalpro', 3, 'js/ThemeOffice/component.png', 0, ''), (106, 'Install Themes', '', 0, 101, 'option=com_jcalpro&task=install&element=themes', 'Install Themes', 'com_jcalpro', 4, 'js/ThemeOffice/install.png', 0, ''), (108, 'About', '', 0, 101, 'option=com_jcalpro&task=about', 'About', 'com_jcalpro', 6, 'js/ThemeOffice/credits.png', 0, ''), (109, 'Documentation', '', 0, 101, 'option=com_jcalpro&task=documentation', 'Documentation', 'com_jcalpro', 7, 'js/ThemeOffice/help.png', 0, ''); -- -------------------------------------------------------- -- -- Structure de la table `jos_contact_details` -- CREATE TABLE `jos_contact_details` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `con_position` varchar(50) default NULL, `address` text, `suburb` varchar(50) default NULL, `state` varchar(20) default NULL, `country` varchar(50) default NULL, `postcode` varchar(10) default NULL, `telephone` varchar(25) default NULL, `fax` varchar(25) default NULL, `misc` mediumtext, `image` varchar(100) default NULL, `imagepos` varchar(20) default NULL, `email_to` varchar(100) default NULL, `default_con` tinyint(1) unsigned NOT NULL default '0', `published` tinyint(1) unsigned NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `params` text NOT NULL, `user_id` int(11) NOT NULL default '0', `catid` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `jos_contact_details` -- INSERT DELAYED IGNORE INTO `jos_contact_details` (`id`, `name`, `con_position`, `address`, `suburb`, `state`, `country`, `postcode`, `telephone`, `fax`, `misc`, `image`, `imagepos`, `email_to`, `default_con`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `user_id`, `catid`, `access`) VALUES (1, 'Name', 'Position', 'Street', 'Suburb', 'State', 'Country', 'Zip Code', 'Telephone', 'Fax', 'Miscellanous info', 'asterisk.png', 'top', 'email@email.com', 1, 1, 0, '0000-00-00 00:00:00', 1, '', 0, 12, 0); -- -------------------------------------------------------- -- -- Structure de la table `jos_content` -- CREATE TABLE `jos_content` ( `id` int(11) unsigned NOT NULL auto_increment, `title` varchar(100) NOT NULL default '', `title_alias` varchar(100) NOT NULL default '', `introtext` mediumtext NOT NULL, `fulltext` mediumtext NOT NULL, `state` tinyint(3) NOT NULL default '0', `sectionid` int(11) unsigned NOT NULL default '0', `mask` int(11) unsigned NOT NULL default '0', `catid` int(11) unsigned NOT NULL default '0', `created` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) unsigned NOT NULL default '0', `created_by_alias` varchar(100) NOT NULL default '', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_by` int(11) unsigned NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `images` text NOT NULL, `urls` text NOT NULL, `attribs` text NOT NULL, `version` int(11) unsigned NOT NULL default '1', `parentid` int(11) unsigned NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `metakey` text NOT NULL, `metadesc` text NOT NULL, `access` int(11) unsigned NOT NULL default '0', `hits` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `idx_section` (`sectionid`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`state`), KEY `idx_catid` (`catid`), KEY `idx_mask` (`mask`) ) TYPE=MyISAM AUTO_INCREMENT=13 ; -- -- Contenu de la table `jos_content` -- INSERT DELAYED IGNORE INTO `jos_content` (`id`, `title`, `title_alias`, `introtext`, `fulltext`, `state`, `sectionid`, `mask`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `parentid`, `ordering`, `metakey`, `metadesc`, `access`, `hits`) VALUES (1, 'Welcome to Joomla!', 'Welcome', 'If you''ve read anything at all about Content Management Systems (CMS), you''ll probably know at least three things: CMS are the most exciting way to do business, CMS can be really, I mean really, complicated and lastly Portals are absolutely, outrageously, often unaffordably expensive.

{mosimage}Joomla! is set to change all that ... Joomla! is different from the normal models for portal software. For a start, it''s not complicated. Joomla! has been developed for the masses. It''s licensed under the GNU/GPL license, easy to install and administer and reliable. Joomla! doesn''t even require the user or administrator of the system to know HTML to operate it once it''s up and running.', '

Joomla! features:

\r\n\r\n

Extensive Administration:

\r\n', -2, 1, 0, 1, '2004-06-12 11:54:06', 62, 'Web Master', '2004-06-12 12:33:27', 62, 0, '0000-00-00 00:00:00', '2004-01-01 00:00:00', '0000-00-00 00:00:00', 'asterisk.png|left|Joomla! Logo|1|Example Caption|bottom|center|120', '', '', 1, 0, 0, '', '', 0, 0), (2, 'Newsflash 1', '', 'Joomla! 1.0 - ''Experience the Freedom''!. It has never been easier to create\r\nyour own dynamic site. Manage all your content from the best CMS admin\r\ninterface.', '', -2, 2, 1, 3, '2004-08-09 08:30:34', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2004-08-09 00:00:00', '0000-00-00 00:00:00', '', '', '', 1, 0, 0, '', '', 0, 0), (3, 'Newsflash 2', '', 'Yesterday all servers in the U.S. went out on strike in a bid to get more RAM and better CPUs. A spokes person said that the need for better RAM was due to some fool increasing the front-side bus speed. In future, busses will be told to slow down in residential motherboards.', '', -2, 2, 1, 3, '2004-08-09 08:30:34', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2004-08-09 00:00:00', '0000-00-00 00:00:00', '', '', '', 1, 0, 0, '', '', 0, 0), (4, 'Newsflash 3', '', 'Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn''t mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae we do not raed ervey lteter by itslef but the wrod as a wlohe.', '', -2, 2, 1, 3, '2004-08-09 08:30:34', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2004-08-09 00:00:00', '0000-00-00 00:00:00', '', '', '', 1, 0, 0, '', '', 0, 1), (5, 'Joomla! License Guidelines', '', '

This website is powered by Joomla! The software and default templates on which it runs are Copyright 2005 Open Source Matters. All other content and data, including data entered into this website and templates added after installation, are copyrighted by their respective copyright owners.

If you want to distribute, copy or modify Joomla!, you are welcome to do so under the terms of the GNU General Public License. If you are unfamiliar with this license, you might want to read ''How To Apply These Terms To Your Program'' and the ''GNU General Public License FAQ''.

', '', 1, 0, 0, 0, '2004-08-19 20:11:07', 62, '', '2004-08-19 20:14:49', 62, 0, '0000-00-00 00:00:00', '2004-08-19 00:00:00', '0000-00-00 00:00:00', '', '', 'menu_image=\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=', 1, 0, 11, '', '', 0, 10), (6, 'Example News Item 1', 'News1', '{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum.', '

{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.

\r\n\r\n

Ut wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.

\r\n\r\n

Nam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.

\r\n\r\n

Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.

\r\n\r\n

Consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem ipsum dolor sit amet.

', -2, 1, 0, 1, '2004-07-07 11:54:06', 62, '', '2004-07-07 18:05:05', 62, 0, '0000-00-00 00:00:00', '2004-07-07 00:00:00', '0000-00-00 00:00:00', 'food/coffee.jpg|left||0\r\nfood/bread.jpg|right||0', '', '', 1, 0, 0, '', '', 0, 4), (7, 'Example News Item 2', 'News2', '

{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.

', '', -2, 1, 0, 1, '2004-07-07 11:54:06', 62, '', '2004-07-07 18:11:30', 62, 0, '0000-00-00 00:00:00', '2004-07-07 00:00:00', '0000-00-00 00:00:00', 'food/bun.jpg|right||0', '', '', 1, 0, 0, '', '', 0, 2), (8, 'Example News Item 3', 'News3', '

{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.

', '', -2, 1, 0, 1, '2004-04-12 11:54:06', 62, '', '2004-07-07 18:08:23', 62, 0, '0000-00-00 00:00:00', '2004-07-07 00:00:00', '0000-00-00 00:00:00', 'fruit/pears.jpg|right||0', '', '', 1, 0, 0, '', '', 0, 1), (9, 'Example News Item 4', 'News4', '

Loremcoffee ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.

', '

{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.

{mospagebreak}

{mosimage}Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.

{mosimage}Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat.

Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores duo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet clita ea et gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero voluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat.

{mospagebreak}

Consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.

', -2, 1, 0, 1, '2004-07-07 11:54:06', 62, '', '2006-03-10 19:09:13', 62, 0, '0000-00-00 00:00:00', '2004-07-07 00:00:00', '0000-00-00 00:00:00', 'fruit/strawberry.jpg|left||0\r\nfruit/pears.jpg|right||0\r\nfruit/cherry.jpg|left||0', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=', 2, 0, 0, '', '', 0, 6), (10, 'Example FAQ Item 1', 'FAQ1', 'articles\r\n

\r\nLorem ipsum dolor sit amet, c\r\n

\r\n

\r\nest Lorem ipsum dolor sit amet.\r\n

\r\n', '', -2, 3, 0, 7, '2004-05-12 11:54:06', 62, '', '2006-03-13 22:15:19', 62, 0, '0000-00-00 00:00:00', '2004-01-01 00:00:00', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=', 3, 0, 0, '', '', 0, 8), (11, 'Example FAQ Item 2', 'FAQ2', '

Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.

', '

{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.

\r\n\r\n

{mosimage}Ut wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.

\r\n\r\n

{mosimage}Nam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.

\r\n\r\n

Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.

\r\n\r\n

Consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem ipsum dolor sit amet.

', -2, 3, 0, 7, '2004-05-12 11:54:06', 62, 'Web master', '2004-07-07 18:10:23', 62, 0, '0000-00-00 00:00:00', '2004-01-01 00:00:00', '0000-00-00 00:00:00', 'fruit/cherry.jpg|left||0\r\nfruit/peas.jpg|right||0\r\nfood/milk.jpg|left||0', '', '', 1, 0, 0, '', '', 0, 10), (12, 'Edito', '', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Qu''est ce que Joomla? Convertir en PDF Version imprimable Suggérer par mail
\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Écrit par hornos le 10-10-2005   
Joomla logo est un système de gestion de contenu (en anglais, CMS, pour Content Management system) créé par une équipe internationale de développeurs récompensée à maintes reprises, celle-là même qui a hissé Mambo vers les sommets. Et un CMS, c''est quoi?? Pour faire simple, un CMS est un logiciel web qui vous permettra de créer un site internet dynamique en toute simplicité. Joomla! est un CMS Open Source distribué sous license GNU/GPL (gratuit) avec lequel vous pourrez mettre en ligne du contenu et mettre à disposition de vos visiteurs des services (forum, boutique en ligne, galerie photos,...), le tout sans connaissance technique particulière.
\r\n

Que se cache-t-il derrière ce nom?

\r\n

\r\n Joomla! est la transcription phonétique d''un mot swahili qui signifie "tous ensemble", ou encore "en un tout". Le choix s''est porté vers ce nom car l''intégralité de l''équipe qui était derrière Mambo était unanime dans la volonté de protéger les intérêts des créateurs et de la communauté. \r\n

\r\n

\r\n Ce nom a été choisi parmi les milliers de propositions faites par la communauté, il a même été passé au banc d''essai par des professionnels du marketing et des marques, convaincus eux aussi que Joomla! était le meilleur choix. \r\n

\r\n

\r\n Ce qui rend Joomla! différent, c''est notre engagement à le rendre aussi simple que possible, tout en offrant un maximum de fonctionnalités. Au final, des non techniciens pourront parfaitement gérer eux-mêmes leur site, sans être obligés de passer par des solutions propriétaires aux coûts exorbitants. \r\n

\r\n

\r\n Joomla! ce n''est pas seulement un logiciel, ce sont aussi des personnes. La communauté Joomla! est composée de développeurs, de designers, d''administrateurs systèmes, de traducteurs, de rédacteurs et, le plus important, d''utilisateurs finaux. \r\n

\r\n

\r\n Nous vous souhaitons la bienvenue dans notre communauté. \r\n

\r\n
\r\n

\r\n \r\n

\r\n', '

\r\n Selon framasoft \r\n

\r\n

\r\nVoici donc Joomla!, un CMS qui a de plus en plus de fidèles et qui se démarque des Nukes, Xoops, eXoops, Zope... par sa modularité et de Typo3 par sa simplicité d''utilisation et d''administration : « Je clique, donc je code ». \r\n

\r\n

\r\nJoomla! est, dans la continuité de Mambo, un CMS convivial, puissant et ergonomique adapté à des sites vitrine, commerciaux, associatifs, institutionnels ou communautaires. \r\n

\r\n

\r\nSon menu d''administration présente les éléments de gestion du contenu plutôt que les fonctionnalités du logiciel. Par exemple, la barre de menu d''administration présente les choix "Articles, News, Menu principal, Sondages..." Même sans être initié aux CMS, il est plus facile de comprendre comment composer les menus et sous-menus, comment ajouter des composants et modules et comment publier des nouvelles. \r\n

\r\n

\r\nComme le soutiennent les développeurs de Joomla! beaucoup de personnes apprécient sa capacité à autoriser l''utilisateur à éditer le contenu "sans devoir être un savant specialisé en fusée". "Le fait qu''il supprime des barrières pour les gens qui ne se seraient jamais considérés comme étant capables d''éditer rapidement et facilement sur le web, est le dispositif le plus attrayant pour ceux qui emploient Joomla!" \r\n

\r\n

\r\nCôté visiteur, le contenu est afficher au traver du template (ou thème) constitué d''un seul fichier (index.php) en plus de la classique feuille de style et des fichiers images. Les emplacements ainsi définis dans le template (main, left, right, top, bottom ou des emplacements personnalisés user1, user 2...) permettent de paramétrer et totalement personnaliser l''aspect de votre site simplement en placant vos publications et blocs d''affichage depuis l''interface d''administration (une zone de nouvelle flash, une bannière publicitaire, des nouvelles, des articles, un login de connexion, un module de recherche, etc.). \r\n

\r\n

\r\nL''équipe de développement se concentre pour nous offrir un moteur simple et fonctionnel et entièrement libre, mais il est possible d''enrichir son Joomla ! grâce à de nombreux composants, modules et hacks d''autres développeurs. \r\n

\r\n

\r\nQuelques fonctionnalités de Joomla ! 1.0 \r\n

\r\n\r\n

\r\nEn conclusion \r\n

\r\n

\r\nPoints forts : \r\n

\r\n\r\n

\r\nPoints faibles \r\n

\r\n

\r\nNécessite : \r\n

\r\n\r\nSITE OFFICIEL \r\n', 1, 4, 0, 16, '2006-05-10 17:54:27', 62, '', '2007-10-28 09:59:33', 62, 0, '0000-00-00 00:00:00', '2006-05-10 17:45:35', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=', 4, 0, 1, '', '', 0, 1); -- -------------------------------------------------------- -- -- Structure de la table `jos_content_frontpage` -- CREATE TABLE `jos_content_frontpage` ( `content_id` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`content_id`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_content_frontpage` -- INSERT DELAYED IGNORE INTO `jos_content_frontpage` (`content_id`, `ordering`) VALUES (1, 3), (2, 4), (3, 5), (4, 6), (5, 7), (9, 2), (12, 1); -- -------------------------------------------------------- -- -- Structure de la table `jos_content_rating` -- CREATE TABLE `jos_content_rating` ( `content_id` int(11) NOT NULL default '0', `rating_sum` int(11) unsigned NOT NULL default '0', `rating_count` int(11) unsigned NOT NULL default '0', `lastip` varchar(50) NOT NULL default '', PRIMARY KEY (`content_id`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_content_rating` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_core_acl_aro` -- CREATE TABLE `jos_core_acl_aro` ( `aro_id` int(11) NOT NULL auto_increment, `section_value` varchar(240) NOT NULL default '0', `value` varchar(240) NOT NULL default '', `order_value` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `hidden` int(11) NOT NULL default '0', PRIMARY KEY (`aro_id`), UNIQUE KEY `jos_gacl_section_value_value_aro` (`section_value`(100),`value`(100)), KEY `jos_gacl_hidden_aro` (`hidden`) ) TYPE=MyISAM AUTO_INCREMENT=12 ; -- -- Contenu de la table `jos_core_acl_aro` -- INSERT DELAYED IGNORE INTO `jos_core_acl_aro` (`aro_id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES (10, 'users', '62', 0, 'Administrator', 0), (11, 'users', '63', 0, 'utilisateur1', 0); -- -------------------------------------------------------- -- -- Structure de la table `jos_core_acl_aro_groups` -- CREATE TABLE `jos_core_acl_aro_groups` ( `group_id` int(11) NOT NULL auto_increment, `parent_id` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `lft` int(11) NOT NULL default '0', `rgt` int(11) NOT NULL default '0', PRIMARY KEY (`group_id`), KEY `parent_id_aro_groups` (`parent_id`), KEY `jos_gacl_parent_id_aro_groups` (`parent_id`), KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`) ) TYPE=MyISAM AUTO_INCREMENT=31 ; -- -- Contenu de la table `jos_core_acl_aro_groups` -- INSERT DELAYED IGNORE INTO `jos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES (17, 0, 'ROOT', 1, 22), (28, 17, 'USERS', 2, 21), (29, 28, 'Public Frontend', 3, 12), (18, 29, 'Registered', 4, 11), (19, 18, 'Author', 5, 10), (20, 19, 'Editor', 6, 9), (21, 20, 'Publisher', 7, 8), (30, 28, 'Public Backend', 13, 20), (23, 30, 'Manager', 14, 19), (24, 23, 'Administrator', 15, 18), (25, 24, 'Super Administrator', 16, 17); -- -------------------------------------------------------- -- -- Structure de la table `jos_core_acl_aro_sections` -- CREATE TABLE `jos_core_acl_aro_sections` ( `section_id` int(11) NOT NULL auto_increment, `value` varchar(230) NOT NULL default '', `order_value` int(11) NOT NULL default '0', `name` varchar(230) NOT NULL default '', `hidden` int(11) NOT NULL default '0', PRIMARY KEY (`section_id`), UNIQUE KEY `value_aro_sections` (`value`), UNIQUE KEY `jos_gacl_value_aro_sections` (`value`), KEY `hidden_aro_sections` (`hidden`), KEY `jos_gacl_hidden_aro_sections` (`hidden`) ) TYPE=MyISAM AUTO_INCREMENT=11 ; -- -- Contenu de la table `jos_core_acl_aro_sections` -- INSERT DELAYED IGNORE INTO `jos_core_acl_aro_sections` (`section_id`, `value`, `order_value`, `name`, `hidden`) VALUES (10, 'users', 1, 'Users', 0); -- -------------------------------------------------------- -- -- Structure de la table `jos_core_acl_groups_aro_map` -- CREATE TABLE `jos_core_acl_groups_aro_map` ( `group_id` int(11) NOT NULL default '0', `section_value` varchar(240) NOT NULL default '', `aro_id` int(11) NOT NULL default '0', UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_core_acl_groups_aro_map` -- INSERT DELAYED IGNORE INTO `jos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES (24, '', 11), (25, '', 10); -- -------------------------------------------------------- -- -- Structure de la table `jos_core_log_items` -- CREATE TABLE `jos_core_log_items` ( `time_stamp` date NOT NULL default '0000-00-00', `item_table` varchar(50) NOT NULL default '', `item_id` int(11) unsigned NOT NULL default '0', `hits` int(11) unsigned NOT NULL default '0' ) TYPE=MyISAM; -- -- Contenu de la table `jos_core_log_items` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_core_log_searches` -- CREATE TABLE `jos_core_log_searches` ( `search_term` varchar(128) NOT NULL default '', `hits` int(11) unsigned NOT NULL default '0' ) TYPE=MyISAM; -- -- Contenu de la table `jos_core_log_searches` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_custom_quickicons` -- CREATE TABLE `jos_custom_quickicons` ( `id` int(11) NOT NULL auto_increment, `title` varchar(64) NOT NULL default '', `target` varchar(255) NOT NULL default '', `icon` varchar(100) NOT NULL default '', `ordering` int(10) unsigned NOT NULL default '0', `new_window` tinyint(1) NOT NULL default '0', `prefix` varchar(30) NOT NULL default '', `postfix` varchar(30) NOT NULL default '', `published` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=13 ; -- -- Contenu de la table `jos_custom_quickicons` -- INSERT DELAYED IGNORE INTO `jos_custom_quickicons` (`id`, `title`, `target`, `icon`, `ordering`, `new_window`, `prefix`, `postfix`, `published`) VALUES (1, 'Add New Content', 'index2.php?option=com_content§ionid=0&task=new', 'module.png', 1, 0, '', '', 1), (2, 'Section Manager', 'index2.php?option=com_sections&scope=content', 'sections.png', 5, 0, '', '', 1), (3, 'Frontpage Manager', 'index2.php?option=com_frontpage', 'frontpage.png', 4, 0, '', '', 1), (4, 'Content Items Manager', 'index2.php?option=com_content§ionid=0', 'addedit.png', 2, 0, '', '', 1), (5, 'Static Content Manager', 'index2.php?option=com_typedcontent', 'addedit.png', 3, 0, '', '', 1), (6, 'Media Manager', 'index2.php?option=com_media', 'mediamanager.png', 7, 0, '', '', 1), (7, 'Category Manager', 'index2.php?option=com_categories§ion=content', 'categories.png', 6, 0, '', '', 1), (8, 'Trash Manager', 'index2.php?option=com_trash', 'trash.png', 8, 0, '', '', 1), (9, 'Menu Manager', 'index2.php?option=com_menumanager', 'menu.png', 9, 0, '', '', 1), (10, 'Language Manager', 'index2.php?option=com_languages', 'langmanager.png', 10, 0, '', '', 1), (11, 'User Manager', 'index2.php?option=com_users', 'user.png', 11, 0, '', '', 1), (12, 'Global Configuration', 'index2.php?option=com_config&hidemainmenu=1', 'config.png', 12, 0, '', '', 1); -- -------------------------------------------------------- -- -- Structure de la table `jos_eventcal` -- CREATE TABLE `jos_eventcal` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `description` text NOT NULL, `contact` text NOT NULL, `url` varchar(100) NOT NULL default '', `email` varchar(120) NOT NULL default '', `catid` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `start_date` int(10) NOT NULL default '0', `end_date` int(10) NOT NULL default '0', `recur_type` set('none','day','week','month','year') NOT NULL default 'none', `recur_week` varchar(7) NOT NULL default '', `recur_count` varchar(3) NOT NULL default '', `recur_except` text NOT NULL, `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `params` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), FULLTEXT KEY `params` (`params`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Contenu de la table `jos_eventcal` -- INSERT DELAYED IGNORE INTO `jos_eventcal` (`id`, `title`, `description`, `contact`, `url`, `email`, `catid`, `published`, `start_date`, `end_date`, `recur_type`, `recur_week`, `recur_count`, `recur_except`, `checked_out`, `checked_out_time`, `params`) VALUES (1, 'Réunion d''information', '', '', '', '', 23, 1, 1193850000, 1193857200, 'week', '', '', '', 0, '0000-00-00 00:00:00', ''), (2, 'Conseil', '', '', '', '', 23, 1, 1193677200, 1225126800, 'none', '', '', '', 0, '0000-00-00 00:00:00', ''); -- -------------------------------------------------------- -- -- Structure de la table `jos_groups` -- CREATE TABLE `jos_groups` ( `id` tinyint(3) unsigned NOT NULL default '0', `name` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_groups` -- INSERT DELAYED IGNORE INTO `jos_groups` (`id`, `name`) VALUES (0, 'Public'), (1, 'Registered'), (2, 'Special'); -- -------------------------------------------------------- -- -- Structure de la table `jos_jcalpro_categories` -- CREATE TABLE `jos_jcalpro_categories` ( `cat_id` int(11) NOT NULL auto_increment, `cat_parent` int(11) NOT NULL default '0', `cat_name` varchar(150) NOT NULL default '', `description` text NOT NULL, `color` varchar(10) default '#000000', `bgcolor` varchar(10) default '#EEF0F0', `options` tinyint(4) default '0', `level` varchar(255) default '0', `published` tinyint(1) default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`cat_id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Contenu de la table `jos_jcalpro_categories` -- INSERT DELAYED IGNORE INTO `jos_jcalpro_categories` (`cat_id`, `cat_parent`, `cat_name`, `description`, `color`, `bgcolor`, `options`, `level`, `published`, `checked_out`, `checked_out_time`) VALUES (1, 0, 'General', 'This is the default category', '#6600CC', '#EEF0F0', 0, 'public frontend', 1, 0, '0000-00-00 00:00:00'), (2, 0, 'Divers', '', '#669933', '#EEF0F0', 0, 'public frontend', 1, 0, '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Structure de la table `jos_jcalpro_config` -- CREATE TABLE `jos_jcalpro_config` ( `name` varchar(40) NOT NULL default '', `value` varchar(255) NOT NULL default '', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`name`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_jcalpro_config` -- INSERT DELAYED IGNORE INTO `jos_jcalpro_config` (`name`, `value`, `checked_out`, `checked_out_time`) VALUES ('cookie_name', 'jcalpro1', 0, '0000-00-00 00:00:00'), ('cookie_path', '/', 0, '0000-00-00 00:00:00'), ('debug_mode', '0', 0, '0000-00-00 00:00:00'), ('events_per_page', '10', 0, '0000-00-00 00:00:00'), ('calendar_name', 'JCal Pro Calendar', 0, '0000-00-00 00:00:00'), ('calendar_admin_email', 'admin@ici.fr', 0, '0000-00-00 00:00:00'), ('calendar_description', 'Your online events calendar', 0, '0000-00-00 00:00:00'), ('lang', 'english', 0, '0000-00-00 00:00:00'), ('charset', 'language file', 0, '0000-00-00 00:00:00'), ('main_table_width', '100%', 0, '0000-00-00 00:00:00'), ('max_tabs', '12', 0, '0000-00-00 00:00:00'), ('theme', '', 0, '0000-00-00 00:00:00'), ('timezone', '1', 0, '0000-00-00 00:00:00'), ('time_format_24hours', '1', 0, '0000-00-00 00:00:00'), ('auto_daylight_saving', '1', 0, '0000-00-00 00:00:00'), ('default_view', '2', 0, '0000-00-00 00:00:00'), ('popup_event_mode', '1', 0, '0000-00-00 00:00:00'), ('popup_event_width', '550', 0, '0000-00-00 00:00:00'), ('popup_event_height', '300', 0, '0000-00-00 00:00:00'), ('add_event_view', '1', 0, '0000-00-00 00:00:00'), ('cats_view', '1', 0, '0000-00-00 00:00:00'), ('daily_view', '1', 0, '0000-00-00 00:00:00'), ('weekly_view', '1', 0, '0000-00-00 00:00:00'), ('monthly_view', '1', 0, '0000-00-00 00:00:00'), ('flyer_view', '1', 0, '0000-00-00 00:00:00'), ('search_view', '1', 0, '0000-00-00 00:00:00'), ('day_start', '1', 0, '0000-00-00 00:00:00'), ('archive', '0', 0, '0000-00-00 00:00:00'), ('flyer_show_picture', '1', 0, '0000-00-00 00:00:00'), ('addevent_allow_html', '1', 0, '0000-00-00 00:00:00'), ('addevent_allow_contact', '1', 0, '0000-00-00 00:00:00'), ('addevent_allow_email', '1', 0, '0000-00-00 00:00:00'), ('addevent_allow_url', '1', 0, '0000-00-00 00:00:00'), ('new_post_notification', '1', 0, '0000-00-00 00:00:00'), ('cal_view_max_chars', '10000', 0, '0000-00-00 00:00:00'), ('flyer_view_max_chars', '10000', 0, '0000-00-00 00:00:00'), ('weekly_view_max_chars', '10000', 0, '0000-00-00 00:00:00'), ('daily_view_max_chars', '10000', 0, '0000-00-00 00:00:00'), ('cats_view_max_chars', '10000', 0, '0000-00-00 00:00:00'), ('mini_cal_def_picture', 'def_pic.gif', 0, '0000-00-00 00:00:00'), ('mini_cal_diplay_options', '1', 0, '0000-00-00 00:00:00'), ('release_name', 'Mambo Version of 2.0 Beta 1', 0, '0000-00-00 00:00:00'), ('release_version', 'Mambo Version of 2.00.25', 0, '0000-00-00 00:00:00'), ('release_type', 'Unique MamboServer Version', 0, '0000-00-00 00:00:00'), ('sort_order', 'ta', 0, '0000-00-00 00:00:00'), ('allow_user_registration', '1', 0, '0000-00-00 00:00:00'), ('reg_email_verify', '1', 0, '0000-00-00 00:00:00'), ('reg_duplicate_emails', '0', 0, '0000-00-00 00:00:00'), ('calendar_status', '1', 0, '0000-00-00 00:00:00'), ('show_recurrent_events', '1', 0, '0000-00-00 00:00:00'), ('multi_day_events', 'all', 0, '0000-00-00 00:00:00'), ('cal_view_show_week', '1', 0, '0000-00-00 00:00:00'), ('mail_method', 'mail', 0, '0000-00-00 00:00:00'), ('mail_smtp_host', 'smtp.myhost.com', 0, '0000-00-00 00:00:00'), ('mail_smtp_auth', '0', 0, '0000-00-00 00:00:00'), ('mail_smtp_username', '', 0, '0000-00-00 00:00:00'), ('mail_smtp_password', '', 0, '0000-00-00 00:00:00'), ('url_target_for_events', '_blank', 0, '0000-00-00 00:00:00'), ('capitalize_event_titles', '1', 0, '0000-00-00 00:00:00'), ('show_top_navigation_bar', '1', 0, '0000-00-00 00:00:00'), ('who_can_add_events', 'manager', 0, '0000-00-00 00:00:00'), ('who_can_edit_events', 'manager', 0, '0000-00-00 00:00:00'), ('who_can_delete_events', 'manager', 0, '0000-00-00 00:00:00'), ('who_can_approve_events', 'manager', 0, '0000-00-00 00:00:00'), ('show_recurrence_info_event_view', '1', 0, '0000-00-00 00:00:00'), ('show_recurrence_info_category_view', '1', 0, '0000-00-00 00:00:00'), ('sort_category_view_by', 'date_asc', 0, '0000-00-00 00:00:00'), ('show_only_start_times', '0', 0, '0000-00-00 00:00:00'), ('show_event_times_in_monthly_view', '0', 0, '0000-00-00 00:00:00'), ('show_event_times_in_flat_view', '1', 0, '0000-00-00 00:00:00'), ('show_event_times_in_weekly_view', '1', 0, '0000-00-00 00:00:00'), ('show_event_times_in_daily_view', '1', 0, '0000-00-00 00:00:00'), ('show_overlapping_recurrences_monthlyview', '1', 0, '0000-00-00 00:00:00'), ('show_overlapping_recurrences_flatview', '0', 0, '0000-00-00 00:00:00'), ('show_overlapping_recurrences_weeklyview', '0', 0, '0000-00-00 00:00:00'), ('show_overlapping_recurrences_dailyview', '0', 0, '0000-00-00 00:00:00'), ('allow_javascript_in_event_urls', '0', 0, '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Structure de la table `jos_jcalpro_events` -- CREATE TABLE `jos_jcalpro_events` ( `extid` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `description` text NOT NULL, `contact` text NOT NULL, `url` varchar(100) NOT NULL default '', `email` varchar(120) NOT NULL default '', `picture` varchar(100) NOT NULL default '', `cat` tinyint(2) NOT NULL default '0', `day` tinyint(2) NOT NULL default '0', `month` smallint(2) NOT NULL default '0', `year` smallint(4) NOT NULL default '0', `approved` tinyint(1) NOT NULL default '0', `start_date` datetime NOT NULL default '0000-00-00 00:00:00', `end_date` datetime default '0000-00-00 00:00:00', `recur_type` varchar(16) default NULL, `recur_val` tinyint(4) default '0', `recur_end_type` tinyint(1) unsigned NOT NULL default '0', `recur_count` tinyint(3) unsigned NOT NULL default '0', `recur_until` date default '0000-00-00', `published` tinyint(1) default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`extid`), KEY `start_date` (`start_date`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `jos_jcalpro_events` -- INSERT DELAYED IGNORE INTO `jos_jcalpro_events` (`extid`, `title`, `description`, `contact`, `url`, `email`, `picture`, `cat`, `day`, `month`, `year`, `approved`, `start_date`, `end_date`, `recur_type`, `recur_val`, `recur_end_type`, `recur_count`, `recur_until`, `published`, `checked_out`, `checked_out_time`) VALUES (1, 'Réunion d''information', '', '', '', '', '', 2, 28, 10, 2008, 1, '2008-10-28 20:00:00', '2008-10-28 22:00:00', '', 0, 0, 0, '0000-00-00', 1, 0, '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Structure de la table `jos_jcalpro_themes` -- CREATE TABLE `jos_jcalpro_themes` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `theme` varchar(100) NOT NULL default '', `type` varchar(100) NOT NULL default 'plugins', `icon` varchar(255) NOT NULL default '', `published` tinyint(3) NOT NULL default '0', `editable` tinyint(3) NOT NULL default '1', `elements` varchar(255) NOT NULL default '', `iscore` tinyint(3) NOT NULL default '0', `client_id` tinyint(3) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `params` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `plugin` (`theme`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `jos_jcalpro_themes` -- INSERT DELAYED IGNORE INTO `jos_jcalpro_themes` (`id`, `name`, `theme`, `type`, `icon`, `published`, `editable`, `elements`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (1, 'default', 'default', 'theme', 'default', 1, 1, '', 1, 0, 0, '0000-00-00 00:00:00', ''); -- -------------------------------------------------------- -- -- Structure de la table `jos_jce_langs` -- CREATE TABLE `jos_jce_langs` ( `id` int(11) NOT NULL auto_increment, `Name` varchar(100) NOT NULL default '', `lang` varchar(100) NOT NULL default '', `published` tinyint(3) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Contenu de la table `jos_jce_langs` -- INSERT DELAYED IGNORE INTO `jos_jce_langs` (`id`, `Name`, `lang`, `published`) VALUES (1, 'English', 'en', 0), (2, 'Français', 'fr', 1); -- -------------------------------------------------------- -- -- Structure de la table `jos_jce_plugins` -- CREATE TABLE `jos_jce_plugins` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `plugin` varchar(100) NOT NULL default '', `type` varchar(100) NOT NULL default 'plugin', `icon` varchar(255) NOT NULL default '', `layout_icon` varchar(255) NOT NULL default '', `access` tinyint(3) unsigned NOT NULL default '18', `row` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `published` tinyint(3) NOT NULL default '0', `editable` tinyint(3) NOT NULL default '0', `elements` varchar(255) NOT NULL default '', `iscore` tinyint(3) NOT NULL default '0', `client_id` tinyint(3) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `params` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `plugin` (`plugin`) ) TYPE=MyISAM AUTO_INCREMENT=52 ; -- -- Contenu de la table `jos_jce_plugins` -- INSERT DELAYED IGNORE INTO `jos_jce_plugins` (`id`, `name`, `plugin`, `type`, `icon`, `layout_icon`, `access`, `row`, `ordering`, `published`, `editable`, `elements`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (1, 'Context Menu', 'contextmenu', 'plugin', '', '', 18, 0, 1, 0, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (2, 'Directionality', 'directionality', 'plugin', 'ltr,rtl', 'directionality', 18, 3, 2, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (3, 'Emotions', 'emotions', 'plugin', 'emotions', 'emotions', 18, 1, 14, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (4, 'Fullscreen', 'fullscreen', 'plugin', 'fullscreen', 'fullscreen', 18, 1, 17, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (5, 'Paste', 'paste', 'plugin', 'pasteword,pastetext', 'paste', 18, 1, 9, 1, 1, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (6, 'Preview', 'preview', 'plugin', 'preview', 'preview', 18, 1, 16, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (7, 'Tables', 'table', 'plugin', 'tablecontrols', 'buttons', 18, 2, 5, 0, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (8, 'Print', 'print', 'plugin', 'print', 'print', 18, 3, 7, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (9, 'Search Replace', 'searchreplace', 'plugin', 'search,replace', 'searchreplace', 18, 1, 11, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (10, 'Styles', 'style', 'plugin', 'styleprops', 'styleprops', 18, 3, 4, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (11, 'Non-Breaking', 'nonbreaking', 'plugin', 'nonbreaking', 'nonbreaking', 18, 4, 3, 0, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (12, 'Visual Characters', 'visualchars', 'plugin', 'visualchars', 'visualchars', 18, 1, 15, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (13, 'XHTML Xtras', 'xhtmlxtras', 'plugin', 'cite,abbr,acronym,del,ins,attribs', 'xhtmlxtras', 18, 4, 6, 0, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (14, 'Image Manager', 'imgmanager', 'plugin', '', 'imgmanager', 18, 4, 10, 1, 1, '', 1, 0, 0, '0000-00-00 00:00:00', 'dir=/images/stories\nurl=/images/stories\ncreate_folder=1\nuse_tree=1\nmax_size=1024\nhspace=5\nvspace=5\nborder=0\nborder_width=1\nborder_style=solid\nborder_color=#000000\nalign=left\nupload=18\nfolder_new=18\nfolder_delete=18\nfolder_rename=18\nfile_delete=18\nfile_rename=18\nfile_move=18\nuser_dir=0\ndir_type=level\nuser_folder=\nuser_dir_level=18'), (15, 'Advanced Link', 'advlink', 'plugin', '', 'advlink', 18, 4, 12, 1, 1, '', 1, 0, 0, '0000-00-00 00:00:00', 'target=_self\narticle=18\nsection=18\ncategory=18\nstatic=18\ncontact=18\nmenu=18'), (16, 'Spell Checker', 'spellchecker', 'plugin', 'spellchecker', 'spellchecker', 18, 1, 13, 1, 1, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (17, 'Layers', 'layer', 'plugin', 'insertlayer,moveforward,movebackward,absolute', 'layer', 18, 4, 8, 0, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (18, 'Font ForeColour', 'forecolor', 'command', 'forecolor', 'forecolor', 18, 3, 1, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (19, 'Bold', 'bold', 'command', 'bold', 'bold', 18, 1, 3, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (20, 'Italic', 'italic', 'command', 'italic', 'italic', 18, 1, 4, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (21, 'Underline', 'underline', 'command', 'underline', 'underline', 18, 1, 5, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (22, 'Font BackColour', 'backcolor', 'command', 'backcolor', 'backcolor', 18, 3, 2, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (23, 'Unlink', 'unlink', 'command', 'unlink', 'unlink', 18, 1, 14, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (24, 'Font Select', 'fontselect', 'command', 'fontselect', 'fontselect', 18, 2, 7, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (25, 'Font Size Select', 'fontsizeselect', 'command', 'fontsizeselect', 'fontsizeselect', 18, 2, 9, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (26, 'Style Select', 'styleselect', 'command', 'styleselect', 'styleselect', 18, 2, 6, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (27, 'New Document', 'newdocument', 'command', 'newdocument', 'newdocument', 18, 1, 2, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (28, 'Help', 'help', 'command', 'help', 'help', 18, 1, 3, 0, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (29, 'StrikeThrough', 'strikethrough', 'command', 'strikethrough', 'strikethrough', 18, 1, 10, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (30, 'Indent', 'indent', 'command', 'indent', 'indent', 18, 1, 9, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (31, 'Outdent', 'outdent', 'command', 'outdent', 'outdent', 18, 1, 8, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (32, 'Undo', 'undo', 'command', 'undo', 'undo', 18, 1, 1, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (33, 'Redo', 'redo', 'command', 'redo', 'redo', 18, 1, 2, 0, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (34, 'Horizontal Rule', 'hr', 'command', 'hr', 'hr', 18, 3, 9, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (35, 'HTML', 'html', 'command', 'code', 'code', 18, 3, 6, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (36, 'Numbered List', 'numlist', 'command', 'numlist', 'numlist', 18, 1, 7, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (37, 'Bullet List', 'bullist', 'command', 'bullist', 'bullist', 18, 1, 6, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (38, 'Clipboard Actions', 'clipboard', 'command', 'cut,copy,paste', 'clipboard', 18, 1, 12, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (39, 'Subscript', 'sub', 'command', 'sub', 'sub', 18, 2, 2, 0, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (40, 'Superscript', 'sup', 'command', 'sup', 'sup', 18, 2, 3, 0, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (41, 'Visual Aid', 'visualaid', 'command', 'visualaid', 'visualaid', 18, 3, 4, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (42, 'Character Map', 'charmap', 'command', 'charmap', 'charmap', 18, 3, 3, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (43, 'Justify Full', 'full', 'command', 'justifyfull', 'justifyfull', 18, 2, 4, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (44, 'Justify Center', 'center', 'command', 'justifycenter', 'justifycenter', 18, 2, 2, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (45, 'Justify Left', 'left', 'command', 'justifyleft', 'justifyleft', 18, 2, 3, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (46, 'Justify Right', 'right', 'command', 'justifyright', 'justifyright', 18, 2, 1, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (47, 'Remove Format', 'removeformat', 'command', 'removeformat', 'removeformat', 18, 3, 7, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (48, 'Anchor', 'anchor', 'command', 'anchor', 'anchor', 18, 2, 5, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (49, 'Format Select', 'formatselect', 'command', 'formatselect', 'formatselect', 18, 2, 8, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (50, 'Image', 'image', 'command', 'image', 'image', 18, 1, 20, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''), (51, 'Link', 'link', 'command', 'link', 'link', 18, 1, 15, 1, 0, '', 1, 0, 0, '0000-00-00 00:00:00', ''); -- -------------------------------------------------------- -- -- Structure de la table `jos_mambots` -- CREATE TABLE `jos_mambots` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `element` varchar(100) NOT NULL default '', `folder` varchar(100) NOT NULL default '', `access` tinyint(3) unsigned NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `published` tinyint(3) NOT NULL default '0', `iscore` tinyint(3) NOT NULL default '0', `client_id` tinyint(3) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_folder` (`published`,`client_id`,`access`,`folder`) ) TYPE=MyISAM AUTO_INCREMENT=27 ; -- -- Contenu de la table `jos_mambots` -- INSERT DELAYED IGNORE INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (1, 'MOS Image', 'mosimage', 'content', 0, -10000, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (2, 'MOS Pagination', 'mospaging', 'content', 0, 10000, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (3, 'Legacy Mambot Includer', 'legacybots', 'content', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (4, 'SEF', 'mossef', 'content', 0, 3, 1, 0, 0, 0, '0000-00-00 00:00:00', ''), (5, 'MOS Rating', 'mosvote', 'content', 0, 4, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (6, 'Search Content', 'content.searchbot', 'search', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (7, 'Search Weblinks', 'weblinks.searchbot', 'search', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (8, 'Code support', 'moscode', 'content', 0, 2, 0, 0, 0, 0, '0000-00-00 00:00:00', ''), (9, 'No WYSIWYG Editor', 'none', 'editors', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (10, 'TinyMCE WYSIWYG Editor', 'tinymce', 'editors', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', 'theme=advanced'), (11, 'MOS Image Editor Button', 'mosimage.btn', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''), (12, 'MOS Pagebreak Editor Button', 'mospage.btn', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''), (13, 'Search Contacts', 'contacts.searchbot', 'search', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', ''), (14, 'Search Categories', 'categories.searchbot', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', ''), (15, 'Search Sections', 'sections.searchbot', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', ''), (16, 'Email Cloaking', 'mosemailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', ''), (17, 'GeSHi', 'geshi', 'content', 0, 5, 0, 0, 0, 0, '0000-00-00 00:00:00', ''), (18, 'Search Newsfeeds', 'newsfeeds.searchbot', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', ''), (19, 'Load Module Positions', 'mosloadposition', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', ''), (23, 'JCEUtilities', 'jceutils', 'system', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''), (24, 'JCE Editor Mambot', 'jce', 'editors', 0, 3, 1, 0, 0, 0, '0000-00-00 00:00:00', 'editor_width=500\neditor_height=600\neditor_state=mceEditor\ncompression=0\nabsolute_url=0\nrelative_url=1\neditor_toggle=[show/hide]\ntext_direction=ltr\ncharset=iso-8859-1\ntable_inline=0\ncontent_css=1\ncontent_css_custom=\nnewlines=0\ntoolbar=top\nverify_html=0\nfix_table_elements=1\nfix_list_elements=1\nmambot_mode=0\nentity_encoding=named\nfont_size_type=length\ninvalid_elements=applet\nextended_elements=\nevent_elements=td,img,a\nallow_script=18\nhtml_height=550\nhtml_width=750\npreview_height=550\npreview_width=750\ntemplate_colors='), (26, 'JCalPro Latest Events Mambot', 'bot_jcalpro_latest_events', 'content', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', ''); -- -------------------------------------------------------- -- -- Structure de la table `jos_menu` -- CREATE TABLE `jos_menu` ( `id` int(11) NOT NULL auto_increment, `menutype` varchar(25) default NULL, `name` varchar(100) default NULL, `link` text, `type` varchar(50) NOT NULL default '', `published` tinyint(1) NOT NULL default '0', `parent` int(11) unsigned NOT NULL default '0', `componentid` int(11) unsigned NOT NULL default '0', `sublevel` int(11) default '0', `ordering` int(11) default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `pollid` int(11) NOT NULL default '0', `browserNav` tinyint(4) default '0', `access` tinyint(3) unsigned NOT NULL default '0', `utaccess` tinyint(3) unsigned NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `componentid` (`componentid`,`menutype`,`published`,`access`), KEY `menutype` (`menutype`) ) TYPE=MyISAM AUTO_INCREMENT=45 ; -- -- Contenu de la table `jos_menu` -- INSERT DELAYED IGNORE INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (1, 'mainmenu', 'Accueil', 'index.php?option=com_frontpage', 'components', 1, 0, 10, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nheader=Bienvenue sur la page d''accueil\npage_title=0\nback_button=0\nleading=1\nintro=2\ncolumns=2\nlink=1\norderby_pri=\norderby_sec=front\npagination=2\npagination_results=1\nimage=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0'), (2, 'mainmenu', 'News', 'index.php?option=com_content&task=section&id=1', 'content_section', 0, 0, 1, 0, 7, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''), (3, 'mainmenu', 'Nous contacter', 'index.php?option=com_contact', 'components', 1, 0, 7, 0, 21, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\ncatid=0\nother_cat_section=1\nother_cat=1\ncat_description=1\ncat_items=1\ndescription=1\ndescription_text=\nimage=-1\nimage_align=right\nheadings=1\nposition=1\nemail=0\ntelephone=1\nfax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1'), (23, 'mainmenu', 'Nos liens', 'index.php?option=com_weblinks', 'components', 1, 0, 4, 0, 13, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=web_links.jpg\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nheadings=1\nhits=\nitem_description=1\nother_cat_section=1\nother_cat=1\ndescription=1\ndescription_text=\nimage=-1\nimage_align=right\nweblink_icons='), (5, 'mainmenu', 'Trouver', 'index.php?option=com_search', 'components', 0, 0, 16, 0, 17, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=\npageclass_sfx=\nback_button=\npage_title=1\nheader='), (6, 'mainmenu', 'Joomla! License', 'index.php?option=com_content&task=view&id=5', 'content_typed', -2, 0, 11, 0, 8, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''), (7, 'mainmenu', 'News Feeds', 'index.php?option=com_newsfeeds', 'components', 0, 0, 12, 0, 18, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader='), (8, 'mainmenu', 'Wrapper', 'index.php?option=com_wrapper', 'wrapper', 0, 0, 0, 0, 20, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=600\nheight_auto=0\nurl=www.joomla.org'), (9, 'mainmenu', 'Blog', 'index.php?option=com_content&task=blogsection&id=0', 'content_blog_section', 0, 0, 0, 0, 11, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=A blog of all section with no images\npage_title=1\nleading=0\nintro=6\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=0\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid='), (10, 'othermenu', 'Joomla! Home', 'http://www.joomla.org', 'url', 0, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''), (11, 'othermenu', 'Joomla! Forums', 'http://forum.joomla.org', 'url', 0, 0, 0, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''), (12, 'othermenu', 'OSM Home', 'http://www.opensourcematters.org', 'url', 0, 0, 0, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''), (24, 'othermenu', 'Admin. site', 'administrator/', 'url', 1, 0, 0, 0, 4, 0, '0000-00-00 00:00:00', 0, 1, 0, 3, 'menu_image=-1'), (21, 'usermenu', 'Your Details', 'index.php?option=com_user&task=UserDetails', 'url', 0, 0, 0, 0, 1, 0, '2000-00-00 00:00:00', 0, 0, 1, 3, ''), (13, 'usermenu', 'Submit News', 'index.php?option=com_content&task=new§ionid=1&Itemid=0', 'url', 0, 0, 0, 0, 2, 0, '2000-00-00 00:00:00', 0, 0, 1, 2, ''), (14, 'usermenu', 'Submit WebLink', 'index.php?option=com_weblinks&task=new', 'url', 0, 0, 0, 0, 4, 0, '2000-00-00 00:00:00', 0, 0, 1, 2, ''), (15, 'usermenu', 'Check-In My Items', 'index.php?option=com_user&task=CheckIn', 'url', 0, 0, 0, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 1, 2, ''), (16, 'usermenu', 'Logout', 'index.php?option=com_login', 'components', 1, 0, 15, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 1, 3, ''), (17, 'topmenu', 'Home', 'index.php', 'url', 1, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''), (18, 'topmenu', 'Contact Us', 'index.php?option=com_contact&Itemid=3', 'url', 1, 0, 0, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''), (19, 'topmenu', 'News', 'index.php?option=com_content&task=section&id=1&Itemid=2', 'url', 1, 0, 0, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''), (20, 'topmenu', 'Links', 'index.php?option=com_weblinks&Itemid=23', 'url', 1, 0, 0, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1'), (25, 'mainmenu', 'FAQs', 'index.php?option=com_content&task=category§ionid=3&id=7', 'content_category', 0, 0, 7, 0, 19, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npage_title=1\npageclass_sfx=\nback_button=\norderby=\ndate_format=\ndate=\nauthor=\ntitle=1\nhits=\nheadings=1\nnavigation=1\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title\nother_cat=1\nempty_cat=0\ncat_items=1\ncat_description=1'), (26, 'mainmenu', 'Albums photos', 'index.php?option=com_zoom', 'components', 1, 0, 43, 0, 16, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''), (27, 'mainmenu', 'PAXXGallery', 'index.php?option=com_paxxgallery', 'components', -2, 0, 44, 0, 9, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''), (28, 'usermenu', 'PAXXGallery', 'index.php?option=com_paxxgallery&userid=me', 'components', 0, 0, 44, 0, 67, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''), (29, 'mainmenu', 'PaXXGallery', 'index.php?option=com_paxxgallery', 'components', -2, 0, 44, 0, 12, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''), (30, 'mainmenu', 'OTF Gallery', 'index.php?option=com_otf_gallery', 'components', -2, 0, 50, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''), (31, 'mainmenu', 'PonyGalleryee', 'index.php?option=com_ponygallery', 'components', -2, 0, 52, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''), (32, 'mainmenu', 'Travaux d''élèves', 'index.php?option=com_content&task=blogsection&id=10', 'content_blog_section', 1, 0, 10, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=1\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid=10'), (33, 'mainmenu', 'Activités artistiques', 'index.php?option=com_content&task=blogsection&id=7', 'content_blog_section', 1, 0, 7, 0, 6, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=1\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid=7'), (34, 'mainmenu', 'Activités sportives', 'index.php?option=com_content&task=blogsection&id=8', 'content_blog_section', 1, 0, 8, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=1\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid=8'), (35, 'mainmenu', 'Projets d''Activités Educ.', 'index.php?option=com_content&task=blogsection&id=5', 'content_blog_section', 1, 0, 5, 0, 14, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=1\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid=5'), (36, 'mainmenu', 'Centre de documentation', 'index.php?option=com_content&task=blogsection&id=6', 'content_blog_section', 1, 0, 6, 0, 15, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=1\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid=6'), (37, 'mainmenu', 'Arts plastiques', 'index.php?option=com_content&task=blogcategory&id=17', 'content_blog_category', 1, 33, 17, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=1\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\ncategoryid=17'), (38, 'mainmenu', 'Educ. musicale', 'index.php?option=com_content&task=blogcategory&id=18', 'content_blog_category', 1, 33, 18, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=1\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\ncategoryid=18'), (39, 'mainmenu', 'Divers', 'index.php?option=com_content&task=blogcategory&id=19', 'content_blog_category', 1, 32, 19, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=1\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\ncategoryid=19'), (40, 'mainmenu', 'Expositions', 'index.php?option=com_content&task=blogcategory&id=15', 'content_blog_category', 1, 32, 15, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=1\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\ncategoryid=15'), (41, 'mainmenu', 'Vie scolaire', 'index.php?option=com_content&task=blogsection&id=4', 'content_blog_section', 1, 0, 4, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=1\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid=4'), (42, 'mainmenu', 'Edito', 'index.php?option=com_content&task=blogcategory&id=16', 'content_blog_category', 1, 41, 16, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=0\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\ncategoryid=16'), (43, 'mainmenu', 'Emplois du temps', 'index.php?option=com_content&task=blogcategory&id=21', 'content_blog_category', 1, 41, 21, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=1\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\ncategoryid=21'), (44, 'othermenu', 'Utilisateurs enregistrés', 'index.php?option=com_login', 'components', 1, 0, 15, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader_login=\nlogin=\nlogin_message=0\ndescription_login=0\ndescription_login_text=\nimage_login=\nimage_login_align=right\nheader_logout=\nlogout=\nlogout_message=1\ndescription_logout=1\ndescription_logout_text=\nimage_logout='); -- -------------------------------------------------------- -- -- Structure de la table `jos_messages` -- CREATE TABLE `jos_messages` ( `message_id` int(10) unsigned NOT NULL auto_increment, `user_id_from` int(10) unsigned NOT NULL default '0', `user_id_to` int(10) unsigned NOT NULL default '0', `folder_id` int(10) unsigned NOT NULL default '0', `date_time` datetime NOT NULL default '0000-00-00 00:00:00', `state` int(11) NOT NULL default '0', `priority` int(1) unsigned NOT NULL default '0', `subject` varchar(230) NOT NULL default '', `message` text NOT NULL, PRIMARY KEY (`message_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Contenu de la table `jos_messages` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_messages_cfg` -- CREATE TABLE `jos_messages_cfg` ( `user_id` int(10) unsigned NOT NULL default '0', `cfg_name` varchar(100) NOT NULL default '', `cfg_value` varchar(255) NOT NULL default '', UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_messages_cfg` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_mgm` -- CREATE TABLE `jos_mgm` ( `img_id` int(11) NOT NULL auto_increment, `img_name` varchar(100) default NULL, `img_path` varchar(255) default NULL, `img_pending` tinyint(4) NOT NULL default '0', `img_published` tinyint(4) NOT NULL default '1', `img_thumbsbyrow` int(11) NOT NULL default '5', `img_tablewidth` varchar(6) NOT NULL default '100%', `img_tablealigment` varchar(7) NOT NULL default 'center', `img_fullsizelimit` tinyint(4) NOT NULL default '1', `img_fullmaxx` int(11) default '750', `img_fullmaxy` int(11) NOT NULL default '550', `img_quality` tinyint(4) NOT NULL default '75', `img_thumbx` int(11) NOT NULL default '100', `img_thumby` int(11) NOT NULL default '100', `img_fullimagemark` int(11) default '0', `img_thumbnailmark` int(11) default '0', `img_ordering` int(11) NOT NULL default '0', `img_expandimages` tinyint(4) NOT NULL default '0', `img_usethumbdir` tinyint(4) NOT NULL default '1', `img_thumbprefix` varchar(20) NOT NULL default 'thumb_', `img_thumbdirectory` varchar(20) NOT NULL default 'thumbs', `img_template` int(11) NOT NULL default '0', `img_date` date default NULL, `img_description` text NOT NULL, `img_accessmode` tinyint(4) NOT NULL default '0', `img_author` varchar(50) NOT NULL default '', PRIMARY KEY (`img_id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `jos_mgm` -- INSERT DELAYED IGNORE INTO `jos_mgm` (`img_id`, `img_name`, `img_path`, `img_pending`, `img_published`, `img_thumbsbyrow`, `img_tablewidth`, `img_tablealigment`, `img_fullsizelimit`, `img_fullmaxx`, `img_fullmaxy`, `img_quality`, `img_thumbx`, `img_thumby`, `img_fullimagemark`, `img_thumbnailmark`, `img_ordering`, `img_expandimages`, `img_usethumbdir`, `img_thumbprefix`, `img_thumbdirectory`, `img_template`, `img_date`, `img_description`, `img_accessmode`, `img_author`) VALUES (1, 'gallerie1', '/essai1', 0, 1, 5, '5', 'center', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', '', 0, NULL, '', 0, ''); -- -------------------------------------------------------- -- -- Structure de la table `jos_mgm_cnf` -- CREATE TABLE `jos_mgm_cnf` ( `cnf_id` int(11) NOT NULL auto_increment, `cnf_testvalue` varchar(20) NOT NULL default '', `cnf_timelimit` tinyint(4) NOT NULL default '1', `cnf_maxtime` int(11) NOT NULL default '30', PRIMARY KEY (`cnf_id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `jos_mgm_cnf` -- INSERT DELAYED IGNORE INTO `jos_mgm_cnf` (`cnf_id`, `cnf_testvalue`, `cnf_timelimit`, `cnf_maxtime`) VALUES (1, '', 1, 30); -- -------------------------------------------------------- -- -- Structure de la table `jos_mgm_img` -- CREATE TABLE `jos_mgm_img` ( `iim_id` int(11) NOT NULL auto_increment, `iim_galid` int(11) default '0', `iim_fullname` varchar(255) default NULL, `iim_published` int(11) NOT NULL default '1', `iim_order` int(11) default NULL, `iim_description` varchar(255) default NULL, PRIMARY KEY (`iim_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Contenu de la table `jos_mgm_img` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_modules` -- CREATE TABLE `jos_modules` ( `id` int(11) NOT NULL auto_increment, `title` text NOT NULL, `content` text NOT NULL, `ordering` int(11) NOT NULL default '0', `position` varchar(10) default NULL, `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', `module` varchar(50) default NULL, `numnews` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', `showtitle` tinyint(3) unsigned NOT NULL default '1', `params` text NOT NULL, `iscore` tinyint(4) NOT NULL default '0', `client_id` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), KEY `published` (`published`,`access`), KEY `newsfeeds` (`module`,`published`) ) TYPE=MyISAM AUTO_INCREMENT=56 ; -- -- Contenu de la table `jos_modules` -- INSERT DELAYED IGNORE INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (1, 'Sondage', '', 7, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_poll', 0, 0, 1, 'cache=0\nmoduleclass_sfx=', 0, 0), (2, 'User Menu', '', 5, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 1, 1, 'menutype=usermenu', 1, 0), (3, 'Menu principal', '', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'class_sfx=\nmoduleclass_sfx=\nmenutype=mainmenu\nmenu_style=vert_indent\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=', 1, 0), (4, 'Accès réservé', '', 6, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_login', 0, 0, 1, 'moduleclass_sfx=\npretext=\nposttext=\nlogin=\nlogout=\nlogin_message=0\nlogout_message=0\ngreeting=1\nname=0', 1, 0), (5, 'Syndication', '', 8, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_rssfeed', 0, 0, 1, 'text=\ncache=0\nmoduleclass_sfx=\nrss091=1\nrss10=1\nrss20=1\natom=1\nopml=1\nrss091_image=\nrss10_image=\nrss20_image=\natom_image=\nopml_image=', 1, 0), (6, 'Articles récents', '', 2, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_latestnews', 0, 0, 1, 'moduleclass_sfx=\ncache=0\ntype=1\nshow_front=1\ncount=5\ncatid=\nsecid=', 1, 0), (7, 'Statistics', '', 7, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_stats', 0, 0, 1, 'serverinfo=1\nsiteinfo=1\ncounter=1\nincrease=0\nmoduleclass_sfx=', 0, 0), (8, 'En ligne...', '', 5, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_whosonline', 0, 0, 1, 'showmode=2\nmoduleclass_sfx=', 0, 0), (9, 'Popular', '', 6, 'user2', 0, '0000-00-00 00:00:00', 0, 'mod_mostread', 0, 0, 1, '', 0, 0), (10, 'Choix d''affichage', '', 9, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_templatechooser', 0, 0, 1, 'title_length=20\nshow_preview=1\npreview_width=140\npreview_height=90\nmoduleclass_sfx=', 0, 0), (11, 'Archive', '', 10, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_archive', 0, 0, 1, '', 1, 0), (12, 'Sections', '', 11, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_sections', 0, 0, 1, '', 1, 0), (13, 'Newsflash', '', 1, 'top', 0, '0000-00-00 00:00:00', 0, 'mod_newsflash', 0, 0, 1, 'catid=3\r\nstyle=random\r\nitems=\r\nmoduleclass_sfx=', 0, 0), (14, 'Related Items', '', 12, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_related_items', 0, 0, 1, '', 0, 0), (15, 'Search', '', 1, 'user4', 0, '0000-00-00 00:00:00', 1, 'mod_search', 0, 0, 0, '', 0, 0), (16, 'Image au hasard (joomla)', '', 8, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_random_image', 0, 0, 1, 'type=jpg,gif\nfolder=images/zoom/album1/\nlink=\nwidth=\nheight=\nmoduleclass_sfx=', 0, 0), (17, 'Top Menu', '', 1, 'user3', 0, '0000-00-00 00:00:00', 0, 'mod_mainmenu', 0, 0, 0, 'menutype=topmenu\nmenu_style=list_flat\nmenu_images=n\nmenu_images_align=left\nexpand_menu=n\nclass_sfx=-nav\nmoduleclass_sfx=\nindent_image1=0\nindent_image2=0\nindent_image3=0\nindent_image4=0\nindent_image5=0\nindent_image6=0', 1, 0), (18, 'Banners', '', 1, 'banner', 0, '0000-00-00 00:00:00', 0, 'mod_banners', 0, 0, 0, 'banner_cids=\nmoduleclass_sfx=\n', 1, 0), (19, 'Components', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_components', 0, 99, 1, '', 1, 1), (20, 'Popular', '', 3, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_popular', 0, 99, 1, '', 0, 1), (21, 'Latest Items', '', 4, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_latest', 0, 99, 1, '', 0, 1), (22, 'Menu Stats', '', 5, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_stats', 0, 99, 1, '', 0, 1), (23, 'Unread Messages', '', 1, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_unread', 0, 99, 1, '', 1, 1), (24, 'Online Users', '', 2, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_online', 0, 99, 1, '', 1, 1), (25, 'Full Menu', '', 1, 'top', 0, '0000-00-00 00:00:00', 1, 'mod_fullmenu', 0, 99, 1, '', 1, 1), (26, 'Pathway', '', 1, 'pathway', 0, '0000-00-00 00:00:00', 1, 'mod_pathway', 0, 99, 1, '', 1, 1), (27, 'Toolbar', '', 1, 'toolbar', 0, '0000-00-00 00:00:00', 1, 'mod_toolbar', 0, 99, 1, '', 1, 1), (28, 'System Message', '', 1, 'inset', 0, '0000-00-00 00:00:00', 1, 'mod_mosmsg', 0, 99, 1, '', 1, 1), (29, 'Quick Icons', '', 1, 'icon', 0, '0000-00-00 00:00:00', 1, 'mod_quickicon', 0, 99, 1, '', 1, 1), (30, 'Accès réservés', '', 4, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'class_sfx=\nmoduleclass_sfx=\nmenutype=othermenu\nmenu_style=vert_indent\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=', 0, 0), (31, 'Wrapper', '', 13, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_wrapper', 0, 0, 1, '', 0, 0), (32, 'Logged', '', 0, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_logged', 0, 99, 1, '', 0, 1), (33, 'StopPressModule', '', 3, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_stop_press', 0, 0, 1, 'contentid=10', 0, 0), (34, 'Slider Module', '', 14, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_paxxgallery', 0, 0, 1, '', 0, 0), (35, 'Custom QuickIcons', '', 15, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_customquickicons', 0, 99, 1, '', 0, 1), (55, 'A venir...', '', 4, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_jcalpro_latest', 0, 0, 1, 'categories=\nmoduleclass_sfx=\nnumber_of_events_to_list_upcoming=5\nnumber_of_events_to_list_recent=0\ntitle_max_length=256\nshow_times=1\nshow_category=1\nshow_description=1\ndescription_max_length=256\nstrip_bbcode_from_description=3\nshow_recurrent_events=3\noutput=1\nevent_separator=\nshow_month_separators=0\nmonth_separator_style=background-color: none; border-top-color: #777777; border-bottom-color: #777777; border-top-width: 1px; border-bottom-width: 1px; border-top-style: solid; border-bottom-style: solid; font-style: italic; font-weight: bold; margin: 4px; text-align: center\nno_upcoming_events_text=There are no upcoming events currently scheduled.\nrecent_events_text=Recent Events\nrecent_events_style=font-size: 130%; font-weight: bold; background-color: none; border-top-color: #333333; border-bottom-color: #333333; border-top-width: 2px; border-bottom-width: 2px; border-top-style: solid; border-bottom-style: solid; margin: 10px; text-align: center\nshow_full_calendar_link=1\nfull_calendar_link_text=Voir le calendrier complet\nshow_add_event_link=1\nadd_event_text=Ajouter un événement\nuse_extcal_locale_settings=0\ntime_format_12_or_24=0\ndays_view=0\ndate_format=%B %d, %Y\ncomponent_itemid=', 0, 0), (41, 'mod_zoom_info', '', 2, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_zoom_info', 0, 0, 1, 'moduleclass_sfx=\nZMI_intro=1\nZMI_intromessage=Statics about the mediagallery (All media, published, protected, unpublished)\nZMI_mediacount=1\nZMI_catscount=1\nZMI_commentscount=1\nZMI_hitscount=1\nZMI_votescount=1\nZMIlayout_newline=0\nZMIlayout_spacer=1\nZMIlayout_align=0\nZMILang_mediacount=Count of media:\nZMILang_catscount=Count of cats:\nZMILang_commentscount=Count of comments:\nZMILang_hitscount=Count of hits:\nZMILang_votescount=Count of votes:', 0, 0), (42, 'mod_zoom_menue', '', 3, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_zoom_menue', 0, 0, 1, 'info=PLEASE NOTE THAT SOME TEMPLATES CAN OVERTAKE THE CONTROL OF SOME USED STYLES, please notify me if it''s so. !!!\nzoomMenueTOPspacer=0\nzoomMenueImageW=40\nzoomMenueImageH=30\nzoomMenueRoot=0\nzoomMenueRootRand=0\nzoomMenueDCut=18\nzoomMenueSub=0\nzoomMenueSubDCut=18\nzoomMenueSubImageW=24\nzoomMenueSubImageH=18\nzoomMenueStyleWidth=160px\nzoomMenueStyleFont=arial\nzoomMenueStyleFontSize=12px\nzoomMenueStyleFontColorA=#c0c0c0\nzoomMenueStyleFontColorB=#ff6600\nzoomMenueStyleBgColorA=#000000\nzoomMenueStyleBgColorB=#c0c0c0', 0, 0), (43, 'Image au hasard', '', 6, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_zoom_pics', 0, 0, 1, 'moduleclass_sfx=\nZMmethod=2\nZMonlythiscat=0\nZMnumerofpics=1\nZMshowmeth=0\nZMshowcat=0\nZMshowcatlinked=1\nZMshowhits=0\nZMshowvotes=0\nZMshowfilename=0\nZMshowname=1\nZMshowdesc=0\nZMimglinking=2\nZMviemode=0\nZMitemidpic=0\nZMstyleallign=not\nZMstylespacer=0\nZMstylespacersize=0\nZMstyleresizeimage=0\nZMstyleresizeimagewidth=150\nZMmulti_direction=vertical\nZMstylescroller=0\nZMstylescrollerDirection=up\nZMstylescrollerW=150\nZMstylescrollerH=200\nZMstylescrollerSpeed=1\nZMstylescrollerDelay=10\nZMLang_random=random\nZMLang_newest=newest\nZMLang_hits=hits\nZMLang_votes=votes', 0, 0), (54, 'Agenda', '', 1, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_jcalpro_minical', 0, 0, 1, 'mini_cal_def_picture=def_pic.gif\npicture=0\nnavigation_controls=1\nuse_component_itemid=0\ncomponent_itemid_mini=\nshow_minical_add_event_button=1\nmonth_to_display=0\ntarget=\nmoduleclass_sfx=', 0, 0); -- -------------------------------------------------------- -- -- Structure de la table `jos_modules_menu` -- CREATE TABLE `jos_modules_menu` ( `moduleid` int(11) NOT NULL default '0', `menuid` int(11) NOT NULL default '0', PRIMARY KEY (`moduleid`,`menuid`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_modules_menu` -- INSERT DELAYED IGNORE INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (1, 1), (2, 0), (3, 0), (4, 1), (5, 1), (6, 1), (6, 36), (8, 1), (9, 1), (9, 2), (9, 4), (9, 27), (9, 36), (10, 1), (13, 0), (15, 0), (16, 1), (17, 0), (18, 0), (30, 1), (33, 1), (34, 0), (35, 0), (41, 0), (42, 1), (43, 1), (54, 0), (55, 0); -- -------------------------------------------------------- -- -- Structure de la table `jos_newsfeeds` -- CREATE TABLE `jos_newsfeeds` ( `catid` int(11) NOT NULL default '0', `id` int(11) NOT NULL auto_increment, `name` text NOT NULL, `link` text NOT NULL, `filename` varchar(200) default NULL, `published` tinyint(1) NOT NULL default '0', `numarticles` int(11) unsigned NOT NULL default '1', `cache_time` int(11) unsigned NOT NULL default '3600', `checked_out` tinyint(3) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `published` (`published`) ) TYPE=MyISAM AUTO_INCREMENT=11 ; -- -- Contenu de la table `jos_newsfeeds` -- INSERT DELAYED IGNORE INTO `jos_newsfeeds` (`catid`, `id`, `name`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`) VALUES (4, 1, 'Joomla! - Official News', 'http://www.joomla.org/index.php?option=com_rss_xtd&feed=RSS2.0&type=com_frontpage&Itemid=1', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 8), (4, 2, 'Joomla! - Community News', 'http://www.joomla.org/index.php?option=com_rss_xtd&feed=RSS2.0&type=com_content&task=blogcategory&id=0&Itemid=33', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 9), (4, 3, 'OpenSourceMatters', 'http://www.opensourcematters.org/index2.php?option=com_rss&feed=RSS2.0&no_html=1', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 10), (10, 4, 'Linux Today', 'http://linuxtoday.com/backend/my-netscape.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 1), (5, 5, 'Business News', 'http://headlines.internet.com/internetnews/bus-news/news.rss', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 2), (11, 6, 'Web Developer News', 'http://headlines.internet.com/internetnews/wd-news/news.rss', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 3), (10, 7, 'Linux Central:New Products', 'http://linuxcentral.com/backend/lcnew.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 4), (10, 8, 'Linux Central:Best Selling', 'http://linuxcentral.com/backend/lcbestns.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 5), (10, 9, 'Linux Central:Daily Specials', 'http://linuxcentral.com/backend/lcspecialns.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 6), (9, 10, 'Internet:Finance News', 'http://headlines.internet.com/internetnews/fina-news/news.rss', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 7); -- -------------------------------------------------------- -- -- Structure de la table `jos_paxxconfig` -- CREATE TABLE `jos_paxxconfig` ( `id` int(11) NOT NULL auto_increment, `key` varchar(64) default NULL, `value` varchar(64) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=15 ; -- -- Contenu de la table `jos_paxxconfig` -- INSERT DELAYED IGNORE INTO `jos_paxxconfig` (`id`, `key`, `value`) VALUES (1, 'ftpserver', 'localhost'), (2, 'ftpuser', 'ftp-user'), (3, 'ftppwd', 'ftp-password'), (4, 'useFTP', '0'), (5, 'allowZIP', '1'), (6, 'doCHMOD', '1'), (7, 'chstr', '0777'), (8, 'imagedir', 'images/PAXXGalleries/paxx'), (9, 'joomlabase', 'joomla/'), (10, 'autoGal', '1'), (11, 'autoPic', '1'), (12, 'prefix', 'small_'), (13, 'aprSystem', '1'), (14, 'userGal', '0'); -- -------------------------------------------------------- -- -- Structure de la table `jos_paxxfiles` -- CREATE TABLE `jos_paxxfiles` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) default NULL, `desc` text, `filename` text, `date` int(16) unsigned default NULL, `gid` int(11) unsigned default NULL, `published` int(1) unsigned default '0', `w` int(11) unsigned default '0', `h` int(11) unsigned default '0', `ordering` int(11) unsigned default '0', `checked_out` tinyint(1) default '0', `userid` int(11) unsigned default '0', `groupid` int(11) unsigned default '0', `access` tinyint(4) unsigned default '0', `approved` tinyint(1) unsigned default '0', `approved_by` int(11) unsigned default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Contenu de la table `jos_paxxfiles` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_paxxgalleries` -- CREATE TABLE `jos_paxxgalleries` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) default NULL, `desc` text, `published` int(1) unsigned default '0', `date` int(16) unsigned default NULL, `num` int(10) unsigned default '0', `ordering` int(10) unsigned default '0', `checked_out` tinyint(1) default '0', `img` int(10) unsigned default '0', `userid` int(11) unsigned default '0', `groupid` int(11) unsigned default '0', `access` tinyint(4) unsigned default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Contenu de la table `jos_paxxgalleries` -- INSERT DELAYED IGNORE INTO `jos_paxxgalleries` (`id`, `name`, `desc`, `published`, `date`, `num`, `ordering`, `checked_out`, `img`, `userid`, `groupid`, `access`) VALUES (1, 'new Gallery1', 'description 1', 1, 1142759716, 0, 1, 0, 0, 0, 0, 0), (2, 'new Gallery2', '', 1, 1142759722, 0, 2, 0, 0, 0, 0, 0); -- -------------------------------------------------------- -- -- Structure de la table `jos_paxxusersettings` -- CREATE TABLE `jos_paxxusersettings` ( `id` int(11) NOT NULL auto_increment, `userid` int(11) unsigned NOT NULL default '0', `template` varchar(50) NOT NULL default 'default', `galName` varchar(50) default 'PAXXGallery', `ctWidth` int(11) default '550', `ctHeight` int(11) default '410', `slideTimeout` int(11) default '2000', `defName` varchar(50) default 'filename', `defDesc` varchar(50) default '', `maxSize` int(11) default '500', `thumbSize` int(11) default '100', PRIMARY KEY (`id`), UNIQUE KEY `userid` (`userid`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Contenu de la table `jos_paxxusersettings` -- INSERT DELAYED IGNORE INTO `jos_paxxusersettings` (`id`, `userid`, `template`, `galName`, `ctWidth`, `ctHeight`, `slideTimeout`, `defName`, `defDesc`, `maxSize`, `thumbSize`) VALUES (1, 0, 'default', 'PAXXGallery', 550, 410, 2000, 'filename', '', 500, 100); -- -------------------------------------------------------- -- -- Structure de la table `jos_poll_data` -- CREATE TABLE `jos_poll_data` ( `id` int(11) NOT NULL auto_increment, `pollid` int(4) NOT NULL default '0', `text` text NOT NULL, `hits` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `pollid` (`pollid`,`text`(1)) ) TYPE=MyISAM AUTO_INCREMENT=13 ; -- -- Contenu de la table `jos_poll_data` -- INSERT DELAYED IGNORE INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (1, 14, 'Absolutely simple', 1), (2, 14, 'Reasonably easy', 0), (3, 14, 'Not straight-forward but I worked it out', 0), (4, 14, 'I had to install extra server stuff', 0), (5, 14, 'I had no idea and got my friend to do it', 0), (6, 14, 'My dog ran away with the README ...', 0), (7, 14, '', 0), (8, 14, '', 0), (9, 14, '', 0), (10, 14, '', 0), (11, 14, '', 0), (12, 14, '', 0); -- -------------------------------------------------------- -- -- Structure de la table `jos_poll_date` -- CREATE TABLE `jos_poll_date` ( `id` bigint(20) NOT NULL auto_increment, `date` datetime NOT NULL default '0000-00-00 00:00:00', `vote_id` int(11) NOT NULL default '0', `poll_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `poll_id` (`poll_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Contenu de la table `jos_poll_date` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_poll_menu` -- CREATE TABLE `jos_poll_menu` ( `pollid` int(11) NOT NULL default '0', `menuid` int(11) NOT NULL default '0', PRIMARY KEY (`pollid`,`menuid`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_poll_menu` -- INSERT DELAYED IGNORE INTO `jos_poll_menu` (`pollid`, `menuid`) VALUES (14, 1); -- -------------------------------------------------------- -- -- Structure de la table `jos_polls` -- CREATE TABLE `jos_polls` ( `id` int(11) unsigned NOT NULL auto_increment, `title` varchar(100) NOT NULL default '', `voters` int(9) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', `access` int(11) NOT NULL default '0', `lag` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=15 ; -- -- Contenu de la table `jos_polls` -- INSERT DELAYED IGNORE INTO `jos_polls` (`id`, `title`, `voters`, `checked_out`, `checked_out_time`, `published`, `access`, `lag`) VALUES (14, 'This Joomla! installation was ....', 0, 0, '0000-00-00 00:00:00', 1, 0, 86400); -- -------------------------------------------------------- -- -- Structure de la table `jos_sections` -- CREATE TABLE `jos_sections` ( `id` int(11) NOT NULL auto_increment, `title` varchar(50) NOT NULL default '', `name` varchar(255) NOT NULL default '', `image` varchar(100) NOT NULL default '', `scope` varchar(50) NOT NULL default '', `image_position` varchar(10) NOT NULL default '', `description` text NOT NULL, `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_scope` (`scope`) ) TYPE=MyISAM AUTO_INCREMENT=12 ; -- -- Contenu de la table `jos_sections` -- INSERT DELAYED IGNORE INTO `jos_sections` (`id`, `title`, `name`, `image`, `scope`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `ordering`, `access`, `count`, `params`) VALUES (1, 'News', 'The News', '', 'content', 'right', 'Select a news topic from the list below, then select a news article to read.\r\n', 1, 0, '0000-00-00 00:00:00', 7, 0, 1, ''), (2, 'Newsflashes', 'Newsflashes', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 8, 0, 1, ''), (3, 'FAQs', 'Frequently Asked Questions', 'pastarchives.jpg', 'content', 'left', 'From the list below choose one of our FAQs topics, then select an FAQ to read. If you have a question which is not in this section, please contact us.', 0, 0, '0000-00-00 00:00:00', 9, 0, 1, ''), (4, 'Vie scolaire', 'Vie scolaire', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 6, 0, 3, ''), (5, 'Projet d''Activités Educ.', 'Projet d''Activités Educ.', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 5, 0, 0, ''), (6, 'Centre de documentation', 'Centre de documentation', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 4, 0, 0, ''), (7, 'Activités artistiques', 'Activités artistiques', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 3, 0, 4, ''), (8, 'Activités sportives', 'Activités sportives', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 2, 0, 0, ''), (10, 'Travaux d''élèves', 'Travaux d''élèves', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 1, 0, 3, ''); -- -------------------------------------------------------- -- -- Structure de la table `jos_session` -- CREATE TABLE `jos_session` ( `username` varchar(50) default '', `time` varchar(14) default '', `session_id` varchar(200) NOT NULL default '0', `guest` tinyint(4) default '1', `userid` int(11) default '0', `usertype` varchar(50) default '', `gid` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`session_id`), KEY `whosonline` (`guest`,`usertype`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_session` -- INSERT DELAYED IGNORE INTO `jos_session` (`username`, `time`, `session_id`, `guest`, `userid`, `usertype`, `gid`) VALUES ('', '1194266729', '408fc26a88f7327597ed94fc101ee3fc', 1, 0, '', 0); -- -------------------------------------------------------- -- -- Structure de la table `jos_stats_agents` -- CREATE TABLE `jos_stats_agents` ( `agent` varchar(255) NOT NULL default '', `type` tinyint(1) unsigned NOT NULL default '0', `hits` int(11) unsigned NOT NULL default '1' ) TYPE=MyISAM; -- -- Contenu de la table `jos_stats_agents` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_template_positions` -- CREATE TABLE `jos_template_positions` ( `id` int(11) NOT NULL auto_increment, `position` varchar(10) NOT NULL default '', `description` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=28 ; -- -- Contenu de la table `jos_template_positions` -- INSERT DELAYED IGNORE INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (1, 'left', ''), (2, 'right', ''), (3, 'top', ''), (4, 'bottom', ''), (5, 'inset', ''), (6, 'banner', ''), (7, 'header', ''), (8, 'footer', ''), (9, 'newsflash', ''), (10, 'legals', ''), (11, 'pathway', ''), (12, 'toolbar', ''), (13, 'cpanel', ''), (14, 'user1', ''), (15, 'user2', ''), (16, 'user3', ''), (17, 'user4', ''), (18, 'user5', ''), (19, 'user6', ''), (20, 'user7', ''), (21, 'user8', ''), (22, 'user9', ''), (23, 'advert1', ''), (24, 'advert2', ''), (25, 'advert3', ''), (26, 'icon', ''), (27, 'debug', ''); -- -------------------------------------------------------- -- -- Structure de la table `jos_templates_menu` -- CREATE TABLE `jos_templates_menu` ( `template` varchar(50) NOT NULL default '', `menuid` int(11) NOT NULL default '0', `client_id` tinyint(4) NOT NULL default '0', PRIMARY KEY (`template`,`menuid`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_templates_menu` -- INSERT DELAYED IGNORE INTO `jos_templates_menu` (`template`, `menuid`, `client_id`) VALUES ('namibia', 0, 0), ('joomla_admin', 0, 1); -- -------------------------------------------------------- -- -- Structure de la table `jos_users` -- CREATE TABLE `jos_users` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `username` varchar(25) NOT NULL default '', `email` varchar(100) NOT NULL default '', `password` varchar(100) NOT NULL default '', `usertype` varchar(25) NOT NULL default '', `block` tinyint(4) NOT NULL default '0', `sendEmail` tinyint(4) default '0', `gid` tinyint(3) unsigned NOT NULL default '1', `registerDate` datetime NOT NULL default '0000-00-00 00:00:00', `lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00', `activation` varchar(100) NOT NULL default '', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `usertype` (`usertype`), KEY `idx_name` (`name`) ) TYPE=MyISAM AUTO_INCREMENT=64 ; -- -- Contenu de la table `jos_users` -- INSERT DELAYED IGNORE INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES (62, 'Administrator', 'admin', 'jibe@ici.fr', '3bfbcb7e083188811bc9d18600e90a94:B0UsyX9bTijKMIDW', 'Super Administrator', 0, 0, 25, '2007-10-27 19:17:22', '2007-11-05 13:45:29', '', 'editor='), (63, 'utilisateur1', 'utilisateur1', 'utilisateur1@ici.fr', 'e8af665706222bf0c0c20f97de44644a:WxxYXCZDPWXjrA29', 'Administrator', 0, 0, 24, '2007-10-27 19:30:04', '2007-10-28 21:31:00', '', 'editor=jce\nexpired=\nexpired_time='); -- -------------------------------------------------------- -- -- Structure de la table `jos_usertypes` -- CREATE TABLE `jos_usertypes` ( `id` tinyint(3) unsigned NOT NULL default '0', `name` varchar(50) NOT NULL default '', `mask` varchar(11) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_usertypes` -- INSERT DELAYED IGNORE INTO `jos_usertypes` (`id`, `name`, `mask`) VALUES (0, 'superadministrator', ''), (1, 'administrator', ''), (2, 'editor', ''), (3, 'user', ''), (4, 'author', ''), (5, 'publisher', ''), (6, 'manager', ''); -- -------------------------------------------------------- -- -- Structure de la table `jos_weblinks` -- CREATE TABLE `jos_weblinks` ( `id` int(11) unsigned NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `sid` int(11) NOT NULL default '0', `title` varchar(250) NOT NULL default '', `url` varchar(250) NOT NULL default '', `description` varchar(250) NOT NULL default '', `date` datetime NOT NULL default '0000-00-00 00:00:00', `hits` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `archived` tinyint(1) NOT NULL default '0', `approved` tinyint(1) NOT NULL default '1', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `catid` (`catid`,`published`,`archived`) ) TYPE=MyISAM AUTO_INCREMENT=6 ; -- -- Contenu de la table `jos_weblinks` -- INSERT DELAYED IGNORE INTO `jos_weblinks` (`id`, `catid`, `sid`, `title`, `url`, `description`, `date`, `hits`, `published`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `params`) VALUES (1, 2, 0, 'Joomla!', 'http://www.joomla.org', 'Home of Joomla!', '2005-02-14 15:19:02', 2, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0'), (2, 2, 0, 'php.net', 'http://www.php.net', 'The language that Joomla! is developed in', '2004-07-07 11:33:24', 0, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, ''), (3, 2, 0, 'MySQL', 'http://www.mysql.com', 'The database that Joomla! uses', '2004-07-07 10:18:31', 0, 1, 0, '0000-00-00 00:00:00', 5, 0, 1, ''), (4, 2, 0, 'OpenSourceMatters', 'http://www.opensourcematters.org', 'Home of OSM', '2005-02-14 15:19:02', 2, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0'), (5, 2, 0, 'Joomla! - Forums', 'http://forum.joomla.org', 'Joomla! Forums', '2005-02-14 15:19:02', 2, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0'); -- -------------------------------------------------------- -- -- Structure de la table `jos_zoom` -- CREATE TABLE `jos_zoom` ( `catid` int(11) NOT NULL auto_increment, `catname` varchar(50) default '0', `catdescr` mediumtext, `catdir` varchar(50) default '0', `catimg` int(11) default NULL, `catpassword` varchar(100) NOT NULL default '', `catkeywords` varchar(240) NOT NULL default '', `subcat_id` int(11) NOT NULL default '0', `pos` int(3) NOT NULL default '0', `hideMsg` tinyint(1) NOT NULL default '0', `shared` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '1', `uid` int(11) NOT NULL default '0', `catmembers` varchar(240) NOT NULL default '', `custom_order` int(20) default NULL, PRIMARY KEY (`catid`), KEY `catdir_search` (`catdir`), KEY `rel_subcats` (`subcat_id`) ) TYPE=MyISAM AUTO_INCREMENT=7 ; -- -- Contenu de la table `jos_zoom` -- INSERT DELAYED IGNORE INTO `jos_zoom` (`catid`, `catname`, `catdescr`, `catdir`, `catimg`, `catpassword`, `catkeywords`, `subcat_id`, `pos`, `hideMsg`, `shared`, `published`, `uid`, `catmembers`, `custom_order`) VALUES (6, 'Album2', '', 'Album2', NULL, '', '', 0, 0, 0, 1, 1, 62, '1', NULL), (5, 'Album1', 'Description temporaire, veuillez la modifier.', 'album1', NULL, '', '', 0, 0, 0, 1, 1, 62, '1', NULL); -- -------------------------------------------------------- -- -- Structure de la table `jos_zoom_comments` -- CREATE TABLE `jos_zoom_comments` ( `cmtid` int(11) NOT NULL auto_increment, `imgid` int(11) NOT NULL default '0', `cmtname` varchar(40) NOT NULL default '', `cmtcontent` text NOT NULL, `cmtdate` timestamp NOT NULL, PRIMARY KEY (`cmtid`), KEY `imgid` (`imgid`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Contenu de la table `jos_zoom_comments` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_zoom_ecards` -- CREATE TABLE `jos_zoom_ecards` ( `ecdid` varchar(25) NOT NULL default '', `imgid` int(11) NOT NULL default '0', `to_name` varchar(50) NOT NULL default '', `from_name` varchar(50) NOT NULL default '', `to_email` varchar(75) NOT NULL default '', `from_email` varchar(75) NOT NULL default '', `message` text NOT NULL, `end_date` date NOT NULL default '0000-00-00', `user_ip` varchar(25) NOT NULL default '', PRIMARY KEY (`ecdid`), KEY `ecard_img` (`imgid`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_zoom_ecards` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_zoom_editmon` -- CREATE TABLE `jos_zoom_editmon` ( `edtid` int(11) NOT NULL auto_increment, `user_session` varchar(200) NOT NULL default '0', `vote_time` varchar(14) default NULL, `comment_time` varchar(14) default NULL, `pass_time` varchar(14) default NULL, `lightbox_time` varchar(14) default NULL, `lightbox_file` varchar(40) default NULL, `object_id` int(11) NOT NULL default '0', PRIMARY KEY (`edtid`), KEY `edit_session` (`user_session`), KEY `object` (`object_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Contenu de la table `jos_zoom_editmon` -- -- -------------------------------------------------------- -- -- Structure de la table `jos_zoom_getid3_cache` -- CREATE TABLE `jos_zoom_getid3_cache` ( `filename` varchar(255) NOT NULL default '', `filesize` int(11) NOT NULL default '0', `filetime` int(11) NOT NULL default '0', `analyzetime` int(11) NOT NULL default '0', `value` text NOT NULL, PRIMARY KEY (`filename`,`filesize`,`filetime`) ) TYPE=MyISAM; -- -- Contenu de la table `jos_zoom_getid3_cache` -- INSERT DELAYED IGNORE INTO `jos_zoom_getid3_cache` (`filename`, `filesize`, `filetime`, `analyzetime`, `value`) VALUES ('i:/easyphp18/www/joomla108fr/images/zoom/essai3/dscn1403.mov', 10073194, 1142718379, 1142718411, 'a:20:{s:14:"GETID3_VERSION";s:5:"1.7.2";s:8:"filesize";i:10073194;s:12:"avdataoffset";i:5116;s:9:"avdataend";i:10073194;s:10:"fileformat";s:9:"quicktime";s:5:"audio";a:8:{s:10:"dataformat";s:9:"quicktime";s:5:"codec";s:7:"raw PCM";s:11:"sample_rate";d:8000;s:8:"channels";i:1;s:15:"bits_per_sample";i:8;s:8:"lossless";b:1;s:11:"channelmode";s:4:"mono";s:7:"streams";a:1:{i:0;a:7:{s:10:"dataformat";s:9:"quicktime";s:5:"codec";s:7:"raw PCM";s:11:"sample_rate";d:8000;s:8:"channels";i:1;s:15:"bits_per_sample";i:8;s:8:"lossless";b:1;s:11:"channelmode";s:4:"mono";}}}s:5:"video";a:8:{s:10:"dataformat";s:9:"quicktime";s:12:"resolution_x";d:320;s:12:"resolution_y";d:240;s:5:"codec";s:12:"Photo - JPEG";s:15:"bits_per_sample";i:24;s:8:"lossless";b:0;s:18:"pixel_aspect_ratio";d:1;s:10:"frame_rate";i:15;}s:4:"tags";a:1:{s:9:"quicktime";a:2:{s:6:"format";a:1:{i:0;s:14:"Digital Camera";}s:11:"information";a:1:{i:0;s:49:"NIKON DIGITAL CAMERA ";}}}s:7:"warning";a:2:{i:0;s:48:"Unknown QuickTime atom type: "PICT" at offset 22";i:1;s:54:"Unknown QuickTime atom type: "TAGS" at offset 10072953";}s:8:"comments";a:1:{s:8:"language";a:1:{i:0;s:7:"English";}}s:8:"encoding";s:10:"ISO-8859-1";s:8:"filename";s:12:"dscn1403.mov";s:8:"filepath";s:47:"i:/easyphp18/www/joomla108fr/images/zoom/essai3";s:12:"filenamepath";s:60:"i:/easyphp18/www/joomla108fr/images/zoom/essai3/dscn1403.mov";s:9:"mime_type";s:15:"video/quicktime";s:9:"quicktime";a:10:{s:4:"pnot";a:9:{s:9:"hierarchy";s:4:"pnot";s:4:"name";s:4:"pnot";s:4:"size";i:22;s:6:"offset";i:0;s:17:"modification_date";d:3214126349;s:14:"version_number";i:0;s:9:"atom_type";s:4:"PICT";s:10:"atom_index";i:1;s:22:"modification_date_unix";d:1131281549;}s:4:"PICT";a:5:{s:9:"hierarchy";s:4:"PICT";s:4:"name";s:4:"PICT";s:4:"size";i:5086;s:6:"offset";i:22;s:4:"data";s:5086:"Ö\0\0\0\0\0x\0 \0ÿÀ\0ÿþ\0\0\0H\0\0\0H\0\0\0\0\0\0\0x\0 \0\0\0\0\0\0€\0€\0€\0\0\0\n\0\0\0\0\0x\0 ‚\0\0\0’\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0@\0\0\0\0\0x\0 \0\0\0\0\0\0\0\0\0\0Vjpeg\0\0\0\0\0\0\0\0\0Niko\0\0\0\0\0\0\0\0 \0x\0H\0\0\0H\0\0\0\0\0\0\0 Photo - JPEG\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0ÿÿÿØÿÛ\0„\0\r \n \n\r \r")"1+330+/.6=NB69I:./D\\DIPSWXW4A`f_UfNUWT''''T8/8TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTÿÀ\0\0x\0 !\0ÿÄ¢\0\0\0\0\0\0\0\0\0\0 \n \0\0\0}\0!1AQa"q2?‘¡#B±Ã?RÑð$3br‚ \n\Z%&''()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyzƒ„…†‡ˆ‰Š’“â€?•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖרÙÚáâãäåæçèéêñòóôõö÷øùú\0\0\0\0\0\0\0 \n \0\0w\0!1AQaq"2?B‘¡±Ã? #3RðbrÑ\n$4á%ñ\Z&''()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz‚ƒ„…†‡ˆ‰Š’“â€?•–—˜™š¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖרÙÚâãäåæçèéêòóôõö÷øùúÿÚ\0 \0\0?\0Êž\r"ÇO€''¶#ÃŒ|ôò¤üöœR-0%SVly¾ŒyX~™þâ€?€ê´¶ÎŸãüÃ?Kuþ¯>Å’?˜§Ã? ø°úÿ\0è5 œYô=ON½©\nۥ*6±^A?\\éúÔÛþvfB1íþsHÉ# Æ…NIGz—‚Ü‚ ¦Q@¾6“œúÆ­:Žr8''§Óÿ\0ÕRÃ?¤‰"FF\\žyÉÅ\n@‡k³bNô8<Ч°t<¨\Zp4Ã?‡ƒN?Z°ûbèQÿ\0•*ž0&CV¬Î/ >ä㦀:m(âÃ?BGõþµfã˜M.€Š‘Œ\\·ùõ«Ê§ì¸0 ýqH%°Ã?»R0‹Œ¯>Ã?¿Ã?Ò¦ 1ÀR`;gÿ\0­BØÈšß˜£##ßÃ?Ã?÷d$ÎÑØg¿CùÃ?ã{1"øˆ†\\¨\0O¯¥E$n?<°Ääíã8¦<Ÿ4àØ Ôxjx5#''³Úu ]ÙÃ??)úÿ\0Ö¤‰²‹ôªèI:\ZµlÒíÿ\0뢊túiýÿýZ˜þåÿ\0Ã?4tUi#†y$•ÕHË1÷4¿Ú¶Æ&‹lÃ?IÃ?Ø\nóøçô¢)½…6’± ¤IȬ7ÃŒ\n ô$Ó¶»;0\r·§Ã?üé%c2KEdPÅ’Å’6ä{Uªe#–Õ’hïåŒM6ÆPÃ?|Ã?ô€ÀìlóÃ?~j?=ŽÛB¶èð*ñ»æ$ŸLW?®Ú¤Zψ ùÔIëÉëGQ#̵y¦ŽåJè¥:+3“Uì''â€?ßBW`[,OZ’–æò7Ê>• jâ€?hO <-“Ä©Óêõ§Œ+"©lI*\Zµo†š6.«±Õ¾lö ö›°¬t¶"2Œ³Ó¥[3Dáâ€?L™é×¹_Aœ·?îš8m#?Ã?YÙ¤;OP1?ýÖ›}$R….vž0jᡜµ=ÂS­®O™º0ã$?qÃ?ô­òN>\\f‰nc ·¦ÆM¿Å‘ÉúT•#1µ{YÚín!?¦_/k#=ýMbÙé·Nw[4Q–''s??NµK¸3¦‚ÇÉ‚8Œ™Ú1Òª_héq/Ëœ''U;vò(lÖÇÃ?z‚?—øÕVÛw zH§õ©S¡CÓÚ¤SP¶4%?‘œŽF=G5f\\-ÌÊBÈÃõ«[ÔPØ4‘ÊAÃŽk9²¢ZK£“N7’Gpãq'' ç=pr\rJchÂ¥srexˆò“Ôÿ\0Å“\n·À˜ÃFY[ñŸÂ­Ž+Cb(V\r*iíä(ë1ß<#Æ’Å Å’jsn{g9ÃŽhrÔ• âÕç\\fF#9#=jdÖnTãÃ?çß §Ì.RQ®NÈP9 -É>çÒ£ŸZœ¹Ãàv€)ó â€?€j³“!ãž½ê3¨I&ÊF:x‹…?;Ö‡îboF#óýjÊVÚÃ?½i“Ôèó†?Z‘MBØÃ?Å¡2 \0zfÂ¥ Þ¹ì{Õ-‰b»b?¯˯n\\v¤ä¾Ô—O$†?`?òŒóþy¢l$ìfÛ]¸?ÈÀŽ{\ZÛ‘ÛÂÈéÀ$ý+I „­Hmîî\\9s´¹,Tž½=…[·¹Þ\0# CD (JúÃqœÒîÀ¬?2?ɃÃ?äRo4ÈÇÖšZËœ–­Ã?Ëœ>Žèk´1{›ñ¶å\rëƒúTªjMI£nE:''rò‡+!ÜuÃŽÅ¡%î>FáG½0·aYÉ]–¶+Ët#8\\zÿ\0\n­s)•î$Ž™®ˆ®Ub$®@…—ƒù\ZÃ?´µ3Bò–U‰A,Ã698 QWÃ?Ã?ÒáÓd·g6’(8!Ã?9 dΞbªê‹ö[?(;pÈÙ<ƒÇµwÑ–Ò‹Ã?’Ú1~Z³¼u<ç½s5gbÆ9˧=ÿ\0Â¥?½1r)\r\0rÚ?6OìAýEcV¦,Ù¶lÃ?ûƒùU…5%’«TÃŒ|þø?¦?Â¥4''¹²Û÷‰=W$þZ{Â¥\nÊ—×p*ãð=ªãyËœ7¡œÒ“ß¾j`äã8&žäÜš2ÈþªØ·±VE%7óžü_ÃŒRëc]ToÜ-/—wïîyçÚ´''¼ŠùM±Dg\0ˆäÇ9ê:i{Ä·u©™g.ÆdSÃ?’z\nàm®vH?Å“GÞÆ>•¬}Ög-M{çXQ‹åOÊÃ?= <÷©™áq¿`CýèÃ?ÊéŒÖº5© ¸°Ga Ã?Æ7/ ;çƒÃ?Jž''Y#Úê_—1¸`?\0r)£U-\nW0ía´îí<ôÃ?…T·— cŸCRôaÔ¶Žr?xŠÑ@\nê+\Z†ˆF?ߥjØø{R¾£?£Œÿ\0¤¨ÿ\0\ZÃ?&Ã?ÊÅ]SJ“N¹ÃŽCdeYIÃ?ª~^Ã’\n»mÔä¹]†µ9â€??â''‚¶{S''–Va½Éã?oÂ¥QŸA°œ8=ò+ ŠPˆs·Ú¢¡p''Šì«äùàWE ëFÚåCÈ®;©çôíQf9­\nõ³wkmi\rŽûÙG°ÿ\0ý+‚Î>•ÒÃ?Ù?Â¥a¤??>fIqµFqéÃ?ZmÂ}—i‰ßiþ6M ú?‘Â¥ZØŽ£ÇÃ?Op?Ã?ùéNyK?À᱆÷÷ÿ\0ëQr¶$Žs6Õ,ÉïÃ?Oÿ\0]X±Òî/—l(ª#8/#\0úsRîË7l¼,T‡¹Ô­ò?‚&Ë~¸¯™£Å´:]Hèl.}¾ö)¸®¢»7lJ¶]öútQ²?7à3Æ´ãÕíœíi6uªäV&ç+㉠• x\\1\r†#·ýjÃ¥7XTÜÞNÅ¢u5FC’(3è"ž+rÖÎkˆ„©•§½Lö.ÇNÔ€ùÿ\0fQSYXêÎûO|ù\0ãÄVi\\¦Ì=Mæ7?üßi$éÔÅ ?Ç%?oëU¹h?“ZÛÞ\\ÊÃ??øNqùçúT§Â6·sù÷°@Xõ Ÿ›ê25·³Œ>"ºŸEµ²·ÿ\0E‰w*¨^?Æ¼×Æ~\Z}&é®­×6rœñÿ\0,ØöúzVэۼ¡$lèk™„w5â€?ü¿…