


create table plugin_events (
e_id int auto_increment not null,
e_title varchar(255),
e_startdate datetime,
e_enddate datetime,
e_venue varchar(255),
e_starttime datetime,
e_endtime datetime,
e_cost varchar(255),
e_register varchar(255),
e_description text,
e_howToBook text,
e_categories varchar(255),
e_openNodes varchar(255),
primary key(e_id),
unique id(e_id)
);


alter table plugin_events add column e_status varchar(255);



create table plugin_events_category_lu (
e_id int,
c_id int
);