[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] ged/setup tables_current.inc.php
From: |
Pascal Vilarem |
Subject: |
[Phpgroupware-cvs] ged/setup tables_current.inc.php |
Date: |
Thu, 27 Sep 2007 20:58:34 +0000 |
CVSROOT: /sources/phpgroupware
Module name: ged
Changes by: Pascal Vilarem <maat> 07/09/27 20:58:34
Modified files:
setup : tables_current.inc.php
Log message:
new tables for types management
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/ged/setup/tables_current.inc.php?cvsroot=phpgroupware&r1=1.8&r2=1.9
Patches:
Index: tables_current.inc.php
===================================================================
RCS file: /sources/phpgroupware/ged/setup/tables_current.inc.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -b -r1.8 -r1.9
--- tables_current.inc.php 1 Aug 2007 17:28:49 -0000 1.8
+++ tables_current.inc.php 27 Sep 2007 20:58:34 -0000 1.9
@@ -1,30 +1,35 @@
<?php
-
/**************************************************************************
- * phpGroupWare - ged
- * http://www.phpgroupware.org
- * Written by Pascal Vilarem <address@hidden>
- *
- *
--------------------------------------------------------------------------
- * This program is free software; you can redistribute it and/or modify
it
- * under the terms of the GNU General Public License as published by the
- * Free Software Foundation; either version 2 of the License, or (at
your
- * option) any later version
-
***************************************************************************/
+ /**************************************************************************\
+ * phpGroupWare - Setup *
+ * http://www.phpgroupware.org *
+ * -------------------------------------------- *
+ * This program is free software; you can redistribute it and/or modify it *
+ * under the terms of the GNU General Public License as published by the *
+ * Free Software Foundation; either version 2 of the License, or (at your *
+ * option) any later version. *
+ \**************************************************************************/
+
+ /**************************************************************************\
+ * This file should be generated for you by setup. It should not need to be *
+ * edited by hand. *
+ \**************************************************************************/
+
+ /* $Id: tables_current.inc.php,v 1.9 2007/09/27 20:58:34 maat Exp $ */
/* table array for ged */
- $phpgw_baseline=array(
- 'ged_comments'=>array(
- 'fd'=>array(
-
'comment_id'=>array('type'=>'auto','nullable'=>False),
- 'element_id'=>array('type'=>'int',
'precision'=>4,'nullable'=>False,'default'=>'0'),
- 'account_id'=>array('type'=>'int',
'precision'=>4,'nullable'=>False,'default'=>'0'),
-
'comment_date'=>array('type'=>'timestamp','nullable'=>False,'default'=>'current_timestamp'),
-
'comment'=>array('type'=>'text','nullable'=>False)
- ),
- 'pk'=>array('comment_id'),
- 'fk'=>array(),
- 'ix'=>array(),
- 'uc'=>array()
+ $phpgw_baseline = array(
+ 'ged_comments' => array(
+ 'fd' => array(
+ 'comment_id' => array('type' =>
'auto','nullable' => False),
+ 'element_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'account_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'comment_date' => array(,'nullable' =>
False,'default' => 'CURRENT_TIMESTAMP'),
+ 'comment' => array('type' => 'text','nullable'
=> False)
+ ),
+ 'pk' => array('comment_id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
),
'ged_elements' => array(
'fd' => array(
@@ -80,84 +85,87 @@
'ix' => array(),
'uc' => array()
),
- 'ged_mimes'=>array(
- 'fd'=>array(
- 'file_extension'=>array('type'=>'char',
'precision'=>10,'nullable'=>False),
- 'mime_type'=>array('type'=>'char',
'precision'=>50,'nullable'=>False)
- ),
- 'pk'=>array('file_extension'),
- 'fk'=>array(),
- 'ix'=>array(),
- 'uc'=>array()
- ),
- 'ged_versions'=>array(
- 'fd'=>array(
- 'url'=>array('type'=>'varchar',
'precision'=>100,'nullable'=>True),
- 'size'=>array('type'=>'int',
'precision'=>4,'nullable'=>False,'default'=>'0'),
- 'status'=>array('type'=>'varchar',
'precision'=>100,'nullable'=>False),
- 'creator_id'=>array('type'=>'int',
'precision'=>4,'nullable'=>False,'default'=>'0'),
- 'validation_date'=>array('type'=>'int',
'precision'=>4,'nullable'=>True ),
- 'creation_date'=>array('type'=>'int',
'precision'=>4,'nullable'=>False,'default'=>'0'),
- 'minor'=>array('type'=>'int',
'precision'=>4,'nullable'=>False,'default'=>'0'),
-
'version_id'=>array('type'=>'auto','nullable'=>False),
- 'element_id'=>array('type'=>'int',
'precision'=>4,'nullable'=>False,'default'=>'0'),
- 'description'=>array('type'=>'varchar',
'precision'=>255,'nullable'=>False),
- 'file_extension'=>array('type'=>'varchar',
'precision'=>100,'nullable'=>False),
- 'file_name'=>array('type'=>'varchar',
'precision'=>255,'nullable'=>False,'default'=>'0'),
- 'major'=>array('type'=>'int',
'precision'=>4,'nullable'=>False,'default'=>'0'),
- 'stored_name'=>array('type'=>'varchar',
'precision'=>255,'nullable'=>False)
- ),
- 'pk'=>array('version_id'),
- 'fk'=>array(),
- 'ix'=>array(),
- 'uc'=>array()
- ),
- 'ged_acl'=>array(
- 'fd'=>array(
-
'acl_id'=>array('type'=>'auto','nullable'=>False),
- 'element_id'=>array('type'=>'int',
'precision'=>4,'nullable'=>False,'default'=>'0'),
- 'account_id'=>array('type'=>'int',
'precision'=>4,'nullable'=>False,'default'=>'0'),
- 'date_begin'=>array('type'=>'int',
'precision'=>4,'nullable'=>True,'default'=>'0'),
- 'date_expire'=>array('type'=>'int',
'precision'=>4,'nullable'=>True,'default'=>'0'),
- 'inherited'=>array('type'=>'int',
'precision'=>2,'nullable'=>True,'default'=>'0'),
- 'aclread'=>array('type'=>'int',
'precision'=>2,'nullable'=>True),
- 'aclwrite'=>array('type'=>'int',
'precision'=>2,'nullable'=>True),
- 'aclchangeacl'=>array('type'=>'int',
'precision'=>2,'nullable'=>True,'default'=>'0')
- ),
- 'pk'=>array('acl_id'),
- 'fk'=>array(),
- 'ix'=>array(),
- 'uc'=>array()
- ),
- 'ged_doc_types'=>array(
- 'fd'=>array(
- 'type_id'=>array('type'=>'varchar',
'precision'=>255,'nullable'=>False),
- 'type_desc'=>array('type'=>'varchar',
'precision'=>255,'nullable'=>True),
- 'type_chrono'=>array('type'=>'int',
'precision'=>4,'nullable'=>False,'default'=>'0'),
- 'type_ref'=>array('type'=>'varchar',
'precision'=>255,'nullable'=>True),
- ),
- 'pk'=>array(),
- 'fk'=>array(),
- 'ix'=>array(),
- 'uc'=>array()
+ 'ged_mimes' => array(
+ 'fd' => array(
+ 'file_extension' => array('type' => 'char',
'precision' => 10,'nullable' => False),
+ 'mime_type' => array('type' => 'char',
'precision' => 50,'nullable' => False)
+ ),
+ 'pk' => array('file_extension'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'ged_versions' => array(
+ 'fd' => array(
+ 'url' => array('type' => 'varchar', 'precision'
=> 100,'nullable' => False),
+ 'size' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'status' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
+ 'creator_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'validation_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'creation_date' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'minor' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
+ 'version_id' => array('type' =>
'auto','nullable' => False),
+ 'element_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'description' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
+ 'file_extension' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
+ 'file_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False,'default' => '0'),
+ 'major' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
+ 'stored_name' => array('type' => 'varchar',
'precision' => 255,'nullable' => False)
+ ),
+ 'pk' => array('version_id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'ged_acl' => array(
+ 'fd' => array(
+ 'acl_id' => array('type' => 'auto','nullable'
=> False),
+ 'element_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'account_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'date_begin' => array('type' => 'int',
'precision' => 4,'nullable' => True,'default' => '0'),
+ 'date_expire' => array('type' => 'int',
'precision' => 4,'nullable' => True,'default' => '0'),
+ 'inherited' => array('type' => 'int',
'precision' => 2,'nullable' => True,'default' => '0'),
+ 'aclread' => array('type' => 'int', 'precision'
=> 2,'nullable' => True),
+ 'aclwrite' => array('type' => 'int',
'precision' => 2,'nullable' => True),
+ 'aclchangeacl' => array('type' => 'int',
'precision' => 2,'nullable' => True,'default' => '0')
+ ),
+ 'pk' => array('acl_id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'ged_doc_types' => array(
+ 'fd' => array(
+ 'type_id' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
+ 'type_desc' => array('type' => 'varchar',
'precision' => 255,'nullable' => True),
+ 'type_chrono' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'type_ref' => array('type' => 'varchar',
'precision' => 255,'nullable' => True)
+ ),
+ 'pk' => array(),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
),
'ged_types_places' => array(
'fd' => array(
+ 'type_id' => array('type' => 'varchar',
'precision' => 255,'nullable' => False),
+ 'project_root' => array('type' => 'int',
'precision' => 4,'nullable' => False),
+ 'element_id' => array('type' => 'int',
'precision' => 4,'nullable' => False)
),
'pk' => array(),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
- 'ged_periods'=>array(
- 'fd'=>array(
- 'period'=>array('type'=>'int',
'precision'=>4,'nullable'=>False,'default'=>'0'),
- 'description'=>array('type'=>'varchar',
'precision'=>100,'nullable'=>False)
- ),
- 'pk'=>array('period'),
- 'fk'=>array(),
- 'ix'=>array(),
- 'uc'=>array()
- )
+ 'ged_periods' => array(
+ 'fd' => array(
+ 'period' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
+ 'description' => array('type' => 'varchar',
'precision' => 100,'nullable' => False)
+ ),
+ 'pk' => array('period'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
);
?>
- [Phpgroupware-cvs] ged/setup tables_current.inc.php,
Pascal Vilarem <=