Changeset 3 for branches/rsr.v5.1.dev/web/install/dist/sql/tables.sql
- Timestamp:
- Nov 14, 2011, 11:17:15 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/rsr.v5.1.dev/web/install/dist/sql/tables.sql
r1 r3 1 CREATE TABLE IF NOT EXISTS`[prefix]albums` (1 CREATE TABLE `[prefix]albums` ( 2 2 `id` int(11) NOT NULL AUTO_INCREMENT, 3 3 `id_artiste` int(11) NOT NULL, … … 16 16 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 17 17 # -- 18 CREATE TABLE IF NOT EXISTS`[prefix]artistes` (18 CREATE TABLE `[prefix]artistes` ( 19 19 `id` int(11) NOT NULL AUTO_INCREMENT, 20 20 `nom` varchar(255) DEFAULT NULL, … … 40 40 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 41 41 # -- 42 CREATE TABLE IF NOT EXISTS`[prefix]artistes_admins` (42 CREATE TABLE `[prefix]artistes_admins` ( 43 43 `id_artiste` int(11) NOT NULL, 44 44 `pun_user` int(11) NOT NULL, … … 46 46 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 47 47 # -- 48 CREATE TABLE IF NOT EXISTS`[prefix]boxes` (48 CREATE TABLE `[prefix]boxes` ( 49 49 `id` int(11) NOT NULL AUTO_INCREMENT, 50 50 `nom` varchar(64) DEFAULT NULL, … … 63 63 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=162 ; 64 64 # -- 65 CREATE TABLE IF NOT EXISTS`[prefix]categories` (65 CREATE TABLE `[prefix]categories` ( 66 66 `id` int(11) NOT NULL AUTO_INCREMENT, 67 67 `nom` varchar(64) DEFAULT NULL, … … 74 74 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=103 ; 75 75 # -- 76 CREATE TABLE IF NOT EXISTS`[prefix]categories_tree` (76 CREATE TABLE `[prefix]categories_tree` ( 77 77 `parent` int(11) NOT NULL, 78 78 `child` int(11) NOT NULL, … … 80 80 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 81 81 # -- 82 CREATE TABLE IF NOT EXISTS`[prefix]concerts` (82 CREATE TABLE `[prefix]concerts` ( 83 83 `id` int(11) NOT NULL AUTO_INCREMENT, 84 84 `id_artiste` int(11) DEFAULT NULL, … … 94 94 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 95 95 # -- 96 CREATE TABLE IF NOT EXISTS`[prefix]configuration` (96 CREATE TABLE `[prefix]configuration` ( 97 97 `key` varchar(255) NOT NULL, 98 98 `value` text NOT NULL, … … 100 100 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 101 101 # -- 102 CREATE TABLE IF NOT EXISTS`[prefix]contenus` (102 CREATE TABLE `[prefix]contenus` ( 103 103 `id` int(11) NOT NULL AUTO_INCREMENT, 104 104 `nom` varchar(64) DEFAULT NULL, … … 117 117 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=935 ; 118 118 # -- 119 CREATE TABLE IF NOT EXISTS`[prefix]downloads` (119 CREATE TABLE `[prefix]downloads` ( 120 120 `id` int(11) NOT NULL AUTO_INCREMENT, 121 121 `id_artiste` int(11) DEFAULT NULL, … … 131 131 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 132 132 # -- 133 CREATE TABLE IF NOT EXISTS`[prefix]download_urls` (133 CREATE TABLE `[prefix]download_urls` ( 134 134 `id` int(11) NOT NULL AUTO_INCREMENT, 135 135 `id_download` int(11) DEFAULT NULL, … … 143 143 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 144 144 # -- 145 CREATE TABLE IF NOT EXISTS`[prefix]formats` (145 CREATE TABLE `[prefix]formats` ( 146 146 `id` int(11) NOT NULL AUTO_INCREMENT, 147 147 `nom` varchar(32) DEFAULT NULL, … … 150 150 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; 151 151 # -- 152 CREATE TABLE IF NOT EXISTS`[prefix]licences` (152 CREATE TABLE `[prefix]licences` ( 153 153 `id` int(11) NOT NULL AUTO_INCREMENT, 154 154 `nom` varchar(255) NOT NULL DEFAULT '', … … 158 158 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ; 159 159 # -- 160 CREATE TABLE IF NOT EXISTS`[prefix]playlists` (160 CREATE TABLE `[prefix]playlists` ( 161 161 `id` int(11) NOT NULL AUTO_INCREMENT, 162 162 `pun_user` int(11) NOT NULL, … … 167 167 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 168 168 # -- 169 CREATE TABLE IF NOT EXISTS`[prefix]playlist_download` (169 CREATE TABLE `[prefix]playlist_download` ( 170 170 `id` int(11) NOT NULL, 171 171 `id_download` int(11) NOT NULL, … … 173 173 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 174 174 # -- 175 CREATE TABLE IF NOT EXISTS`[prefix]pun_bans` (175 CREATE TABLE `[prefix]pun_bans` ( 176 176 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 177 177 `username` varchar(200) DEFAULT NULL, 178 178 `ip` varchar(255) DEFAULT NULL, 179 `email` varchar( 50) DEFAULT NULL,179 `email` varchar(80) DEFAULT NULL, 180 180 `message` varchar(255) DEFAULT NULL, 181 181 `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)) 183 185 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; 184 186 # -- 185 CREATE TABLE IF NOT EXISTS`[prefix]pun_categories` (187 CREATE TABLE `[prefix]pun_categories` ( 186 188 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 187 189 `cat_name` varchar(80) NOT NULL DEFAULT 'New Category', … … 190 192 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ; 191 193 # -- 192 CREATE TABLE IF NOT EXISTS`[prefix]pun_censoring` (194 CREATE TABLE `[prefix]pun_censoring` ( 193 195 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 194 196 `search_for` varchar(60) NOT NULL DEFAULT '', … … 197 199 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 198 200 # -- 199 CREATE TABLE IF NOT EXISTS`[prefix]pun_config` (201 CREATE TABLE `[prefix]pun_config` ( 200 202 `conf_name` varchar(255) NOT NULL DEFAULT '', 201 203 `conf_value` text, … … 203 205 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 204 206 # -- 205 CREATE TABLE IF NOT EXISTS`[prefix]pun_forums` (207 CREATE TABLE `[prefix]pun_forums` ( 206 208 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 207 209 `forum_name` varchar(80) NOT NULL DEFAULT 'New forum', … … 220 222 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=103 ; 221 223 # -- 222 CREATE TABLE IF NOT EXISTS`[prefix]pun_forum_perms` (224 CREATE TABLE `[prefix]pun_forum_perms` ( 223 225 `group_id` int(10) NOT NULL DEFAULT '0', 224 226 `forum_id` int(10) NOT NULL DEFAULT '0', … … 229 231 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 230 232 # -- 231 CREATE TABLE IF NOT EXISTS `[prefix]pun_groups` ( 233 CREATE 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 # -- 239 CREATE TABLE `[prefix]pun_groups` ( 232 240 `g_id` int(10) unsigned NOT NULL AUTO_INCREMENT, 233 241 `g_title` varchar(50) NOT NULL DEFAULT '', 234 242 `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', 235 248 `g_read_board` tinyint(1) NOT NULL DEFAULT '1', 249 `g_view_users` tinyint(1) NOT NULL DEFAULT '1', 236 250 `g_post_replies` tinyint(1) NOT NULL DEFAULT '1', 237 251 `g_post_topics` tinyint(1) NOT NULL DEFAULT '1', 238 `g_post_polls` tinyint(1) NOT NULL DEFAULT '1',239 252 `g_edit_posts` tinyint(1) NOT NULL DEFAULT '1', 240 253 `g_delete_posts` tinyint(1) NOT NULL DEFAULT '1', … … 243 256 `g_search` tinyint(1) NOT NULL DEFAULT '1', 244 257 `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', 246 259 `g_post_flood` smallint(6) NOT NULL DEFAULT '30', 247 260 `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', 248 263 PRIMARY KEY (`g_id`) 249 264 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; 250 265 # -- 251 CREATE TABLE IF NOT EXISTS`[prefix]pun_online` (266 CREATE TABLE `[prefix]pun_online` ( 252 267 `user_id` int(10) unsigned NOT NULL DEFAULT '1', 253 268 `ident` varchar(200) NOT NULL DEFAULT '', 254 269 `logged` int(10) unsigned NOT NULL DEFAULT '0', 255 270 `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 # -- 279 CREATE TABLE `[prefix]pun_posts` ( 260 280 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 261 281 `poster` varchar(200) NOT NULL DEFAULT '', 262 282 `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, 266 286 `hide_smilies` tinyint(1) NOT NULL DEFAULT '0', 267 287 `posted` int(10) unsigned NOT NULL DEFAULT '0', … … 274 294 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21233 ; 275 295 # -- 276 CREATE TABLE IF NOT EXISTS`[prefix]pun_ranks` (296 CREATE TABLE `[prefix]pun_ranks` ( 277 297 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 278 298 `rank` varchar(50) NOT NULL DEFAULT '', … … 281 301 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; 282 302 # -- 283 CREATE TABLE IF NOT EXISTS`[prefix]pun_reports` (303 CREATE TABLE `[prefix]pun_reports` ( 284 304 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 285 305 `post_id` int(10) unsigned NOT NULL DEFAULT '0', … … 295 315 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; 296 316 # -- 297 CREATE TABLE IF NOT EXISTS`[prefix]pun_search_cache` (317 CREATE TABLE `[prefix]pun_search_cache` ( 298 318 `id` int(10) unsigned NOT NULL DEFAULT '0', 299 319 `ident` varchar(200) NOT NULL DEFAULT '', 300 `search_data` text NOT NULL,320 `search_data` mediumtext, 301 321 PRIMARY KEY (`id`), 302 322 KEY `pun_search_cache_ident_idx` (`ident`(8)) 303 323 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 304 324 # -- 305 CREATE TABLE IF NOT EXISTS`[prefix]pun_search_matches` (325 CREATE TABLE `[prefix]pun_search_matches` ( 306 326 `post_id` int(10) unsigned NOT NULL DEFAULT '0', 307 327 `word_id` mediumint(8) unsigned NOT NULL DEFAULT '0', … … 311 331 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 312 332 # -- 313 CREATE TABLE IF NOT EXISTS`[prefix]pun_search_words` (333 CREATE TABLE `[prefix]pun_search_words` ( 314 334 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, 315 335 `word` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', … … 318 338 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 319 339 # -- 320 CREATE TABLE IF NOT EXISTS`[prefix]pun_smilies` (340 CREATE TABLE `[prefix]pun_smilies` ( 321 341 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 322 342 `image` varchar(60) NOT NULL DEFAULT '', … … 326 346 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=89 ; 327 347 # -- 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` ( 348 CREATE TABLE `[prefix]pun_topics` ( 335 349 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 336 350 `poster` varchar(200) NOT NULL DEFAULT '', 337 351 `subject` varchar(255) NOT NULL DEFAULT '', 338 352 `posted` int(10) unsigned NOT NULL DEFAULT '0', 353 `first_post_id` int(10) unsigned NOT NULL DEFAULT '0', 339 354 `last_post` int(10) unsigned NOT NULL DEFAULT '0', 340 355 `last_post_id` int(10) unsigned NOT NULL DEFAULT '0', … … 348 363 PRIMARY KEY (`id`), 349 364 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`) 351 368 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2441 ; 352 369 # -- 353 CREATE TABLE IF NOT EXISTS `[prefix]pun_users` ( 370 CREATE 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 # -- 376 CREATE TABLE `[prefix]pun_users` ( 354 377 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 355 378 `group_id` int(10) unsigned NOT NULL DEFAULT '4', 356 379 `username` varchar(200) NOT NULL DEFAULT '', 357 380 `password` varchar(40) NOT NULL DEFAULT '', 358 `email` varchar( 50) NOT NULL DEFAULT '',381 `email` varchar(80) NOT NULL DEFAULT '', 359 382 `title` varchar(50) DEFAULT NULL, 360 383 `realname` varchar(40) DEFAULT NULL, 361 384 `url` varchar(100) DEFAULT NULL, 362 `jabber` varchar( 75) DEFAULT NULL,385 `jabber` varchar(80) DEFAULT NULL, 363 386 `icq` varchar(12) DEFAULT NULL, 364 `msn` varchar( 50) DEFAULT NULL,387 `msn` varchar(80) DEFAULT NULL, 365 388 `aim` varchar(30) DEFAULT NULL, 366 389 `yahoo` varchar(30) DEFAULT NULL, 367 390 `location` varchar(30) DEFAULT NULL, 368 `use_avatar` tinyint(1) NOT NULL DEFAULT '0',369 391 `signature` text, 370 392 `disp_topics` tinyint(3) unsigned DEFAULT NULL, 371 393 `disp_posts` tinyint(3) unsigned DEFAULT NULL, 372 394 `email_setting` tinyint(1) NOT NULL DEFAULT '1', 373 `save_pass` tinyint(1) NOT NULL DEFAULT '1',374 395 `notify_with_post` tinyint(1) NOT NULL DEFAULT '0', 396 `auto_notify` tinyint(1) NOT NULL DEFAULT '0', 375 397 `show_smilies` tinyint(1) NOT NULL DEFAULT '1', 376 398 `show_img` tinyint(1) NOT NULL DEFAULT '1', … … 379 401 `show_sig` tinyint(1) NOT NULL DEFAULT '1', 380 402 `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', 381 406 `language` varchar(25) NOT NULL DEFAULT 'English', 382 407 `style` varchar(25) NOT NULL DEFAULT 'Oxygen', 383 408 `num_posts` int(10) unsigned NOT NULL DEFAULT '0', 384 409 `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, 385 413 `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', 387 415 `last_visit` int(10) unsigned NOT NULL DEFAULT '0', 388 416 `admin_note` varchar(30) DEFAULT NULL, 389 `activate_string` varchar( 50) DEFAULT NULL,417 `activate_string` varchar(80) DEFAULT NULL, 390 418 `activate_key` varchar(8) DEFAULT NULL, 391 419 PRIMARY KEY (`id`), 420 UNIQUE KEY `[prefix]_pun_users_username_idx` (`username`(25)), 392 421 KEY `pun_users_registered_idx` (`registered`), 393 422 KEY `pun_users_username_idx` (`username`(8)) 394 423 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1559 ; 395 424 # -- 396 CREATE TABLE IF NOT EXISTS`[prefix]super_admins` (425 CREATE TABLE `[prefix]super_admins` ( 397 426 `id_pun_user` int(11) NOT NULL, 398 427 PRIMARY KEY (`id_pun_user`) 399 428 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 400 429 # -- 401 CREATE TABLE IF NOT EXISTS`[prefix]thumbs` (430 CREATE TABLE `[prefix]thumbs` ( 402 431 `id` int(11) NOT NULL AUTO_INCREMENT, 403 432 `src` varchar(255) NOT NULL DEFAULT '', … … 413 442 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 414 443 # -- 415 CREATE TABLE IF NOT EXISTS`[prefix]videos` (444 CREATE TABLE `[prefix]videos` ( 416 445 `id` int(11) NOT NULL AUTO_INCREMENT, 417 446 `id_artiste` int(11) DEFAULT NULL,
Note: See TracChangeset
for help on using the changeset viewer.
