| |
автор: Саня (19.06.2005 в 20:19) |
|
| | create table forums (
id tinyint unsigned not null auto_increment primary key,
name varchar(30),
description varchar(150),
last_topic_name varchar(50),
last_topic_id mediumint unsigned not null,
total_topics mediumint unsigned not null,
total_posts unsigned not null,
status tinyint not null default 1
) TYPE=MyISAM; | |
| |
|
|
| |
|
|
| |
для: Саня
(19.06.2005 в 20:19)
| | | при определении поля total_posts пропущен тип mediumint, запрос следует записать следующим образом
CREATE TABLE forums( id tinyint unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY ,
name varchar( 30 ) ,
description varchar( 150 ) ,
last_topic_name varchar( 50 ) ,
last_topic_id mediumint unsigned NOT NULL ,
total_topics mediumint unsigned NOT NULL ,
total_posts mediumint unsigned NOT NULL ,
STATUS tinyint NOT NULL default 1 ) TYPE = MYISAM
|
| |
| |
|
|
