CREATE TABLE DATABASE

[jel]

solution to that error?

CREATE TABLE IF NOT EXISTS boosted_creature (
	boostname TEXT,
	date varchar(250) NOT NULL default '',
	raceid varchar(250) NOT NULL default '',
	PRIMARY KEY (date)
	) AS SELECT 42 AS date, "name" AS boostname, 69 AS raceid;

erro:
#1071 - Specified key was too long; max key length is 767 bytes

 

[Raikou]

This looks broken, but i doubt the primary key is a date field, try to use raceid as primary key

 

[jel]

This looks broken, but i doubt the primary key is a date field, try to use raceid as primary key

how would it be?

 

[Aoxomoxoa]

how would it be?

Date is horrible for a primary key. Just try changing it.