modules/upcomingorg/upcomingorg.mysql

-- $Id: upcomingorg.mysql,v 1.5 2005/08/28 22:01:11 sjaensch Exp $


CREATE TABLE upcomingorg_category (
  category_id INT UNSIGNED NOT NULL,
  name VARCHAR(250) NOT NULL,
  description TEXT,
  PRIMARY KEY (category_id)
);


CREATE TABLE upcomingorg_event (
  nid int(10) unsigned NOT NULL default '0',
  event_id int(10) unsigned default NULL,
  metro_id int(10) unsigned default NULL,
  venue_nid int(10) unsigned default NULL,
  user_id int(10) unsigned default NULL,
  category_id int(10) unsigned default NULL,
  description text,
  tags text,
  personal tinyint(1) unsigned NOT NULL default '0',
  selfpromotion tinyint(1) unsigned NOT NULL default '0',
  is_imported tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (nid)
);


CREATE TABLE upcomingorg_user (
  uid int(10) unsigned NOT NULL default '0',
  upcomingorg_rest_url varchar(200) NOT NULL default '',
  upcomingorg_username varchar(50) NOT NULL default '',
  upcomingorg_password varchar(50) NOT NULL default '',
  upcomingorg_user_id int(10) unsigned default NULL,
  upcomingorg_apikey varchar(50) NOT NULL default '',
  PRIMARY KEY  (uid)
);


CREATE TABLE upcomingorg_venue (
  nid int(10) unsigned NOT NULL default '0',
  venue_id int(10) unsigned NOT NULL default '0',
  user_id int(10) unsigned NOT NULL default '0',
  description text,
  url varchar(250) default NULL,
  phone varchar(50) default NULL,
  private tinyint(1) unsigned NOT NULL default '0',
  is_imported tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (nid)
);
1	-- $Id: upcomingorg.mysql,v 1.5 2005/08/28 22:01:11 sjaensch Exp $
2
3
4	CREATE TABLE upcomingorg_category (
5	category_id INT UNSIGNED NOT NULL,
6	name VARCHAR(250) NOT NULL,
7	description TEXT,
8	PRIMARY KEY (category_id)
9	);
10
11
12	CREATE TABLE upcomingorg_event (
13	nid int(10) unsigned NOT NULL default '0',
14	event_id int(10) unsigned default NULL,
15	metro_id int(10) unsigned default NULL,
16	venue_nid int(10) unsigned default NULL,
17	user_id int(10) unsigned default NULL,
18	category_id int(10) unsigned default NULL,
19	description text,
20	tags text,
21	personal tinyint(1) unsigned NOT NULL default '0',
22	selfpromotion tinyint(1) unsigned NOT NULL default '0',
23	is_imported tinyint(1) unsigned NOT NULL default '0',
24	PRIMARY KEY (nid)
25	);
26
27
28	CREATE TABLE upcomingorg_user (
29	uid int(10) unsigned NOT NULL default '0',
30	upcomingorg_rest_url varchar(200) NOT NULL default '',
31	upcomingorg_username varchar(50) NOT NULL default '',
32	upcomingorg_password varchar(50) NOT NULL default '',
33	upcomingorg_user_id int(10) unsigned default NULL,
34	upcomingorg_apikey varchar(50) NOT NULL default '',
35	PRIMARY KEY (uid)
36	);
37
38
39	CREATE TABLE upcomingorg_venue (
40	nid int(10) unsigned NOT NULL default '0',
41	venue_id int(10) unsigned NOT NULL default '0',
42	user_id int(10) unsigned NOT NULL default '0',
43	description text,
44	url varchar(250) default NULL,
45	phone varchar(50) default NULL,
46	private tinyint(1) unsigned NOT NULL default '0',
47	is_imported tinyint(1) unsigned NOT NULL default '0',
48	PRIMARY KEY (nid)
49	);