Ignore:
Timestamp:
Nov 14, 2011, 11:17:15 PM (13 years ago)
Author:
dj3c1t
Message:

passage a Fluxbb 1.4.7

Location:
branches/rsr.v5.1.dev/web/install/dist/sql
Files:
1 added
1 deleted
3 edited

Legend:

Unmodified
Added
Removed

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

    r2 r3  
    8888INSERT INTO `[prefix]contenus` (`id`, `nom`, `categorie`, `titre`, `description`, `contenu`, `auteur_creation`, `date_creation`, `auteur_modification`, `date_modification`, `date_publication`, `public`, `ordre`) VALUES
    8989(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);
    90 
    9190# --
    9291INSERT INTO `[prefix]formats` (`id`, `nom`, `content_type`) VALUES
    … …  
    120119# --
    121120INSERT INTO `[prefix]pun_config` (`conf_name`, `conf_value`) VALUES
    122 ('o_cur_version', '1.2.10'),
     121('o_cur_version', '1.4.7'),
    123122('o_cur_version_fr', '1.2.10'),
    124123('o_board_title', 'Forums'),
    125124('o_board_desc', NULL),
    126 ('o_server_timezone', '0'),
     125('o_default_timezone', '0'),
    127126('o_time_format', 'H:i:s'),
    128127('o_date_format', 'd-m-Y'),
    129 ('o_timeout_visit', '600'),
     128('o_timeout_visit', '1800'),
    130129('o_timeout_online', '300'),
    131130('o_redirect_delay', '1'),
    … …  
    163162('o_admin_email', '[email_admin]'),
    164163('o_webmaster_email', '[email_admin]'),
    165 ('o_subscriptions', '1'),
     164('o_topic_subscriptions', '1'),
    166165('o_smtp_host', NULL),
    167166('o_smtp_user', NULL),
    … …  
    177176('o_maintenance', '0'),
    178177('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'),
    179 ('p_mod_edit_users', '1'),
    180 ('p_mod_rename_users', '0'),
    181 ('p_mod_change_passwords', '0'),
    182 ('p_mod_ban_users', '0'),
     178('o_forum_subscriptions', '1'),
    183179('p_message_bbcode', '1'),
    184180('p_message_img_tag', '1'),
    … …  
    192188('p_allow_banned_email', '1'),
    193189('p_allow_dupe_email', '0'),
    194 ('p_force_guest_email', '1');
     190('p_force_guest_email', '1'),
     191('o_database_revision', '15'),
     192('o_searchindex_revision', '2'),
     193('o_parser_revision', '2'),
     194('o_default_email_setting', '1'),
     195('o_topic_views', '1'),
     196('o_signatures', '1'),
     197('o_smtp_ssl', '0'),
     198('o_default_dst', '0'),
     199('o_quote_depth', '3'),
     200('o_feed_type', '2'),
     201('o_feed_ttl', '0');
    195202# --
    196203INSERT INTO `[prefix]pun_forum_perms` (`group_id`, `forum_id`, `read_forum`, `post_replies`, `post_topics`) VALUES
    … …  
    220227(6, 80, 0, 0, 0);
    221228# --
    222 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
    223 (1, 'Admin', 'Admin', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0),
    224 (2, 'Modérateurs', 'Modérateur', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0),
    225 (3, 'Touriste', NULL, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0),
    226 (4, 'Membres', NULL, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 300, 60, 30),
    227 (5, 'Artiste', 'Artiste', 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 10, 10),
    228 (6, '100 eme Membre', '100 eme Membre', 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 300, 60, 30);
    229 # --
    230 INSERT INTO `[prefix]pun_online` (`user_id`, `ident`, `logged`, `idle`) VALUES
    231 (1, '192.168.10.13', 1321118546, 0);
     229INSERT 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
     230(1, 'Admin', 'Admin', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0),
     231(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),
     232(3, 'Touriste', NULL, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0),
     233(4, 'Membres', NULL, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 60, 30, 60, 60),
     234(5, 'Artiste', 'Artiste', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 10, 10, 60, 60),
     235(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);
     236# --
     237INSERT INTO `[prefix]pun_online` (`user_id`, `ident`, `logged`, `idle`, `last_post`, `last_search`) VALUES
     238(1, '192.168.10.13', 1321306351, 0, NULL, NULL);
    232239# --
    233240INSERT INTO `[prefix]pun_ranks` (`id`, `rank`, `min_posts`) VALUES
    … …  
    254261(87, 'terminator.png', ':terminator:', 0);
    255262# --
    256 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
    257 (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),
    258 (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);
     263INSERT 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
     264(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),
     265(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);

  • branches/rsr.v5.1.dev/web/install/dist/sql/raz.sql

    r1 r3  
    2727DROP TABLE IF EXISTS `[prefix]playlists`;
    2828# --
    29 DROP TABLE IF EXISTS `[prefix]playlis[prefix]download`;
     29DROP TABLE IF EXISTS `[prefix]playlist_download`;
    3030# --
    3131DROP TABLE IF EXISTS `[prefix]pun_bans`;
    … …  
    4040# --
    4141DROP TABLE IF EXISTS `[prefix]pun_forum_perms`;
     42# --
     43DROP TABLE IF EXISTS `[prefix]pun_forum_subscriptions`;
    4244# --
    4345DROP TABLE IF EXISTS `[prefix]pun_groups`;
    … …  
    5961DROP TABLE IF EXISTS `[prefix]pun_smilies`;
    6062# --
    61 DROP TABLE IF EXISTS `[prefix]pun_subscriptions`;
     63DROP TABLE IF EXISTS `[prefix]pun_topics`;
    6264# --
    63 DROP TABLE IF EXISTS `[prefix]pun_topics`;
     65DROP TABLE IF EXISTS `[prefix]pun_topic_subscriptions`;
    6466# --
    6567DROP TABLE IF EXISTS `[prefix]pun_users`;

  • branches/rsr.v5.1.dev/web/install/dist/sql/tables.sql

    r1 r3  
    1 CREATE TABLE IF NOT EXISTS `[prefix]albums` (
     1CREATE TABLE `[prefix]albums` (
    22  `id` int(11) NOT NULL AUTO_INCREMENT,
    33  `id_artiste` int(11) NOT NULL,
    … …  
    1616) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    1717# --
    18 CREATE TABLE IF NOT EXISTS `[prefix]artistes` (
     18CREATE TABLE `[prefix]artistes` (
    1919  `id` int(11) NOT NULL AUTO_INCREMENT,
    2020  `nom` varchar(255) DEFAULT NULL,
    … …  
    4040) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    4141# --
    42 CREATE TABLE IF NOT EXISTS `[prefix]artistes_admins` (
     42CREATE TABLE `[prefix]artistes_admins` (
    4343  `id_artiste` int(11) NOT NULL,
    4444  `pun_user` int(11) NOT NULL,
    … …  
    4646) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    4747# --
    48 CREATE TABLE IF NOT EXISTS `[prefix]boxes` (
     48CREATE TABLE `[prefix]boxes` (
    4949  `id` int(11) NOT NULL AUTO_INCREMENT,
    5050  `nom` varchar(64) DEFAULT NULL,
    … …  
    6363) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=162 ;
    6464# --
    65 CREATE TABLE IF NOT EXISTS `[prefix]categories` (
     65CREATE TABLE `[prefix]categories` (
    6666  `id` int(11) NOT NULL AUTO_INCREMENT,
    6767  `nom` varchar(64) DEFAULT NULL,
    … …  
    7474) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=103 ;
    7575# --
    76 CREATE TABLE IF NOT EXISTS `[prefix]categories_tree` (
     76CREATE TABLE `[prefix]categories_tree` (
    7777  `parent` int(11) NOT NULL,
    7878  `child` int(11) NOT NULL,
    … …  
    8080) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    8181# --
    82 CREATE TABLE IF NOT EXISTS `[prefix]concerts` (
     82CREATE TABLE `[prefix]concerts` (
    8383  `id` int(11) NOT NULL AUTO_INCREMENT,
    8484  `id_artiste` int(11) DEFAULT NULL,
    … …  
    9494) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    9595# --
    96 CREATE TABLE IF NOT EXISTS `[prefix]configuration` (
     96CREATE TABLE `[prefix]configuration` (
    9797  `key` varchar(255) NOT NULL,
    9898  `value` text NOT NULL,
    … …  
    100100) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    101101# --
    102 CREATE TABLE IF NOT EXISTS `[prefix]contenus` (
     102CREATE TABLE `[prefix]contenus` (
    103103  `id` int(11) NOT NULL AUTO_INCREMENT,
    104104  `nom` varchar(64) DEFAULT NULL,
    … …  
    117117) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=935 ;
    118118# --
    119 CREATE TABLE IF NOT EXISTS `[prefix]downloads` (
     119CREATE TABLE `[prefix]downloads` (
    120120  `id` int(11) NOT NULL AUTO_INCREMENT,
    121121  `id_artiste` int(11) DEFAULT NULL,
    … …  
    131131) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    132132# --
    133 CREATE TABLE IF NOT EXISTS `[prefix]download_urls` (
     133CREATE TABLE `[prefix]download_urls` (
    134134  `id` int(11) NOT NULL AUTO_INCREMENT,
    135135  `id_download` int(11) DEFAULT NULL,
    … …  
    143143) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    144144# --
    145 CREATE TABLE IF NOT EXISTS `[prefix]formats` (
     145CREATE TABLE `[prefix]formats` (
    146146  `id` int(11) NOT NULL AUTO_INCREMENT,
    147147  `nom` varchar(32) DEFAULT NULL,
    … …  
    150150) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
    151151# --
    152 CREATE TABLE IF NOT EXISTS `[prefix]licences` (
     152CREATE TABLE `[prefix]licences` (
    153153  `id` int(11) NOT NULL AUTO_INCREMENT,
    154154  `nom` varchar(255) NOT NULL DEFAULT '',
    … …  
    158158) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
    159159# --
    160 CREATE TABLE IF NOT EXISTS `[prefix]playlists` (
     160CREATE TABLE `[prefix]playlists` (
    161161  `id` int(11) NOT NULL AUTO_INCREMENT,
    162162  `pun_user` int(11) NOT NULL,
    … …  
    167167) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    168168# --
    169 CREATE TABLE IF NOT EXISTS `[prefix]playlist_download` (
     169CREATE TABLE `[prefix]playlist_download` (
    170170  `id` int(11) NOT NULL,
    171171  `id_download` int(11) NOT NULL,
    … …  
    173173) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    174174# --
    175 CREATE TABLE IF NOT EXISTS `[prefix]pun_bans` (
     175CREATE TABLE `[prefix]pun_bans` (
    176176  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    177177  `username` varchar(200) DEFAULT NULL,
    178178  `ip` varchar(255) DEFAULT NULL,
    179   `email` varchar(50) DEFAULT NULL,
     179  `email` varchar(80) DEFAULT NULL,
    180180  `message` varchar(255) DEFAULT NULL,
    181181  `expire` int(10) unsigned DEFAULT NULL,
    182   PRIMARY KEY (`id`)
     182  `ban_creator` int(10) unsigned NOT NULL DEFAULT '0',
     183  PRIMARY KEY (`id`),
     184  KEY `[prefix]pun_bans_username_idx` (`username`(25))
    183185) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
    184186# --
    185 CREATE TABLE IF NOT EXISTS `[prefix]pun_categories` (
     187CREATE TABLE `[prefix]pun_categories` (
    186188  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    187189  `cat_name` varchar(80) NOT NULL DEFAULT 'New Category',
    … …  
    190192) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
    191193# --
    192 CREATE TABLE IF NOT EXISTS `[prefix]pun_censoring` (
     194CREATE TABLE `[prefix]pun_censoring` (
    193195  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    194196  `search_for` varchar(60) NOT NULL DEFAULT '',
    … …  
    197199) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    198200# --
    199 CREATE TABLE IF NOT EXISTS `[prefix]pun_config` (
     201CREATE TABLE `[prefix]pun_config` (
    200202  `conf_name` varchar(255) NOT NULL DEFAULT '',
    201203  `conf_value` text,
    … …  
    203205) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    204206# --
    205 CREATE TABLE IF NOT EXISTS `[prefix]pun_forums` (
     207CREATE TABLE `[prefix]pun_forums` (
    206208  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    207209  `forum_name` varchar(80) NOT NULL DEFAULT 'New forum',
    … …  
    220222) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=103 ;
    221223# --
    222 CREATE TABLE IF NOT EXISTS `[prefix]pun_forum_perms` (
     224CREATE TABLE `[prefix]pun_forum_perms` (
    223225  `group_id` int(10) NOT NULL DEFAULT '0',
    224226  `forum_id` int(10) NOT NULL DEFAULT '0',
    … …  
    229231) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    230232# --
    231 CREATE TABLE IF NOT EXISTS `[prefix]pun_groups` (
     233CREATE TABLE `[prefix]pun_forum_subscriptions` (
     234  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
     235  `forum_id` int(10) unsigned NOT NULL DEFAULT '0',
     236  PRIMARY KEY (`user_id`,`forum_id`)
     237) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     238# --
     239CREATE TABLE `[prefix]pun_groups` (
    232240  `g_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    233241  `g_title` varchar(50) NOT NULL DEFAULT '',
    234242  `g_user_title` varchar(50) DEFAULT NULL,
     243  `g_moderator` tinyint(1) NOT NULL DEFAULT '0',
     244  `g_mod_edit_users` tinyint(1) NOT NULL DEFAULT '0',
     245  `g_mod_rename_users` tinyint(1) NOT NULL DEFAULT '0',
     246  `g_mod_change_passwords` tinyint(1) NOT NULL DEFAULT '0',
     247  `g_mod_ban_users` tinyint(1) NOT NULL DEFAULT '0',
    235248  `g_read_board` tinyint(1) NOT NULL DEFAULT '1',
     249  `g_view_users` tinyint(1) NOT NULL DEFAULT '1',
    236250  `g_post_replies` tinyint(1) NOT NULL DEFAULT '1',
    237251  `g_post_topics` tinyint(1) NOT NULL DEFAULT '1',
    238   `g_post_polls` tinyint(1) NOT NULL DEFAULT '1',
    239252  `g_edit_posts` tinyint(1) NOT NULL DEFAULT '1',
    240253  `g_delete_posts` tinyint(1) NOT NULL DEFAULT '1',
    … …  
    243256  `g_search` tinyint(1) NOT NULL DEFAULT '1',
    244257  `g_search_users` tinyint(1) NOT NULL DEFAULT '1',
    245   `g_edit_subjects_interval` smallint(6) NOT NULL DEFAULT '300',
     258  `g_send_email` tinyint(1) NOT NULL DEFAULT '1',
    246259  `g_post_flood` smallint(6) NOT NULL DEFAULT '30',
    247260  `g_search_flood` smallint(6) NOT NULL DEFAULT '30',
     261  `g_email_flood` smallint(6) NOT NULL DEFAULT '60',
     262  `g_report_flood` smallint(6) NOT NULL DEFAULT '60',
    248263  PRIMARY KEY (`g_id`)
    249264) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
    250265# --
    251 CREATE TABLE IF NOT EXISTS `[prefix]pun_online` (
     266CREATE TABLE `[prefix]pun_online` (
    252267  `user_id` int(10) unsigned NOT NULL DEFAULT '1',
    253268  `ident` varchar(200) NOT NULL DEFAULT '',
    254269  `logged` int(10) unsigned NOT NULL DEFAULT '0',
    255270  `idle` tinyint(1) NOT NULL DEFAULT '0',
    256   KEY `pun_online_user_id_idx` (`user_id`)
    257 ) ENGINE=MEMORY DEFAULT CHARSET=utf8;
    258 # --
    259 CREATE TABLE IF NOT EXISTS `[prefix]pun_posts` (
     271  `last_post` int(10) unsigned DEFAULT NULL,
     272  `last_search` int(10) unsigned DEFAULT NULL,
     273  UNIQUE KEY `[prefix]pun_online_user_id_ident_idx` (`user_id`,`ident`(25)),
     274  KEY `pun_online_user_id_idx` (`user_id`),
     275  KEY `[prefix]pun_online_ident_idx` (`ident`(25)),
     276  KEY `[prefix]pun_online_logged_idx` (`logged`)
     277) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     278# --
     279CREATE TABLE `[prefix]pun_posts` (
    260280  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    261281  `poster` varchar(200) NOT NULL DEFAULT '',
    262282  `poster_id` int(10) unsigned NOT NULL DEFAULT '1',
    263   `poster_ip` varchar(15) DEFAULT NULL,
    264   `poster_email` varchar(50) DEFAULT NULL,
    265   `message` text NOT NULL,
     283  `poster_ip` varchar(39) DEFAULT NULL,
     284  `poster_email` varchar(80) DEFAULT NULL,
     285  `message` mediumtext,
    266286  `hide_smilies` tinyint(1) NOT NULL DEFAULT '0',
    267287  `posted` int(10) unsigned NOT NULL DEFAULT '0',
    … …  
    274294) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21233 ;
    275295# --
    276 CREATE TABLE IF NOT EXISTS `[prefix]pun_ranks` (
     296CREATE TABLE `[prefix]pun_ranks` (
    277297  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    278298  `rank` varchar(50) NOT NULL DEFAULT '',
    … …  
    281301) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
    282302# --
    283 CREATE TABLE IF NOT EXISTS `[prefix]pun_reports` (
     303CREATE TABLE `[prefix]pun_reports` (
    284304  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    285305  `post_id` int(10) unsigned NOT NULL DEFAULT '0',
    … …  
    295315) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
    296316# --
    297 CREATE TABLE IF NOT EXISTS `[prefix]pun_search_cache` (
     317CREATE TABLE `[prefix]pun_search_cache` (
    298318  `id` int(10) unsigned NOT NULL DEFAULT '0',
    299319  `ident` varchar(200) NOT NULL DEFAULT '',
    300   `search_data` text NOT NULL,
     320  `search_data` mediumtext,
    301321  PRIMARY KEY (`id`),
    302322  KEY `pun_search_cache_ident_idx` (`ident`(8))
    303323) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    304324# --
    305 CREATE TABLE IF NOT EXISTS `[prefix]pun_search_matches` (
     325CREATE TABLE `[prefix]pun_search_matches` (
    306326  `post_id` int(10) unsigned NOT NULL DEFAULT '0',
    307327  `word_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
    … …  
    311331) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    312332# --
    313 CREATE TABLE IF NOT EXISTS `[prefix]pun_search_words` (
     333CREATE TABLE `[prefix]pun_search_words` (
    314334  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    315335  `word` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
    … …  
    318338) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    319339# --
    320 CREATE TABLE IF NOT EXISTS `[prefix]pun_smilies` (
     340CREATE TABLE `[prefix]pun_smilies` (
    321341  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    322342  `image` varchar(60) NOT NULL DEFAULT '',
    … …  
    326346) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=89 ;
    327347# --
    328 CREATE TABLE IF NOT EXISTS `[prefix]pun_subscriptions` (
    329   `user_id` int(10) unsigned NOT NULL DEFAULT '0',
    330   `topic_id` int(10) unsigned NOT NULL DEFAULT '0',
    331   PRIMARY KEY (`user_id`,`topic_id`)
    332 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    333 # --
    334 CREATE TABLE IF NOT EXISTS `[prefix]pun_topics` (
     348CREATE TABLE `[prefix]pun_topics` (
    335349  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    336350  `poster` varchar(200) NOT NULL DEFAULT '',
    337351  `subject` varchar(255) NOT NULL DEFAULT '',
    338352  `posted` int(10) unsigned NOT NULL DEFAULT '0',
     353  `first_post_id` int(10) unsigned NOT NULL DEFAULT '0',
    339354  `last_post` int(10) unsigned NOT NULL DEFAULT '0',
    340355  `last_post_id` int(10) unsigned NOT NULL DEFAULT '0',
    … …  
    348363  PRIMARY KEY (`id`),
    349364  KEY `pun_topics_forum_id_idx` (`forum_id`),
    350   KEY `pun_topics_moved_to_idx` (`moved_to`)
     365  KEY `pun_topics_moved_to_idx` (`moved_to`),
     366  KEY `[prefix]pun_topics_last_post_idx` (`last_post`),
     367  KEY `[prefix]pun_topics_first_post_id_idx` (`first_post_id`)
    351368) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2441 ;
    352369# --
    353 CREATE TABLE IF NOT EXISTS `[prefix]pun_users` (
     370CREATE TABLE `[prefix]pun_topic_subscriptions` (
     371  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
     372  `topic_id` int(10) unsigned NOT NULL DEFAULT '0',
     373  PRIMARY KEY (`user_id`,`topic_id`)
     374) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     375# --
     376CREATE TABLE `[prefix]pun_users` (
    354377  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    355378  `group_id` int(10) unsigned NOT NULL DEFAULT '4',
    356379  `username` varchar(200) NOT NULL DEFAULT '',
    357380  `password` varchar(40) NOT NULL DEFAULT '',
    358   `email` varchar(50) NOT NULL DEFAULT '',
     381  `email` varchar(80) NOT NULL DEFAULT '',
    359382  `title` varchar(50) DEFAULT NULL,
    360383  `realname` varchar(40) DEFAULT NULL,
    361384  `url` varchar(100) DEFAULT NULL,
    362   `jabber` varchar(75) DEFAULT NULL,
     385  `jabber` varchar(80) DEFAULT NULL,
    363386  `icq` varchar(12) DEFAULT NULL,
    364   `msn` varchar(50) DEFAULT NULL,
     387  `msn` varchar(80) DEFAULT NULL,
    365388  `aim` varchar(30) DEFAULT NULL,
    366389  `yahoo` varchar(30) DEFAULT NULL,
    367390  `location` varchar(30) DEFAULT NULL,
    368   `use_avatar` tinyint(1) NOT NULL DEFAULT '0',
    369391  `signature` text,
    370392  `disp_topics` tinyint(3) unsigned DEFAULT NULL,
    371393  `disp_posts` tinyint(3) unsigned DEFAULT NULL,
    372394  `email_setting` tinyint(1) NOT NULL DEFAULT '1',
    373   `save_pass` tinyint(1) NOT NULL DEFAULT '1',
    374395  `notify_with_post` tinyint(1) NOT NULL DEFAULT '0',
     396  `auto_notify` tinyint(1) NOT NULL DEFAULT '0',
    375397  `show_smilies` tinyint(1) NOT NULL DEFAULT '1',
    376398  `show_img` tinyint(1) NOT NULL DEFAULT '1',
    … …  
    379401  `show_sig` tinyint(1) NOT NULL DEFAULT '1',
    380402  `timezone` float NOT NULL DEFAULT '0',
     403  `dst` tinyint(1) NOT NULL DEFAULT '0',
     404  `date_format` tinyint(1) NOT NULL DEFAULT '0',
     405  `time_format` tinyint(1) NOT NULL DEFAULT '0',
    381406  `language` varchar(25) NOT NULL DEFAULT 'English',
    382407  `style` varchar(25) NOT NULL DEFAULT 'Oxygen',
    383408  `num_posts` int(10) unsigned NOT NULL DEFAULT '0',
    384409  `last_post` int(10) unsigned DEFAULT NULL,
     410  `last_search` int(10) unsigned DEFAULT NULL,
     411  `last_email_sent` int(10) unsigned DEFAULT NULL,
     412  `last_report_sent` int(10) unsigned DEFAULT NULL,
    385413  `registered` int(10) unsigned NOT NULL DEFAULT '0',
    386   `registration_ip` varchar(15) NOT NULL DEFAULT '0.0.0.0',
     414  `registration_ip` varchar(39) NOT NULL DEFAULT '0.0.0.0',
    387415  `last_visit` int(10) unsigned NOT NULL DEFAULT '0',
    388416  `admin_note` varchar(30) DEFAULT NULL,
    389   `activate_string` varchar(50) DEFAULT NULL,
     417  `activate_string` varchar(80) DEFAULT NULL,
    390418  `activate_key` varchar(8) DEFAULT NULL,
    391419  PRIMARY KEY (`id`),
     420  UNIQUE KEY `[prefix]_pun_users_username_idx` (`username`(25)),
    392421  KEY `pun_users_registered_idx` (`registered`),
    393422  KEY `pun_users_username_idx` (`username`(8))
    394423) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1559 ;
    395424# --
    396 CREATE TABLE IF NOT EXISTS `[prefix]super_admins` (
     425CREATE TABLE `[prefix]super_admins` (
    397426  `id_pun_user` int(11) NOT NULL,
    398427  PRIMARY KEY (`id_pun_user`)
    399428) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    400429# --
    401 CREATE TABLE IF NOT EXISTS `[prefix]thumbs` (
     430CREATE TABLE `[prefix]thumbs` (
    402431  `id` int(11) NOT NULL AUTO_INCREMENT,
    403432  `src` varchar(255) NOT NULL DEFAULT '',
    … …  
    413442) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    414443# --
    415 CREATE TABLE IF NOT EXISTS `[prefix]videos` (
     444CREATE TABLE `[prefix]videos` (
    416445  `id` int(11) NOT NULL AUTO_INCREMENT,
    417446  `id_artiste` int(11) DEFAULT NULL,
Note: See TracChangeset for help on using the changeset viewer.