modules/netforum_views/netforum_views.install

<?php
  // $Id: netforum_views.install,v 1.1 2007/11/05 02:14:06 jamesmichaelhill Exp $

  function netforum_views_install() {
    drupal_set_message('Installing netFORUM views');
    switch ($GLOBALS['db_type']) {
      case 'mysqli':
      case 'mysql':
      db_query("CREATE TABLE if not exists {netforum_view} (
        vid int(10) unsigned NOT NULL default '0',
        name varchar(32) NOT NULL UNIQUE,
        description varchar(255),
        access varchar(255),
        -- page fields
        page int(1),
        page_title varchar(255),
        page_header longtext,
        page_header_format int(4) NOT NULL,
        page_empty longtext,
        page_empty_format int(4) NOT NULL,
        page_footer longtext,
        page_footer_format int(4) NOT NULL,
        url varchar(255),
        -- menu fields
        menu int(1),
        menu_tab int(1),
        menu_tab_weight int(4),
        menu_title varchar(255),
        menu_tab_default int(1),
        menu_tab_default_parent_type varchar(10),
        menu_parent_title varchar(255),
        menu_parent_tab_weight int(4),
        -- block fields
        block int(1),
        block_title varchar(255),
        block_use_page_header int(1),
        block_header longtext,
        block_header_format int(4) NOT NULL,
        block_use_page_footer int(1),
        block_footer longtext,
        block_footer_format int(4) NOT NULL,
        block_use_page_empty int(1),
        block_empty longtext,
        block_empty_format int(4) NOT NULL,
        -- breadcrumb
        breadcrumb_no_home int(1), -- true means start breadcrumb trail from 'Home'.
        -- arguments
        argument_list varchar(255),
        argument_from_get int(1),
        argument_from_post int(1),
        -- other
        changed int(11),
        view_body longtext,
        view_body_format int(4) NOT NULL,
        PRIMARY KEY (vid),
        KEY (name)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */");

      $success = TRUE;
      break;
    case 'pgsql':
      db_query("CREATE TABLE {netforum_view} (
        vid SERIAL,
        name varchar(32) NOT NULL UNIQUE,
        description varchar(255),
        access varchar(255),
        -- page fields
        page smallint,
        page_title varchar(255),
        page_header text,
        page_header_format smallint NOT NULL,
        page_empty text,
        page_empty_format smallint NOT NULL,
        page_footer text,
        page_footer_format smallint NOT NULL,
        url varchar(255),
        -- menu fields
        menu smallint,
        menu_tab smallint,
        menu_tab_weight smallint,
        menu_title varchar(255),
        menu_tab_default smallint,
        menu_tab_default_parent_type varchar(10),
        menu_parent_title varchar(255),
        menu_parent_tab_weight smallint,
        -- block fields
        block smallint,
        block_title varchar(255),
        block_use_page_header smallint,
        block_header text,
        block_header_format smallint NOT NULL,
        block_use_page_footer smallint,
        block_footer text,
        block_footer_format smallint NOT NULL,
        block_use_page_empty smallint,
        block_empty text,
        block_empty_format smallint NOT NULL,
        -- breadcrumb
        breadcrumb_no_home smallint, -- true means start breadcrumb trail from 'Home'.
        -- arguments
        argument_list varchar(255),
        argument_from_get smallint,
        argument_from_post smallint,
        -- other
        changed integer,
        view_body text,
        PRIMARY KEY (vid)
      )");
      db_query("CREATE INDEX {netforum_view}_name_idx ON {netforum_view} (name)");

      $success = TRUE;
      break;
  } // End case

  if ($success) {
    drupal_set_message(t('netFORUM views module installed tables successfully.'));
  }
  else {
    drupal_set_message(t('The installation of netFORUM views module was unsuccessful.'), 'error');
  }
}

function netforum_views_uninstall() {
  if (db_table_exists('netforum_view')) {
    db_query("DROP TABLE {netforum_view}");
  }
}

1	<?php
2	// $Id: netforum_views.install,v 1.1 2007/11/05 02:14:06 jamesmichaelhill Exp $
3
4	function netforum_views_install() {
5	drupal_set_message('Installing netFORUM views');
6	switch ($GLOBALS['db_type']) {
7	case 'mysqli':
8	case 'mysql':
9	db_query("CREATE TABLE if not exists {netforum_view} (
10	vid int(10) unsigned NOT NULL default '0',
11	name varchar(32) NOT NULL UNIQUE,
12	description varchar(255),
13	access varchar(255),
14	-- page fields
15	page int(1),
16	page_title varchar(255),
17	page_header longtext,
18	page_header_format int(4) NOT NULL,
19	page_empty longtext,
20	page_empty_format int(4) NOT NULL,
21	page_footer longtext,
22	page_footer_format int(4) NOT NULL,
23	url varchar(255),
24	-- menu fields
25	menu int(1),
26	menu_tab int(1),
27	menu_tab_weight int(4),
28	menu_title varchar(255),
29	menu_tab_default int(1),
30	menu_tab_default_parent_type varchar(10),
31	menu_parent_title varchar(255),
32	menu_parent_tab_weight int(4),
33	-- block fields
34	block int(1),
35	block_title varchar(255),
36	block_use_page_header int(1),
37	block_header longtext,
38	block_header_format int(4) NOT NULL,
39	block_use_page_footer int(1),
40	block_footer longtext,
41	block_footer_format int(4) NOT NULL,
42	block_use_page_empty int(1),
43	block_empty longtext,
44	block_empty_format int(4) NOT NULL,
45	-- breadcrumb
46	breadcrumb_no_home int(1), -- true means start breadcrumb trail from 'Home'.
47	-- arguments
48	argument_list varchar(255),
49	argument_from_get int(1),
50	argument_from_post int(1),
51	-- other
52	changed int(11),
53	view_body longtext,
54	view_body_format int(4) NOT NULL,
55	PRIMARY KEY (vid),
56	KEY (name)
57	) /!40100 DEFAULT CHARACTER SET utf8 /");
58
59	$success = TRUE;
60	break;
61	case 'pgsql':
62	db_query("CREATE TABLE {netforum_view} (
63	vid SERIAL,
64	name varchar(32) NOT NULL UNIQUE,
65	description varchar(255),
66	access varchar(255),
67	-- page fields
68	page smallint,
69	page_title varchar(255),
70	page_header text,
71	page_header_format smallint NOT NULL,
72	page_empty text,
73	page_empty_format smallint NOT NULL,
74	page_footer text,
75	page_footer_format smallint NOT NULL,
76	url varchar(255),
77	-- menu fields
78	menu smallint,
79	menu_tab smallint,
80	menu_tab_weight smallint,
81	menu_title varchar(255),
82	menu_tab_default smallint,
83	menu_tab_default_parent_type varchar(10),
84	menu_parent_title varchar(255),
85	menu_parent_tab_weight smallint,
86	-- block fields
87	block smallint,
88	block_title varchar(255),
89	block_use_page_header smallint,
90	block_header text,
91	block_header_format smallint NOT NULL,
92	block_use_page_footer smallint,
93	block_footer text,
94	block_footer_format smallint NOT NULL,
95	block_use_page_empty smallint,
96	block_empty text,
97	block_empty_format smallint NOT NULL,
98	-- breadcrumb
99	breadcrumb_no_home smallint, -- true means start breadcrumb trail from 'Home'.
100	-- arguments
101	argument_list varchar(255),
102	argument_from_get smallint,
103	argument_from_post smallint,
104	-- other
105	changed integer,
106	view_body text,
107	PRIMARY KEY (vid)
108	)");
109	db_query("CREATE INDEX {netforum_view}_name_idx ON {netforum_view} (name)");
110
111	$success = TRUE;
112	break;
113	} // End case
114
115	if ($success) {
116	drupal_set_message(t('netFORUM views module installed tables successfully.'));
117	}
118	else {
119	drupal_set_message(t('The installation of netFORUM views module was unsuccessful.'), 'error');
120	}
121	}
122
123	function netforum_views_uninstall() {
124	if (db_table_exists('netforum_view')) {
125	db_query("DROP TABLE {netforum_view}");
126	}
127	}
128