Création d'un wiki à partir d'un SQL
Closed this issue · 0 comments
sylvainboyer commented
- Le fichier
create-table.sql
contient
CREATE TABLE `{{prefix}}__nature` (
`bn_id_nature` int(10) UNSIGNED NOT NULL DEFAULT 0,
`bn_label_nature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bn_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bn_condition` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bn_sem_context` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bn_sem_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bn_sem_use_template` tinyint(1) NOT NULL DEFAULT 1,
`bn_template` text COLLATE utf8mb4_unicode_ci NOT NULL,
`bn_ce_i18n` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`bn_id_nature`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- Sur un wiki récent (Version du Wiki : 2019-12-09-1 ), la base contient
| 1 | bn_id_nature | int(10) | | UNSIGNED | No | 0 | | | Change | Drop | More
| 2 | varchar(255) | utf8mb4_unicode_ci | | Yes | NULL | | | Change | Drop | More
| 3 | text | utf8mb4_unicode_ci | | Yes | | | | Change | Drop | More
| 4 | text | utf8mb4_unicode_ci | | Yes | | | | Change | Drop | More
| 5 | text | utf8mb4_unicode_ci | | No | | | | Change | Drop | More
| 6 | varchar(5) | utf8mb4_unicode_ci | | No | | | | Change | Drop | More
- Le fichier généré par `{{generatemodel}} contient
INSERT INTO `{{prefix}}__nature` (`bn_id_nature`, `bn_label_nature`, `bn_description`, `bn_condition`, `bn_ce_id_menu`, `bn_commentaire`, `bn_appropriation`, `bn_image_titre`, `bn_image_logo`, `bn_couleur_calendrier`, `bn_picto_calendrier`, `bn_template`, `bn_ce_i18n`, `bn_type_fiche`, `bn_label_class`) VALUES
Résultat
#1054 - Unknown column 'bn_ce_id_menu' in 'field list'