Changeset 420 for veekun/trunk/script/base.sql
- Timestamp:
- 03/18/08 02:09:04 (20 months ago)
- Files:
-
- 1 modified
-
veekun/trunk/script/base.sql (modified) (25 diffs)
Legend:
- Unmodified
- Added
- Removed
-
veekun/trunk/script/base.sql
r406 r420 15 15 16 16 DROP TABLE IF EXISTS edits; 17 SET @saved_cs_client = @@character_set_client; 18 SET character_set_client = utf8; 17 19 CREATE TABLE edits ( 18 20 id int(10) unsigned NOT NULL auto_increment, … … 20 22 user_id int(10) unsigned NOT NULL default '0', 21 23 `time` int(10) unsigned NOT NULL default '0', 22 old_content text NOT NULL,24 old_content mediumtext NOT NULL, 23 25 PRIMARY KEY (id), 24 26 KEY POSTID USING BTREE (post_id) 25 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 27 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 28 SET character_set_client = @saved_cs_client; 26 29 27 30 -- … … 30 33 31 34 DROP TABLE IF EXISTS error_log; 35 SET @saved_cs_client = @@character_set_client; 36 SET character_set_client = utf8; 32 37 CREATE TABLE error_log ( 33 38 id int(10) unsigned NOT NULL auto_increment, … … 41 46 PRIMARY KEY (id) 42 47 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 48 SET character_set_client = @saved_cs_client; 43 49 44 50 -- … … 47 53 48 54 DROP TABLE IF EXISTS forums; 55 SET @saved_cs_client = @@character_set_client; 56 SET character_set_client = utf8; 49 57 CREATE TABLE forums ( 50 58 id int(10) unsigned NOT NULL auto_increment, … … 57 65 description varchar(255) NOT NULL, 58 66 PRIMARY KEY (id) 59 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; 67 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 68 SET character_set_client = @saved_cs_client; 60 69 61 70 -- … … 64 73 65 74 DROP TABLE IF EXISTS group_permissions; 75 SET @saved_cs_client = @@character_set_client; 76 SET character_set_client = utf8; 66 77 CREATE TABLE group_permissions ( 67 78 group_id int(10) unsigned NOT NULL default '0', … … 70 81 polarity enum('allow','deny') default NULL, 71 82 PRIMARY KEY USING BTREE (group_id,permission,scope) 72 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 83 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 84 SET character_set_client = @saved_cs_client; 73 85 74 86 -- … … 77 89 78 90 DROP TABLE IF EXISTS groups; 91 SET @saved_cs_client = @@character_set_client; 92 SET character_set_client = utf8; 79 93 CREATE TABLE groups ( 80 94 id int(10) unsigned NOT NULL auto_increment, … … 83 97 UNIQUE KEY id (id) 84 98 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 99 SET character_set_client = @saved_cs_client; 85 100 86 101 -- … … 89 104 90 105 DROP TABLE IF EXISTS messages; 106 SET @saved_cs_client = @@character_set_client; 107 SET character_set_client = utf8; 91 108 CREATE TABLE messages ( 92 109 id int(10) unsigned NOT NULL auto_increment, … … 95 112 `time` int(10) unsigned NOT NULL default '0', 96 113 `subject` tinytext NOT NULL, 97 message text NOT NULL, 98 PRIMARY KEY (id) 99 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 114 message mediumtext NOT NULL, 115 PRIMARY KEY (id) 116 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 117 SET character_set_client = @saved_cs_client; 100 118 101 119 -- … … 104 122 105 123 DROP TABLE IF EXISTS posts; 124 SET @saved_cs_client = @@character_set_client; 125 SET character_set_client = utf8; 106 126 CREATE TABLE posts ( 107 127 id int(10) unsigned NOT NULL auto_increment, … … 111 131 `time` int(10) unsigned NOT NULL default '0', 112 132 format enum('bbcode','raw','html') NOT NULL default 'raw', 113 content text NOT NULL,133 content mediumtext NOT NULL, 114 134 last_edit_id int(10) unsigned NOT NULL default '0', 115 135 PRIMARY KEY (id), 116 136 KEY THREAD USING BTREE (thread_id), 117 137 KEY `USER` USING BTREE (user_id) 118 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED; 138 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; 139 SET character_set_client = @saved_cs_client; 119 140 120 141 -- … … 123 144 124 145 DROP TABLE IF EXISTS sessions; 146 SET @saved_cs_client = @@character_set_client; 147 SET character_set_client = utf8; 125 148 CREATE TABLE sessions ( 126 149 id varchar(72) NOT NULL default '', 127 150 user_id int(10) unsigned NOT NULL default '0', 128 151 time_expires int(10) unsigned default NULL, 129 `data` text,152 `data` mediumtext, 130 153 PRIMARY KEY USING BTREE (id), 131 154 KEY USER_ID USING BTREE (user_id) 132 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 155 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 156 SET character_set_client = @saved_cs_client; 133 157 134 158 -- … … 137 161 138 162 DROP TABLE IF EXISTS shoutbox; 163 SET @saved_cs_client = @@character_set_client; 164 SET character_set_client = utf8; 139 165 CREATE TABLE shoutbox ( 140 166 id int(10) unsigned NOT NULL auto_increment, … … 143 169 ip int(10) unsigned NOT NULL default '0', 144 170 `time` int(10) unsigned NOT NULL default '0', 145 content text NOT NULL, 146 PRIMARY KEY (id) 147 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 171 content mediumtext NOT NULL, 172 PRIMARY KEY (id) 173 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 174 SET character_set_client = @saved_cs_client; 148 175 149 176 -- … … 152 179 153 180 DROP TABLE IF EXISTS threads; 181 SET @saved_cs_client = @@character_set_client; 182 SET character_set_client = utf8; 154 183 CREATE TABLE threads ( 155 184 id int(10) unsigned NOT NULL auto_increment, … … 165 194 PRIMARY KEY (id), 166 195 KEY FORUMID USING BTREE (forum_id) 167 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; 196 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 197 SET character_set_client = @saved_cs_client; 168 198 169 199 -- … … 172 202 173 203 DROP TABLE IF EXISTS thread_views; 204 SET @saved_cs_client = @@character_set_client; 205 SET character_set_client = utf8; 174 206 CREATE TABLE thread_views ( 175 207 thread_id int(10) unsigned NOT NULL, … … 178 210 PRIMARY KEY (thread_id,user_id) 179 211 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 212 SET character_set_client = @saved_cs_client; 180 213 181 214 -- … … 184 217 185 218 DROP TABLE IF EXISTS user_groups; 219 SET @saved_cs_client = @@character_set_client; 220 SET character_set_client = utf8; 186 221 CREATE TABLE user_groups ( 187 222 user_id int(10) unsigned NOT NULL default '0', … … 191 226 KEY user_id USING BTREE (user_id), 192 227 KEY group_id USING BTREE (group_id) 193 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 228 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 229 SET character_set_client = @saved_cs_client; 194 230 195 231 -- … … 198 234 199 235 DROP TABLE IF EXISTS users; 236 SET @saved_cs_client = @@character_set_client; 237 SET character_set_client = utf8; 200 238 CREATE TABLE users ( 201 239 id int(10) unsigned NOT NULL auto_increment, … … 218 256 pm_icon enum('bead','bellossom','dream','duskull','eatmail','gorgeous','letter','magnemite','pika','retro','slakoth','vee','wailmer','wingull','zigzagoon') NOT NULL default 'letter', 219 257 custom_title varchar(32) NOT NULL, 220 signature text NOT NULL,258 signature mediumtext NOT NULL, 221 259 is_dumb tinyint(1) NOT NULL default '0', 222 260 PRIMARY KEY (id), 223 261 UNIQUE KEY `NAME` (`name`) 224 ) ENGINE=MyISAM DEFAULT CHARSET=latin1; 262 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 263 SET character_set_client = @saved_cs_client; 225 264 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 226 265
