Closed (won't fix)
Project:
Panels
Version:
6.x-2.x-dev
Component:
Panel pages
Priority:
Normal
Category:
Task
Assigned:
Unassigned
Reporter:
Created:
4 Dec 2008 at 04:09 UTC
Updated:
17 Sep 2009 at 16:30 UTC
Schema module warning
panels_node.did is part of the primary key but is not specified to be 'not null'.
Primary key cant be null and why it is not serial?
panels_node.install
$schema['panels_node'] = array(
'fields' => array(
'nid' => array(
'type' => 'int',
'not null' => TRUE,
'default' => 0,
),
'css_id' => array(
'type' => 'varchar',
'length' => '255',
),
'did' => array(
'type' => 'int',
+ 'not null' => TRUE,
),
),
'primary key' => array('did'),
);
Comments
Comment #1
andypostIt's not a duplicate just for pages
panels_page
declared: array('type' => 'int', 'default' => )
actual: array('type' => 'int', 'not null' => FALSE, 'disp-width' => '11')
Comment #2
merlinofchaos commentedIf it can't be null why is it bad to specify it as NOT NULL? Is there something wrong with explicitness?
It's not serial because it refers to another table, it's just set up as the primary key because it's already guaranteed to be unique and that provides a nice easy index.
Comment #3
andypostJust testing this module by Schema module which find some differences between DB structure and schema definitions
Comment #4
merlinofchaos commentedPanels 2 is no longer available and is unsupported. Marking all Panels 2 issues won't fix.