CREATE TABLE newsticker (

   id int(11) DEFAULT '0' NOT NULL auto_increment,

   BackgroundColor varchar(6) NOT NULL,

   BorderColor varchar(6) NOT NULL,

   BorderMargin char(1) NOT NULL,

   BorderStyle char(1) NOT NULL,

   richtung int(1) DEFAULT '1' NOT NULL,

   Height int(2) DEFAULT '0' NOT NULL,

   HighlightColor varchar(6) NOT NULL,

   delay int(4) DEFAULT '500' NOT NULL,

   rate int(2) DEFAULT '50' NOT NULL,

   spacing int(3) DEFAULT '2' NOT NULL,

   textfarbe varchar(6) NOT NULL,

   textsize int(2) DEFAULT '11' NOT NULL,

   TextStyle int(2) DEFAULT '0' NOT NULL,

   url varchar(100) DEFAULT 'http://www.screenheads.de' NOT NULL,

   Width int(3) DEFAULT '0' NOT NULL,

   text mediumblob,

   aktuell int(1) DEFAULT '0',

   sprache int(1) DEFAULT '0' NOT NULL,

   pass varchar(20),

   PRIMARY KEY (id)

);



#

# Dumping data for table 'newsticker'

#



INSERT INTO newsticker (id, BackgroundColor, BorderColor, BorderMargin, BorderStyle, richtung, Height, HighlightColor, delay, rate, spacing, textfarbe, textsize, TextStyle, url, Width, text, aktuell, sprache, pass) VALUES ( '1', '006666', '006633', '1', '1', '2', '30', 'CC3333', '300', '30', '4', '99FF99', '20', '4', 'http://www.methodica.ch/', '300', 'PHP-Tickertool zur Administration des Methodica - Tickerapplets', '0', '1', 'test');

INSERT INTO newsticker (id, BackgroundColor, BorderColor, BorderMargin, BorderStyle, richtung, Height, HighlightColor, delay, rate, spacing, textfarbe, textsize, TextStyle, url, Width, text, aktuell, sprache, pass) VALUES ( '2', 'CC9933', 'CC6633', '1', '1', '2', '55', 'FFFF99', '300', '30', '4', '666600', '40', '4', 'http://www.screenheads.de', '250', 'written by O. Strasser / www.screenheads.de

', '1', '1', '');

INSERT INTO newsticker (id, BackgroundColor, BorderColor, BorderMargin, BorderStyle, richtung, Height, HighlightColor, delay, rate, spacing, textfarbe, textsize, TextStyle, url, Width, text, aktuell, sprache, pass) VALUES ( '3', '6666FF', '6666FF', '1', '1', '0', '60', 'FFFF99', '200', '60', '1', '333333', '30', '1', 'http:/www.screenheads.de', '500', 'Stellen Sie als Webmaster Ihrem Kunden die Möglichkeit zur Verfügung,

seinen Newsticker selbst zu pflegen.', '0', '1', '');

INSERT INTO newsticker (id, BackgroundColor, BorderColor, BorderMargin, BorderStyle, richtung, Height, HighlightColor, delay, rate, spacing, textfarbe, textsize, TextStyle, url, Width, text, aktuell, sprache, pass) VALUES ( '4', '660066', 'CC0033', '1', '1', '2', '70', '3333FF', '500', '50', '1', 'FFFFCC', '50', '2', 'http://www.screenheads.de', '300', 'sämtliche verfügbaren Parameter lassen sich einstellen', '0', '1', '');

INSERT INTO newsticker (id, BackgroundColor, BorderColor, BorderMargin, BorderStyle, richtung, Height, HighlightColor, delay, rate, spacing, textfarbe, textsize, TextStyle, url, Width, text, aktuell, sprache, pass) VALUES ( '5', '666600', 'CCCC00', '1', '1', '2', '60', 'FFFFFF', '400', '30', '2', 'CC0033', '40', '3', 'http://www.screenheads.de', '500', 'Damit die Änderungen im Text auch sichtbar werden muss der Browser geschlossen und neu gestartet werden', '0', '1', '');

INSERT INTO newsticker (id, BackgroundColor, BorderColor, BorderMargin, BorderStyle, richtung, Height, HighlightColor, delay, rate, spacing, textfarbe, textsize, TextStyle, url, Width, text, aktuell, sprache, pass) VALUES ( '6', '000066', '6666FF', '1', '1', '2', '70', 'FFFF99', '430', '30', '2', '666600', '60', '3', 'http://www.screenheads.de', '430', 'PHP-Tickertool by http://www.screenheads.de', '0', '1', '');

INSERT INTO newsticker (id, BackgroundColor, BorderColor, BorderMargin, BorderStyle, richtung, Height, HighlightColor, delay, rate, spacing, textfarbe, textsize, TextStyle, url, Width, text, aktuell, sprache, pass) VALUES ( '7', 'FFFF99', 'FFFF00', '1', '1', '0', '80', '00FFFF', '200', '90', '1', '006666', '40', '1', 'http://www.screenheads.de', '100', 'Besuchen Sie unsere Website: http://www.screenheads.de', '0', '1', '');

id int(11) UNSIGNED NOT NULL AUTO_INCREMENT,