Context Navigation

← Previous Changeset
Next Changeset →

Changeset 420

Timestamp:

03/18/08 02:09:04 (5 months ago)

Author:

eevee

Message:

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

Location:

veekun/trunk/script

Files:

: 3 modified

base.sql (modified) (25 diffs)
gallery.sql (modified) (9 diffs)
pokedex.sql (modified) (37 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

veekun/trunk/script/gallery.sql

r406	r420
15	15
16	16	DROP TABLE IF EXISTS creators;
	17	SET @saved_cs_client = @@character_set_client;
	18	SET character_set_client = utf8;
17	19	CREATE TABLE creators (
18	20	id int(10) unsigned NOT NULL auto_increment,
…	…
22	24	PRIMARY KEY (id)
23	25	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	26	SET character_set_client = @saved_cs_client;
24	27
25	28	--
…	…
28	31
29	32	DROP TABLE IF EXISTS gallery;
	33	SET @saved_cs_client = @@character_set_client;
	34	SET character_set_client = utf8;
30	35	CREATE TABLE gallery (
31	36	id int(10) unsigned NOT NULL auto_increment,
…	…
37	42	`hash` varchar(32) NOT NULL default '',
38	43	title varchar(48) NOT NULL default '',
39		description text NOT NULL,
	44	description mediumtext NOT NULL,
40	45	height smallint(5) unsigned NOT NULL default '0',
41	46	width smallint(5) unsigned NOT NULL default '0',
…	…
45	50	PRIMARY KEY (id),
46	51	UNIQUE KEY filename (filename)
47		) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	52	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	53	SET character_set_client = @saved_cs_client;
48	54
49	55	--
…	…
52	58
53	59	DROP TABLE IF EXISTS gallery_keywords;
	60	SET @saved_cs_client = @@character_set_client;
	61	SET character_set_client = utf8;
54	62	CREATE TABLE gallery_keywords (
55	63	id int(10) unsigned NOT NULL auto_increment,
…	…
59	67	PRIMARY KEY (id),
60	68	UNIQUE KEY keyword (keyword)
61		) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	69	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	70	SET character_set_client = @saved_cs_client;
62	71
63	72	--
…	…
66	75
67	76	DROP TABLE IF EXISTS item_keywords;
	77	SET @saved_cs_client = @@character_set_client;
	78	SET character_set_client = utf8;
68	79	CREATE TABLE item_keywords (
69	80	itemid int(10) unsigned NOT NULL default '0',
…	…
72	83	KEY itemid (itemid),
73	84	KEY keywordid (keywordid)
74		) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	85	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	86	SET character_set_client = @saved_cs_client;
75	87	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;
76	88

veekun/trunk/script/pokedex.sql

r410	r420
15	15
16	16	DROP TABLE IF EXISTS abilities;
	17	SET @saved_cs_client = @@character_set_client;
	18	SET character_set_client = utf8;
17	19	CREATE TABLE abilities (
18	20	id tinyint(3) unsigned NOT NULL default '0',
…	…
22	24	PRIMARY KEY (id)
23	25	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	26	SET character_set_client = @saved_cs_client;
24	27
25	28	--
…	…
161	164
162	165	DROP TABLE IF EXISTS berries;
	166	SET @saved_cs_client = @@character_set_client;
	167	SET character_set_client = utf8;
163	168	CREATE TABLE berries (
164	169	id int(10) unsigned NOT NULL auto_increment,
…	…
176	181	PRIMARY KEY (id)
177	182	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	183	SET character_set_client = @saved_cs_client;
178	184
179	185	--
…	…
255	261
256	262	DROP TABLE IF EXISTS contest_effects;
	263	SET @saved_cs_client = @@character_set_client;
	264	SET character_set_client = utf8;
257	265	CREATE TABLE contest_effects (
258	266	id tinyint(4) NOT NULL default '0',
…	…
263	271	PRIMARY KEY (id)
264	272	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	273	SET character_set_client = @saved_cs_client;
265	274
266	275	--
…	…
311	320
312	321	DROP TABLE IF EXISTS evo_chains;
	322	SET @saved_cs_client = @@character_set_client;
	323	SET character_set_client = utf8;
313	324	CREATE TABLE evo_chains (
314	325	id tinyint(3) unsigned NOT NULL default '0',
…	…
317	328	baby_item varchar(12) NOT NULL,
318	329	PRIMARY KEY (id)
319		) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	330	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	331	SET character_set_client = @saved_cs_client;
320	332
321	333	--
…	…
581	593
582	594	DROP TABLE IF EXISTS flavor_text;
	595	SET @saved_cs_client = @@character_set_client;
	596	SET character_set_client = utf8;
583	597	CREATE TABLE flavor_text (
584	598	pokemon_id smallint(5) unsigned NOT NULL default '0',
…	…
587	601	PRIMARY KEY USING BTREE (pokemon_id,generation)
588	602	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	603	SET character_set_client = @saved_cs_client;
589	604
590	605	--
…	…
4088	4103
4089	4104	DROP TABLE IF EXISTS items;
	4105	SET @saved_cs_client = @@character_set_client;
	4106	SET character_set_client = utf8;
4090	4107	CREATE TABLE items (
4091	4108	id int(10) unsigned NOT NULL,
…	…
4129	4146	PRIMARY KEY (id)
4130	4147	) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
	4148	SET character_set_client = @saved_cs_client;
4131	4149
4132	4150	--
…	…
4585	4603
4586	4604	DROP TABLE IF EXISTS locations;
	4605	SET @saved_cs_client = @@character_set_client;
	4606	SET character_set_client = utf8;
4587	4607	CREATE TABLE locations (
4588	4608	id int(10) unsigned NOT NULL auto_increment,
…	…
4593	4613	PRIMARY KEY (id)
4594	4614	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	4615	SET character_set_client = @saved_cs_client;
4595	4616
4596	4617	--
…	…
4688	4709
4689	4710	DROP TABLE IF EXISTS location_sections;
	4711	SET @saved_cs_client = @@character_set_client;
	4712	SET character_set_client = utf8;
4690	4713	CREATE TABLE location_sections (
4691	4714	id int(10) unsigned NOT NULL auto_increment,
…	…
4694	4717	PRIMARY KEY (id)
4695	4718	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	4719	SET character_set_client = @saved_cs_client;
4696	4720
4697	4721	--
…	…
4849	4873
4850	4874	DROP TABLE IF EXISTS location_encounters;
	4875	SET @saved_cs_client = @@character_set_client;
	4876	SET character_set_client = utf8;
4851	4877	CREATE TABLE location_encounters (
4852	4878	location_id int(10) unsigned NOT NULL,
…	…
4860	4886	max_level tinyint(3) unsigned NOT NULL default '0'
4861	4887	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	4888	SET character_set_client = @saved_cs_client;
4862	4889
4863	4890	--
…	…
11523	11550
11524	11551	DROP TABLE IF EXISTS machines;
	11552	SET @saved_cs_client = @@character_set_client;
	11553	SET character_set_client = utf8;
11525	11554	CREATE TABLE machines (
11526	11555	id tinyint(3) unsigned NOT NULL default '0',
…	…
11530	11559	location tinytext NOT NULL,
11531	11560	PRIMARY KEY (id,generation)
11532		) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	11561	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	11562	SET character_set_client = @saved_cs_client;
11533	11563
11534	11564	--
…	…
11816	11846
11817	11847	DROP TABLE IF EXISTS moves;
	11848	SET @saved_cs_client = @@character_set_client;
	11849	SET character_set_client = utf8;
11818	11850	CREATE TABLE moves (
11819	11851	id smallint(3) NOT NULL default '0',
11820	11852	`name` varchar(30) NOT NULL default '',
11821		name_jp ~~tinyblob NOT~~ NULL,
	11853	name_jp varchar(7) default NULL,
11822	11854	name_romaji varchar(16) NOT NULL default '',
11823	11855	`type` varchar(8) NOT NULL default '',
…	…
11835	11867	move_effect_id int(10) unsigned NOT NULL,
11836	11868	blurb_rusa tinytext NOT NULL,
11837		blurb_dp tinytext ~~character set utf8~~ NOT NULL,
	11869	blurb_dp tinytext NOT NULL,
11838	11870	contest_type enum('cute','tough','smart','cool','beauty') NOT NULL default 'cute',
11839	11871	contest_effect_id tinyint(4) NOT NULL default '0',
11840		notes text,
	11872	notes mediumtext,
11841	11873	XXX_new_flags char(13) default NULL,
11842	11874	PRIMARY KEY (id)
11843		) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	11875	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	11876	SET character_set_client = @saved_cs_client;
11844	11877
11845	11878	--
…	…
12335	12368
12336	12369	DROP TABLE IF EXISTS move_effects;
	12370	SET @saved_cs_client = @@character_set_client;
	12371	SET character_set_client = utf8;
12337	12372	CREATE TABLE move_effects (
12338	12373	id int(10) unsigned NOT NULL,
12339	12374	priority tinyint(4) NOT NULL,
12340	12375	short_description varchar(128) NOT NULL,
12341		description text NOT NULL,
	12376	description mediumtext NOT NULL,
12342	12377	PRIMARY KEY (id)
12343		) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	12378	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	12379	SET character_set_client = @saved_cs_client;
12344	12380
12345	12381	--
…	…
12614	12650
12615	12651	DROP TABLE IF EXISTS pokemon;
	12652	SET @saved_cs_client = @@character_set_client;
	12653	SET character_set_client = utf8;
12616	12654	CREATE TABLE pokemon (
12617	12655	id smallint(3) NOT NULL default '0',
…	…
12621	12659	`name` varchar(20) NOT NULL default '',
12622	12660	alt_form varchar(16) NOT NULL,
12623		name_jp ~~tinyblob NOT~~ NULL,
	12661	name_jp varchar(5) default NULL,
12624	12662	name_romaji varchar(16) NOT NULL default '',
12625	12663	evo_chain_id smallint(3) unsigned NOT NULL default '0',
…	…
12646	12684	gender_rate tinyint(3) unsigned NOT NULL default '0',
12647	12685	base_happiness tinyint(3) unsigned NOT NULL,
12648		notes text,
	12686	notes mediumtext,
12649	12687	flags set('baby','dpfem','dpfemback') NOT NULL default '',
12650	12688	real_pokemon_id int(10) unsigned NOT NULL,
…	…
12657	12695	KEY HP (stat_hp),
12658	12696	KEY REALID USING BTREE (real_pokemon_id)
12659		) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	12697	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	12698	SET character_set_client = @saved_cs_client;
12660	12699
12661	12700	--
…	…
13173	13212
13174	13213	DROP TABLE IF EXISTS pokemon_abilities;
	13214	SET @saved_cs_client = @@character_set_client;
	13215	SET character_set_client = utf8;
13175	13216	CREATE TABLE pokemon_abilities (
13176	13217	pokemon_id int(10) unsigned NOT NULL,
…	…
13181	13222	KEY abilityid USING BTREE (ability_id)
13182	13223	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	13224	SET character_set_client = @saved_cs_client;
13183	13225
13184	13226	--
…	…
13966	14008
13967	14009	DROP TABLE IF EXISTS pokemon_breeds;
	14010	SET @saved_cs_client = @@character_set_client;
	14011	SET character_set_client = utf8;
13968	14012	CREATE TABLE pokemon_breeds (
13969	14013	pokemon_id int(10) unsigned NOT NULL,
…	…
13972	14016	KEY breed (breed),
13973	14017	KEY pokeid USING BTREE (pokemon_id)
13974		) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	14018	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	14019	SET character_set_client = @saved_cs_client;
13975	14020
13976	14021	--
…	…
14634	14679
14635	14680	DROP TABLE IF EXISTS pokemon_items;
	14681	SET @saved_cs_client = @@character_set_client;
	14682	SET character_set_client = utf8;
14636	14683	CREATE TABLE pokemon_items (
14637	14684	pokemon_id smallint(5) unsigned NOT NULL,
…	…
14642	14689	KEY item (item_id)
14643	14690	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	14691	SET character_set_client = @saved_cs_client;
14644	14692
14645	14693	--
…	…
14882	14930
14883	14931	DROP TABLE IF EXISTS pokemon_moves;
	14932	SET @saved_cs_client = @@character_set_client;
	14933	SET character_set_client = utf8;
14884	14934	CREATE TABLE pokemon_moves (
14885	14935	pokemon_id smallint(5) unsigned NOT NULL default '0',
…	…
14893	14943	KEY MOVEID USING BTREE (move_id),
14894	14944	KEY VERSION USING BTREE (versions)
14895		) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	14945	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	14946	SET character_set_client = @saved_cs_client;
14896	14947
14897	14948	--
…	…
54114	54165
54115	54166	DROP TABLE IF EXISTS types;
	54167	SET @saved_cs_client = @@character_set_client;
	54168	SET character_set_client = utf8;
54116	54169	CREATE TABLE `types` (
54117	54170	`name` varchar(8) NOT NULL default '',
…	…
54125	54178	PRIMARY KEY (`name`)
54126	54179	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	54180	SET character_set_client = @saved_cs_client;
54127	54181
54128	54182	--

Download in other formats: