root/ip/tags/release_1_3_0_53/install/schemas/mysql_schema.sql

Show revision log
 
111163
31
CREATE TABLE `phpbb_ads` (
31
CREATE TABLE `phpbb_ads` (
32
	`ad_id` mediumint(8) unsigned NOT NULL auto_increment,
32
	`ad_id` mediumint(8) unsigned NOT NULL auto_increment,
33
	`ad_title` varchar(255) NOT NULL,
33
	`ad_title` varchar(255) NOT NULL,
 
34
	`ad_text` text,
34
	`ad_text` TEXT NOT NULL,
 
35
	`ad_position` varchar(255) NOT NULL,
35
	`ad_position` varchar(255) NOT NULL,
36
	`ad_auth` tinyint(1) NOT NULL default '0',
36
	`ad_auth` tinyint(1) NOT NULL default '0',
37
	`ad_format` tinyint(1) NOT NULL default '0',
37
	`ad_format` tinyint(1) NOT NULL default '0',
...
...
52
	`pic_size` int(15) unsigned NOT NULL DEFAULT '0',
52
	`pic_size` int(15) unsigned NOT NULL DEFAULT '0',



53
	`pic_thumbnail` varchar(255) DEFAULT '',
53
	`pic_thumbnail` varchar(255) DEFAULT '',



54
	`pic_title` varchar(255) NOT NULL DEFAULT '',
54
	`pic_title` varchar(255) NOT NULL DEFAULT '',



55
	`pic_desc` text,
55
	`pic_desc` TEXT NOT NULL,



56
	`pic_user_id` mediumint(8) NOT NULL DEFAULT '0',
56
	`pic_user_id` mediumint(8) NOT NULL DEFAULT '0',



57
	`pic_username` varchar(32) DEFAULT '',
57
	`pic_username` varchar(32) DEFAULT '',



58
	`pic_user_ip` varchar(8) NOT NULL DEFAULT '0',
58
	`pic_user_ip` varchar(8) NOT NULL DEFAULT '0',


...
...
77
CREATE TABLE `phpbb_album_cat` (
77
CREATE TABLE `phpbb_album_cat` (



78
	`cat_id` mediumint(8) unsigned NOT NULL auto_increment,
78
	`cat_id` mediumint(8) unsigned NOT NULL auto_increment,



79
	`cat_title` varchar(255) NOT NULL DEFAULT '',
79
	`cat_title` varchar(255) NOT NULL DEFAULT '',



80
	`cat_desc` text,
80
	`cat_desc` TEXT NOT NULL,



81
	`cat_wm` text,
81
	`cat_wm` TEXT NOT NULL,



82
	`cat_pics` mediumint(8) unsigned NOT NULL DEFAULT '0',
82
	`cat_pics` mediumint(8) unsigned NOT NULL DEFAULT '0',



83
	`cat_order` mediumint(8) NOT NULL DEFAULT '0',
83
	`cat_order` mediumint(8) NOT NULL DEFAULT '0',



84
	`cat_view_level` tinyint(3) NOT NULL DEFAULT '-1',
84
	`cat_view_level` tinyint(3) NOT NULL DEFAULT '-1',


...
...
116
	`comment_username` varchar(32) DEFAULT '',
116
	`comment_username` varchar(32) DEFAULT '',



117
	`comment_user_ip` varchar(8) NOT NULL DEFAULT '',
117
	`comment_user_ip` varchar(8) NOT NULL DEFAULT '',



118
	`comment_time` int(11) unsigned NOT NULL DEFAULT '0',
118
	`comment_time` int(11) unsigned NOT NULL DEFAULT '0',



119
	`comment_text` text,
119
	`comment_text` TEXT NOT NULL,



120
	`comment_edit_time` int(11) unsigned DEFAULT NULL,
120
	`comment_edit_time` int(11) unsigned DEFAULT NULL,



121
	`comment_edit_count` smallint(5) unsigned NOT NULL DEFAULT '0',
121
	`comment_edit_count` smallint(5) unsigned NOT NULL DEFAULT '0',



122
	`comment_edit_user_id` mediumint(8) DEFAULT NULL,
122
	`comment_edit_user_id` mediumint(8) DEFAULT NULL,


...
...
328
	`ban_time` int(11) DEFAULT NULL,
328
	`ban_time` int(11) DEFAULT NULL,



329
	`ban_expire_time` int(11) DEFAULT NULL,
329
	`ban_expire_time` int(11) DEFAULT NULL,



330
	`ban_by_userid` mediumint(8) DEFAULT NULL,
330
	`ban_by_userid` mediumint(8) DEFAULT NULL,



331
	`ban_priv_reason` text,
331
	`ban_priv_reason` TEXT NOT NULL,



332
	`ban_pub_reason_mode` tinyint(1) DEFAULT NULL,
332
	`ban_pub_reason_mode` tinyint(1) DEFAULT NULL,



333
	`ban_pub_reason` text,
333
	`ban_pub_reason` TEXT NOT NULL,



334
	PRIMARY KEY (`ban_id`),
334
	PRIMARY KEY (`ban_id`),



335
	KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`)
335
	KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`)



336
);
336
);


...
...
395
	`cat_main` mediumint(8) unsigned NOT NULL DEFAULT '0',
395
	`cat_main` mediumint(8) unsigned NOT NULL DEFAULT '0',



396
	`cat_main_type` char(1) DEFAULT NULL,
396
	`cat_main_type` char(1) DEFAULT NULL,



397
	`cat_title` varchar(100) DEFAULT NULL,
397
	`cat_title` varchar(100) DEFAULT NULL,



398
	`cat_desc` text,
398
	`cat_desc` TEXT NOT NULL,



399
	`icon` varchar(255) DEFAULT NULL,
399
	`icon` varchar(255) DEFAULT NULL,



400
	`cat_order` mediumint(8) unsigned NOT NULL DEFAULT '0',
400
	`cat_order` mediumint(8) unsigned NOT NULL DEFAULT '0',



401
	PRIMARY KEY (`cat_id`),
401
	PRIMARY KEY (`cat_id`),


...
...
411
411



412
CREATE TABLE `phpbb_config` (
412
CREATE TABLE `phpbb_config` (



413
	`config_name` varchar(255) NOT NULL DEFAULT '',
413
	`config_name` varchar(255) NOT NULL DEFAULT '',



414
	`config_value` text,
414
	`config_value` TEXT NOT NULL,



415
	PRIMARY KEY (`config_name`)
415
	PRIMARY KEY (`config_name`)



416
);
416
);



417
417


...
...
559
	`cat_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
559
	`cat_id` mediumint(8) unsigned NOT NULL DEFAULT '0',



560
	`main_type` char(1) DEFAULT NULL,
560
	`main_type` char(1) DEFAULT NULL,



561
	`forum_name` varchar(150) DEFAULT NULL,
561
	`forum_name` varchar(150) DEFAULT NULL,



562
	`forum_desc` text,
562
	`forum_desc` TEXT NOT NULL,



563
	`forum_status` tinyint(4) NOT NULL DEFAULT '0',
563
	`forum_status` tinyint(4) NOT NULL DEFAULT '0',



564
	`forum_order` mediumint(8) unsigned NOT NULL DEFAULT '1',
564
	`forum_order` mediumint(8) unsigned NOT NULL DEFAULT '1',



565
	`forum_posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
565
	`forum_posts` mediumint(8) unsigned NOT NULL DEFAULT '0',


...
...
696
	`hack_desc` varchar(255) NOT NULL DEFAULT '',
696
	`hack_desc` varchar(255) NOT NULL DEFAULT '',



697
	`hack_author` varchar(255) NOT NULL DEFAULT '',
697
	`hack_author` varchar(255) NOT NULL DEFAULT '',



698
	`hack_author_email` varchar(255) NOT NULL DEFAULT '',
698
	`hack_author_email` varchar(255) NOT NULL DEFAULT '',



699
	`hack_author_website` tinytext NOT NULL,
699
	`hack_author_website` TINYTEXT NOT NULL,



700
	`hack_version` varchar(32) NOT NULL DEFAULT '',
700
	`hack_version` varchar(32) NOT NULL DEFAULT '',



701
	`hack_hide` enum('Yes','No') NOT NULL DEFAULT 'No',
701
	`hack_hide` enum('Yes','No') NOT NULL DEFAULT 'No',



702
	`hack_download_url` tinytext NOT NULL,
702
	`hack_download_url` TINYTEXT NOT NULL,



703
	`hack_file` varchar(255) NOT NULL DEFAULT '',
703
	`hack_file` varchar(255) NOT NULL DEFAULT '',



704
	`hack_file_mtime` int(10) unsigned NOT NULL DEFAULT '0',
704
	`hack_file_mtime` int(10) unsigned NOT NULL DEFAULT '0',



705
	PRIMARY KEY (`hack_id`),
705
	PRIMARY KEY (`hack_id`),


...
...
717
717



718
CREATE TABLE `phpbb_jr_admin_users` (
718
CREATE TABLE `phpbb_jr_admin_users` (



719
	`user_id` mediumint(9) NOT NULL DEFAULT '0',
719
	`user_id` mediumint(9) NOT NULL DEFAULT '0',



720
	`user_jr_admin` longtext NOT NULL,
720
	`user_jr_admin` LONGTEXT NOT NULL,



721
	`start_date` int(10) unsigned NOT NULL DEFAULT '0',
721
	`start_date` int(10) unsigned NOT NULL DEFAULT '0',



722
	`update_date` int(10) unsigned NOT NULL DEFAULT '0',
722
	`update_date` int(10) unsigned NOT NULL DEFAULT '0',



723
	`admin_notes` text NOT NULL,
723
	`admin_notes` text NOT NULL,


...
...
1009
	`user_id` mediumint(8) NOT NULL,
1009
	`user_id` mediumint(8) NOT NULL,



1010
	`group_id` mediumint(8) NOT NULL,
1010
	`group_id` mediumint(8) NOT NULL,



1011
	`email_subject` varchar(255) NOT NULL,
1011
	`email_subject` varchar(255) NOT NULL,



1012
	`email_body` text,
1012
	`email_body` TEXT NOT NULL,



1013
	`email_format` tinyint(1) NOT NULL default '0',
1013
	`email_format` tinyint(1) NOT NULL default '0',



1014
	`batch_start` mediumint(8) NOT NULL,
1014
	`batch_start` mediumint(8) NOT NULL,



1015
	`batch_size` smallint UNSIGNED NOT NULL,
1015
	`batch_size` smallint UNSIGNED NOT NULL,


...
...
1085
1085



1086
CREATE TABLE `phpbb_pa_cat` (
1086
CREATE TABLE `phpbb_pa_cat` (



1087
	`cat_id` int(10) NOT NULL auto_increment,
1087
	`cat_id` int(10) NOT NULL auto_increment,



1088
	`cat_name` text,
1088
	`cat_name` TEXT NOT NULL,



1089
	`cat_desc` text,
1089
	`cat_desc` TEXT NOT NULL,



1090
	`cat_parent` int(50) DEFAULT NULL,
1090
	`cat_parent` int(50) DEFAULT NULL,



1091
	`parents_data` text NOT NULL,
1091
	`parents_data` text NOT NULL,



1092
	`cat_order` int(50) DEFAULT NULL,
1092
	`cat_order` int(50) DEFAULT NULL,


...
...
1202
	`file_id` int(10) NOT NULL auto_increment,
1202
	`file_id` int(10) NOT NULL auto_increment,



1203
	`user_id` mediumint(8) NOT NULL DEFAULT '0',
1203
	`user_id` mediumint(8) NOT NULL DEFAULT '0',



1204
	`poster_ip` varchar(8) NOT NULL DEFAULT '',
1204
	`poster_ip` varchar(8) NOT NULL DEFAULT '',



1205
	`file_name` text,
1205
	`file_name` TEXT NOT NULL,



1206
	`file_size` int(20) NOT NULL DEFAULT '0',
1206
	`file_size` int(20) NOT NULL DEFAULT '0',



1207
	`unique_name` varchar(255) NOT NULL DEFAULT '',
1207
	`unique_name` varchar(255) NOT NULL DEFAULT '',



1208
	`real_name` varchar(255) NOT NULL DEFAULT '',
1208
	`real_name` varchar(255) NOT NULL DEFAULT '',



1209
	`file_dir` varchar(255) NOT NULL DEFAULT '',
1209
	`file_dir` varchar(255) NOT NULL DEFAULT '',



1210
	`file_desc` text,
1210
	`file_desc` TEXT NOT NULL,



1211
	`file_creator` text,
1211
	`file_creator` TEXT NOT NULL,



1212
	`file_version` text,
1212
	`file_version` TEXT NOT NULL,



1213
	`file_longdesc` text,
1213
	`file_longdesc` TEXT NOT NULL,



1214
	`file_ssurl` text,
1214
	`file_ssurl` TEXT NOT NULL,



1215
	`file_sshot_link` tinyint(2) NOT NULL DEFAULT '0',
1215
	`file_sshot_link` tinyint(2) NOT NULL DEFAULT '0',



1216
	`file_dlurl` text,
1216
	`file_dlurl` TEXT NOT NULL,



1217
	`file_time` int(50) DEFAULT NULL,
1217
	`file_time` int(50) DEFAULT NULL,



1218
	`file_update_time` int(50) NOT NULL DEFAULT '0',
1218
	`file_update_time` int(50) NOT NULL DEFAULT '0',



1219
	`file_catid` int(10) DEFAULT NULL,
1219
	`file_catid` int(10) DEFAULT NULL,



1220
	`file_posticon` text,
1220
	`file_posticon` TEXT NOT NULL,



1221
	`file_license` int(10) DEFAULT NULL,
1221
	`file_license` int(10) DEFAULT NULL,



1222
	`file_dls` int(10) DEFAULT NULL,
1222
	`file_dls` int(10) DEFAULT NULL,



1223
	`file_last` int(50) DEFAULT NULL,
1223
	`file_last` int(50) DEFAULT NULL,



1224
	`file_pin` int(2) DEFAULT NULL,
1224
	`file_pin` int(2) DEFAULT NULL,



1225
	`file_docsurl` text,
1225
	`file_docsurl` TEXT NOT NULL,



1226
	`file_approved` tinyint(1) NOT NULL DEFAULT '1',
1226
	`file_approved` tinyint(1) NOT NULL DEFAULT '1',



1227
	`file_broken` tinyint(1) NOT NULL DEFAULT '0',
1227
	`file_broken` tinyint(1) NOT NULL DEFAULT '0',



1228
	PRIMARY KEY (`file_id`)
1228
	PRIMARY KEY (`file_id`)


...
...
1237
1237



1238
CREATE TABLE `phpbb_pa_license` (
1238
CREATE TABLE `phpbb_pa_license` (



1239
	`license_id` int(10) NOT NULL auto_increment,
1239
	`license_id` int(10) NOT NULL auto_increment,



1240
	`license_name` text,
1240
	`license_name` TEXT NOT NULL,



1241
	`license_text` text,
1241
	`license_text` TEXT NOT NULL,



1242
	PRIMARY KEY (`license_id`)
1242
	PRIMARY KEY (`license_id`)



1243
);
1243
);



1244
1244


...
...
1294
	`poster_ip` varchar(8) NOT NULL DEFAULT '',
1294
	`poster_ip` varchar(8) NOT NULL DEFAULT '',



1295
	`post_username` varchar(25) DEFAULT NULL,
1295
	`post_username` varchar(25) DEFAULT NULL,



1296
	`post_subject` varchar(255) DEFAULT NULL,
1296
	`post_subject` varchar(255) DEFAULT NULL,



1297
	`post_text` text,
1297
	`post_text` TEXT NOT NULL,



1298
	`post_text_compiled` text,
1298
	`post_text_compiled` TEXT NOT NULL,



1299
	`enable_bbcode` tinyint(1) NOT NULL DEFAULT '1',
1299
	`enable_bbcode` tinyint(1) NOT NULL DEFAULT '1',



1300
	`enable_html` tinyint(1) NOT NULL DEFAULT '0',
1300
	`enable_html` tinyint(1) NOT NULL DEFAULT '0',



1301
	`enable_smilies` tinyint(1) NOT NULL DEFAULT '1',
1301
	`enable_smilies` tinyint(1) NOT NULL DEFAULT '1',



1302
	`enable_sig` tinyint(1) NOT NULL DEFAULT '1',
1302
	`enable_sig` tinyint(1) NOT NULL DEFAULT '1',



1303
	`edit_notes` mediumtext,
1303
	`edit_notes` MEDIUMTEXT,



1304
	`post_edit_time` int(11) DEFAULT NULL,
1304
	`post_edit_time` int(11) DEFAULT NULL,



1305
	`post_edit_count` smallint(5) unsigned NOT NULL DEFAULT '0',
1305
	`post_edit_count` smallint(5) unsigned NOT NULL DEFAULT '0',



1306
	`post_edit_id` mediumint(8) NOT NULL DEFAULT '0',
1306
	`post_edit_id` mediumint(8) NOT NULL DEFAULT '0',


...
...
1325
	`privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
1325
	`privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,



1326
	`privmsgs_type` tinyint(4) NOT NULL DEFAULT '0',
1326
	`privmsgs_type` tinyint(4) NOT NULL DEFAULT '0',



1327
	`privmsgs_subject` varchar(255) NOT NULL DEFAULT '',
1327
	`privmsgs_subject` varchar(255) NOT NULL DEFAULT '',



1328
	`privmsgs_text` text,
1328
	`privmsgs_text` TEXT NOT NULL,



1329
	`privmsgs_from_userid` mediumint(8) NOT NULL DEFAULT '0',
1329
	`privmsgs_from_userid` mediumint(8) NOT NULL DEFAULT '0',



1330
	`privmsgs_to_userid` mediumint(8) NOT NULL DEFAULT '0',
1330
	`privmsgs_to_userid` mediumint(8) NOT NULL DEFAULT '0',



1331
	`privmsgs_date` int(11) NOT NULL DEFAULT '0',
1331
	`privmsgs_date` int(11) NOT NULL DEFAULT '0',


...
...
1352
	`privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
1352
	`privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,



1353
	`privmsgs_type` tinyint(4) NOT NULL DEFAULT '0',
1353
	`privmsgs_type` tinyint(4) NOT NULL DEFAULT '0',



1354
	`privmsgs_subject` varchar(255) NOT NULL DEFAULT '',
1354
	`privmsgs_subject` varchar(255) NOT NULL DEFAULT '',



1355
	`privmsgs_text` text,
1355
	`privmsgs_text` TEXT NOT NULL,



1356
	`privmsgs_from_userid` mediumint(8) NOT NULL DEFAULT '0',
1356
	`privmsgs_from_userid` mediumint(8) NOT NULL DEFAULT '0',



1357
	`privmsgs_to_userid` mediumint(8) NOT NULL DEFAULT '0',
1357
	`privmsgs_to_userid` mediumint(8) NOT NULL DEFAULT '0',



1358
	`privmsgs_date` int(11) NOT NULL DEFAULT '0',
1358
	`privmsgs_date` int(11) NOT NULL DEFAULT '0',


...
...
1382
	`field_type` tinyint(4) unsigned NOT NULL DEFAULT '0',
1382
	`field_type` tinyint(4) unsigned NOT NULL DEFAULT '0',



1383
	`text_field_default` varchar(255) DEFAULT NULL,
1383
	`text_field_default` varchar(255) DEFAULT NULL,



1384
	`text_field_maxlen` int(255) unsigned NOT NULL DEFAULT '255',
1384
	`text_field_maxlen` int(255) unsigned NOT NULL DEFAULT '255',



1385
	`text_area_default` text,
1385
	`text_area_default` TEXT NOT NULL,



1386
	`text_area_maxlen` int(255) unsigned NOT NULL DEFAULT '1024',
1386
	`text_area_maxlen` int(255) unsigned NOT NULL DEFAULT '1024',



1387
	`radio_button_default` varchar(255) DEFAULT NULL,
1387
	`radio_button_default` varchar(255) DEFAULT NULL,



1388
	`radio_button_values` text,
1388
	`radio_button_values` TEXT NOT NULL,



1389
	`checkbox_default` text,
1389
	`checkbox_default` TEXT NOT NULL,



1390
	`checkbox_values` text,
1390
	`checkbox_values` TEXT NOT NULL,



1391
	`is_required` tinyint(2) unsigned NOT NULL DEFAULT '0',
1391
	`is_required` tinyint(2) unsigned NOT NULL DEFAULT '0',



1392
	`users_can_view` tinyint(2) unsigned NOT NULL DEFAULT '1',
1392
	`users_can_view` tinyint(2) unsigned NOT NULL DEFAULT '1',



1393
	`view_in_profile` tinyint(2) unsigned NOT NULL DEFAULT '1',
1393
	`view_in_profile` tinyint(2) unsigned NOT NULL DEFAULT '1',


...
...
2001
	`user_icq` varchar(15) DEFAULT NULL,
2001
	`user_icq` varchar(15) DEFAULT NULL,



2002
	`user_website` varchar(100) DEFAULT NULL,
2002
	`user_website` varchar(100) DEFAULT NULL,



2003
	`user_from` varchar(100) DEFAULT NULL,
2003
	`user_from` varchar(100) DEFAULT NULL,



2004
	`user_sig` text,
2004
	`user_sig` TEXT NOT NULL,



2005
	`user_aim` varchar(255) DEFAULT NULL,
2005
	`user_aim` varchar(255) DEFAULT NULL,



2006
	`user_yim` varchar(255) DEFAULT NULL,
2006
	`user_yim` varchar(255) DEFAULT NULL,



2007
	`user_msnm` varchar(255) DEFAULT NULL,
2007
	`user_msnm` varchar(255) DEFAULT NULL,


...
...
2052
	`user_sudoku_playing` int(1) NOT NULL DEFAULT '0',
2052
	`user_sudoku_playing` int(1) NOT NULL DEFAULT '0',



2053
	`user_from_flag` varchar(30) DEFAULT NULL,
2053
	`user_from_flag` varchar(30) DEFAULT NULL,



2054
	`user_phone` varchar(255) DEFAULT NULL,
2054
	`user_phone` varchar(255) DEFAULT NULL,



2055
	`user_selfdes` text,
2055
	`user_selfdes` TEXT NOT NULL,



2056
	`user_upi2db_which_system` tinyint(1) NOT NULL DEFAULT '1',
2056
	`user_upi2db_which_system` tinyint(1) NOT NULL DEFAULT '1',



2057
	`user_upi2db_disable` tinyint(1) NOT NULL DEFAULT '0',
2057
	`user_upi2db_disable` tinyint(1) NOT NULL DEFAULT '0',



2058
	`user_upi2db_datasync` int(11) NOT NULL DEFAULT '0',
2058
	`user_upi2db_datasync` int(11) NOT NULL DEFAULT '0',


...
...
2208
	);
2208
	);



2209
2209



2210
CREATE TABLE `phpbb_ctracker_filechk` (
2210
CREATE TABLE `phpbb_ctracker_filechk` (



2211
	`filepath` text,
2211
	`filepath` TEXT NOT NULL,



2212
	`hash` varchar(32) DEFAULT NULL
2212
	`hash` varchar(32) DEFAULT NULL



2213
	);
2213
	);



2214
2214



2215
CREATE TABLE `phpbb_ctracker_filescanner` (
2215
CREATE TABLE `phpbb_ctracker_filescanner` (



2216
	`id` smallint(5) NOT NULL,
2216
	`id` smallint(5) NOT NULL,



2217
	`filepath` text,
2217
	`filepath` TEXT NOT NULL,



2218
	`safety` smallint(1) NOT NULL DEFAULT '0',
2218
	`safety` smallint(1) NOT NULL DEFAULT '0',



2219
	PRIMARY KEY (`id`)
2219
	PRIMARY KEY (`id`)



2220
	);
2220
	);


...
...
2242
	`forum_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
2242
	`forum_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,



2243
	`save_time` int(11) UNSIGNED DEFAULT '0' NOT NULL,
2243
	`save_time` int(11) UNSIGNED DEFAULT '0' NOT NULL,



2244
	`draft_subject` varchar(100) DEFAULT '' NOT NULL,
2244
	`draft_subject` varchar(100) DEFAULT '' NOT NULL,



2245
	`draft_message` text,
2245
	`draft_message` TEXT NOT NULL,



2246
	PRIMARY KEY (`draft_id`),
2246
	PRIMARY KEY (`draft_id`),



2247
	KEY `save_time` (`save_time`)
2247
	KEY `save_time` (`save_time`)



2248
);
2248
);


...
...
2343
	`background` tinyint(1) NOT NULL DEFAULT '1',
2343
	`background` tinyint(1) NOT NULL DEFAULT '1',



2344
	`local` tinyint(1) NOT NULL DEFAULT '0',
2344
	`local` tinyint(1) NOT NULL DEFAULT '0',



2345
	`edit_auth` tinyint(1) NOT NULL DEFAULT '5',
2345
	`edit_auth` tinyint(1) NOT NULL DEFAULT '5',



2346
	`groups` tinytext NOT NULL,
2346
	`groups` TINYTEXT NOT NULL,



2347
	PRIMARY KEY (`bid`)
2347
	PRIMARY KEY (`bid`)



2348
);
2348
);



