# 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');