modules/sifr/sifr.install

<?php
// $Id: sifr.install,v 1.6 2008/01/07 00:01:00 sun Exp $

function sifr_install(){
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {sifr} (
          rid int(10) NOT NULL default '0',
          name varchar(50) NOT NULL default '',
          font varchar(100) NOT NULL default '',
          selector varchar(255) NOT NULL default '',
          color varchar(10) NOT NULL default '',
          linkcolor varchar(10) NOT NULL default '',
          hovercolor varchar(10) NOT NULL default '',
          bgcolor varchar(10) NOT NULL default '',
          transparent tinyint(3) NOT NULL default '0',
          weight float NOT NULL default '0',
          letterspacing varchar(10) NOT NULL default '',
          fontsize varchar(10) NOT NULL default '',
          paddingtop varchar(10) NOT NULL default '',
          paddingright varchar(10) NOT NULL default '',
          paddingbottom varchar(10) NOT NULL default '',
          paddingleft varchar(10) NOT NULL default '',
          textalign varchar(10) NOT NULL default '',
          underline tinyint(3) NOT NULL default '0',
          lettercase varchar(10) NOT NULL default '',
          UNIQUE KEY rid (rid),
          KEY rid_2 (rid)
        ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
      drupal_set_message(t('sIFR database table has been installed.'));
      break;
      
    case 'pgsql':
      break;
  }
}

function sifr_uninstall() {
  variable_del('sifr_rules');
  variable_del('sifr_dir');

  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query('DROP TABLE {sifr}');
      break;
      
    case 'pgsql':
      break;
  }
}

function sifr_update_1(){
	$ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
			$ret[] = update_sql("ALTER TABLE {sifr} 
      		ADD textalign varchar(10) NOT NULL default '',
					ADD underline tinyint(3) NOT NULL default '0',
					ADD lettercase varchar(10) NOT NULL default ''
				");
			drupal_set_message(t('sIFR module has been updated.'));
			break;

    case 'pgsql':
      
      break;
  }
  return $ret;
}

function sifr_update_2() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql('ALTER TABLE {sifr} CHANGE selector selector VARCHAR(255) NOT NULL default ""');
      break;

    case 'pgsql':
      break;
  }
  return $ret;
}
1	<?php
2	// $Id: sifr.install,v 1.6 2008/01/07 00:01:00 sun Exp $
3
4	function sifr_install(){
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	db_query("CREATE TABLE {sifr} (
9	rid int(10) NOT NULL default '0',
10	name varchar(50) NOT NULL default '',
11	font varchar(100) NOT NULL default '',
12	selector varchar(255) NOT NULL default '',
13	color varchar(10) NOT NULL default '',
14	linkcolor varchar(10) NOT NULL default '',
15	hovercolor varchar(10) NOT NULL default '',
16	bgcolor varchar(10) NOT NULL default '',
17	transparent tinyint(3) NOT NULL default '0',
18	weight float NOT NULL default '0',
19	letterspacing varchar(10) NOT NULL default '',
20	fontsize varchar(10) NOT NULL default '',
21	paddingtop varchar(10) NOT NULL default '',
22	paddingright varchar(10) NOT NULL default '',
23	paddingbottom varchar(10) NOT NULL default '',
24	paddingleft varchar(10) NOT NULL default '',
25	textalign varchar(10) NOT NULL default '',
26	underline tinyint(3) NOT NULL default '0',
27	lettercase varchar(10) NOT NULL default '',
28	UNIQUE KEY rid (rid),
29	KEY rid_2 (rid)
30	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
31	drupal_set_message(t('sIFR database table has been installed.'));
32	break;
33
34	case 'pgsql':
35	break;
36	}
37	}
38
39	function sifr_uninstall() {
40	variable_del('sifr_rules');
41	variable_del('sifr_dir');
42
43	switch ($GLOBALS['db_type']) {
44	case 'mysql':
45	case 'mysqli':
46	db_query('DROP TABLE {sifr}');
47	break;
48
49	case 'pgsql':
50	break;
51	}
52	}
53
54	function sifr_update_1(){
55	$ret = array();
56	switch ($GLOBALS['db_type']) {
57	case 'mysql':
58	case 'mysqli':
59	$ret[] = update_sql("ALTER TABLE {sifr}
60	ADD textalign varchar(10) NOT NULL default '',
61	ADD underline tinyint(3) NOT NULL default '0',
62	ADD lettercase varchar(10) NOT NULL default ''
63	");
64	drupal_set_message(t('sIFR module has been updated.'));
65	break;
66
67	case 'pgsql':
68
69	break;
70	}
71	return $ret;
72	}
73
74	function sifr_update_2() {
75	$ret = array();
76	switch ($GLOBALS['db_type']) {
77	case 'mysql':
78	case 'mysqli':
79	$ret[] = update_sql('ALTER TABLE {sifr} CHANGE selector selector VARCHAR(255) NOT NULL default ""');
80	break;
81
82	case 'pgsql':
83	break;
84	}
85	return $ret;
86	}