modules/advcache/advcache.install

<?php

function advcache_install() {
  $tables = array('node', 'comment', 'taxonomy', 'path', 'search', 'forum', 'advcache_block');
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      foreach ($tables as $table) {
        db_query("CREATE TABLE {cache_$table} (
          cid varchar(255) NOT NULL default '',
          data longblob,
          expire int NOT NULL default '0',
          created int NOT NULL default '0',
          headers text,
          serialized int(1) NOT NULL default '0',
          PRIMARY KEY (cid),
          INDEX expire (expire)
        ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      }
      break;

    case 'pgsql':
      foreach ($tables as $table) {
        db_query("CREATE TABLE {cache_$table} (
          cid varchar(255) NOT NULL default '',
          data bytea,
          expire int NOT NULL default '0',
          created int NOT NULL default '0',
          headers text,
          serialized int NOT NULL default '0',
          PRIMARY KEY (cid)
        )");
      db_query("CREATE INDEX {cache_$table}_expire_idx ON {cache_$table} (expire)");
      }
      break;
  }
}

function advcache_uninstall() {
  $tables = array('node', 'comment', 'taxonomy', 'path', 'search', 'forum', 'advcache_block');
  foreach ($tables as $table) {
    if (db_table_exists("cache_$table")) {
      db_query("DROP TABLE {cache_$table}");
    }
  }
}


function advcache_update_1() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("CREATE TABLE {cache_forum} (
        cid varchar(255) NOT NULL default '',
        data longblob,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid),
        INDEX expire (expire)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;

    case 'pgsql':
      $ret[] = update_sql("CREATE TABLE {cache_forum} (
        cid varchar(255) NOT NULL default '',
        data bytea,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid)
      )");
      db_query("CREATE INDEX {cache_forum}_expire_idx ON {cache_forum} (expire)");
      break;
  }
  return $ret;
}

function advcache_update_2() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("CREATE TABLE {cache_advcache_block} (
        cid varchar(255) NOT NULL default '',
        data longblob,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid),
        INDEX expire (expire)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      db_query("CREATE TABLE {cache_search} (
        cid varchar(255) NOT NULL default '',
        data longblob,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid),
        INDEX expire (expire)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      db_query("CREATE TABLE {cache_forum} (
        cid varchar(255) NOT NULL default '',
        data longblob,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid),
        INDEX expire (expire)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      db_query("CREATE TABLE {cache_advcache_block} (
        cid varchar(255) NOT NULL default '',
        data longblob,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid),
        INDEX expire (expire)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;

    case 'pgsql':
      $ret[] = update_sql("CREATE TABLE {cache_advcache_block} (
        cid varchar(255) NOT NULL default '',
        data bytea,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid)
      )");
      db_query("CREATE INDEX {cache_taxonomy}_expire_idx ON {cache_taxonomy} (expire)");
      db_query("CREATE TABLE {cache_path} (
        cid varchar(255) NOT NULL default '',
        data bytea,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid)
      )");
      db_query("CREATE INDEX {cache_path}_expire_idx ON {cache_path} (expire)");
      db_query("CREATE TABLE {cache_search} (
        cid varchar(255) NOT NULL default '',
        data bytea,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid)
      )");
      db_query("CREATE INDEX {cache_search}_expire_idx ON {cache_search} (expire)");
      db_query("CREATE TABLE {cache_forum} (
        cid varchar(255) NOT NULL default '',
        data bytea,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid)
      )");
      db_query("CREATE INDEX {cache_forum}_expire_idx ON {cache_forum} (expire)");
      db_query("CREATE TABLE {cache_advcache_block} (
        cid varchar(255) NOT NULL default '',
        data bytea,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid)
      )");
      db_query("CREATE INDEX {cache_advcache_block}_expire_idx ON {cache_advcache_block} (expire)");
      break;
  }
  return $ret;
}

function advcache_update_3() {
  $tables = array('node', 'comment', 'taxonomy', 'path', 'search', 'forum', 'advcache_block');

  switch ($GLOBALS['db_type']) {
    case 'pgsql':
      foreach ($tables as $table) {
        $ret[] = update_sql("DELETE FROM {cache_$table}");
        db_add_column($ret, 'cache_' . $table, 'serialized', 'integer', array('default' => "'0'", 'not null' => TRUE));
      }
      break;
    case 'mysql':
    case 'mysqli':
      foreach ($tables as $table) {
        $ret[] = update_sql("DELETE FROM {cache_$table}");
        $ret[] = update_sql("ALTER TABLE {cache_$table} ADD serialized int(1) NOT NULL default '0'");
      }
      break;
  }
  if (db_table_exists('cache_search')) {
    db_query("DROP TABLE {cache_search}");
  }
  if (db_table_exists('cache_forum')) {
    db_query("DROP TABLE {cache_forum}");
  }
  if (db_table_exists('cache_advcache_block')) {
    db_query("DROP TABLE {cache_advcache_block}");
  }
}


