Show
Ignore:
Timestamp:
03/18/08 02:09:04 (2 years ago)
Author:
eevee
Message:

Converted all tables to UTF-8, hopefully fixing the little shoutbox problem. (#287, kinda #58)

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • veekun/trunk/script/gallery.sql

    r406 r420  
    1515 
    1616DROP TABLE IF EXISTS creators; 
     17SET @saved_cs_client     = @@character_set_client; 
     18SET character_set_client = utf8; 
    1719CREATE TABLE creators ( 
    1820  id int(10) unsigned NOT NULL auto_increment, 
    … …  
    2224  PRIMARY KEY  (id) 
    2325) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
     26SET character_set_client = @saved_cs_client; 
    2427 
    2528-- 
    … …  
    2831 
    2932DROP TABLE IF EXISTS gallery; 
     33SET @saved_cs_client     = @@character_set_client; 
     34SET character_set_client = utf8; 
    3035CREATE TABLE gallery ( 
    3136  id int(10) unsigned NOT NULL auto_increment, 
    … …  
    3742  `hash` varchar(32) NOT NULL default '', 
    3843  title varchar(48) NOT NULL default '', 
    39   description text NOT NULL, 
     44  description mediumtext NOT NULL, 
    4045  height smallint(5) unsigned NOT NULL default '0', 
    4146  width smallint(5) unsigned NOT NULL default '0', 
    … …  
    4550  PRIMARY KEY  (id), 
    4651  UNIQUE KEY filename (filename) 
    47 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     52) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     53SET character_set_client = @saved_cs_client; 
    4854 
    4955-- 
    … …  
    5258 
    5359DROP TABLE IF EXISTS gallery_keywords; 
     60SET @saved_cs_client     = @@character_set_client; 
     61SET character_set_client = utf8; 
    5462CREATE TABLE gallery_keywords ( 
    5563  id int(10) unsigned NOT NULL auto_increment, 
    … …  
    5967  PRIMARY KEY  (id), 
    6068  UNIQUE KEY keyword (keyword) 
    61 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     69) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     70SET character_set_client = @saved_cs_client; 
    6271 
    6372-- 
    … …  
    6675 
    6776DROP TABLE IF EXISTS item_keywords; 
     77SET @saved_cs_client     = @@character_set_client; 
     78SET character_set_client = utf8; 
    6879CREATE TABLE item_keywords ( 
    6980  itemid int(10) unsigned NOT NULL default '0', 
    … …  
    7283  KEY itemid (itemid), 
    7384  KEY keywordid (keywordid) 
    74 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
     85) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     86SET character_set_client = @saved_cs_client; 
    7587/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 
    7688