2349
2349


...
...
2362
	`template` varchar(100) NOT NULL DEFAULT '',
2362
	`template` varchar(100) NOT NULL DEFAULT '',



2363
	`global_blocks` tinyint(1) NOT NULL DEFAULT '0',
2363
	`global_blocks` tinyint(1) NOT NULL DEFAULT '0',



2364
	`page_nav` tinyint(1) NOT NULL DEFAULT '1',
2364
	`page_nav` tinyint(1) NOT NULL DEFAULT '1',



2365
	`config_vars` text NOT NULL DEFAULT '',
2365
	`config_vars` TEXT NOT NULL,



2366
	`view` tinyint(1) NOT NULL DEFAULT '0',
2366
	`view` tinyint(1) NOT NULL DEFAULT '0',



2367
	`edit_auth` tinyint(1) NOT NULL DEFAULT '5',
2367
	`edit_auth` tinyint(1) NOT NULL DEFAULT '5',



2368
	`groups` tinytext NOT NULL,
2368
	`groups` TINYTEXT NOT NULL,



2369
	PRIMARY KEY (`lid`)
2369
	PRIMARY KEY (`lid`)



2370
);
2370
);



2371
2371


...
...
2378
	`template` varchar(100) NOT NULL DEFAULT '',
2378
	`template` varchar(100) NOT NULL DEFAULT '',



