modules/translatable/translatable.install

<?php
// $Id: translatable.install,v 1.1 2008/02/17 05:22:40 sun Exp $

function translatable_install() {
  global $locale, $db_type;

  switch ($db_type) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {node_translatable} (
        nid int(10) unsigned NOT NULL,
        language VARCHAR(10) NOT NULL default '',
        tnid int(10) unsigned NOT NULL,
        any tinyint(1) NOT NULL default 0,
        PRIMARY KEY (nid),
        KEY node_translatable_idx1 (tnid),
        UNIQUE KEY node_translatable_idx2 (language,tnid)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {translatable_object} (
        tid int(10) unsigned NOT NULL auto_increment,
        object_name varchar(100) NOT NULL,
        object_key varchar(100) NOT NULL,
        object_field varchar(100) NOT NULL,
        translation text NOT NULL,
        locale varchar(10) NOT NULL,
        PRIMARY KEY  (tid),
        UNIQUE KEY translatable_object_idx1 (object_name, object_key, object_field, locale)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    
    case 'pgsql':
      db_query("CREATE TABLE {node_translatable} (
        nid int4 NOT NULL,
        language VARCHAR(10) NOT NULL default '',
        tnid int4 NOT NULL,
        any smallint NOT NULL default 0,
        PRIMARY KEY (nid),
        UNIQUE (language,tnid)
      );");
      db_query("create index node_translatable_tnid_index on {node_translatable} (tnid)");

      db_query("CREATE TABLE {translatable_object} (
        tid serial NOT NULL ,
        object_name varchar(100) NOT NULL,
        object_key varchar(100) NOT NULL,
        object_field varchar(100) NOT NULL,
        translation text NOT NULL,
        locale varchar(10) NOT NULL,
        PRIMARY KEY  (tid),
        UNIQUE (object_name, object_key, object_field, locale)
      );");
      break;
  }

  // Import all existing nodes.
  if (!$locale) {
    $locale = 'en';
  }
  db_query("INSERT INTO {node_translatable} (nid, language, tnid) SELECT nid, '%s', nid FROM {node}", $locale);
  
  // Try to enable our blocks.
  _block_rehash();
}

1	<?php
2	// $Id: translatable.install,v 1.1 2008/02/17 05:22:40 sun Exp $
3
4	function translatable_install() {
5	global $locale, $db_type;
6
7	switch ($db_type) {
8	case 'mysql':
9	case 'mysqli':
10	db_query("CREATE TABLE {node_translatable} (
11	nid int(10) unsigned NOT NULL,
12	language VARCHAR(10) NOT NULL default '',
13	tnid int(10) unsigned NOT NULL,
14	any tinyint(1) NOT NULL default 0,
15	PRIMARY KEY (nid),
16	KEY node_translatable_idx1 (tnid),
17	UNIQUE KEY node_translatable_idx2 (language,tnid)
18	) /!40100 DEFAULT CHARACTER SET utf8 /;");
19
20	db_query("CREATE TABLE {translatable_object} (
21	tid int(10) unsigned NOT NULL auto_increment,
22	object_name varchar(100) NOT NULL,
23	object_key varchar(100) NOT NULL,
24	object_field varchar(100) NOT NULL,
25	translation text NOT NULL,
26	locale varchar(10) NOT NULL,
27	PRIMARY KEY (tid),
28	UNIQUE KEY translatable_object_idx1 (object_name, object_key, object_field, locale)
29	) /!40100 DEFAULT CHARACTER SET utf8 /;");
30	break;
31
32	case 'pgsql':
33	db_query("CREATE TABLE {node_translatable} (
34	nid int4 NOT NULL,
35	language VARCHAR(10) NOT NULL default '',
36	tnid int4 NOT NULL,
37	any smallint NOT NULL default 0,
38	PRIMARY KEY (nid),
39	UNIQUE (language,tnid)
40	);");
41	db_query("create index node_translatable_tnid_index on {node_translatable} (tnid)");
42
43	db_query("CREATE TABLE {translatable_object} (
44	tid serial NOT NULL ,
45	object_name varchar(100) NOT NULL,
46	object_key varchar(100) NOT NULL,
47	object_field varchar(100) NOT NULL,
48	translation text NOT NULL,
49	locale varchar(10) NOT NULL,
50	PRIMARY KEY (tid),
51	UNIQUE (object_name, object_key, object_field, locale)
52	);");
53	break;
54	}
55
56	// Import all existing nodes.
57	if (!$locale) {
58	$locale = 'en';
59	}
60	db_query("INSERT INTO {node_translatable} (nid, language, tnid) SELECT nid, '%s', nid FROM {node}", $locale);
61
62	// Try to enable our blocks.
63	_block_rehash();
64	}
65