Sql

[Dean C]

Can anyone see anything wrong with this:


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;


???

Regards :)

- miSt

[filburt1]

event_start date bigint( 20 ) unsigned NOT NULL default '0',
event_end date bigint( 20 ) unsigned NOT NULL default '0',

Something's wrong there.

[Dean C]

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

[filburt1]

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.

[Dean C]

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