2379
	`global_blocks` tinyint(1) NOT NULL DEFAULT '0',
2379
	`global_blocks` tinyint(1) NOT NULL DEFAULT '0',



2380
	`page_nav` tinyint(1) NOT NULL DEFAULT '1',
2380
	`page_nav` tinyint(1) NOT NULL DEFAULT '1',



2381
	`config_vars` text NOT NULL DEFAULT '',
2381
	`config_vars` TEXT NOT NULL,



2382
	`view` tinyint(1) NOT NULL DEFAULT '0',
2382
	`view` tinyint(1) NOT NULL DEFAULT '0',



2383
	`edit_auth` tinyint(1) NOT NULL DEFAULT '5',
2383
	`edit_auth` tinyint(1) NOT NULL DEFAULT '5',



2384
	`groups` tinytext NOT NULL,
2384
	`groups` TINYTEXT NOT NULL,



2385
	PRIMARY KEY (`lsid`),
2385
	PRIMARY KEY (`lsid`),



2386
	UNIQUE KEY `page_id` (`page_id`)
2386
	UNIQUE KEY `page_id` (`page_id`)



2387
);
2387
);


...
...
2398
	`menu_icon` varchar(255) DEFAULT NULL,
2398
	`menu_icon` varchar(255) DEFAULT NULL,



