"Fossies" - the Fresh Open Source Software Archive

Member "tiki-21.2/installer/schema/20081019_score_tiki.sql" (29 Jul 2020, 348 Bytes) of package /linux/www/tiki-21.2.tar.xz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 #2008-10-19 sylvieg
    2 ALTER TABLE  tiki_users_score DROP PRIMARY KEY;
    3 ALTER TABLE  tiki_users_score DROP KEY user;
    4 ALTER TABLE tiki_users_score CHANGE event_id event_id char(200) NOT NULL default '';
    5 ALTER TABLE  tiki_users_score ADD PRIMARY KEY (user(110),event_id(110));
    6 ALTER TABLE  tiki_users_score ADD KEY user (user(110),event_id(110),expire);