6gU5pD4j

1CREATE TABLE IF NOT EXISTS `phrases2` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `shortcut` varchar(20) NOT NULL,
4  `username` varchar(10) DEFAULT NULL,
5  `groupname` varchar(10) DEFAULT NULL,
6  `phrase_text` text,
7  PRIMARY KEY (`id`)
8) 
9
10INSERT INTO `phrases2` (`id`, `shortcut`, `username`, `groupname`, `phrase_text`) VALUES
11(1, 'a', NULL, NULL, 'AAA'),
12(3, 'b', NULL, NULL, 'BBB'),
13(4, 'c', NULL, NULL, 'CCC'),
14(5, 'a', 'user1', NULL, 'AAA - for user 1'),
15(6, 'a', NULL, 'group1', 'AAA - group1'),
16(7, 'a', 'user2', NULL, 'AAA - for user 2'),
17(8, 'a', NULL, 'group2', 'AAA - group2');