Parašė bad_user· 2009 Bal. 6 11:04:16
#2
DROP TABLE IF EXISTS prefrix_settings;
CREATE TABLE prefix_settings (
sitename VARCHAR(200) NOT NULL DEFAULT '',
siteurl VARCHAR(200) NOT NULL DEFAULT '',
sitebanner VARCHAR(200) NOT NULL DEFAULT '',
siteemail VARCHAR(100) NOT NULL DEFAULT '',
siteusername VARCHAR(30) NOT NULL DEFAULT '',
siteintro TEXT NOT NULL,
description TEXT NOT NULL,
keywords TEXT NOT NULL,
footer TEXT NOT NULL,
opening_page VARCHAR(100) NOT NULL DEFAULT '',
news_style TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
locale VARCHAR(20) NOT NULL DEFAULT 'English',
theme VARCHAR(100) NOT NULL DEFAULT '',
shortdate VARCHAR(50) NOT NULL DEFAULT '',
longdate VARCHAR(50) NOT NULL DEFAULT '',
forumdate VARCHAR(50) NOT NULL DEFAULT '',
subheaderdate VARCHAR(50) NOT NULL DEFAULT '',
timeoffset VARCHAR(3) NOT NULL DEFAULT '0',
numofthreads SMALLINT(2) UNSIGNED NOT NULL DEFAULT '5',
attachments TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
attachmax INT(12) UNSIGNED NOT NULL DEFAULT '150000',
attachtypes VARCHAR(150) NOT NULL DEFAULT '.gif,.jpg,.png,.zip,.rar,.tar',
thread_notify TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
enable_registration TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL,
email_verification TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL,
admin_activation TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL,
display_validation TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL,
validation_method VARCHAR(5) DEFAULT 'image' NOT NULL,
thumb_w SMALLINT(3) UNSIGNED NOT NULL DEFAULT '100',
thumb_h SMALLINT(3) UNSIGNED NOT NULL DEFAULT '100',
photo_w SMALLINT(4) UNSIGNED NOT NULL DEFAULT '400',
photo_h SMALLINT(4) UNSIGNED NOT NULL DEFAULT '300',
photo_max_w SMALLINT(4) UNSIGNED NOT NULL DEFAULT '1800',
photo_max_h SMALLINT(4) UNSIGNED NOT NULL DEFAULT '1600',
photo_max_b INT(10) UNSIGNED NOT NULL DEFAULT '150000',
thumb_compression CHAR(3) DEFAULT 'gd2' NOT NULL,
thumbs_per_row SMALLINT(2) UNSIGNED NOT NULL DEFAULT '4',
thumbs_per_page SMALLINT(2) UNSIGNED NOT NULL DEFAULT '12',
tinymce_enabled TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
smtp_host VARCHAR(200) NOT NULL DEFAULT '' ,
smtp_username VARCHAR(100) NOT NULL DEFAULT '',
smtp_password VARCHAR(100) NOT NULL DEFAULT '',
bad_words_enabled TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
bad_words TEXT NOT NULL,
bad_word_replace VARCHAR(20) DEFAULT '[censored]' NOT NULL,
guestposts TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
numofshouts TINYINT(2) UNSIGNED NOT NULL DEFAULT '10',
flood_interval TINYINT(2) UNSIGNED NOT NULL DEFAULT '15',
counter BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
version VARCHAR(10) NOT NULL DEFAULT '6.00.400',
maintenance TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
maintenance_message TEXT NOT NULL
) TYPE=MyISAM;
Paryškinta vietą keiti į savo.