Changeset 3 for branches/rsr.v5.1.dev/web/install/dist/sql/content.sql

Timestamp:

Nov 14, 2011, 11:17:15 PM (12 years ago)

Author:

dj3c1t

Message:

passage a Fluxbb 1.4.7

File:

• branches/rsr.v5.1.dev/web/install/dist/sql/content.sql (modified) (7 diffs)

branches/rsr.v5.1.dev/web/install/dist/sql/content.sql

@@ -88 +88 @@
 INSERT INTO `[prefix]contenus` (`id`, `nom`, `categorie`, `titre`, `description`, `contenu`, `auteur_creation`, `date_creation`, `auteur_modification`, `date_modification`, `date_publication`, `public`, `ordre`) VALUES
 (919, '', 1, 'Nouvelle installation', '', '<p>Bienvenue sur votre installation de rsr v.5.</p>\r\n<p>Pensez &agrave; effacer le dossier <strong>install</strong></p>\r\n<p>&nbsp;</p>\r\n<p>Bonnes publications !</p>', 186, '2011-09-04 15:03:09', 186, '2011-11-12 22:07:24', '2011-09-04 00:00:00', 1, NULL);
-
 # --
 INSERT INTO `[prefix]formats` (`id`, `nom`, `content_type`) VALUES
@@ -120 +119 @@
 # --
 INSERT INTO `[prefix]pun_config` (`conf_name`, `conf_value`) VALUES
-('o_cur_version', '1.2.10'),
+('o_cur_version', '1.4.7'),
 ('o_cur_version_fr', '1.2.10'),
 ('o_board_title', 'Forums'),
 ('o_board_desc', NULL),
-('o_server_timezone', '0'),
+('o_default_timezone', '0'),
 ('o_time_format', 'H:i:s'),
 ('o_date_format', 'd-m-Y'),
-('o_timeout_visit', '600'),
+('o_timeout_visit', '1800'),
 ('o_timeout_online', '300'),
 ('o_redirect_delay', '1'),
@@ -163 +162 @@
 ('o_admin_email', '[email_admin]'),
 ('o_webmaster_email', '[email_admin]'),
-('o_subscriptions', '1'),
+('o_topic_subscriptions', '1'),
 ('o_smtp_host', NULL),
 ('o_smtp_user', NULL),
@@ -177 +176 @@
 ('o_maintenance', '0'),
 ('o_maintenance_message', 'Les forums sont temporairement fermés pour des raisons de maintenance. Nous vous prions de bien vouloir nous excuser pour cette gÚne. Veuillez essayer à nouveau d''ici quelques minutes.<br />\n<br />\nRevolution Sound Records'),
-('p_mod_edit_users', '1'),
-('p_mod_rename_users', '0'),
-('p_mod_change_passwords', '0'),
-('p_mod_ban_users', '0'),
+('o_forum_subscriptions', '1'),
 ('p_message_bbcode', '1'),
 ('p_message_img_tag', '1'),
@@ -192 +188 @@
 ('p_allow_banned_email', '1'),
 ('p_allow_dupe_email', '0'),
-('p_force_guest_email', '1');
+('p_force_guest_email', '1'),
+('o_database_revision', '15'),
+('o_searchindex_revision', '2'),
+('o_parser_revision', '2'),
+('o_default_email_setting', '1'),
+('o_topic_views', '1'),
+('o_signatures', '1'),
+('o_smtp_ssl', '0'),
+('o_default_dst', '0'),
+('o_quote_depth', '3'),
+('o_feed_type', '2'),
+('o_feed_ttl', '0');
 # --
 INSERT INTO `[prefix]pun_forum_perms` (`group_id`, `forum_id`, `read_forum`, `post_replies`, `post_topics`) VALUES
@@ -220 +227 @@
 (6, 80, 0, 0, 0);
 # --
