modules/webcomic/webcomic.install

<?php
// $Id: webcomic.install,v 1.6 2006/04/18 21:05:55 eaton Exp $

/**
 * Implementaton of hook_install().
 */
function webcomic_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {webcomic_content} (
        nid int(10) unsigned NOT NULL default '0',
        publish_timestamp int(11) NOT NULL default '0',
        storyline_timestamp int(11) NOT NULL default '0',
        weight int(4) NOT NULL default '0',
        sequence varchar(35) NOT NULL default '0',
        PRIMARY KEY (nid)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE  {webcomic_strip_character} (
        strip_nid int(10) unsigned NOT NULL default '0',
        character_nid int(10) unsigned NOT NULL default '0',
        PRIMARY KEY  (strip_nid),
        KEY character_nid (character_nid)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE  {webcomic_parent} (
        child_nid int(10) unsigned NOT NULL default '0',
        parent_nid int(10) unsigned NOT NULL default '0',
        PRIMARY KEY  (child_nid),
        KEY parent_nid (parent_nid)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      break;
      
    case 'pgsql':
      db_query("CREATE TABLE {webcomic_content} (
        nid int NOT NULL default '0',
        publish_timestamp int NOT NULL default '0',
        storyline_timestamp int NOT NULL default '0',
        weight int NOT NULL default '0',
        sequence varchar(35) NOT NULL default '0',
        PRIMARY KEY (nid)
      )");

      db_query("CREATE TABLE  {webcomic_strip_character} (
        strip_nid int NOT NULL default '0',
        character_nid int NOT NULL default '0',
        PRIMARY KEY (strip_nid)
      )");

      db_query("CREATE TABLE  {webcomic_parent} (
        child_nid int NOT NULL default '0',
        parent_nid int NOT NULL default '0',
        PRIMARY KEY (child_nid)
      )");

      break;
  }
}
1	<?php
2	// $Id: webcomic.install,v 1.6 2006/04/18 21:05:55 eaton Exp $
3
4	/**
5	* Implementaton of hook_install().
6	*/
7	function webcomic_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	db_query("CREATE TABLE {webcomic_content} (
12	nid int(10) unsigned NOT NULL default '0',
13	publish_timestamp int(11) NOT NULL default '0',
14	storyline_timestamp int(11) NOT NULL default '0',
15	weight int(4) NOT NULL default '0',
16	sequence varchar(35) NOT NULL default '0',
17	PRIMARY KEY (nid)
18	) /!40100 DEFAULT CHARACTER SET utf8 /;");
19
20	db_query("CREATE TABLE {webcomic_strip_character} (
21	strip_nid int(10) unsigned NOT NULL default '0',
22	character_nid int(10) unsigned NOT NULL default '0',
23	PRIMARY KEY (strip_nid),
24	KEY character_nid (character_nid)
25	) /!40100 DEFAULT CHARACTER SET utf8 /;");
26
27	db_query("CREATE TABLE {webcomic_parent} (
28	child_nid int(10) unsigned NOT NULL default '0',
29	parent_nid int(10) unsigned NOT NULL default '0',
30	PRIMARY KEY (child_nid),
31	KEY parent_nid (parent_nid)
32	) /!40100 DEFAULT CHARACTER SET utf8 /;");
33
34	break;
35
36	case 'pgsql':
37	db_query("CREATE TABLE {webcomic_content} (
38	nid int NOT NULL default '0',
39	publish_timestamp int NOT NULL default '0',
40	storyline_timestamp int NOT NULL default '0',
41	weight int NOT NULL default '0',
42	sequence varchar(35) NOT NULL default '0',
43	PRIMARY KEY (nid)
44	)");
45
46	db_query("CREATE TABLE {webcomic_strip_character} (
47	strip_nid int NOT NULL default '0',
48	character_nid int NOT NULL default '0',
49	PRIMARY KEY (strip_nid)
50	)");
51
52	db_query("CREATE TABLE {webcomic_parent} (
53	child_nid int NOT NULL default '0',
54	parent_nid int NOT NULL default '0',
55	PRIMARY KEY (child_nid)
56	)");
57
58	break;
59	}
60	}