OXPUS.de

Code: Alles auswählen

MySQL meldet:  

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'character set latin1 NOT NULL,
  `chapter_img` varchar(32) cha 

Code: Alles auswählen

CREATE TABLE `phpbb_kitaplik_ayarlar` (
  `config_name` varchar(255) character set latin1 NOT NULL default '',
  `config_value` varchar(255) character set latin1 NOT NULL default '',
  PRIMARY KEY  (`config_name`)
);

INSERT INTO `phpbb_kitaplik_ayarlar` VALUES ('allow_html', '0');
INSERT INTO `phpbb_kitaplik_ayarlar` VALUES ('allow_bbcode', '1');
INSERT INTO `phpbb_kitaplik_ayarlar` VALUES ('allow_smilies', '1');
INSERT INTO `phpbb_kitaplik_ayarlar` VALUES ('allow_avatar', '1');
INSERT INTO `phpbb_kitaplik_ayarlar` VALUES ('icons_path', 'images/icons');
INSERT INTO `phpbb_kitaplik_ayarlar` VALUES ('articles_per_page', '12');
INSERT INTO `phpbb_kitaplik_ayarlar` VALUES ('comments_per_page', '10');
INSERT INTO `phpbb_kitaplik_ayarlar` VALUES ('max_rating', '5');
INSERT INTO `phpbb_kitaplik_ayarlar` VALUES ('resim_yukseklik', '150');
INSERT INTO `phpbb_kitaplik_ayarlar` VALUES ('articles_on_list_a', '4');
INSERT INTO `phpbb_kitaplik_ayarlar` VALUES ('articles_on_list_b', '2');
INSERT INTO `phpbb_kitaplik_ayarlar` VALUES ('resim_genislik', '150');

CREATE TABLE `phpbb_kitaplik_bolumler` (
  `chapter_id` smallint(5) unsigned NOT NULL auto_increment,
  `chapter_name` varchar(50) character set latin1 NOT NULL default '',
  `chapter_desc` text character set latin1 NOT NULL,
  `chapter_img` varchar(32) character set latin1 NOT NULL default '',
  `chapter_order` smallint(5) NOT NULL default '0',
  `chapter_parent_id` smallint(5) unsigned NOT NULL default '0',
  `pending_article` tinyint(1) unsigned NOT NULL default '0',
  `pending_comments` tinyint(1) unsigned NOT NULL default '0',
  `enable_comments` tinyint(1) unsigned NOT NULL default '0',
  `stop_article_count` tinyint(1) unsigned NOT NULL default '0',
  `stop_comment_count` tinyint(1) unsigned NOT NULL default '0',
  `chapter_articles` mediumint(8) unsigned NOT NULL default '0',
  `chapter_comments` mediumint(8) unsigned NOT NULL default '0',
  `a_view` tinyint(1) unsigned NOT NULL default '0',
  `a_read` tinyint(1) unsigned NOT NULL default '0',
  `a_new` tinyint(1) unsigned NOT NULL default '0',
  `a_edit` tinyint(1) unsigned NOT NULL default '0',
  `a_delete` tinyint(1) unsigned NOT NULL default '0',
  `a_rate` tinyint(1) unsigned NOT NULL default '0',
  `a_approve` tinyint(1) unsigned NOT NULL default '0',
  `c_view` tinyint(1) unsigned NOT NULL default '0',
  `c_new` tinyint(1) unsigned NOT NULL default '0',
  `c_edit` tinyint(1) unsigned NOT NULL default '0',
  `c_delete` tinyint(1) unsigned NOT NULL default '0',
  `c_rate` tinyint(1) unsigned NOT NULL default '0',
  `c_approve` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`chapter_id`),
  KEY `chapter_parent_id` (`chapter_parent_id`,`chapter_id`)
);

INSERT INTO `phpbb_kitaplik_bolumler` VALUES (10, 'Yemek', 'Lezzetin, sayfalardan yayyldy?y an', '', 140, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (11, 'Hobi & Ýþ', 'Boþ zamanlarýn en deðerli dostu', '', 80, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (5, 'Mizah', 'Mizahsal, eðlencelik kitaplar', '', 90, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (6, 'Dini', 'Din üzerine yazýlmýþ kitaplar', '', 30, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (7, 'Roman', 'Sayfalar ilerledikçe sürükleyiciði artan', '', 100, 0, 0, 0, 1, 0, 0, 11, 2, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (8, 'Denemeler', 'Önü parlak, arkasý kara aynalar...', '', 40, 0, 0, 0, 1, 0, 0, 16, 9, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (9, 'Þiir', 'Her satýrýn sonunda mutlu bir son', '', 120, 0, 0, 0, 1, 0, 0, 36, 28, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (12, 'Teknik', 'Bilgisayar, elektronik, mekanik vs...', '', 130, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (13, 'Fikir & Düþünce', 'Akýl akýldan üstündür...', '', 70, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (14, 'Felsefe', 'Varsa yok mu?', '', 60, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (15, 'Saðlýk', 'Nane, limon kabuðu...', '', 110, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (16, 'Çocuk', 'Yaþamýn ilk yýllarý', '', 20, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (17, 'Evlilik', 'En güzel birliktelikler', '', 50, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);
INSERT INTO `phpbb_kitaplik_bolumler` VALUES (18, 'Araþtýrma', 'Mercek altýna alýnanlar', '', 10, 0, 0, 0, 1, 0, 0, 3, 0, 0, 0, 1, 1, 1, 1, 5, 0, 1, 1, 1, 1, 5);

CREATE TABLE `phpbb_kitaplik_kitaplar` (
  `article_id` mediumint(8) unsigned NOT NULL auto_increment,
  `chapter_id` smallint(5) unsigned NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `article_icon` mediumint(8) unsigned NOT NULL default '0',
  `article_views` mediumint(8) unsigned NOT NULL default '0',
  `article_comments` mediumint(8) unsigned NOT NULL default '0',
  `article_username` varchar(255) character set latin1 NOT NULL default '',
  `article_ip` varchar(8) character set latin1 NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  `article_pending` tinyint(1) NOT NULL default '0',
  `enable_bbcode` tinyint(1) NOT NULL default '0',
  `enable_html` tinyint(1) NOT NULL default '0',
  `enable_smilies` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`article_id`),
  KEY `chapter_id` (`chapter_id`),
  KEY `user_id` (`user_id`),
  KEY `icon_id` (`article_icon`)
);

CREATE TABLE `phpbb_kitaplik_kitaplar_puan` (
  `article_id` mediumint(8) unsigned NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `user_ip` char(8) character set latin1 NOT NULL default '',
  `rating` tinyint(2) NOT NULL default '0',
  `time` int(11) default NULL,
  KEY `article_id` (`article_id`),
  KEY `user_id` (`user_id`)
);

CREATE TABLE `phpbb_kitaplik_kitaplar_tanitimlar` (
  `article_id` mediumint(8) NOT NULL default '0',
  `article_title` varchar(255) character set latin1 NOT NULL default '',
  `kitap_resim` varchar(255) character set latin1 NOT NULL default '',
  `kitabevi` varchar(255) character set latin1 NOT NULL default '',
  `kitap_yazar` varchar(255) character set latin1 NOT NULL default '',
  `isbn_no` int(15) NOT NULL default '0',
  `sayfa` int(5) NOT NULL default '0',
  `ceviren` varchar(255) character set latin1 NOT NULL default '',
  `pic_filename` varchar(255) character set latin1 NOT NULL default '',
  `article_text` text character set latin1 NOT NULL,
  `bbcode_uid` varchar(10) character set latin1 NOT NULL default '',
  KEY `article_id` (`article_id`)
);

CREATE TABLE `phpbb_kitaplik_kullanici_izinleri` (
  `group_id` mediumint(8) unsigned NOT NULL default '0',
  `chapter_id` smallint(5) unsigned NOT NULL default '0',
  `a_view` tinyint(1) unsigned NOT NULL default '0',
  `a_read` tinyint(1) unsigned NOT NULL default '0',
  `a_new` tinyint(1) unsigned NOT NULL default '0',
  `a_edit` tinyint(1) unsigned NOT NULL default '0',
  `a_delete` tinyint(1) unsigned NOT NULL default '0',
  `a_rate` tinyint(1) unsigned NOT NULL default '0',
  `a_approve` tinyint(1) unsigned NOT NULL default '0',
  `c_view` tinyint(1) unsigned NOT NULL default '0',
  `c_new` tinyint(1) unsigned NOT NULL default '0',
  `c_edit` tinyint(1) unsigned NOT NULL default '0',
  `c_delete` tinyint(1) unsigned NOT NULL default '0',
  `c_rate` tinyint(1) unsigned NOT NULL default '0',
  `c_approve` tinyint(1) unsigned NOT NULL default '0',
  KEY `group_id` (`group_id`),
  KEY `chapter_id` (`chapter_id`)
);


CREATE TABLE `phpbb_kitaplik_yorum_yazilari` (
  `comment_id` mediumint(8) unsigned NOT NULL default '0',
  `article_id` mediumint(8) unsigned NOT NULL default '0',
  `subject` varchar(255) character set latin1 NOT NULL default '',
  `comments` text character set latin1 NOT NULL,
  `bbcode_uid` varchar(10) character set latin1 NOT NULL default '',
  KEY `comment_id` (`comment_id`),
  KEY `article_id` (`article_id`)
);

CREATE TABLE `phpbb_kitaplik_yorumlar` (
  `comment_id` mediumint(8) unsigned NOT NULL auto_increment,
  `article_id` mediumint(8) unsigned NOT NULL default '0',
  `chapter_id` smallint(5) unsigned NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `comment_icon` mediumint(8) unsigned NOT NULL default '0',
  `comment_username` varchar(20) character set latin1 NOT NULL default '',
  `comment_ip` varchar(8) character set latin1 NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  `comment_pending` tinyint(1) unsigned NOT NULL default '0',
  `enable_html` tinyint(1) unsigned NOT NULL default '0',
  `enable_bbcode` tinyint(1) unsigned NOT NULL default '0',
  `enable_smilies` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`comment_id`),
  KEY `user_id` (`user_id`),
  KEY `article_id` (`article_id`),
  KEY `chapter_id` (`chapter_id`)
);

CREATE TABLE `phpbb_kitaplik_yorumlar_puan` (
  `comment_id` mediumint(8) unsigned NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `user_ip` char(8) character set latin1 NOT NULL default '',
  `rating` tinyint(2) NOT NULL default '0',
  `time` int(11) default NULL,
  KEY `comments_id` (`comment_id`),
  KEY `user_id` (`user_id`)
);

ALTER TABLE `phpbb_users` ADD COLUMN `user_articles` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `user_posts`;
ALTER TABLE `phpbb_users` ADD COLUMN `user_comments` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `user_articles`; 

Code: Alles auswählen

character set latin1