jci9U8i8

1ALTER TABLE `user_message`
2	ADD COLUMN `phone_number` VARCHAR(10) NULL;
3
4CREATE TABLE IF NOT EXISTS `phone_messages` (
5  `id` int(11) NOT NULL AUTO_INCREMENT,
6  `transmitter` varchar(10) NOT NULL,
7  `receiver` varchar(10) NOT NULL,
8  `message` varchar(255) NOT NULL DEFAULT '0',
9  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
10  `isRead` int(11) NOT NULL DEFAULT '0',
11  `owner` int(11) NOT NULL DEFAULT '0',
12  PRIMARY KEY (`id`)
13);
14
15CREATE TABLE IF NOT EXISTS `phone_users_contacts` (
16  `id` int(11) NOT NULL AUTO_INCREMENT,
17  `identifier` varchar(255) NOT NULL,
18  `number` varchar(10) NOT NULL,
19  `display` varchar(64) NOT NULL,
20  PRIMARY KEY (`id`)
21);
22
23
24-- CONVERT
25-- INSERT into phone_users_contacts ( identifier, number, display) 
26-- (Select user_phonelist.owner_id , users.phone_number , CONCAT(users.prenom, ' ', users.nom)
27-- from user_phonelist left join users on users.identifier = user_phonelist.contact_id)