ubercart/uc_cart/uc_cart.install

<?php
// $Id$

/**
 * Ubercart uc_cart.module schema
 */
function uc_cart_schema() {
  $schema = array();

  $schema['uc_cart_products'] = array(
    'fields' => array(
      'cart_id' => array(
        'type' => 'varchar',
        'length' => 32,
        'not null' => TRUE,
        'default' => '0',
      ),
      'nid' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'qty' => array(
        'type' => 'int',
        'size' => 'small',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'changed' => array(
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ),
      'data' => array(
        'type' => 'text',
      ),
    ),
    'indexes' => array(
      'uc_cart_products_cart_id' => array('cart_id'),
    ),
  );

  return $schema;
}

function uc_cart_install() {
  drupal_install_schema('uc_cart');
}

function uc_cart_uninstall() {
  drupal_uninstall_schema('uc_cart');

  db_query("DELETE FROM {variable} WHERE name LIKE 'uc_pane_%%'");
  db_query("DELETE FROM {variable} WHERE name LIKE 'uc_cap_%%'");
  variable_del('uc_cart_empty_hide');
  variable_del('uc_cart_expanded');
  variable_del('uc_cart_show_help_text');
  variable_del('uc_cart_help_text');
  variable_del('uc_cart_anon_duration');
  variable_del('uc_cart_anon_unit');
  variable_del('uc_cart_auth_duration');
  variable_del('uc_cart_auth_unit');
  variable_del('uc_minimum_subtotal');
  variable_del('uc_add_item_redirect');
  variable_del('uc_continue_shopping_url');
  variable_del('uc_continue_shopping_text');
  variable_del('uc_continue_shopping_type');
  variable_del('uc_cart_breadcrumb_url');
  variable_del('uc_cart_breadcrumb_text');
  variable_del('uc_checkout_enabled');
  variable_del('uc_checkout_next_button');
  variable_del('uc_checkout_review_button');
  variable_del('uc_checkout_submit_button');
  variable_del('uc_use_next_buttons');
  variable_del('uc_collapse_current_pane');
  variable_del('uc_cart_delivery_not_shippable');
  variable_del('uc_new_customer_email');
  variable_del('uc_checkout_anonymous');
  variable_del('uc_cart_checkout_complete_page');
  variable_del('uc_checkout_instructions');
  variable_del('uc_checkout_review_instructions');
  variable_del('uc_msg_order_submit');
  variable_del('uc_msg_order_logged_in');
  variable_del('uc_msg_order_existing_user');
  variable_del('uc_msg_order_new_user');
  variable_del('uc_msg_continue_shopping');
}
1	<?php
2	// $Id$
3
4	/**
5	* Ubercart uc_cart.module schema
6	*/
7	function uc_cart_schema() {
8	$schema = array();
9
10	$schema['uc_cart_products'] = array(
11	'fields' => array(
12	'cart_id' => array(
13	'type' => 'varchar',
14	'length' => 32,
15	'not null' => TRUE,
16	'default' => '0',
17	),
18	'nid' => array(
19	'type' => 'int',
20	'unsigned' => TRUE,
21	'not null' => TRUE,
22	'default' => 0,
23	),
24	'qty' => array(
25	'type' => 'int',
26	'size' => 'small',
27	'unsigned' => TRUE,
28	'not null' => TRUE,
29	'default' => 0,
30	),
31	'changed' => array(
32	'type' => 'int',
33	'not null' => TRUE,
34	'default' => 0,
35	),
36	'data' => array(
37	'type' => 'text',
38	),
39	),
40	'indexes' => array(
41	'uc_cart_products_cart_id' => array('cart_id'),
42	),
43	);
44
45	return $schema;
46	}
47
48	function uc_cart_install() {
49	drupal_install_schema('uc_cart');
50	}
51
52	function uc_cart_uninstall() {
53	drupal_uninstall_schema('uc_cart');
54
55	db_query("DELETE FROM {variable} WHERE name LIKE 'uc_pane_%%'");
56	db_query("DELETE FROM {variable} WHERE name LIKE 'uc_cap_%%'");
57	variable_del('uc_cart_empty_hide');
58	variable_del('uc_cart_expanded');
59	variable_del('uc_cart_show_help_text');
60	variable_del('uc_cart_help_text');
61	variable_del('uc_cart_anon_duration');
62	variable_del('uc_cart_anon_unit');
63	variable_del('uc_cart_auth_duration');
64	variable_del('uc_cart_auth_unit');
65	variable_del('uc_minimum_subtotal');
66	variable_del('uc_add_item_redirect');
67	variable_del('uc_continue_shopping_url');
68	variable_del('uc_continue_shopping_text');
69	variable_del('uc_continue_shopping_type');
70	variable_del('uc_cart_breadcrumb_url');
71	variable_del('uc_cart_breadcrumb_text');
72	variable_del('uc_checkout_enabled');
73	variable_del('uc_checkout_next_button');
74	variable_del('uc_checkout_review_button');
75	variable_del('uc_checkout_submit_button');
76	variable_del('uc_use_next_buttons');
77	variable_del('uc_collapse_current_pane');
78	variable_del('uc_cart_delivery_not_shippable');
79	variable_del('uc_new_customer_email');
80	variable_del('uc_checkout_anonymous');
81	variable_del('uc_cart_checkout_complete_page');
82	variable_del('uc_checkout_instructions');
83	variable_del('uc_checkout_review_instructions');
84	variable_del('uc_msg_order_submit');
85	variable_del('uc_msg_order_logged_in');
86	variable_del('uc_msg_order_existing_user');
87	variable_del('uc_msg_order_new_user');
88	variable_del('uc_msg_continue_shopping');
89	}