modules/ljxp/ljxp.install

<?php
function ljxp_schema() {
	$schema['ljxp'] = array(
		'description' => 'ljxp module main table',
		'fields' => array(
			'uid' => array(
				'type' => 'int',
				'unsigned' => TRUE,
    			'not null' => TRUE),
			'active' => array(
				'type' => 'int',
				'unsigned' => TRUE,
    			'not null' => TRUE,
				'default' => 0),
			'host' => array(
				'type' => 'varchar',
				'length' => 255,),
			'name' => array(
				'type' => 'varchar',
				'length' => 255,),
			'pass' => array(
				'type' => 'varchar',
				'length' => 255,),
			'community' => array(
				'type' => 'varchar',
				'length' => 255,),
			'site_name' => array(
				'type' => 'varchar',
				'length' => 255,),
			'custom_header' => array(
				'type' => 'text',
				'size' => 'medium',),
			'custom_header_format' => array(
				'type' => 'int',
			),
			'tags' => array(
				'type' => 'int', 
			),
			'privacy' => array(
				'type' => 'varchar',
				'length' => 20,),
			'comments' => array(
				'type' => 'int', 
			),
			'post_type' => array(
				'type' => 'varchar',
				'length' => 20,),
			'cut_text' => array(
				'type' => 'varchar',
				'length' => 255,),
			
		),
		'primary key' => array('uid'), 
	);

	$schema['ljxp_node'] = array(
		'description' => 'ljxp to node relation',
		'fields' => array(
			'nid' => array(
				'type' => 'int',
				'unsigned' => TRUE,
    			'not null' => TRUE),
			'ljid' => array(
				'type' => 'int',
				'unsigned' => TRUE,
    			'not null' => TRUE,
				'default' => 0),
		),
		'primary key' => array('nid'), 
	);
	
	return $schema;
}

function ljxp_install() {
   drupal_install_schema('ljxp');
   db_query("UPDATE {system} SET weight = 10 WHERE name = 'ljxp'");
}

function ljxp_uninstall() {
	drupal_uninstall_schema('ljxp');
}
1	<?php
2	function ljxp_schema() {
3	$schema['ljxp'] = array(
4	'description' => 'ljxp module main table',
5	'fields' => array(
6	'uid' => array(
7	'type' => 'int',
8	'unsigned' => TRUE,
9	'not null' => TRUE),
10	'active' => array(
11	'type' => 'int',
12	'unsigned' => TRUE,
13	'not null' => TRUE,
14	'default' => 0),
15	'host' => array(
16	'type' => 'varchar',
17	'length' => 255,),
18	'name' => array(
19	'type' => 'varchar',
20	'length' => 255,),
21	'pass' => array(
22	'type' => 'varchar',
23	'length' => 255,),
24	'community' => array(
25	'type' => 'varchar',
26	'length' => 255,),
27	'site_name' => array(
28	'type' => 'varchar',
29	'length' => 255,),
30	'custom_header' => array(
31	'type' => 'text',
32	'size' => 'medium',),
33	'custom_header_format' => array(
34	'type' => 'int',
35	),
36	'tags' => array(
37	'type' => 'int',
38	),
39	'privacy' => array(
40	'type' => 'varchar',
41	'length' => 20,),
42	'comments' => array(
43	'type' => 'int',
44	),
45	'post_type' => array(
46	'type' => 'varchar',
47	'length' => 20,),
48	'cut_text' => array(
49	'type' => 'varchar',
50	'length' => 255,),
51
52	),
53	'primary key' => array('uid'),
54	);
55
56	$schema['ljxp_node'] = array(
57	'description' => 'ljxp to node relation',
58	'fields' => array(
59	'nid' => array(
60	'type' => 'int',
61	'unsigned' => TRUE,
62	'not null' => TRUE),
63	'ljid' => array(
64	'type' => 'int',
65	'unsigned' => TRUE,
66	'not null' => TRUE,
67	'default' => 0),
68	),
69	'primary key' => array('nid'),
70	);
71
72	return $schema;
73	}
74
75	function ljxp_install() {
76	drupal_install_schema('ljxp');
77	db_query("UPDATE {system} SET weight = 10 WHERE name = 'ljxp'");
78	}
79
80	function ljxp_uninstall() {
81	drupal_uninstall_schema('ljxp');
82	}