2399
	`menu_name_lang` varchar(150) DEFAULT NULL,
2399
	`menu_name_lang` varchar(150) DEFAULT NULL,



2400
	`menu_name` varchar(150) DEFAULT NULL,
2400
	`menu_name` varchar(150) DEFAULT NULL,



2401
	`menu_desc` text,
2401
	`menu_desc` TEXT NOT NULL,



2402
	`menu_link` varchar(255) DEFAULT NULL,
2402
	`menu_link` varchar(255) DEFAULT NULL,



2403
	`menu_link_external` tinyint(1) NOT NULL DEFAULT '0',
2403
	`menu_link_external` tinyint(1) NOT NULL DEFAULT '0',



2404
	`auth_view` tinyint(2) NOT NULL DEFAULT '0',
2404
	`auth_view` tinyint(2) NOT NULL DEFAULT '0',


...
...
2514
	klicks INT(11) DEFAULT '0',
2514
	klicks INT(11) DEFAULT '0',



2515
	free TINYINT(1) DEFAULT '0',
2515
	free TINYINT(1) DEFAULT '0',



2516
	extern TINYINT(1) DEFAULT '0',
2516
	extern TINYINT(1) DEFAULT '0',



2517
	long_desc TEXT DEFAULT '',
2517
	long_desc TEXT NOT NULL,



