diff -r 1ede5203910d -r edd0c3ee3e1d install/database-structure.inc.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/install/database-structure.inc.php	Mon Apr 28 18:18:06 2008 +0000
@@ -0,0 +1,290 @@
+<?
+
+
+$def_tables = 
+	array(
+		array(
+			'table_name'	=>	'perm_items',
+			'fields'	=>	array(
+				    'id' => array(
+				    	    'type'		=> 'integer',
+					    'notnull' 		=> 1,
+					    'length' 		=> 4,
+					    'unsigned' 		=> 0,
+					    'autoincrement'	=> 1,
+					    'name' 		=> 'id',
+					    'table' 		=> 'perm_items',
+					    'flags' 		=> 'primary_keynot_null'
+					),
+				    'name' => array(
+				    	    'type'		=> 'text',
+					    'notnull' 		=> 1,
+					    'length' 		=> 64,
+					    'fixed' 		=> 0,
+					    'default' 		=> 0,
+					    'name' 		=> 'name',
+					    'table' 		=> 'perm_items',
+					    'flags' 		=> 'not_null'
+					),
+				    'descr' => array(
+				    	    'type'		=> 'text',
+					    'length'		=> 1024,
+					    'notnull' 		=> 1,
+					    'fixed' 		=> 0,
+					    'default' 		=> 0,
+					    'name' 		=> 'descr',
+					    'table' 		=> 'perm_items',
+					    'flags' 		=> 'not_null'
+					)
+				)
+			),
+		array(
+			'table_name'	=>	'perm_templ',
+			'fields'	=>	array(
+				   'id' => array(
+				    	    'type'		=> 'integer',
+					    'notnull' 		=> 1,
+					    'length' 		=> 4,
+					    'unsigned' 		=> 0,
+					    'default' 		=> 0,
+					    'autoincrement'	=> 1,
+					    'name' 		=> 'id',
+					    'table' 		=> 'perm_templ',
+					    'flags' 		=> 'primary_keynot_null'
+					),
+				    'name' => array(
+				    	    'type'		=> 'integer',
+					    'notnull' 		=> 1,
+					    'length' 		=> 128,
+					    'fixed' 		=> 0,
+					    'default' 		=> 0,
+					    'name' 		=> 'name',
+					    'table' 		=> 'perm_templ',
+					    'flags' 		=> 'not_null'
+					),
+				    'descr' => array(
+					    'notnull' 		=> 1,
+					    'fixed' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'text',
+					    'length'		=> 1024,
+					    'name' 		=> 'descr',
+					    'table' 		=> 'perm_templ',
+					    'flags' 		=> 'not_null'
+					)
+				)
+			),
+		array(
+			'table_name'	=>	'perm_templ_items',
+			'fields'	=>	array(
+				   'id' => array(
+					    'notnull' 		=> 1,
+					    'length' 		=> 4,
+					    'unsigned' 		=> 0,
+					    'default' 		=> 0,
+					    'autoincrement'	=> 1,
+					    'type' 		=> 'integer',
+					    'name' 		=> 'id',
+					    'table' 		=> 'perm_templ_items',
+					    'flags' 		=> 'primary_keynot_null'
+					),
+				    'templ_id' => array(
+					    'notnull' 		=> 1,
+					    'length' 		=> 4,
+					    'unsigned' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'integer',
+					    'name' 		=> 'templ_id',
+					    'table' 		=> 'perm_templ_items',
+					    'flags' 		=> 'not_null'
+					),
+				    'perm_id' => array(
+					    'notnull' 		=> 1,
+					    'length' 		=> 4,
+					    'unsigned' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'integer',
+					    'name' 		=> 'perm_id',
+					    'table' 		=> 'perm_templ_items',
+					    'flags' 		=> 'not_null'
+					)
+				)
+			),
+		array(
+			'table_name'	=>	'users',
+			'fields'	=>	array(
+				    'id' => array
+					(
+					    'notnull' 		=> 1,
+					    'length' 		=> 4,
+					    'unsigned' 		=> 0,
+					    'default' 		=> 0,
+					    'autoincrement'	=> 1,
+					    'type' 		=> 'integer',
+					    'name' 		=> 'id',
+					    'table' 		=> 'users',
+					    'flags' 		=> 'primary_keynot_null'
+					),
+				    'username' => array
+					(
+					    'notnull' 		=> 1,
+					    'length' 		=> 16,
+					    'fixed' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'text',
+					    'name' 		=> 'username',
+					    'table' 		=> 'users',
+					    'flags' 		=> 'not_null'
+					),
+				    'password' => array
+					(
+					    'notnull' 		=> 1,
+					    'length' 		=> 34,
+					    'fixed' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'text',
+					    'name' 		=> 'password',
+					    'table' 		=> 'users',
+					    'flags' 		=> 'not_null'
+					),
+				    'fullname' => array
+					(
+					    'notnull' 		=> 1,
+					    'length' 		=> 255,
+					    'fixed' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'text',
+					    'name' 		=> 'fullname',
+					    'table' 		=> 'users',
+					    'flags' 		=> 'not_null'
+					),
+				    'email' => array
+					(
+					    'notnull' 		=> 1,
+					    'length' 		=> 255,
+					    'fixed' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'text',
+					    'name' 		=> 'email',
+					    'table' 		=> 'users',
+					    'flags' 		=> 'not_null'
+					),
+				    'description' => array
+					(
+					    'notnull' 		=> 1,
+					    'fixed' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'text',
+					    'length'		=> 1024,
+					    'name' 		=> 'description',
+					    'table' 		=> 'users',
+					    'flags' 		=> 'not_null'
+					),
+				    'perm_templ' => array
+					(
+					    'notnull' 		=> 1,
+					    'length' 		=> 1,
+					    'unsigned' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'integer',
+					    'name' 		=> 'perm_templ',
+					    'table' 		=> 'users',
+					    'flags' 		=> 'not_null'
+					),
+				    'active' => array
+					(
+					    'notnull' 		=> 1,
+					    'length' 		=> 1,
+					    'unsigned' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'integer',
+					    'name' 		=> 'active',
+					    'table' 		=> 'users',
+					    'flags' 		=> 'not_null'
+					)
+				)
+			),
+		array(
+			'table_name'	=>	'zones',
+			'fields'	=>	array(
+				    'id' => array
+					(
+					    'notnull' 		=> 1,
+					    'length' 		=> 4,
+					    'unsigned' 		=> 0,
+					    'default' 		=> 0,
+					    'autoincrement'	=> 1,
+					    'type' 		=> 'integer',
+					    'name' 		=> 'id',
+					    'table' 		=> 'zones',
+					    'flags' 		=> 'primary_keynot_null'
+					),
+				    'domain_id' => array
+					(
+					    'notnull' 		=> 1,
+					    'length' 		=> 4,
+					    'unsigned' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'integer',
+					    'name' 		=> 'domain_id',
+					    'table' 		=> 'zones',
+					    'flags' 		=> 'not_null'
+					),
+				    'owner' => array
+					(
+					    'notnull' 		=> 1,
+					    'length' 		=> 4,
+					    'unsigned' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'integer',
+					    'name' 		=> 'owner',
+					    'table' 		=> 'zones',
+					    'flags' 		=> 'not_null'
+					),
+				    'comment' => array
+					(
+					    'notnull' 		=> 0,
+					    'length' 		=> 1024,
+					    'fixed' 		=> 0,
+					    'default' 		=> 0,
+					    'type' 		=> 'text',
+					    'name' 		=> 'comment',
+					    'table' 		=> 'zones',
+					    'flags' 		=> ''
+					)
+				)
+			)
+		);
+
+$def_permissions = array(
+			array(41,'zone_master_add','User is allowed to add new master zones.'),
+			array(42,'zone_slave_add','User is allowed to add new slave zones.'),
+			array(43,'zone_content_view_own','User is allowed to see the content and meta data of zones he owns.'),
+			array(44,'zone_content_edit_own','User is allowed to edit the content of zones he owns.'),
+			array(45,'zone_meta_edit_own','User is allowed to edit the meta data of zones he owns.'),
+			array(46,'zone_content_view_others','User is allowed to see the content and meta data of zones he does not own.'),
+			array(47,'zone_content_edit_others','User is allowed to edit the content of zones he does not own.'),
+			array(48,'zone_meta_edit_others','User is allowed to edit the meta data of zones he does not own.'),
+			array(49,'search','User is allowed to perform searches.'),
+			array(50,'supermaster_view','User is allowed to view supermasters.'),
+			array(51,'supermaster_add','User is allowed to add new supermasters.'),
+			array(52,'supermaster_edit','User is allowed to edit supermasters.'),
+			array(53,'user_is_ueberuser','User has full access. God-like. Redeemer.'),
+			array(54,'user_view_others','User is allowed to see other users and their details.'),
+			array(55,'user_add_new','User is allowed to add new users.'),
+			array(56,'user_edit_own','User is allowed to edit their own details.'),
+			array(57,'user_edit_others','User is allowed to edit other users.'),
+			array(58,'user_passwd_edit_others','User is allowed to edit the password of other users.'),
+			array(59,'user_edit_templ_perm','User is allowed to change the permission template that is assigned to a user.'),
+			array(60,'templ_perm_add','User is allowed to add new permission templates.'),
+			array(61,'templ_perm_edit','User is allowed to edit existing permission templates.')
+		);
+
+$def_remaining_queries = array(
+			"INSERT INTO users VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3','Administrator','admin@example.net','Administrator with full rights.',1,1)",
+			"INSERT INTO perm_templ VALUES (1,'Administrator','Administrator template with full rights.')",
+			"INSERT INTO perm_templ_items VALUES (249,1,53)"
+		);
+
+
+