databases/Apps/Extranet/schema/aide.sql
2016-10-25 15:54:11 +02:00

19 lines
453 B
SQL
Executable File

--
-- Structure de la table `aide`
--
CREATE TABLE IF NOT EXISTS `aide` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`methode` varchar(20) NOT NULL,
`champ` varchar(20) NOT NULL,
`texte` text NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
--
-- Contenu de la table `aide`
--
INSERT INTO `aide` (`id`, `methode`, `champ`, `texte`) VALUES
(1, 'Identite', 'Nom', 'Raison sociale / Nom de l''entreprise (format court avec\r\nabréviations)');