2518
	sort INT(11) DEFAULT '0',
2518
	sort INT(11) DEFAULT '0',



2519
	cat INT(11) DEFAULT '0',
2519
	cat INT(11) DEFAULT '0',



2520
	hacklist TINYINT(1) DEFAULT '0',
2520
	hacklist TINYINT(1) DEFAULT '0',



2521
	hack_author VARCHAR(255) DEFAULT '',
2521
	hack_author VARCHAR(255) DEFAULT '',



2522
	hack_author_email VARCHAR(255) DEFAULT '',
2522
	hack_author_email VARCHAR(255) DEFAULT '',



2523
	hack_author_website TINYTEXT DEFAULT '',
2523
	hack_author_website TINYTEXT,



2524
	hack_version VARCHAR(32) DEFAULT '',
2524
	hack_version VARCHAR(32) DEFAULT '',



2525
	hack_dl_url TINYTEXT DEFAULT '',
2525
	hack_dl_url TINYTEXT,



2526
	test varchar(50) DEFAULT '',
2526
	test varchar(50) DEFAULT '',



2527
	req TEXT DEFAULT '',
2527
	req TEXT NOT NULL,



2528
	todo TEXT DEFAULT '',
2528
	todo TEXT NOT NULL,



2529
	warning TEXT DEFAULT '',
2529
	warning TEXT NOT NULL,



2530
	mod_desc TEXT DEFAULT '',
2530
	mod_desc TEXT NOT NULL,



2531
	mod_list TINYINT(1) DEFAULT '0',
2531
	mod_list TINYINT(1) DEFAULT '0',



2532
	file_size BIGINT(20) NOT NULL DEFAULT '0',
2532
	file_size BIGINT(20) NOT NULL DEFAULT '0',



2533
	change_time INT(11) DEFAULT '0',
2533
	change_time INT(11) DEFAULT '0',


...
...
2551
	path VARCHAR(255) DEFAULT '',
2551
	path VARCHAR(255) DEFAULT '',



2552
	cat_name VARCHAR(255) DEFAULT '',
2552
	cat_name VARCHAR(255) DEFAULT '',



2553
	sort INT(11) DEFAULT '0',
2553
	sort INT(11) DEFAULT '0',



2554
	description TEXT DEFAULT '',
2554
	description TEXT NOT NULL,



2555
	rules TEXT DEFAULT '',
2555
	rules TEXT NOT NULL,



2556
	auth_view TINYINT(1) NOT NULL DEFAULT '1',
2556
	auth_view TINYINT(1) NOT NULL DEFAULT '1',



2557
	auth_dl TINYINT(1) NOT NULL DEFAULT '1',
