· 7 years ago · Jan 31, 2019, 04:16 PM
1CREATE TABLE IF NOT EXISTS `xphonemessages` (
2 `sender` varchar(50) DEFAULT NULL,
3 `receiver` varchar(50) DEFAULT NULL,
4 `message` text,
5 `timesent` timestamp NULL DEFAULT CURRENT_TIMESTAMP
6) ENGINE=InnoDB DEFAULT CHARSET=latin1;
7
8
9CREATE TABLE IF NOT EXISTS `xphonenumbers` (
10 `number` varchar(50) DEFAULT NULL,
11 `uid` varchar(50) DEFAULT NULL
12) ENGINE=InnoDB DEFAULT CHARSET=latin1;