modules/signwriter/signwriter.install

<?php
// $Id: signwriter.install,v 1.7 2008/09/04 06:34:56 nterbogt Exp $

/**
 * Implementation of hook_install().
 */
function signwriter_install() {
  drupal_install_schema('signwriter');
}

/**
 * Implementation of hook_uninstall().
 */
function signwriter_uninstall() {
  drupal_uninstall_schema('signwriter');
}

/**
 * Implementation of hook_schema().
 */
function signwriter_schema() {
  $schema['signwriter'] = array(
    'description' => t('signwriter table'),
    'fields' => array(
      'id'    => array(
        'description' => 'the primary identifier of the schema',
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE
      ),
      'name' => array(
        'description' => 'the name of the schema',
        'type' => 'varchar',
        'length' => 128
      ),
      'pattern' => array(
        'description' => 'the signwriter pattern',
        'type' => 'varchar',
        'length' => 128
      ),
      'fontfile' => array(
        'description' => 'the name of the font, without ttf',
        'type' => 'varchar',
        'length' => 128
      ),
      'fontsize' => array(
        'description' => 'the size of the font',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 20
      ),
      'imagetype' => array(
        'description' => 'the type of the image',
        'type' => 'varchar',
        'length' => 8,
        'not null' => TRUE,
        'default' => 'gif'
      ),
      'background' => array(
        'description' => 'background color',
        'type' => 'varchar',
        'length' => 6,
        'not null' => TRUE,
        'default' => 'ffffff'
      ),
      'foreground' => array(
        'description' => 'foreground color',
        'type' => 'varchar',
        'length' => 6,
        'not null' => TRUE,
        'default' => '000000'
      ),
      'transparent' => array(
        'description' => 'transparent image',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 1
      ),
      'bgimage' => array(
        'description' => 'background image',
        'type' => 'varchar',
        'length' => 128
      ),
      'width' => array(
        'description' => 'width of the image',
        'type' => 'int'
      ),
      'height' => array(
        'description' => 'height of the image',
        'type' => 'int'
      ),
      'maxwidth' => array(
        'description' => 'maximum width of the image',
        'type' => 'int'
      ),
      'textalign' => array(
        'description' => 'alignment of text within the image',
        'type' => 'varchar',
        'length' => 32
      ),
      'xoffset' => array(
        'description' => 'x offset of the text within the image',
        'type' => 'int'
      ),
      'yoffset' => array(
        'description' => 'y offset of the text within the image',
        'type' => 'int'
      ),
      'multiline' => array(
        'description' => 'is multiline functionality enabled',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 1
      ),
      'drop_shadow' => array(
        'description' => 'are drop shadows on or off',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0
      ),
      'shadow_color' => array(
        'description' => 'are drop shadows on or off',
        'type' => 'varchar',
        'not null' => TRUE,
        'length' => 6,
        'default' => 'D2D2D2'
      ),
      'shadow_xoffset' => array(
        'description' => 'x offset of shadow from actual text',
        'type' => 'int',
        'default' => 5
      ),
      'shadow_yoffset' => array(
        'description' => 'y offset of shadow from actual text',
        'type' => 'int'
      )
    ),
    'indexes' => array(
      'name'    => array('name')
    ),
    'primary key' => array('id'),
  );

  return $schema;
}
1	<?php
2	// $Id: signwriter.install,v 1.7 2008/09/04 06:34:56 nterbogt Exp $
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function signwriter_install() {
8	drupal_install_schema('signwriter');
9	}
10
11	/**
12	* Implementation of hook_uninstall().
13	*/
14	function signwriter_uninstall() {
15	drupal_uninstall_schema('signwriter');
16	}
17
18	/**
19	* Implementation of hook_schema().
20	*/
21	function signwriter_schema() {
22	$schema['signwriter'] = array(
23	'description' => t('signwriter table'),
24	'fields' => array(
25	'id' => array(
26	'description' => 'the primary identifier of the schema',
27	'type' => 'serial',
28	'unsigned' => TRUE,
29	'not null' => TRUE
30	),
31	'name' => array(
32	'description' => 'the name of the schema',
33	'type' => 'varchar',
34	'length' => 128
35	),
36	'pattern' => array(
37	'description' => 'the signwriter pattern',
38	'type' => 'varchar',
39	'length' => 128
40	),
41	'fontfile' => array(
42	'description' => 'the name of the font, without ttf',
43	'type' => 'varchar',
44	'length' => 128
45	),
46	'fontsize' => array(
47	'description' => 'the size of the font',
48	'type' => 'int',
49	'not null' => TRUE,
50	'default' => 20
51	),
52	'imagetype' => array(
53	'description' => 'the type of the image',
54	'type' => 'varchar',
55	'length' => 8,
56	'not null' => TRUE,
57	'default' => 'gif'
58	),
59	'background' => array(
60	'description' => 'background color',
61	'type' => 'varchar',
62	'length' => 6,
63	'not null' => TRUE,
64	'default' => 'ffffff'
65	),
66	'foreground' => array(
67	'description' => 'foreground color',
68	'type' => 'varchar',
69	'length' => 6,
70	'not null' => TRUE,
71	'default' => '000000'
72	),
73	'transparent' => array(
74	'description' => 'transparent image',
75	'type' => 'int',
76	'not null' => TRUE,
77	'default' => 1
78	),
79	'bgimage' => array(
80	'description' => 'background image',
81	'type' => 'varchar',
82	'length' => 128
83	),
84	'width' => array(
85	'description' => 'width of the image',
86	'type' => 'int'
87	),
88	'height' => array(
89	'description' => 'height of the image',
90	'type' => 'int'
91	),
92	'maxwidth' => array(
93	'description' => 'maximum width of the image',
94	'type' => 'int'
95	),
96	'textalign' => array(
97	'description' => 'alignment of text within the image',
98	'type' => 'varchar',
99	'length' => 32
100	),
101	'xoffset' => array(
102	'description' => 'x offset of the text within the image',
103	'type' => 'int'
104	),
105	'yoffset' => array(
106	'description' => 'y offset of the text within the image',
107	'type' => 'int'
108	),
109	'multiline' => array(
110	'description' => 'is multiline functionality enabled',
111	'type' => 'int',
112	'not null' => TRUE,
113	'default' => 1
114	),
115	'drop_shadow' => array(
116	'description' => 'are drop shadows on or off',
117	'type' => 'int',
118	'not null' => TRUE,
119	'default' => 0
120	),
121	'shadow_color' => array(
122	'description' => 'are drop shadows on or off',
123	'type' => 'varchar',
124	'not null' => TRUE,
125	'length' => 6,
126	'default' => 'D2D2D2'
127	),
128	'shadow_xoffset' => array(
129	'description' => 'x offset of shadow from actual text',
130	'type' => 'int',
131	'default' => 5
132	),
133	'shadow_yoffset' => array(
134	'description' => 'y offset of shadow from actual text',
135	'type' => 'int'
136	)
137	),
138	'indexes' => array(
139	'name' => array('name')
140	),
141	'primary key' => array('id'),
142	);
143
144	return $schema;
145	}