BNoteBot/create_table.SQL at master · Bfas237/BNoteBot · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
CREATE TABLE IF NOT EXISTS `BNoteBot_memo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL,
  `memo` text NOT NULL,
  `timestamp` int(11) NOT NULL,
  `type` text,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `memo` (`memo`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;

CREATE TABLE IF NOT EXISTS `BNoteBot_reminder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL,
  `memoid` int(11) NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;

CREATE TABLE IF NOT EXISTS `BNoteBot_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userID` text,
  `username` text,
  `name` text,
  `status` text,
  `lang` text,
  `invertmemodata` int(1) NOT NULL DEFAULT '0',
  `justwritemode` tinyint(1) NOT NULL DEFAULT '1',
  `timezone` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;