modules/ec_mvmg/gozabocheckout.install

<?php
// $Id: paypal.install,v 1.3.6.1 2007/02/14 06:48:25 sime Exp $

/**
 * E-Commerce paypal module schema
 */
function gozabocheckout_install() {
      db_query("CREATE TABLE ec_mvmg_userstore_settings (
        uid int(10) unsigned NOT NULL default '0',
        paypal_enabled tinyint(3) unsigned NOT NULL default '0',
        cod_enabled tinyint(3) unsigned NOT NULL default '0',
        receiver_email varchar(150) NOT NULL default '',
        currency varchar(5) NOT NULL default '',
        ipn_debug tinyint(3) unsigned NOT NULL default '0',
        UNIQUE KEY uid (uid)
      ) TYPE=MyISAM");
      db_query("CREATE TABLE ec_mvmg (
        mvmgtxnid bigint(20) unsigned NOT NULL auto_increment,
        txnid int(10) unsigned NOT NULL default '0',
        uid int(10) unsigned NOT NULL default '0',
        type varchar(16) NOT NULL default '',
        mail varchar(64) NOT NULL default '',
        shipping_cost decimal(10,2) NOT NULL default '0.00',
        payment_method varchar(32) NOT NULL default '',
        payment_status varchar(32) NOT NULL default '1',
        payment_date int(11) NOT NULL default '0',
        workflow int(10) unsigned NOT NULL default '1',
        gross decimal(10,2) NOT NULL default '0.00',
        created int(11) NOT NULL default '0',
        changed int(11) NOT NULL default '0',
        duedate int(11) NOT NULL default '0',
        token varchar(42) NOT NULL default '',
        vendor int(10) unsigned default NULL,
        prod text NOT NULL,
        ppid varchar(255) default NULL,
        PRIMARY KEY  (mvmgtxnid),
        KEY uid (uid)
      ) TYPE=MyISAM");
  drupal_set_message(t('E-Commerce: GozaboCheckout tables have been created.'));
}

1	<?php
2	// $Id: paypal.install,v 1.3.6.1 2007/02/14 06:48:25 sime Exp $
3
4	/**
5	* E-Commerce paypal module schema
6	*/
7	function gozabocheckout_install() {
8	db_query("CREATE TABLE ec_mvmg_userstore_settings (
9	uid int(10) unsigned NOT NULL default '0',
10	paypal_enabled tinyint(3) unsigned NOT NULL default '0',
11	cod_enabled tinyint(3) unsigned NOT NULL default '0',
12	receiver_email varchar(150) NOT NULL default '',
13	currency varchar(5) NOT NULL default '',
14	ipn_debug tinyint(3) unsigned NOT NULL default '0',
15	UNIQUE KEY uid (uid)
16	) TYPE=MyISAM");
17	db_query("CREATE TABLE ec_mvmg (
18	mvmgtxnid bigint(20) unsigned NOT NULL auto_increment,
19	txnid int(10) unsigned NOT NULL default '0',
20	uid int(10) unsigned NOT NULL default '0',
21	type varchar(16) NOT NULL default '',
22	mail varchar(64) NOT NULL default '',
23	shipping_cost decimal(10,2) NOT NULL default '0.00',
24	payment_method varchar(32) NOT NULL default '',
25	payment_status varchar(32) NOT NULL default '1',
26	payment_date int(11) NOT NULL default '0',
27	workflow int(10) unsigned NOT NULL default '1',
28	gross decimal(10,2) NOT NULL default '0.00',
29	created int(11) NOT NULL default '0',
30	changed int(11) NOT NULL default '0',
31	duedate int(11) NOT NULL default '0',
32	token varchar(42) NOT NULL default '',
33	vendor int(10) unsigned default NULL,
34	prod text NOT NULL,
35	ppid varchar(255) default NULL,
36	PRIMARY KEY (mvmgtxnid),
37	KEY uid (uid)
38	) TYPE=MyISAM");
39	drupal_set_message(t('E-Commerce: GozaboCheckout tables have been created.'));
40	}
41