[Sommaire] [Imprimer]

   1  # Database: messages.db for I18N in PRADO
   2  # --------------------------------------------------------
   3  
   4  #
   5  # Table structure for table: catalogue
   6  #
   7  CREATE TABLE catalogue ( 
   8    cat_id INTEGER PRIMARY KEY, 
   9    name VARCHAR NOT NULL, 
  10    source_lang VARCHAR , 
  11    target_lang VARCHAR , 
  12    date_created INT, 
  13    date_modified INT, 
  14    author VARCHAR );
  15  
  16  #
  17  # Dumping data for table: catalogue
  18  #
  19  INSERT INTO catalogue VALUES ('1', 'messages', '', '', '', '', '');
  20  INSERT INTO catalogue VALUES ('2', 'messages.en', '', '', '', '', '');
  21  INSERT INTO catalogue VALUES ('3', 'messages.en_AU', '', '', '', '', '');
  22  # --------------------------------------------------------
  23  
  24  
  25  #
  26  # Table structure for table: trans_unit
  27  #
  28  CREATE TABLE trans_unit ( 
  29    msg_id INTEGER PRIMARY KEY, 
  30    cat_id INTEGER NOT NULL DEFAULT '1', 
  31    id VARCHAR, 
  32    source TEXT, 
  33    target TEXT, 
  34    comments TEXT, 
  35    date_added INT, 
  36    date_modified INT, 
  37    author VARCHAR, 
  38    translated INT(1) NOT NULL DEFAULT '0' );
  39  
  40  #
  41  # Dumping data for table: trans_unit
  42  #
  43  INSERT INTO trans_unit VALUES ('1', '1', '1', 'Hello', 'Hello World', '', '', '', '', '1');
  44  INSERT INTO trans_unit VALUES ('2', '2', '', 'Hello', 'Hello :)', '', '', '', '', '0');
  45  INSERT INTO trans_unit VALUES ('3', '1', '1', 'Welcome', 'Welcome', '', '', '', '', '0');
  46  INSERT INTO trans_unit VALUES ('4', '3', '', 'Hello', 'G''day Mate!', '', '', '', '', '0');
  47  INSERT INTO trans_unit VALUES ('5', '3', '', 'Welcome', 'Welcome Mate!', '', '', '', '', '0');
  48  # --------------------------------------------------------
  49