2557
	auth_dl TINYINT(1) NOT NULL DEFAULT '1',



2558
	auth_up TINYINT(1) NOT NULL DEFAULT '0',
2558
	auth_up TINYINT(1) NOT NULL DEFAULT '0',


...
...
2595
	report_id INT(11) AUTO_INCREMENT NOT NULL,
2595
	report_id INT(11) AUTO_INCREMENT NOT NULL,



2596
	df_id INT(11) NOT NULL DEFAULT '0',
2596
	df_id INT(11) NOT NULL DEFAULT '0',



2597
	report_title VARCHAR(255) DEFAULT '',
2597
	report_title VARCHAR(255) DEFAULT '',



2598
	report_text TEXT,
2598
	report_text TEXT NOT NULL,



2599
	report_file_ver VARCHAR(50) DEFAULT '',
2599
	report_file_ver VARCHAR(50) DEFAULT '',



2600
	report_date INT(11) DEFAULT '0',
2600
	report_date INT(11) DEFAULT '0',



2601
	report_author_id MEDIUMINT(8) DEFAULT 0 NOT NULL,
2601
	report_author_id MEDIUMINT(8) DEFAULT 0 NOT NULL,


...
...
2627
	username VARCHAR(32) NOT NULL DEFAULT '',
2627
	username VARCHAR(32) NOT NULL DEFAULT '',



