tehro0n
چهارشنبه 07 مهر 1389, 14:46 عصر
کار index در ساخت جدول phpMyAdmin چیه؟
CREATE TABLE `sites` (
`s_id` SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT ,
`flag` SMALLINT NOT NULL ,
`r_flag` MEDIUMINT UNSIGNED NOT NULL , `site` VARCHAR( 32 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ,
`subject` VARCHAR( 38 ) NOT NULL ,
`comment` VARCHAR( 255 ) NOT NULL ,
`ip` VARCHAR( 16 ) NOT NULL ,
`time` INT UNSIGNED NOT NULL ,
PRIMARY KEY ( `s_id` ) ,
INDEX ( `site` , `time`)
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_persian_ci;
CREATE TABLE `sites` (
`s_id` SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT ,
`flag` SMALLINT NOT NULL ,
`r_flag` MEDIUMINT UNSIGNED NOT NULL , `site` VARCHAR( 32 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ,
`subject` VARCHAR( 38 ) NOT NULL ,
`comment` VARCHAR( 255 ) NOT NULL ,
`ip` VARCHAR( 16 ) NOT NULL ,
`time` INT UNSIGNED NOT NULL ,
PRIMARY KEY ( `s_id` ) ,
INDEX ( `site` , `time`)
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_persian_ci;