function advcache_update_1() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("CREATE TABLE {cache_forum} (
        cid varchar(255) NOT NULL default '',
        data longblob,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid),
        INDEX expire (expire)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;

    case 'pgsql':
      $ret[] = update_sql("CREATE TABLE {cache_forum} (
        cid varchar(255) NOT NULL default '',
        data bytea,
        expire int NOT NULL default '0',
        created int NOT NULL default '0',
        headers text,
        PRIMARY KEY (cid)
      )");
      db_query("CREATE INDEX {cache_forum}_expire_idx ON {cache_forum} (expire)");
      break;
  }
  return $ret;
}
1	<?php
2
3	function advcache_install() {
4	$tables = array('node', 'comment', 'taxonomy', 'path', 'search', 'forum', 'advcache_block');
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	foreach ($tables as $table) {
9	db_query("CREATE TABLE {cache_$table} (
10	cid varchar(255) NOT NULL default '',
11	data longblob,
12	expire int NOT NULL default '0',
13	created int NOT NULL default '0',
14	headers text,
15	serialized int(1) NOT NULL default '0',
16	PRIMARY KEY (cid),
17	INDEX expire (expire)
18	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
19	}
20	break;
21
22	case 'pgsql':
23	foreach ($tables as $table) {
24	db_query("CREATE TABLE {cache_$table} (
25	cid varchar(255) NOT NULL default '',
26	data bytea,
27	expire int NOT NULL default '0',
28	created int NOT NULL default '0',
29	headers text,
30	serialized int NOT NULL default '0',
31	PRIMARY KEY (cid)
32	)");
33	db_query("CREATE INDEX {cache_$table}_expire_idx ON {cache_$table} (expire)");
34	}
35	break;
36	}
37	}
38
39	function advcache_uninstall() {
40	$tables = array('node', 'comment', 'taxonomy', 'path', 'search', 'forum', 'advcache_block');
41	foreach ($tables as $table) {
42	if (db_table_exists("cache_$table")) {
43	db_query("DROP TABLE {cache_$table}");
44	}
45	}
46	}
47
48
49	function advcache_update_1() {
50	switch ($GLOBALS['db_type']) {
51	case 'mysql':
52	case 'mysqli':
53	$ret[] = update_sql("CREATE TABLE {cache_forum} (
54	cid varchar(255) NOT NULL default '',
55	data longblob,
56	expire int NOT NULL default '0',
57	created int NOT NULL default '0',
58	headers text,
59	PRIMARY KEY (cid),
60	INDEX expire (expire)
61	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
62	break;
63
64	case 'pgsql':
65	$ret[] = update_sql("CREATE TABLE {cache_forum} (
66	cid varchar(255) NOT NULL default '',
67	data bytea,
68	expire int NOT NULL default '0',
69	created int NOT NULL default '0',
70	headers text,
71	PRIMARY KEY (cid)
72	)");
73	db_query("CREATE INDEX {cache_forum}_expire_idx ON {cache_forum} (expire)");
74	break;
75	}
76	return $ret;
77	}
78
79	function advcache_update_2() {
80	switch ($GLOBALS['db_type']) {
81	case 'mysql':
82	case 'mysqli':
83	$ret[] = update_sql("CREATE TABLE {cache_advcache_block} (
84	cid varchar(255) NOT NULL default '',
85	data longblob,
86	expire int NOT NULL default '0',
87	created int NOT NULL default '0',
88	headers text,
89	PRIMARY KEY (cid),
90	INDEX expire (expire)
91	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
92	db_query("CREATE TABLE {cache_search} (
93	cid varchar(255) NOT NULL default '',
94	data longblob,
95	expire int NOT NULL default '0',
96	created int NOT NULL default '0',
97	headers text,
98	PRIMARY KEY (cid),
99	INDEX expire (expire)
100	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
101	db_query("CREATE TABLE {cache_forum} (
102	cid varchar(255) NOT NULL default '',
103	data longblob,
104	expire int NOT NULL default '0',
105	created int NOT NULL default '0',
106	headers text,
107	PRIMARY KEY (cid),
108	INDEX expire (expire)
109	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
110	db_query("CREATE TABLE {cache_advcache_block} (
111	cid varchar(255) NOT NULL default '',
112	data longblob,
113	expire int NOT NULL default '0',
114	created int NOT NULL default '0',
115	headers text,
116	PRIMARY KEY (cid),
117	INDEX expire (expire)
118	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
119	break;
120
121	case 'pgsql':
122	$ret[] = update_sql("CREATE TABLE {cache_advcache_block} (
123	cid varchar(255) NOT NULL default '',
124	data bytea,
125	expire int NOT NULL default '0',
126	created int NOT NULL default '0',
127	headers text,
128	PRIMARY KEY (cid)
129	)");
130	db_query("CREATE INDEX {cache_taxonomy}_expire_idx ON {cache_taxonomy} (expire)");
131	db_query("CREATE TABLE {cache_path} (
132	cid varchar(255) NOT NULL default '',
133	data bytea,
134	expire int NOT NULL default '0',
135	created int NOT NULL default '0',
136	headers text,
137	PRIMARY KEY (cid)
138	)");
139	db_query("CREATE INDEX {cache_path}_expire_idx ON {cache_path} (expire)");
140	db_query("CREATE TABLE {cache_search} (
141	cid varchar(255) NOT NULL default '',
142	data bytea,
143	expire int NOT NULL default '0',
144	created int NOT NULL default '0',
145	headers text,
146	PRIMARY KEY (cid)
147	)");
148	db_query("CREATE INDEX {cache_search}_expire_idx ON {cache_search} (expire)");
149	db_query("CREATE TABLE {cache_forum} (
150	cid varchar(255) NOT NULL default '',
151	data bytea,
152	expire int NOT NULL default '0',
153	created int NOT NULL default '0',
154	headers text,
155	PRIMARY KEY (cid)
156	)");
157	db_query("CREATE INDEX {cache_forum}_expire_idx ON {cache_forum} (expire)");
158	db_query("CREATE TABLE {cache_advcache_block} (
159	cid varchar(255) NOT NULL default '',
160	data bytea,
161	expire int NOT NULL default '0',
162	created int NOT NULL default '0',
163	headers text,
164	PRIMARY KEY (cid)
165	)");
166	db_query("CREATE INDEX {cache_advcache_block}_expire_idx ON {cache_advcache_block} (expire)");
167	break;
168	}
169	return $ret;
170	}
171
172	function advcache_update_3() {
173	$tables = array('node', 'comment', 'taxonomy', 'path', 'search', 'forum', 'advcache_block');
174
175	switch ($GLOBALS['db_type']) {
176	case 'pgsql':
177	foreach ($tables as $table) {
178	$ret[] = update_sql("DELETE FROM {cache_$table}");
179	db_add_column($ret, 'cache_' . $table, 'serialized', 'integer', array('default' => "'0'", 'not null' => TRUE));
180	}
181	break;
182	case 'mysql':
183	case 'mysqli':
184	foreach ($tables as $table) {
185	$ret[] = update_sql("DELETE FROM {cache_$table}");
186	$ret[] = update_sql("ALTER TABLE {cache_$table} ADD serialized int(1) NOT NULL default '0'");
187	}
188	break;
189	}
190	if (db_table_exists('cache_search')) {
191	db_query("DROP TABLE {cache_search}");
192	}
193	if (db_table_exists('cache_forum')) {
194	db_query("DROP TABLE {cache_forum}");
195	}
196	if (db_table_exists('cache_advcache_block')) {
197	db_query("DROP TABLE {cache_advcache_block}");
198	}
199	}
200
201
202	function advcache_update_1() {
203	switch ($GLOBALS['db_type']) {
204	case 'mysql':
205	case 'mysqli':
206	$ret[] = update_sql("CREATE TABLE {cache_forum} (
207	cid varchar(255) NOT NULL default '',
208	data longblob,
209	expire int NOT NULL default '0',
210	created int NOT NULL default '0',
211	headers text,
212	PRIMARY KEY (cid),
213	INDEX expire (expire)
214	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
215	break;
216
217	case 'pgsql':
218	$ret[] = update_sql("CREATE TABLE {cache_forum} (
219	cid varchar(255) NOT NULL default '',
220	data bytea,
221	expire int NOT NULL default '0',
222	created int NOT NULL default '0',
223	headers text,
224	PRIMARY KEY (cid)
225	)");
226	db_query("CREATE INDEX {cache_forum}_expire_idx ON {cache_forum} (expire)");
227	break;
228	}
229	return $ret;
230	}