Problem (MySql <-> MSSql 2008): Creating table - How to use Gentle.Framework Class ? (1 Viewer)

[Scrounger]

Hi,

i have a strange behaviour in my plugins. I use the following manual SQL string to create a table in Tv Server Database. I tested it with standard MP MySql Server. But some people from the community has problems using MsSql2008. The strang thing is, that it works for a tvserver plugin, for a MP plugin not ?!

Call

Broker.Execute(SQLstring)

Tv Movie EPG Import++ (TvServer plugin) - works both (MySql, MsSql2008)

CREATE  TABLE `mptvdb`.`TVMovieProgram` ( `idTVMovieProgram` INT NOT NULL AUTO_INCREMENT , `idProgram` INT NOT NULL DEFAULT 0 , `TVMovieBewertung` INT NOT NULL DEFAULT 0 , `FanArt` VARCHAR(255) , `idSeries` INT NOT NULL DEFAULT 0 , `SeriesPosterImage` VARCHAR(255) , `idEpisode` VARCHAR(15) , `EpisodeImage` VARCHAR(255) , `local` BIT(1) NOT NULL DEFAULT 0 , `idMovingPictures` INT NOT NULL DEFAULT 0 , `idVideo` INT NOT NULL DEFAULT 0 , `KurzKritik` VARCHAR(255) , `BildDateiname` VARCHAR(32) , `Cover` VARCHAR(512) , `Fun` INT NOT NULL DEFAULT 0 , `Action` INT NOT NULL DEFAULT 0 , `Feelings` INT NOT NULL DEFAULT 0 , `Erotic` INT NOT NULL DEFAULT 0 , `Tension` INT NOT NULL DEFAULT 0 , `Requirement` INT NOT NULL DEFAULT 0 , `Actors` TEXT , `needsUpdate` BIT(1) NOT NULL DEFAULT 1 , `Dolby` BIT(1) NOT NULL DEFAULT 0 , `HDTV` BIT(1) NOT NULL DEFAULT 0 , `Country` VARCHAR(50) , `Regie` VARCHAR(50) , `Year` DATETIME NOT NULL , `Describtion` TEXT , `ShortDescribtion` TEXT , PRIMARY KEY (`idTVMovieProgram`) )

Clickfinder ProgramGuide (MP plugin) - works not for MsSql2008

CREATE TABLE mptvdb.ClickfinderCategories ( idClickfinderCategories INT NOT NULL AUTO_INCREMENT , Name VARCHAR(255) , Beschreibung VARCHAR(255) , isVisible BIT(1) NOT NULL DEFAULT 0 , Image VARCHAR(255) , SqlString TEXT , sortOrder INT NOT NULL DEFAULT 0 , MinRunTime INT NOT NULL DEFAULT 0 , NowOffset INT NOT NULL DEFAULT 0 , sortedBy VARCHAR(100) , groupName VARCHAR(100) , PRIMARY KEY (idClickfinderCategories) )

Anyone has an idea what could be the reason for this?

Or is there a way to use directly the gentle.framwork class to create tables. An example would be very useful
Thx.