CREATE TABLE IF NOT EXISTS {PREFIX}notes (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    user_id INT(11) NOT NULL,
    title VARCHAR(50),
    body TEXT,
    uri  VARCHAR(150),
    created DATETIME DEFAULT NULL,
    modified DATETIME DEFAULT NULL,
    like_count INT(11) DEFAULT '0',
    dislike_count INT(11) DEFAULT '0',
    comment_count INT(11) DEFAULT '0',
    FULLTEXT KEY title (title,body)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO {PREFIX}notes (user_id,title,body,created,modified,uri)
VALUES ('1', 'The title', 'This is the post body.', NOW(), NOW(),'uri_1'),
       ('1', 'A title once again', 'And the post body follows.', NOW(), NOW(),'uri_2'),
       ('1', 'Title strikes back', 'This is really exciting! Not.', NOW(), NOW(),'uri_3');

INSERT INTO core_blocks(name, path_view,params,is_active)
VALUES('My Notes', 'myNotes','[{"label":"Title","input":"text","value":"MyNotes","name":"title"},{"label":"plugin","input":"hidden","value":"Note","name":"plugin"}]',1);