joomla/com_wk1_6/admin/sql/install.mysql.utf8.sql

DROP TABLE IF EXISTS `#__wk1`;
 
CREATE TABLE `#__wk1` (
    `id`       INT(11)     NOT NULL AUTO_INCREMENT,
    `greeting` VARCHAR(25) NOT NULL,
    `published` tinyint(4) nOT NULL DEFAULT '1',
    PRIMARY KEY (`id`)
)
    ENGINE =MyISAM
    AUTO_INCREMENT =0
    DEFAULT CHARSET =utf8;
 
INSERT INTO `#__wk1` (`greeting`) VALUES
('Salut component wk1'),
('Tschüss component wk1');