modules/subscription/subscription.mysql

#
# Table structure for table 'subscription_channels'
#

CREATE TABLE subscription_channels (
  cid int(3) unsigned default '0',
  uid tinyint(3) unsigned default '0',
  name varchar(25) default NULL,
  id varchar(50) default NULL,
  daily int(11) default '0'
) TYPE=MyISAM;


#
# Dumping data for table 'subscription_channels'
#

#INSERT INTO subscription_channels (cid, uid, name, id, daily) VALUES("1", "0", "Debug", "debug", "0");
INSERT INTO subscription_channels (cid, uid, name, id, daily) VALUES("2", "0", "Instant mailer", "simple_mail", "0");
INSERT INTO sequences (name, id) VALUES ("subscription_channels",3);


#
# Table structure for table 'subscription_subscriptions'
#

CREATE TABLE subscription_subscriptions (
  sid int(3) unsigned NOT NULL default '0',
  uid int(10) unsigned NOT NULL default '0',
  `condition` text NOT NULL,
  cid int(10) unsigned default '0',
  object varchar(15) NOT NULL default '',
  PRIMARY KEY  (sid)
) TYPE=MyISAM;
1	#
2	# Table structure for table 'subscription_channels'
3	#
4
5	CREATE TABLE subscription_channels (
6	cid int(3) unsigned default '0',
7	uid tinyint(3) unsigned default '0',
8	name varchar(25) default NULL,
9	id varchar(50) default NULL,
10	daily int(11) default '0'
11	) TYPE=MyISAM;
12
13
14
15	#
16	# Dumping data for table 'subscription_channels'
17	#
18
19	#INSERT INTO subscription_channels (cid, uid, name, id, daily) VALUES("1", "0", "Debug", "debug", "0");
20	INSERT INTO subscription_channels (cid, uid, name, id, daily) VALUES("2", "0", "Instant mailer", "simple_mail", "0");
21	INSERT INTO sequences (name, id) VALUES ("subscription_channels",3);
22
23
24	#
25	# Table structure for table 'subscription_subscriptions'
26	#
27
28	CREATE TABLE subscription_subscriptions (
29	sid int(3) unsigned NOT NULL default '0',
30	uid int(10) unsigned NOT NULL default '0',
31	`condition` text NOT NULL,
32	cid int(10) unsigned default '0',
33	object varchar(15) NOT NULL default '',
34	PRIMARY KEY (sid)
35	) TYPE=MyISAM;