[Lukasz2010]

Witam !

Posiadam WebServ 2.0, za pomocą PHP tworzę tabele, lecz tworzonych jest tylko 11 z 20, czy ktoś wie jaka jest przyczyna?

Dzięki z góry.

[Master Nexis]

Może na początek zamieściłbyś kod...

[Lukasz2010]

function CreateTable($DBPrefix)
{
	mysql_query("CREATE TABLE ".$DBPrefix."articles (
	 `id` INT(11) NOT NULL auto_increment,
	 `title` VARCHAR(150) NOT NULL,
	 `go` VARCHAR(255) NOT NULL,
	 `content` text NOT NULL,
	 `author` VARCHAR(25) NOT NULL,
	 `read` INT(11) NOT NULL,
	 `keywords` VARCHAR(255) NOT NULL,
	 PRIMARY KEY(`id`)
	 ) TYPE=MyISAM;");
	 
	 mysql_query("CREATE TABLE ".$DBPrefix."ban (
	`id` INT(11) NOT NULL auto_increment,
	`value` VARCHAR(255) NOT NULL,
	`what` CHAR(1) NOT NULL,
	PRIMARY KEY(`id`)
	) TYPE=MyISAM;");
	
	mysql_query("CREATE TABLE ".$DBPrefix."banip (
	`id` INT(11) NOT NULL auto_increment,
	`ip` VARCHAR(15) NOT NULL,
	PRIMARY KEY(`id`)
	) TYPE=MyISAM;");
	
	mysql_query("CREATE TABLE ".$DBPrefix."block (
	`id` INT(11) NOT NULL auto_increment,
	`name` VARCHAR(20) NOT NULL,
	`view` VARCHAR(255) NOT NULL,
	`page` CHAR(1) NOT NULL,
	`position` int(11) NOT NULL,
	`activ` CHAR(1) NOT NULL,
	PRIMARY KEY (`id`)
	) TYPE=MyISAM;");
	
	mysql_query("CREATE TABLE ".$DBPrefix."config (
	`id` INT(11) NOT NULL auto_increment,
	`name` VARCHAR(20) NOT NULL,
	`value` VARCHAR(255) NOT NULL,
	PRIMARY KEY(`id`)
	) TYPE=MyISAM;");
	
	mysql_query("CREATE TABLE ".$DBPrefix."download (
	 `id` INT(11) NOT NULL auto_increment,
	 `title` VARCHAR(255) NOT NULL,
	 `info` text NOT NULL,
	 `url` VARCHAR(45) NOT NULL,
	 `count` INT(11) NOT NULL,
	 `file` VARCHAR(255) NOT NULL,
	 PRIMAR KEY(`id`)
	 ) TYPE=MyISAM;");
	
	mysql_query("CREATE TABLE ".$DBPrefix."langtemp (
	`id` INT(11) NOT NULL auto_increment,
	`name` VARCHAR(255) NOT NULL,
	`type` CHAR(1) NOT NULL,
	 PRIMARY KEY(`id`)
	 ) TYPE=MyISAM;");
	 
	 mysql_query("CREATE TABLE ".$DBPrefix."menu (
	 `id` INT(11) NOT NULL auto_increment,
	 `title` VARCHAR(35) NOT NULL,
	 `info` VARCHAR(255) NOT NULL,
	 `to` VARCHAR(255) NOT NULL,
	 `pozition` INT(11) NOT NULL,
	 PRIMARY KEY(`id`)
	 ) TYPE=MyISAM;");
	 
	 mysql_query("CREATE TABLE ".$DBPrefix."modules (
	 `id` INT(11) NOT NULL auto_increment,
	 `name` VARCHAR(20) NOT NULL,
	 PRIMARY KEY(`id`)
	 ) TYPE=MyISAM;");
	 
	 mysql_query("CREATE TABLE ".$DBPrefix."news (
	 `id` INT(11) NOT NULL auto_increment,
	 `title` VARCHAR(150) NOT NULL,
	 `go` VARCHAR(255) NOT NULL,
	 `content` text NOT NULL,
	 `author` VARCHAR(25) NOT NULL,
	 `read` INT(11) NOT NULL,
	 `time` VARCHAR(10) NOT NULL,
	 PRIMARY KEY(`id`)
	 ) TYPE=MyISAM;");
	 
	 mysql_query("CREATE TABLE ".$DBPrefix."page (
	 `id` INT(11) NOT NULL auto_increment,
	 `title` VARCHAR(255) NOT NULL,
	 `content` VARCHAR(255) NOT NULL,
	 `kewords` VARCHAR(255) NOT NULL,
	 `description` VARCHAR(255) NOT NULL,
	 PRIMARY KEY(`id`)
	 ) TYPE=MyISAM;");
	 
	 mysql_query("CREATE TABLE ".$DBPrefix."team (
	 `id` INT(11) NOT NULL auto_increment,
	 `name` VARCHAR(25) NOT NULL,
	 `email` VARCHAR(255) NOT NULL,
	 PRIMARY KEY(`id`)
	 ) TYPE=MyISAM;");
	 
	 mysql_query("CREATE TABLE ".$DBPrefix."users (
	 `id` INT(11) NOT NULL auto_increment,
	 `name` VARCHAR(255) NOT NULL,
	 `login` VARCHAR(255) NOT NULL,
	 `password` VARCHAR(255) NOT NULL,
	 `email` VARCHAR(255) NOT NULL,
	 `gg` VARCHAR(10) NOT NULL,
	 `o2` VARCHAR(200) NOT NULL,
	 `skype` VARCHAR(200) NOT NULL,
	 `city` VARCHAR(200) NOT NULL,
	 `site` CHARCHAR(200) NOT NULL,
	 `level` CHAR(1) NOT NULL,
	 `activ` CHAR(1) NOT NULL,
	 `template` VARCHAR(20) NOT NULL,
	 `language` VARCHAR(20) NOT NULL,
	 `key` VARCHAR(30) NOT NULL,
	 PRIMARY KEY(`id`)
	 ) TYPE=MyISAM;"); 
}