modules/game_clock/game_clock.install

<?php
// $Id$

/**
 *  @file
 *  The installation file for the Game Clock module.
 */

/**
 * Implementation of hook_install().
 */
function game_clock_install() {
  $success = drupal_install_schema('game_clock');

  if ($success) {
    // Insert a starting record.
    // Note that UI strings in the following SQL, e.g. "Bookmark this", aren't
    // wrapped in t() and that's intentional: they are passed to t() later,
    // thus allowing for multilingual sites.
    db_query("INSERT INTO {game_clocks} (name, title, increment, block) VALUES ('default', 'Default', 5, 1)");
  }

  if ($success) {
    drupal_set_message(st('Game Clock module installed tables successfully.'));
  }
  else {
    drupal_set_message(st('The installation of Game Clock module failed.'), 'error');
  }
}

/**
 * Implementation of hook_uninstall().
 */
function game_clock_uninstall() {
  drupal_uninstall_schema('game_clock');
  $result = db_query("SELECT name FROM {variable} WHERE name LIKE 'game_clock_%'");
  while ($row = db_fetch_object($result)) {
    variable_del($row->name);
  }

  drupal_set_message(t('Game Clock has been uninstalled.'));
}

/**
 * Implementation of hook_schema().
 */
function game_clock_schema() {
  $schema = array();

  $schema['game_clocks'] = array(
    'fields' => array(
      'cid' => array(
        'type' => 'serial',
        'size' => 'small',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'name' => array(
        'type' => 'varchar',
        'length' => '32',
        'not null' => FALSE,
        'default' => '',
      ),
      'title' => array(
        'type' => 'varchar',
        'length' => '255',
        'not null' => FALSE,
        'default' => '',
      ),
      'status' => array(
        'type' => 'int',
        'size' => 'tiny',
        'not null' => FALSE,
        'default' => 0,
      ),
      'turn' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
        'disp-size' => 11,
      ),
      'increment' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
        'disp-size' => 11,
      ),
      'next_tick' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
        'disp-size' => 11,
      ),
      'block' => array(
        'type' => 'int',
        'size' => 'tiny',
        'not null' => FALSE,
        'default' => 0,
      ),
      'init' => array(
        'type' => 'int',
        'size' => 'tiny',
        'not null' => FALSE,
        'default' => 0,
      ),
    ),
    'primary key' => array('cid'),
    'unique keys' => array(
      'name' => array('name')
    ),
  );

  return $schema;
}
1	<?php
2	// $Id$
3
4	/**
5	* @file
6	* The installation file for the Game Clock module.
7	*/
8
9	/**
10	* Implementation of hook_install().
11	*/
12	function game_clock_install() {
13	$success = drupal_install_schema('game_clock');
14
15	if ($success) {
16	// Insert a starting record.
17	// Note that UI strings in the following SQL, e.g. "Bookmark this", aren't
18	// wrapped in t() and that's intentional: they are passed to t() later,
19	// thus allowing for multilingual sites.
20	db_query("INSERT INTO {game_clocks} (name, title, increment, block) VALUES ('default', 'Default', 5, 1)");
21	}
22
23	if ($success) {
24	drupal_set_message(st('Game Clock module installed tables successfully.'));
25	}
26	else {
27	drupal_set_message(st('The installation of Game Clock module failed.'), 'error');
28	}
29	}
30
31	/**
32	* Implementation of hook_uninstall().
33	*/
34	function game_clock_uninstall() {
35	drupal_uninstall_schema('game_clock');
36	$result = db_query("SELECT name FROM {variable} WHERE name LIKE 'game_clock_%'");
37	while ($row = db_fetch_object($result)) {
38	variable_del($row->name);
39	}
40
41	drupal_set_message(t('Game Clock has been uninstalled.'));
42	}
43
44	/**
45	* Implementation of hook_schema().
46	*/
47	function game_clock_schema() {
48	$schema = array();
49
50	$schema['game_clocks'] = array(
51	'fields' => array(
52	'cid' => array(
53	'type' => 'serial',
54	'size' => 'small',
55	'unsigned' => TRUE,
56	'not null' => TRUE,
57	),
58	'name' => array(
59	'type' => 'varchar',
60	'length' => '32',
61	'not null' => FALSE,
62	'default' => '',
63	),
64	'title' => array(
65	'type' => 'varchar',
66	'length' => '255',
67	'not null' => FALSE,
68	'default' => '',
69	),
70	'status' => array(
71	'type' => 'int',
72	'size' => 'tiny',
73	'not null' => FALSE,
74	'default' => 0,
75	),
76	'turn' => array(
77	'type' => 'int',
78	'unsigned' => TRUE,
79	'not null' => TRUE,
80	'default' => 0,
81	'disp-size' => 11,
82	),
83	'increment' => array(
84	'type' => 'int',
85	'unsigned' => TRUE,
86	'not null' => TRUE,
87	'default' => 0,
88	'disp-size' => 11,
89	),
90	'next_tick' => array(
91	'type' => 'int',
92	'unsigned' => TRUE,
93	'not null' => TRUE,
94	'default' => 0,
95	'disp-size' => 11,
96	),
97	'block' => array(
98	'type' => 'int',
99	'size' => 'tiny',
100	'not null' => FALSE,
101	'default' => 0,
102	),
103	'init' => array(
104	'type' => 'int',
105	'size' => 'tiny',
106	'not null' => FALSE,
107	'default' => 0,
108	),
109	),
110	'primary key' => array('cid'),
111	'unique keys' => array(
112	'name' => array('name')
113	),
114	);
115
116	return $schema;
117	}