modules/tinymce/tinymce.install

<?php
// $Id: tinymce.install,v 1.6.2.9 2007/05/06 01:07:56 m3avrck Exp $

/**
 * Implementation of hook_install()
 *
 * This will automatically install the database tables for the TinyMCE module for both the MySQL and PostgreSQL databases.
 *
 * If you are using another database, you will have to install the tables by hand, using the queries below as a reference.
 *
 * Note that the curly braces around table names are a drupal-specific feature to allow for automatic database table prefixing,
 * and will need to be removed.
 */
function tinymce_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {tinymce_settings} (
                name varchar(128) NOT NULL default '',
                settings text,
                PRIMARY KEY (name)
               ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {tinymce_role} (
                name varchar(128) NOT NULL default '',
                rid tinyint(3) unsigned NOT NULL default '0',
                PRIMARY KEY (name,rid)
               ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;

    case 'pgsql':
      db_query("CREATE TABLE {tinymce_settings} (
                name varchar(128) NOT NULL default '',
                settings text,
                PRIMARY KEY (name)
               );");

      db_query("CREATE TABLE {tinymce_role} (
                name varchar(128) NOT NULL default '',
                rid smallint NOT NULL default '0',
                PRIMARY KEY (name,rid)
               );");
      break;
   }
}

function tinymce_update_1() {
  return _system_update_utf8(array('tinymce_settings', 'tinymce_role'));
}

/**
 * Implementation of hook_uninstall()
 */
function tinymce_uninstall() {
  db_query('DROP TABLE {tinymce_settings}');
  db_query('DROP TABLE {tinymce_role}');
}
1	<?php
2	// $Id: tinymce.install,v 1.6.2.9 2007/05/06 01:07:56 m3avrck Exp $
3
4	/**
5	* Implementation of hook_install()
6	*
7	* This will automatically install the database tables for the TinyMCE module for both the MySQL and PostgreSQL databases.
8	*
9	* If you are using another database, you will have to install the tables by hand, using the queries below as a reference.
10	*
11	* Note that the curly braces around table names are a drupal-specific feature to allow for automatic database table prefixing,
12	* and will need to be removed.
13	*/
14	function tinymce_install() {
15	switch ($GLOBALS['db_type']) {
16	case 'mysql':
17	case 'mysqli':
18	db_query("CREATE TABLE {tinymce_settings} (
19	name varchar(128) NOT NULL default '',
20	settings text,
21	PRIMARY KEY (name)
22	) /!40100 DEFAULT CHARACTER SET utf8 /;");
23
24	db_query("CREATE TABLE {tinymce_role} (
25	name varchar(128) NOT NULL default '',
26	rid tinyint(3) unsigned NOT NULL default '0',
27	PRIMARY KEY (name,rid)
28	) /!40100 DEFAULT CHARACTER SET utf8 /;");
29	break;
30
31	case 'pgsql':
32	db_query("CREATE TABLE {tinymce_settings} (
33	name varchar(128) NOT NULL default '',
34	settings text,
35	PRIMARY KEY (name)
36	);");
37
38	db_query("CREATE TABLE {tinymce_role} (
39	name varchar(128) NOT NULL default '',
40	rid smallint NOT NULL default '0',
41	PRIMARY KEY (name,rid)
42	);");
43	break;
44	}
45	}
46
47	function tinymce_update_1() {
48	return _system_update_utf8(array('tinymce_settings', 'tinymce_role'));
49	}
50
51	/**
52	* Implementation of hook_uninstall()
53	*/
54	function tinymce_uninstall() {
55	db_query('DROP TABLE {tinymce_settings}');
56	db_query('DROP TABLE {tinymce_role}');
57	}