root/ip/trunk/install/schemas/mysql_schema.sql

Show revision log
 
161167
1199
	`file_id` int(10) NOT NULL auto_increment,
1199
	`file_id` int(10) NOT NULL auto_increment,
1200
	`user_id` mediumint(8) NOT NULL DEFAULT '0',
1200
	`user_id` mediumint(8) NOT NULL DEFAULT '0',
1201
	`poster_ip` varchar(8) NOT NULL DEFAULT '',
1201
	`poster_ip` varchar(8) NOT NULL DEFAULT '',
 
1202
	`file_name` TEXT NOT NULL,
1202
	`file_name` text NOT NULL,
 
1203
	`file_size` int(20) NOT NULL DEFAULT '0',
1203
	`file_size` int(20) NOT NULL DEFAULT '0',
1204
	`unique_name` varchar(255) NOT NULL DEFAULT '',
1204
	`unique_name` varchar(255) NOT NULL DEFAULT '',
1205
	`real_name` varchar(255) NOT NULL DEFAULT '',
1205
	`real_name` varchar(255) NOT NULL DEFAULT '',
1206
	`file_dir` varchar(255) NOT NULL DEFAULT '',
1206
	`file_dir` varchar(255) NOT NULL DEFAULT '',
 
1207
	`file_desc` TEXT NOT NULL,
1207
	`file_desc` text NOT NULL,
1208
	`file_creator` TEXT NOT NULL,
1208
	`file_creator` text NOT NULL,
1209
	`file_version` TEXT NOT NULL,
1209
	`file_version` text NOT NULL,
1210
	`file_longdesc` TEXT NOT NULL,
1210
	`file_longdesc` text NOT NULL,
1211
	`file_ssurl` TEXT NOT NULL,
1211
	`file_ssurl` text NOT NULL,
 
1212
	`file_sshot_link` tinyint(2) NOT NULL DEFAULT '0',
1212
	`file_sshot_link` tinyint(2) NOT NULL DEFAULT '0',
 
1213
	`file_dlurl` TEXT NOT NULL,
1213
	`file_dlurl` text NOT NULL,
 
1214
	`file_time` int(50) DEFAULT NULL,
1214
	`file_time` int(50) DEFAULT NULL,
1215
	`file_update_time` int(50) NOT NULL DEFAULT '0',
1215
	`file_update_time` int(50) NOT NULL DEFAULT '0',
1216
	`file_catid` int(10) DEFAULT NULL,
1216
	`file_catid` int(10) DEFAULT NULL,
 
1217
	`file_posticon` TEXT NOT NULL,
1217
	`file_posticon` text NOT NULL,
 
1218
	`file_license` int(10) DEFAULT NULL,
1218
	`file_license` int(10) DEFAULT NULL,
1219
	`file_dls` int(10) DEFAULT NULL,
1219
	`file_dls` int(10) DEFAULT NULL,
1220
	`file_last` int(50) DEFAULT NULL,
1220
	`file_last` int(50) DEFAULT NULL,
1221
	`file_pin` int(2) DEFAULT NULL,
1221
	`file_pin` int(2) DEFAULT NULL,
 
1222
	`file_docsurl` TEXT NOT NULL,
1222
	`file_docsurl` text NOT NULL,
 
1223
	`file_approved` tinyint(1) NOT NULL DEFAULT '1',
1223
	`file_approved` tinyint(1) NOT NULL DEFAULT '1',
1224
	`file_broken` tinyint(1) NOT NULL DEFAULT '0',
1224
	`file_broken` tinyint(1) NOT NULL DEFAULT '0',
1225
	PRIMARY KEY (`file_id`)
1225
	PRIMARY KEY (`file_id`)
...
...
1283
## `phpbb_plugins`
1283
## `phpbb_plugins`



1284
1284



1285
CREATE TABLE phpbb_plugins (
1285
CREATE TABLE phpbb_plugins (



1286
	plugin_name VARCHAR(255) NOT NULL DEFAULT '',
1286
	plugin_name varchar(255) NOT NULL DEFAULT '',



1287
	plugin_dir VARCHAR(255) NOT NULL DEFAULT '',
1287
	plugin_dir varchar(255) NOT NULL DEFAULT '',



1288
	plugin_enabled tinyint(2) NOT NULL DEFAULT 0,
1288
	plugin_enabled tinyint(2) NOT NULL DEFAULT 0,



1289
	PRIMARY KEY (plugin_name)
1289
	PRIMARY KEY (plugin_name)



1290
);
1290
);


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



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



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



1308
	`post_text` TEXT NOT NULL,
1308
	`post_text` text NOT NULL,



1309
	`post_text_compiled` TEXT NOT NULL,
1309
	`post_text_compiled` TEXT NOT NULL,



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



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



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



1313
	`enable_autolinks_acronyms` tinyint(1) NOT NULL DEFAULT '1',
1313
	`enable_autolinks_acronyms` tinyint(1) NOT NULL DEFAULT '1',



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



1315
	`edit_notes` MEDIUMTEXT,
1315
	`edit_notes` mediumtext,



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



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



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


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



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



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



1339
	`privmsgs_text` TEXT NOT NULL,
1339
	`privmsgs_text` text NOT NULL,



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



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



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


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



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



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



1366
	`privmsgs_text` TEXT NOT NULL,
1366
	`privmsgs_text` text NOT NULL,



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



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



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


...
...
1396
	`text_area_default` TEXT NOT NULL,
1396
	`text_area_default` TEXT NOT NULL,



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



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



1399
	`radio_button_values` TEXT NOT NULL,
1399
	`radio_button_values` text NOT NULL,



1400
	`checkbox_default` TEXT NOT NULL,
1400
	`checkbox_default` text NOT NULL,



1401
	`checkbox_values` TEXT NOT NULL,
1401
	`checkbox_values` text NOT NULL,



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



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



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