[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [6463] Booking: allow null
From: |
Sigurd Nes |
Subject: |
[Fmsystem-commits] [6463] Booking: allow null |
Date: |
Sun, 10 Oct 2010 16:45:29 +0000 |
Revision: 6463
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=6463
Author: sigurdne
Date: 2010-10-10 16:45:28 +0000 (Sun, 10 Oct 2010)
Log Message:
-----------
Booking: allow null
Modified Paths:
--------------
trunk/booking/setup/tables_current.inc.php
Modified: trunk/booking/setup/tables_current.inc.php
===================================================================
--- trunk/booking/setup/tables_current.inc.php 2010-10-10 16:30:49 UTC (rev
6462)
+++ trunk/booking/setup/tables_current.inc.php 2010-10-10 16:45:28 UTC (rev
6463)
@@ -22,13 +22,13 @@
'name' => array('type' => 'varchar','precision'
=> '50','nullable' => False),
'homepage' => array('type' => 'text',
'nullable' => False),
'location_code' => array('type' =>
'varchar','precision' => '50','nullable' => True),
- 'phone' => array('type' =>
'varchar','precision' => '50','nullable' => False, 'default'=>''),
- 'email' => array('type' =>
'varchar','precision' => '50','nullable' => False, 'default'=>''),
- 'street' => array('type' =>
'varchar','precision' => '255', 'nullable' => False, 'default'=>''),
- 'zip_code' => array('type' =>
'varchar','precision' => '255', 'nullable' => False, 'default'=>''),
- 'district' => array('type' =>
'varchar','precision' => '255', 'nullable' => False, 'default'=>''),
- 'city' => array('type' => 'varchar','precision'
=> '255', 'nullable' => False, 'default'=>''),
- 'description' => array('type' => 'text',
'nullable' => False, 'default'=>''),
+ 'phone' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'email' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'street' => array('type' =>
'varchar','precision' => '255', 'nullable' => True),
+ 'zip_code' => array('type' =>
'varchar','precision' => '255', 'nullable' => True),
+ 'district' => array('type' =>
'varchar','precision' => '255', 'nullable' => True),
+ 'city' => array('type' => 'varchar','precision'
=> '255', 'nullable' => True),
+ 'description' => array('type' => 'text',
'nullable' => True),
),
'pk' => array('id'),
'fk' => array(),
@@ -54,9 +54,9 @@
'ssn' => array('type' => 'varchar', 'precision'
=> '12', 'nullable' => True,),
'name' => array('type' => 'varchar','precision'
=> '50','nullable' => False),
'homepage' => array('type' => 'text',
'nullable' => True),
- 'phone' => array('type' =>
'varchar','precision' => '50','nullable' => False, 'default'=>''),
- 'email' => array('type' =>
'varchar','precision' => '50','nullable' => False, 'default'=>''),
- 'description' => array('type' =>
'varchar','precision' => '1000','nullable' => False, 'default'=>''),
+ 'phone' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'email' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'description' => array('type' =>
'varchar','precision' => '1000','nullable' => True),
),
'pk' => array('id'),
'fk' => array(),
@@ -70,13 +70,13 @@
'active' => array('type' => 'int', 'nullable'
=> False,'precision' => '4', 'default' => 1),
'name' => array('type' => 'varchar','precision'
=> '50','nullable' => False),
'homepage' => array('type' => 'text',
'nullable' => True),
- 'phone' => array('type' =>
'varchar','precision' => '50','nullable' => False, 'default'=>''),
- 'email' => array('type' =>
'varchar','precision' => '50','nullable' => False, 'default'=>''),
- 'street' => array('type' =>
'varchar','precision' => '255', 'nullable' => False, 'default'=>''),
- 'zip_code' => array('type' =>
'varchar','precision' => '255', 'nullable' => False, 'default'=>''),
- 'district' => array('type' =>
'varchar','precision' => '255', 'nullable' => False, 'default'=>''),
- 'city' => array('type' => 'varchar','precision'
=> '255', 'nullable' => False, 'default'=>''),
- 'description' => array('type' => 'text',
'nullable' => False, 'default'=>''),
+ 'phone' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'email' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'street' => array('type' =>
'varchar','precision' => '255', 'nullable' => True),
+ 'zip_code' => array('type' =>
'varchar','precision' => '255', 'nullable' => True),
+ 'district' => array('type' =>
'varchar','precision' => '255', 'nullable' => True),
+ 'city' => array('type' => 'varchar','precision'
=> '255', 'nullable' => True),
+ 'description' => array('type' => 'text',
'nullable' => True),
'activity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'customer_identifier_type' => array('type' =>
'varchar', 'precision' => '255', 'nullable' => True),
'customer_number' => array('type' => 'text',
'nullable' => True),
@@ -98,7 +98,7 @@
'building_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '50','nullable' => False),
'type' => array('type' => 'varchar',
'precision' => '50', 'nullable' => False),
- 'description' => array('type' => 'text',
'nullable' => False, 'default'=>''),
+ 'description' => array('type' => 'text',
'nullable' => True),
'activity_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'sort' => array('type' => 'int','precision' =>
'4','nullable' => False,'default' => 0),
),
@@ -114,7 +114,7 @@
'id' => array('type' => 'auto', 'nullable' =>
false),
'active' => array('type' => 'int', 'nullable'
=> False,'precision' => '4', 'default' => 1),
'organization_id' => array('type' =>
'int','precision' => '4','nullable' => False),
- 'description' => array('type' => 'text',
'nullable' => False, 'default'=>''),
+ 'description' => array('type' => 'text',
'nullable' => True),
'name' => array('type' => 'varchar','precision'
=> '50','nullable' => False),
'activity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'shortname' => array('type' =>
'varchar','precision' => '11', 'nullable' => True),
@@ -475,10 +475,10 @@
'bb_organization_contact' => array(
'fd' => array(
'id' => array('type' => 'auto', 'nullable' =>
false),
- 'name' => array('type' => 'varchar',
'precision' => '50', 'nullable' => false, 'default'=>''),
- 'ssn' => array('type' => 'varchar',
'precision' => '12', 'nullable' => false, 'default'=>''),
- 'phone' => array('type' => 'varchar',
'precision' => '50', 'nullable' => false, 'default'=>''),
- 'email' => array('type' => 'varchar',
'precision' => '50', 'nullable' => false, 'default'=>''),
+ 'name' => array('type' => 'varchar',
'precision' => '50', 'nullable' => True),
+ 'ssn' => array('type' => 'varchar',
'precision' => '12', 'nullable' => True),
+ 'phone' => array('type' => 'varchar',
'precision' => '50', 'nullable' => True),
+ 'email' => array('type' => 'varchar',
'precision' => '50', 'nullable' => True),
'organization_id' => array('type' => 'int',
'precision' => '4', 'nullable' => false),
),
'pk' => array('id'),
@@ -491,9 +491,9 @@
'bb_group_contact' => array(
'fd' => array(
'id' => array('type' => 'auto', 'nullable' =>
false),
- 'name' => array('type' => 'varchar',
'precision' => '50', 'nullable' => false, 'default'=>''),
- 'phone' => array('type' => 'varchar',
'precision' => '50', 'nullable' => false, 'default'=>''),
- 'email' => array('type' => 'varchar',
'precision' => '50', 'nullable' => false, 'default'=>''),
+ 'name' => array('type' => 'varchar',
'precision' => '50', 'nullable' => True),
+ 'phone' => array('type' => 'varchar',
'precision' => '50', 'nullable' => True),
+ 'email' => array('type' => 'varchar',
'precision' => '50', 'nullable' => True),
'group_id' => array('type' => 'int',
'precision' => '4', 'nullable' => false),
),
'pk' => array('id'),
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [6463] Booking: allow null,
Sigurd Nes <=