SHARE
TWEET

Untitled

a guest Feb 16th, 2020 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- Dumping structure for tabel vrpfx.phone_app_chat
  2. DROP TABLE IF EXISTS `phone_app_chat`;
  3. CREATE TABLE IF NOT EXISTS `phone_app_chat` (
  4.   `id` int(11) NOT NULL AUTO_INCREMENT,
  5.   `channel` varchar(20) NOT NULL,
  6.   `message` varchar(255) NOT NULL,
  7.   `time` timestamp NOT NULL DEFAULT current_timestamp(),
  8.   `userid` int(11) NOT NULL,
  9.   PRIMARY KEY (`id`)
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  11.  
  12. -- Dumping data for table vrpfx.phone_app_chat: ~0 rows (approximately)
  13. /*!40000 ALTER TABLE `phone_app_chat` DISABLE KEYS */;
  14. /*!40000 ALTER TABLE `phone_app_chat` ENABLE KEYS */;
  15.  
  16. -- Dumping structure for tabel vrpfx.phone_calls
  17. DROP TABLE IF EXISTS `phone_calls`;
  18. CREATE TABLE IF NOT EXISTS `phone_calls` (
  19.   `id` int(11) NOT NULL AUTO_INCREMENT,
  20.   `owner` varchar(10) NOT NULL COMMENT 'Num tel proprio',
  21.   `num` varchar(10) NOT NULL COMMENT 'Num reférence du contact',
  22.   `incoming` int(11) NOT NULL COMMENT 'Défini si on est à l''origine de l''appels',
  23.   `time` timestamp NOT NULL DEFAULT current_timestamp(),
  24.   `accepts` int(11) NOT NULL COMMENT 'Appels accepter ou pas',
  25.   PRIMARY KEY (`id`)
  26. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  27.  
  28. -- Dumping data for table vrpfx.phone_calls: ~0 rows (approximately)
  29. /*!40000 ALTER TABLE `phone_calls` DISABLE KEYS */;
  30. /*!40000 ALTER TABLE `phone_calls` ENABLE KEYS */;
  31.  
  32. -- Dumping structure for tabel vrpfx.phone_messages
  33. DROP TABLE IF EXISTS `phone_messages`;
  34. CREATE TABLE IF NOT EXISTS `phone_messages` (
  35.   `id` int(11) NOT NULL AUTO_INCREMENT,
  36.   `transmitter` varchar(10) NOT NULL,
  37.   `receiver` varchar(10) NOT NULL,
  38.   `message` varchar(255) NOT NULL DEFAULT '0',
  39.   `time` timestamp NOT NULL DEFAULT current_timestamp(),
  40.   `isRead` int(11) NOT NULL DEFAULT 0,
  41.   `owner` int(11) NOT NULL DEFAULT 0,
  42.   PRIMARY KEY (`id`)
  43. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  44.  
  45. -- Dumping data for table vrpfx.phone_messages: 0 rows
  46. /*!40000 ALTER TABLE `phone_messages` DISABLE KEYS */;
  47. /*!40000 ALTER TABLE `phone_messages` ENABLE KEYS */;
  48.  
  49. -- Dumping structure for tabel vrpfx.phone_twitter
  50. DROP TABLE IF EXISTS `phone_twitter`;
  51. CREATE TABLE IF NOT EXISTS `phone_twitter` (
  52.   `id` int(11) NOT NULL AUTO_INCREMENT,
  53.   `userid` int(11) NOT NULL,
  54.   `name` varchar(300) NOT NULL,
  55.   `message` varchar(300) NOT NULL,
  56.   `time` varchar(30) NOT NULL,
  57.   PRIMARY KEY (`id`)
  58. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top