-INSERT INTO `[prefix]pun_groups` (`g_id`, `g_title`, `g_user_title`, `g_read_board`, `g_post_replies`, `g_post_topics`, `g_post_polls`, `g_edit_posts`, `g_delete_posts`, `g_delete_topics`, `g_set_title`, `g_search`, `g_search_users`, `g_edit_subjects_interval`, `g_post_flood`, `g_search_flood`) VALUES
-(1, 'Admin', 'Admin', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0),
-(2, 'Modérateurs', 'Modérateur', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0),
-(3, 'Touriste', NULL, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0),
-(4, 'Membres', NULL, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 300, 60, 30),
-(5, 'Artiste', 'Artiste', 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 10, 10),
-(6, '100 eme Membre', '100 eme Membre', 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 300, 60, 30);
-# --
-INSERT INTO `[prefix]pun_online` (`user_id`, `ident`, `logged`, `idle`) VALUES
-(1, '192.168.10.13', 1321118546, 0);
+INSERT INTO `[prefix]pun_groups` (`g_id`, `g_title`, `g_user_title`, `g_moderator`, `g_mod_edit_users`, `g_mod_rename_users`, `g_mod_change_passwords`, `g_mod_ban_users`, `g_read_board`, `g_view_users`, `g_post_replies`, `g_post_topics`, `g_edit_posts`, `g_delete_posts`, `g_delete_topics`, `g_set_title`, `g_search`, `g_search_users`, `g_send_email`, `g_post_flood`, `g_search_flood`, `g_email_flood`, `g_report_flood`) VALUES
+(1, 'Admin', 'Admin', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0),
+(2, 'Modérateurs', 'Modérateur', 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0),
+(3, 'Touriste', NULL, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0),
+(4, 'Membres', NULL, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 60, 30, 60, 60),
+(5, 'Artiste', 'Artiste', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 10, 10, 60, 60),
+(6, '100 eme Membre', '100 eme Membre', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 60, 30, 60, 60);
+# --
+INSERT INTO `[prefix]pun_online` (`user_id`, `ident`, `logged`, `idle`, `last_post`, `last_search`) VALUES
+(1, '192.168.10.13', 1321306351, 0, NULL, NULL);
 # --
 INSERT INTO `[prefix]pun_ranks` (`id`, `rank`, `min_posts`) VALUES
@@ -254 +261 @@
 (87, 'terminator.png', ':terminator:', 0);
 # --
-INSERT INTO `[prefix]pun_users` (`id`, `group_id`, `username`, `password`, `email`, `title`, `realname`, `url`, `jabber`, `icq`, `msn`, `aim`, `yahoo`, `location`, `use_avatar`, `signature`, `disp_topics`, `disp_posts`, `email_setting`, `save_pass`, `notify_with_post`, `show_smilies`, `show_img`, `show_img_sig`, `show_avatars`, `show_sig`, `timezone`, `language`, `style`, `num_posts`, `last_post`, `registered`, `registration_ip`, `last_visit`, `admin_note`, `activate_string`, `activate_key`) VALUES
-(186, 1, 'admin', '90f1b3c6cf62b05606b215265803f553e22bc657', '[email_admin]', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 1, 1, 0, 1, 1, 1, 1, 1, 0, 'French', 'Rsr', 1382, 1321043538, 1156702867, '82.243.194.97', 1321118443, NULL, NULL, NULL),
-(1, 3, 'Invité', 'Invité', 'Invité', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 1, 1, 0, 1, 1, 1, 1, 1, 0, 'English', 'Oxygen', 0, NULL, 0, '0.0.0.0', 0, NULL, NULL, NULL);
+INSERT INTO `[prefix]pun_users` (`id`, `group_id`, `username`, `password`, `email`, `title`, `realname`, `url`, `jabber`, `icq`, `msn`, `aim`, `yahoo`, `location`, `signature`, `disp_topics`, `disp_posts`, `email_setting`, `notify_with_post`, `auto_notify`, `show_smilies`, `show_img`, `show_img_sig`, `show_avatars`, `show_sig`, `timezone`, `dst`, `date_format`, `time_format`, `language`, `style`, `num_posts`, `last_post`, `last_search`, `last_email_sent`, `last_report_sent`, `registered`, `registration_ip`, `last_visit`, `admin_note`, `activate_string`, `activate_key`) VALUES
+(186, 1, 'admin', '90f1b3c6cf62b05606b215265803f553e22bc657', '[email_admin]', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 'French', 'Rsr', 1382, 1321043538, NULL, NULL, NULL, 1156702867, '82.243.194.97', 1321305012, NULL, NULL, NULL),
+(1, 3, 'Invité', 'Invité', 'Invité', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 'English', 'Oxygen', 0, NULL, NULL, NULL, NULL, 0, '0.0.0.0', 0, NULL, NULL, NULL);