Navigation

← Previous Changeset
Next Changeset →

Changeset 135

Timestamp:

12/05/06 17:02:06 (2 years ago)

Author:

moensch

Message:

Adding comupgrade.xml

Files:

trunk/com_mls_events/install/comupgrade.xml (modified) (1 diff)

Legend:

: Unmodified
: Added
: Removed
: Modified
: Copied
: Moved

trunk/com_mls_events/install/comupgrade.xml

r37	r135
1	1	<?xml version="1.0" ?>
2	2	<compupgrade version="1.0">
3		<install version="0.1.4" date="20060911">
4		<phpfile name="install.php" />
5		<query>DROP TABLE IF EXISTS `#__mls_events`;</query>
6		<query>CREATE TABLE `#__mls_events` (
	3	<install version="0.1.0" date="20061205">
	4	<query>DROP TABLE IF EXISTS `#__mls_paypal_packages`</query>
	5	<query>CREATE TABLE `#__mls_paypal_packages` (
7	6	`id` int(11) NOT NULL auto_increment,
8	7	`name` varchar(255) NOT NULL default '',
9		`start` datetime NOT NULL default '0000-00-00 00:00:00',
10		`end` datetime NOT NULL default '0000-00-00 00:00:00',
11		`infos` text NOT NULL,
12		`loc_journey_desc` text NOT NULL,
13		`loc_location_name` varchar(255) NOT NULL default '',
14		`loc_street` varchar(255) NOT NULL default '',
15		`loc_street_no` int(11) NOT NULL default '0',
16		`loc_zip` varchar(10) NOT NULL default '',
17		`loc_city` varchar(255) NOT NULL default '',
18		`loc_country` char(3) NOT NULL default '',
19		`loc_parking_space` varchar(255) NOT NULL default '',
20		`price_advance_sale` decimal(4,2) NOT NULL default '0.00',
21		`price_direct_sale` decimal(4,2) NOT NULL default '0.00',
22		`price_currency` char(3) NOT NULL default '',
23		`price_payment_instructions` text NOT NULL,
24		`participants_number` int(11) NOT NULL default '0',
25		`participants_visitors` varchar(255) NOT NULL default '',
26		`participants_min_age` int(11) NOT NULL default '0',
27		`features_smokers_section` tinyint(1) NOT NULL default '0',
28		`features_network` text NOT NULL,
29		`features_internet` text NOT NULL,
30		`contact_icq` varchar(255) NOT NULL default '',
31		`contact_irc` varchar(255) NOT NULL default '',
32		`contact_mail` varchar(255) NOT NULL default '',
33		`enrol` tinyint(1) NOT NULL default '0',
34		`active` tinyint(1) NOT NULL default '0',
35		`published` tinyint(1) NOT NULL default '0',
36		`checked_out` int(11) unsigned NOT NULL default '0',
37		`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
38		`extcal_id` int(11) NOT NULL default '0',
39		PRIMARY KEY (`id`)
40		) TYPE=MyISAM;</query>
41		<query>DROP TABLE IF EXISTS `#__mls_events_comments`</query>
42		<query>CREATE TABLE `#__mls_events_comments` (
43		`id` int(11) NOT NULL auto_increment,
	8	`description` mediumtext NOT NULL,
	9	`type` tinyint(1) NOT NULL default '1',
	10	`eventamount` int(11) NOT NULL default '0',
44	11	`eventid` int(11) NOT NULL default '0',
45		`userid` int(11) NOT NULL default '0',
46		`text` text NOT NULL,
47		`time` datetime NOT NULL default '0000-00-00 00:00:00',
	12	`timeid` int(11) NOT NULL default '0',
	13	`timeamount` int(11) NOT NULL default '0',
	14	`timetype` enum('Y','M','D') NOT NULL default 'M',
	15	`price` decimal(4,2) NOT NULL default '0.00',
	16	`currency` char(3) NOT NULL default '',
48	17	`published` tinyint(1) NOT NULL default '0',
49	18	PRIMARY KEY (`id`)
50	19	) TYPE=MyISAM;</query>
51		~~<query>DROP TABLE IF EXISTS `#__mls_events_participant~~s`</query>
52		~~<query>CREATE TABLE `#__mls_events_participant~~s` (
	20	<query>DROP TABLE IF EXISTS `#__mls_paypal_packages_users`</query>
	21	<query>CREATE TABLE `#__mls_paypal_packages_users` (
53	22	`id` int(11) NOT NULL auto_increment,
	23	`packageid` int(11) NOT NULL default '0',
	24	`userid` int(11) NOT NULL default '0',
	25	`time` datetime NOT NULL default '0000-00-00 00:00:00',
	26	`expiration_time` datetime NOT NULL default '0000-00-00 00:00:00',
	27	`num_events` int(11) NOT NULL default '0',
	28	PRIMARY KEY (`id`)
	29	) TYPE=MyISAM;</query>
	30	<query>DROP TABLE IF EXISTS `#__mls_paypal_payments`</query>
	31	<query>CREATE TABLE `#__mls_paypal_payments` (
	32	`id` int(11) NOT NULL auto_increment,
	33	`txn_id` varchar(255) NOT NULL default '',
	34	`time` datetime NOT NULL default '0000-00-00 00:00:00',
	35	`status` varchar(255) NOT NULL default '',
	36	`validation` varchar(20) NOT NULL default '',
	37	`statuscode` tinyint(2) NOT NULL default '0',
	38	`statustext` mediumtext NOT NULL,
	39	`amount` int(11) NOT NULL default '0',
	40	`currency` varchar(10) NOT NULL default '',
	41	`item_name` varchar(255) NOT NULL default '',
	42	`item_number` varchar(200) NOT NULL default '',
	43	`payer_email` varchar(255) NOT NULL default '',
	44	`need_action` tinyint(1) NOT NULL default '0',
	45	`request` longtext NOT NULL,
54	46	`eventid` int(11) NOT NULL default '0',
55	47	`userid` int(11) NOT NULL default '0',
56		`timeid` INT( 11 ) NOT NULL default '0',
57		`subscribed` tinyint(1) NOT NULL default '0',
58		`subscribed_time` datetime NOT NULL default '0000-00-00 00:00:00',
59		`paid` tinyint(1) NOT NULL default '0',
60		`paid_time` datetime NOT NULL default '0000-00-00 00:00:00',
61		`checkin` tinyint(1) NOT NULL default '0',
62		`checkin_time` datetime NOT NULL default '0000-00-00 00:00:00',
63		`checkout` tinyint(1) NOT NULL default '0',
64		`checkout_time` datetime NOT NULL default '0000-00-00 00:00:00',
65		`comments` MEDIUMTEXT NOT NULL,
	48	`packageid` int(11) NOT NULL default '0',
	49	`comments` mediumtext NOT NULL,
66	50	PRIMARY KEY (`id`)
67		) TYPE=MyISAM;</query>
68		<query>DROP TABLE IF EXISTS `#__mls_events_reviews`</query>
69		<query>CREATE TABLE `#__mls_events_reviews` (
70		`id` int(11) NOT NULL auto_increment,
71		`eventid` int(11) NOT NULL default '0',
72		`userid` int(11) NOT NULL default '0',
73		`title` varchar(255) NOT NULL default '',
74		`text` text NOT NULL,
75		`time` datetime NOT NULL default '0000-00-00 00:00:00',
76		`published` tinyint(1) NOT NULL default '0',
77		PRIMARY KEY (`id`)
78		) TYPE=MyISAM;</query>
79		<query>DROP TABLE IF EXISTS `#__mls_events_times`</query>
80		<query>CREATE TABLE `#__mls_events_times` (
81		`id` int(11) NOT NULL auto_increment,
82		`eventid` int(11) NOT NULL default '0',
83		`name` varchar(255) NOT NULL default '',
84		`start` datetime NOT NULL default '0000-00-00 00:00:00',
85		`end` datetime NOT NULL default '0000-00-00 00:00:00',
86		PRIMARY KEY (`id`)
87		) TYPE=MyISAM;</query>
88		<query>DROP TABLE IF EXISTS `#__mls_events_coupons`</query>
89		<query>CREATE TABLE `#__mls_events_coupons` (
90		`id` INT(11) NOT NULL AUTO_INCREMENT,
91		`code` VARCHAR(45) NOT NULL DEFAULT '',
92		`eventid` INT(11) NOT NULL DEFAULT 0,
93		`filter` VARCHAR(255) NOT NULL DEFAULT '',
94		`filter_field` varchar(10) NOT NULL default '',
95		`valid_from` datetime NOT NULL default '0000-00-00 00:00:00',
96		`valid_until` datetime NOT NULL default '0000-00-00 00:00:00',
97		`published` tinyint(1) NOT NULL default '0',
98		`used` tinyint(1) NOT NULL default '0',
99		`used_by` int(11) NOT NULL default '0',
100		`used_time` datetime NOT NULL default '0000-00-00 00:00:00',
101		PRIMARY KEY(`id`)
102		) TYPE=MyISAM;</query>
	51	) TYPE=MyISAM;
	52	</query>
103	53	</install>
104	54	<upgrade>
105		<version number="0.0.2" date="20050810">
106		<phpfile name="upgrade_0.0.2.php" />
107		<query>ALTER TABLE `#__mls_events` ADD `price_currency` char(3) NOT NULL default '' AFTER `price_direct_sale`</query>
108		<query>ALTER TABLE `#__mls_events`
109		CHANGE `price_advance_sale` `price_advance_sale` DECIMAL( 4, 2 ) DEFAULT '0.00' NOT NULL,
110		CHANGE `price_direct_sale` `price_direct_sale` DECIMAL( 4, 2 ) DEFAULT '0.00' NOT NULL</query>
111		<query>ALTER TABLE `#__mls_events_participants` ADD `timeid` INT( 11 ) DEFAULT '0' NOT NULL AFTER `userid`</query>
112		<query>CREATE TABLE `#__mls_events_times` (
113		`id` int(11) NOT NULL auto_increment,
114		`eventid` int(11) NOT NULL default '0',
115		`name` varchar(255) NOT NULL default '',
116		`start` datetime NOT NULL default '0000-00-00 00:00:00',
117		`end` datetime NOT NULL default '0000-00-00 00:00:00',
118		PRIMARY KEY (`id`)
119		) TYPE=MyISAM</query>
120		</version>
121		<version number="0.1.0" date="20051103">
122		<phpfile name="upgrade_0.1.0.php" />
123		<query>ALTER TABLE `#__mls_events` ADD `extcal_id` INT( 11 ) DEFAULT '0' NOT NULL</query>
124		<query>ALTER TABLE `#__mls_events_participants` ADD `comments` MEDIUMTEXT NOT NULL</query>
125		</version>
126		<version number="0.1.1" date="20060302">
127		<query>ALTER TABLE `#__mls_events` DROP `wwcl_pid`, DROP `ngl_pid`</query>
128		</version>
129		<version number="0.1.2" date="20060318" />
130		<version number="0.1.3" date="20060606">
131		<query>CREATE TABLE `#__mls_events_coupons` (
132		`id` INT(11) NOT NULL AUTO_INCREMENT,
133		`code` VARCHAR(45) NOT NULL DEFAULT '',
134		`eventid` INT(11) NOT NULL DEFAULT 0,
135		`filter` VARCHAR(255) NOT NULL DEFAULT '',
136		`filter_field` varchar(10) NOT NULL default '',
137		`valid_from` datetime NOT NULL default '0000-00-00 00:00:00',
138		`valid_until` datetime NOT NULL default '0000-00-00 00:00:00',
139		`published` tinyint(1) NOT NULL default '0',
140		`used` tinyint(1) NOT NULL default '0',
141		`used_by` int(11) NOT NULL default '0',
142		`used_time` datetime NOT NULL default '0000-00-00 00:00:00',
143		PRIMARY KEY(`id`)
144		) TYPE=MyISAM</query>
145		</version>
146		<version number="0.1.4" date="20060911" />
	55	<version number="0.1.0" date="20061205" />
147	56	</upgrade>
148	57	</compupgrade>

myLANsite

Navigation

Changeset 135

Legend:

trunk/com_mls_events/install/comupgrade.xml

Download in other formats: