[Sommaire] [Imprimer]

   1  # 
   2  # Database : `messages` for I18N in PRADO
   3  # 
   4  
   5  # --------------------------------------------------------
   6  
   7  #
   8  # Table structure for table `catalogue`
   9  #
  10  
  11  CREATE TABLE `catalogue` (
  12    `cat_id` int(11) NOT NULL auto_increment,
  13    `name` varchar(100) NOT NULL default '',
  14    `source_lang` varchar(100) NOT NULL default '',
  15    `target_lang` varchar(100) NOT NULL default '',
  16    `date_created` int(11) NOT NULL default '0',
  17    `date_modified` int(11) NOT NULL default '0',
  18    `author` varchar(255) NOT NULL default '',
  19    PRIMARY KEY  (`cat_id`)
  20  ) TYPE=MyISAM AUTO_INCREMENT=4 ;
  21  
  22  #
  23  # Dumping data for table `catalogue`
  24  #
  25  
  26  INSERT INTO `catalogue` VALUES (1, 'messages', '', '', 0, 0, '');
  27  INSERT INTO `catalogue` VALUES (2, 'messages.en', '', '', 0, 0, '');
  28  INSERT INTO `catalogue` VALUES (3, 'messages.en_AU', '', '', 0, 0, '');
  29  
  30  # --------------------------------------------------------
  31  
  32  #
  33  # Table structure for table `trans_unit`
  34  #
  35  
  36  CREATE TABLE `trans_unit` (
  37    `msg_id` int(11) NOT NULL auto_increment,
  38    `cat_id` int(11) NOT NULL default '1',
  39    `id` varchar(255) NOT NULL default '',
  40    `source` text NOT NULL,
  41    `target` text NOT NULL,
  42    `comments` text NOT NULL,
  43    `date_added` int(11) NOT NULL default '0',
  44    `date_modified` int(11) NOT NULL default '0',
  45    `author` varchar(255) NOT NULL default '',
  46    `translated` tinyint(1) NOT NULL default '0',
  47    PRIMARY KEY  (`msg_id`)
  48  ) TYPE=MyISAM AUTO_INCREMENT=6 ;
  49  
  50  #
  51  # Dumping data for table `trans_unit`
  52  #
  53  
  54  INSERT INTO `trans_unit` VALUES (1, 1, '1', 'Hello', 'Hello World', '', 0, 0, '', 1);
  55  INSERT INTO `trans_unit` VALUES (2, 2, '', 'Hello', 'Hello :)', '', 0, 0, '', 0);
  56  INSERT INTO `trans_unit` VALUES (3, 1, '1', 'Welcome', 'Welcome', '', 0, 0, '', 0);
  57  INSERT INTO `trans_unit` VALUES (4, 3, '', 'Hello', 'G\'day Mate!', '', 0, 0, '', 0);
  58  INSERT INTO `trans_unit` VALUES (5, 3, '', 'Welcome', 'Welcome Mate!', '', 0, 0, '', 0);