Бази даних

створити таблицю новини
CREATE TABLE news
(
ID SMALLINT UNSIGNED NOT NULL auto_increment,
title VARCHAR(180) NOT NULL,
text TEXT NOT NULL,
tema TEXT NOT NULL,
ntext TEXT NOT NULL,
category VARCHAR(50) NOT NULL,
fotossulka VARCHAR(50) NOT NULL,
fotopodpis VARCHAR(50) NOT NULL,
comment TEXT NOT NULL,
foto1 VARCHAR(30) NOT NULL,
foto2 VARCHAR(30) NOT NULL,
aid INT(9) NOT NULL,
date1     DATETIME     NOT NULL,
time time NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
topnews VARCHAR(10) NOT NULL,
reiting INT(9) NOT NULL,
sum INT(9) NOT NULL,
count INT(9) NOT NULL,
today date NOT NULL,
status VARCHAR(15) NOT NULL,
ip VARCHAR(30) NOT NULL,
PRIMARY KEY(ID)
);