protected static $tables = [
'wgbb_notes' => [
'createQuery' => 'CREATE TABLE IF NOT EXISTS `wgbb_notes` (
`note_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL,
`note_text` text NOT NULL,
`created_at` int(11) NOT NULL,
PRIMARY KEY (`note_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1',
'dropQuery' => 'DROP TABLE IF EXISTS `wgbb_notes`'
],
'wgbb_note_read' => [
'createQuery' => 'CREATE TABLE IF NOT EXISTS `wgbb_note_read` (
`user_id` int(10) unsigned NOT NULL,
`last_read` int(10) unsigned NOT NULL,
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;',
'dropQuery' => 'DROP TABLE IF EXISTS `wgbb_note_read`'
]
];
