upgrade/newdirectory-0.0.1/04_telephone.sql

   1 DROP TABLE IF EXISTS profile_phones;
   2
   3 CREATE TABLE `profile_phones` (
   4     `uid` smallint unsigned NOT NULL,
   5     `link_type` enum('address', 'pro', 'user') NOT NULL DEFAULT 'user' COMMENT 'type of parent element',
   6     `link_id` tinyint unsigned NOT NULL COMMENT 'id of his parent element',
   7     `tel_id` tinyint unsigned NOT NULL COMMENT 'index of this number for the couple (user, parent element)',
   8     `tel_type` enum('fixed', 'mobile', 'fax') NOT NULL DEFAULT 'fixed',
   9     `search_tel` varchar(25) NOT NULL COMMENT 'search number in an international format with only digits and the initial +',
  10     `display_tel` varchar(30) NOT NULL COMMENT 'display number',
  11     `pub` enum('private', 'ax', 'public') NOT NULL DEFAULT 'private',
  12     `comment` varchar(80) NOT NULL,
  13     PRIMARY KEY(`uid`, `link_type`, `link_id`, `tel_id`),
  14     INDEX (`search_tel`),
  15     INDEX uid (uid)
  16 ) ENGINE=InnoDB, CHARSET=utf8;
  17
  18
  19 -- Adds a temporary column to convert phone prefixes from varchar to int
  20 ALTER TABLE `geoloc_pays` ADD COLUMN `tmp_phoneprf` smallint unsigned NULL;
  21
  22 -- Adds phone format column
  23 ALTER TABLE `geoloc_pays` ADD COLUMN `phoneformat` varchar(25) NOT NULL AFTER `nat`;
  24
  25 # vim:set syntax=mysql: