PHPize Online / SQLize Online  /  SQLtest Online

CREATE TABLE IF NOT EXISTS `groupe` ( `id_hm` int(2) NOT NULL AUTO_INCREMENT, `groupe_tran` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `onoff` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1' COMMENT '0:no, 1:active', `search` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' COMMENT 'include in search menu, 0: 0ff, 1: on', PRIMARY KEY (`id_hm`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1; INSERT INTO groupe VALUES (NULL, 'GROUP1', 1, 1), (NULL, 'GROUP2', 1, 1); CREATE TABLE IF NOT EXISTS `sgroupe` ( `id_bm` int(2) NOT NULL AUTO_INCREMENT, `id_hm1` tinyint(2) NOT NULL COMMENT 'head menu id', `sgroupe_tran` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `sgroupe_en` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `onoff` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1' COMMENT '0:no, 1:active', `search` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' COMMENT 'include in search menu, 0: 0ff, 1: on', PRIMARY KEY (`id_bm`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=49 ; INSERT INTO sgroupe VALUES (NULL, 1, 'sgroup1-a', 'GP1a', 1, 1), (NULL, 1, 'sgroup1-b', 'GP1b', 1, 1), (NULL, 1, 'sgroup1-c', 'GP1c', 1, 1), (NULL, 1, 'sgroup1-d', 'GP1d', 1, 1), (NULL, 2, 'sgroup2-a', 'GP2a', 1, 1), (NULL, 2, 'sgroup2-b', 'GP2b', 1, 1);