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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
| CREATE TABLE T_ESTABLISHMENT_ETB(
etb_id BIGINT(20) NOT NULL AUTO_INCREMENT,
etb_name VARCHAR(60) NOT NULL,
etb_name_alt VARCHAR(255) DEFAULT NULL,
etb_street VARCHAR(255) DEFAULT NULL,
etb_street_2 VARCHAR(255) DEFAULT NULL,
etb_geo_info VARCHAR(255) DEFAULT NULL,
etb_tel VARCHAR(15) DEFAULT NULL,
etb_tel_2 VARCHAR(15) DEFAULT NULL,
etb_is_sitting INT(1) DEFAULT NULL,
etb_is_sitting_count INT(4) DEFAULT NULL,
etb_is_take_away INT(1) DEFAULT NULL,
etb_is_drive INT(1) DEFAULT NULL,
etb_lat DECIMAL(10, 6) DEFAULT NULL,
etb_long DECIMAL(10, 6) DEFAULT NULL,
etb_website VARCHAR(150) DEFAULT NULL,
etb_status ENUM('offline', 'online', 'closed', 'in work', 'missing informations') NOT NULL DEFAULT 'offline',
etb_facebook VARCHAR(150) DEFAULT NULL,
etb_twitter VARCHAR(150) DEFAULT NULL,
etb_email VARCHAR(50) DEFAULT NULL,
etb_is_wifi INT(1) DEFAULT NULL,
etb_is_terrace INT(1) DEFAULT NULL,
etb_is_terrace_sunny INT(1) DEFAULT NULL,
etb_is_terrace_count INT(4) DEFAULT NULL,
etb_is_terrace_sunny_count INT(4) DEFAULT NULL,
etb_is_air_conditioning INT(1) DEFAULT NULL,
etb_is_smoke_area INT(1) DEFAULT NULL,
etb_is_bio INT(1) DEFAULT NULL,
etb_is_vegetarian INT(1) DEFAULT NULL,
etb_is_halal INT(1) DEFAULT NULL,
etb_is_kosher INT(1) DEFAULT NULL,
etb_customer_card INT(1) DEFAULT NULL,
etb_menu_start_price DECIMAL(3, 1) DEFAULT NULL COMMENT 'A menu is composed at least with 2 elements',
etb_is_menu_unlimited INT(1) DEFAULT NULL,
etb_menu_unlimited_price DECIMAL(3, 1) DEFAULT NULL,
etb_is_meal_voucher INT(1) DEFAULT NULL,
etb_is_credit_card INT(1) DEFAULT NULL,
etb_credit_card_start_price DECIMAL(3, 1) DEFAULT NULL,
etb_is_credit_card_delivery INT(1) DEFAULT NULL,
etb_credit_card_delivery_start_price DECIMAL(3, 1) DEFAULT NULL,
etb_is_cheque INT(1) DEFAULT NULL,
etb_cheque_start_price DECIMAL(3, 1) DEFAULT NULL,
etb_take_away_reduction VARCHAR(60) DEFAULT NULL,
etb_url VARCHAR(255) DEFAULT NULL,
etb_quality INT(5) DEFAULT NULL,
etb_meta_title VARCHAR(73) NOT NULL,
etb_is_franchise INT(11) DEFAULT NULL,
etb_id_parent BIGINT(20) NOT NULL,
txt_id BIGINT(20) DEFAULT NULL,
PRIMARY KEY (etb_id),
INDEX etb_id_parent (etb_id_parent)
)
ENGINE = INNODB
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci; |
Partager