Changeset 631


Ignore:
Timestamp:
02/06/12 05:36:42 (4 months ago)
Author:
radu
Message:

fix alias coherence

Files:
2 edited

Legend:

Unmodified
Added
Removed

  • patches/00065.sql

    r629 r631  
    11CREATE TABLE `RandomWord` ( 
    22    `id` int(11) NOT NULL DEFAULT '0', 
    3     `form` char(50) NOT NULL, 
     3    `cuv` char(50) NOT NULL, 
    44    `surse` char(255) DEFAULT NULL, 
    55    PRIMARY KEY (`id`) 
    … …  
    88 
    99INSERT INTO RandomWord 
    10 SELECT L.id, L.formNoAccent form, GROUP_CONCAT(DISTINCT S.shortName) surse 
     10SELECT L.id, L.formNoAccent cuv, GROUP_CONCAT(DISTINCT S.shortName) surse 
    1111FROM Lexem L 
    1212JOIN LexemDefinitionMap M ON L.id=M.lexemId 

  • tools/updateRandomWord.sh

    r629 r631  
    77 
    88INSERT INTO tmpRandomWord 
    9 SELECT L.id, L.formNoAccent form, GROUP_CONCAT(DISTINCT S.shortName) surse 
     9SELECT L.id, L.formNoAccent cuv, GROUP_CONCAT(DISTINCT S.shortName) surse 
    1010FROM Lexem L 
    1111JOIN LexemDefinitionMap M ON L.id=M.lexemId 
Note: See TracChangeset for help on using the changeset viewer.