# Sql120640_3 CREATE TABLE news_users ( idusers INT NOT NULL AUTO_INCREMENT, PRIMARY KEY( idusers ), username VARCHAR ( 50 ), password VARCHAR( 255 ), email VARCHAR ( 50 )); CREATE TABLE news_vars ( idvars INT NOT NULL AUTO_INCREMENT, PRIMARY KEY( idvars ), title VARCHAR ( 255 ), bgcolor VARCHAR( 255 ), tborder VARCHAR( 255 ), twidth VARCHAR( 255 ), theight VARCHAR( 255 ), tpadding VARCHAR( 255 ), tspacing VARCHAR( 255 ), howmany VARCHAR ( 255 ), ok VARCHAR ( 255 ), notok VARCHAR ( 255 ), tbg1 VARCHAR( 255 ), tbg2 VARCHAR ( 255 ), tbg3 VARCHAR( 255 ), tbg4 VARCHAR( 255 ), tbg5 VARCHAR ( 255 ), tbg6 VARCHAR( 255 ), fface VARCHAR( 255 ), fcolor VARCHAR ( 255 ), fsize VARCHAR( 255 ), fface2 VARCHAR( 255 ), fcolor2 VARCHAR ( 255 ), fsize2 VARCHAR( 255 ), css blob); CREATE TABLE news_logged ( idlogged INT NOT NULL AUTO_INCREMENT, PRIMARY KEY( idlogged ), IP VARCHAR ( 100 ), HOST VARCHAR( 100 ), WHATTIME VARCHAR ( 100 )); CREATE TABLE news_posted ( idposted INT NOT NULL AUTO_INCREMENT, PRIMARY KEY( idposted ), subject VARCHAR ( 100 ), whattime VARCHAR ( 100 ), messages BLOB, poster VARCHAR ( 100 )); CREATE TABLE news_cookie ( idlog INT NOT NULL AUTO_INCREMENT, PRIMARY KEY( idlog ), browsingid VARCHAR ( 100 ), username VARCHAR ( 100 ), password VARCHAR ( 100 ), timeout VARCHAR ( 100 )); INSERT INTO news_users ( username, password , email ) values('admin','21232f297a57a5a743894a0e4a801fc3','trentatre@fastwebnet.it'); INSERT INTO news_vars ( title, bgcolor, tborder, twidth, theight, tpadding, tspacing, howmany, ok, notok, tbg1, tbg2, tbg3, tbg4, tbg5, tbg6, fface, fcolor, fsize, fface2, fcolor2, fsize2, css ) values('Current News','ff9944','0','100%','*','5','0','10','','','dddddd','ffffff','dddddd','ffffff','dddddd','ffffff','verdana','black','2','arial','black','1',''); INSERT INTO news_posted ( subject, whattime, messages, poster ) values('Introduction','$postedtime','$posted','$news');