Sql
 

Can anyone see anything wrong with this:

[sql]
CREATE TABLE events (
event_id int(11) NOT NULL auto_increment,
event_title varchar(255) NOT NULL default '',
event_start date bigint(20) unsigned NOT NULL default '0',
event_end date bigint(20) unsigned NOT NULL default '0',
event_parent int(11) unsigned NOT NULL default '0',
event_description text,
event_times_recuring int(11) unsigned NOT NULL default '0',
event_recurs int(11) unsigned NOT NULL default '0',
event_remind int(10) unsigned NOT NULL default '0',
event_icon varchar(20) default 'obj/event',
event_owner int(11) default '0',
event_project int(11) default '0',
event_private tinyint(3) default '0',
PRIMARY KEY (event_id),
KEY id_esd (event_start_date),
KEY id_eed (event_end_date),
KEY id_evp (event_parent)
) TYPE=MyISAM;
[/sql]

???

Regards :)

- miSt

Something's wrong there.

Nope nothing is wrong. My conclusion was that it was the name of the table is not allowed. For some reason you can't call the table events... i managed to run the same query with the name eventsx as the tablename..

Something is majorly funny because no-one could possibly release software for beta testing with table names that don't work... any ideas?

- miSt

I doubt that the table name was an issue because it didn't fail immediately there. I think the DATE and BIGINT (why the hell would you need BIGINT for a date!?) was the problem.

Don't ask me hehe - its a software in its alpha stage and that query wouldn't run. Unfortunately the development of the software is at sourgeforce.net so getting support is a hassle. So im trying to get in contact with the owner and resolve some issues. I managed to change the table name by running a query :)

Tis very odd... But an excellent client management system. If only the development would go faster :p

- miSt