All The Tropes Wiki Project, Part XXI

[LulzKiller]

Not against adding translation features.

Who's Gani and why are they adding SQL code in blogposts?

Code:

<vote />
    +    
<!--start text-->
    +    
CREATE TABLE IF NOT EXISTS /*_*/Vote (
    +    
  -- Internal ID to identify between different vote tags on different pages
    +    
  vote_id int(11) NOT NULL PRIMARY KEY auto_increment,
    +    
  -- Key to actor_id for the person who voted
    +    
  vote_actor bigint unsigned NOT NULL,
    +    
  -- Username (if any) of the person who voted
    +    
  username varchar(255) NOT NULL default 0,
    +    
  -- User ID of the person who voted
    +    
  vote_user_id int(11) NOT NULL default 0,
    +    
  -- ID of the page where the vote tag is in
    +    
  vote_page_id int(11) NOT NULL default 0,
    +    
  -- Value of the vote (ranging from 1 to 5)
    +    
  vote_value char(1) character set latin1 collate latin1_bin NOT NULL default '',
    +    
  -- Timestamp when the vote was cast
    +    
  vote_date datetime NOT NULL default '1970-01-01 00:00:01',
    +    
  -- IP address of the user who voted
    +    
  vote_ip varchar(45) NOT NULL default ''
    +    
) /*$wgDBTableOptions*/;
    +    
    +    
CREATE INDEX vote_page_id_index ON /*_*/Vote (vote_page_id);
    +    
CREATE INDEX valueidx ON /*_*/Vote (vote_value);
    +    
CREATE INDEX actoridx ON /*_*/Vote (vote_actor);
    +    
CREATE INDEX usernameidx ON /*_*/Vote (username);
    +    
CREATE INDEX vote_date ON /*_*/Vote (vote_date);
    +    
    +    
    +    
<comments />
    +    
    +    
[[Category:Articles by user Gani]]
    +    
[[Category:30 August 2021]]
    +    
[[Category:Sql]]
    +    
__NOEDITSECTION__