mysql пример создания таблицы для хранения информации о странице

Primary tabs

Submitted by yii-primer on Wed, 01/09/2013 - 17:21

Forums: 

CREATE TABLE `page` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`title` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
	`urlalias_id` INT(11) NULL DEFAULT NULL,
	`body` MEDIUMTEXT NULL COLLATE 'utf8_unicode_ci',
	`published` ENUM('1','0') NOT NULL DEFAULT '0' COLLATE 'utf8_unicode_ci',
	PRIMARY KEY (`id`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB

Key Words for FKN + antitotal forum (CS VSU):

  • Log in to post comments
  • 2500 reads