Тематика форума', 'Краткое описание', 1, 'show'); CREATE TABLE liteforum_last_time ( id_author int(11) NOT NULL auto_increment, now1 datetime NOT NULL default '0000-00-00 00:00:00', last_time1 datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id_author) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; CREATE TABLE liteforum_links ( id_links int(11) NOT NULL auto_increment, name tinytext NOT NULL, url tinytext NOT NULL, hide enum('show','hide') NOT NULL default 'show', pos tinyint(11) NOT NULL default '0', part tinyint(11) NOT NULL default '0', PRIMARY KEY (id_links) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; CREATE TABLE liteforum_personally ( id_personally int(11) NOT NULL auto_increment, id_theme int(11) NOT NULL default '0', id_first int(11) NOT NULL default '0', id_second int(11) NOT NULL default '0', PRIMARY KEY (id_personally), KEY id_theme (id_theme), KEY id_first (id_first), KEY id_second (id_second) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; CREATE TABLE liteforum_posts ( id_post int(11) NOT NULL auto_increment, name text NOT NULL, url tinytext NOT NULL, putfile tinytext NOT NULL, author tinytext NOT NULL, id_author int(6) NOT NULL default '0', hide enum('show','hide','lock') NOT NULL default 'show', `time` datetime NOT NULL default '0000-00-00 00:00:00', parent_post int(11) NOT NULL default '0', id_theme int(11) NOT NULL default '0', PRIMARY KEY (id_post), FULLTEXT KEY search (`name`,author) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; CREATE TABLE liteforum_settings ( name_forum tinytext NOT NULL, number_themes int(11) NOT NULL default '0', size_file int(11) NOT NULL default '0', size_photo int(10) NOT NULL default '0', send_mail enum('yes','no') NOT NULL default 'no', email tinytext NOT NULL, show_struct_switch enum('yes','no') NOT NULL default 'yes', show_forum_switch enum('yes','no') NOT NULL default 'yes', hello tinytext NOT NULL, cooktime int(10) NOT NULL default '0', skin tinytext NOT NULL, show_personally enum('yes','no') NOT NULL default 'no', user_email_required enum('yes','no') NOT NULL default 'no', email_distribution enum('yes','no') NOT NULL default 'no', registration_required enum('yes','no') NOT NULL default 'no', type_crypt enum('PLAIN','MD5','PASSWORD','OLD_PASSWORD') NOT NULL default 'MD5', confirm_registration enum('yes','no') NOT NULL default 'no' ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; INSERT INTO liteforum_settings VALUES('Форум PHP', 30, 1024000, 824288, 'yes', 'somebody@somewhere.ru', 'yes', 'yes', 'Здравствуйте,', 100, 'base', 'yes', 'no', 'no', 'no', 'MD5', 'no'); CREATE TABLE liteforum_themes ( id_theme int(11) NOT NULL auto_increment, name tinytext NOT NULL, author tinytext NOT NULL, id_author int(6) NOT NULL default '0', last_author tinytext NOT NULL, id_last_author int(6) NOT NULL default '0', hide enum('show','hide','lock') NOT NULL default 'show', `time` datetime NOT NULL default '0000-00-00 00:00:00', id_forum int(2) NOT NULL default '0', PRIMARY KEY (id_theme), FULLTEXT KEY search (`name`,author) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; "; $res=@mysql_query($sql)or die("Ошибка: " . mysql_error()); if(!$res){echo "Провал";} else { echo "Таблица создана!"; } ?>