1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| SET AUTOCOMMIT = 0;
START TRANSACTION;
SET collation_connection = latin1_general_ci;
-- ======================
-- Base de Données `base`
-- ======================
DROP DATABASE IF EXISTS `base`;
CREATE DATABASE `base`
DEFAULT CHARACTER SET `latin1`
DEFAULT COLLATE `latin1_general_ci`;
USE `base`;
-- ============
-- Table `test`
-- ============
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test`
( `id` integer unsigned NOT NULL AUTO_INCREMENT,
`category` integer unsigned NOT NULL,
`name` char(20) NOT NULL,
`visiteur` integer unsigned NOT NULL,
PRIMARY KEY (`name`,`category`,`visiteur` desc),
UNIQUE INDEX `idx` (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=`latin1` COLLATE=`latin1_general_ci`
ROW_FORMAT=COMPRESSED; |
Partager