2628
	comment_time INT(11) NOT NULL DEFAULT '0',
2628
	comment_time INT(11) NOT NULL DEFAULT '0',



2629
	comment_edit_time INT(11) NOT NULL DEFAULT '0',
2629
	comment_edit_time INT(11) NOT NULL DEFAULT '0',



2630
	comment_text TEXT NOT NULL DEFAULT '',
2630
	comment_text TEXT NOT NULL,



2631
	approve TINYINT(1) NOT NULL DEFAULT '0',
2631
	approve TINYINT(1) NOT NULL DEFAULT '0',



2632
PRIMARY KEY (dl_id)
2632
PRIMARY KEY (dl_id)



2633
);
2633
);


...
...
2720
	reg_max_option3 smallint(5) unsigned NOT NULL default '0',
2720
	reg_max_option3 smallint(5) unsigned NOT NULL default '0',



2721
	reg_start int(11) NOT NULL default '0',
2721
	reg_start int(11) NOT NULL default '0',



2722
	reg_length int(11) NOT NULL default '0',
2722
	reg_length int(11) NOT NULL default '0',



2723
	PRIMARY KEY  (reg_id),
2723
	PRIMARY KEY (reg_id),



2724
	KEY `topic_id` (topic_id)
2724
	KEY `topic_id` (topic_id)



2725
);
2725
);



2726
2726



2727
ALTER TABLE phpbb_topics ADD topic_reg TINYINT(1) DEFAULT '0' NOT NULL AFTER topic_calendar_duration;
2727
ALTER TABLE phpbb_topics ADD topic_reg TINYINT(1) DEFAULT '0' NOT NULL AFTER topic_calendar_duration;



2728
## EVENT REG - BEGIN
2728
## EVENT REG - END



2729



2730
## TICKETS - BEGIN



2731
CREATE TABLE phpbb_tickets_cat (



2732
	ticket_cat_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,



2733
	ticket_cat_title VARCHAR(255) NOT NULL DEFAULT '',



2734
	ticket_cat_des TEXT NOT NULL,



2735
	ticket_cat_emails TEXT NOT NULL,



2736
	PRIMARY KEY (ticket_cat_id)



2737
);



2738
## TICKETS - END