Differences

This shows you the differences between two versions of the page.

--- v5:dictionary:structure:sample_usage [2016/04/09 21:43] – mnewnham
+++ v5:dictionary:structure:sample_usage [2016/04/09 21:46] (current) – mnewnham
@@ Line 10: / Line 10: @@
 $t->addAttribute('ENGINE INNODB','mysql');
 $t->addColumnObject('COL1','I');
-$t->addColumnObject('COL1','I')->addAttribute('NOTNULL');
+$t->addColumnObject('COL1','I')
+                   ->addAttribute('NOTNULL');
 $c = $t->addColumnObject('COL2','C(64)');
@@ Line 18: / Line 19: @@
 $ii = $i->addIndexItemObject('COL1');
-$t->addColumnObject('COL1','C(32)')->addAttribute('NOTNULL')
+$t->addColumnObject('COL1','C(32)')
-                                   ->addAttribute(array('DEFAULT'=>'abc'));
+                ->addAttribute('NOTNULL')
+                ->addAttribute(array('DEFAULT'=>'abc'));
-$t->addColumnObject('COL2','I')->addAttribute('NOTNULL')
+$t->addColumnObject('COL2','I')
-                               ->addAttribute('PRIMARY')
+               ->addAttribute('NOTNULL')
-                               ->addAttribute('AUTO');
+               ->addAttribute('PRIMARY')
+               ->addAttribute('AUTO');
 $t->addColumnObject('COL3','N(12.2)');
 $t->addColumnObject('COL4','C(64)')
@@ Line 30: / Line 33: @@
 $t->addColumnObject('COL5',"ENUM('cats','dogs','fish')");
-$t->addColumnObject('COL6','T')->addAttribute('DEFTIMESTAMP');
+$t->addColumnObject('COL6','T')
+              ->addAttribute('DEFTIMESTAMP');
-$t->addColumnObject('COL7','D')->addAttribute('DEFDATE');
+$t->addColumnObject('COL7','D')
+              ->addAttribute('DEFDATE');
-$t->addIndexObject('COL4-INDEX')->addIndexItem('COL4')->addAttribute('ASC');
+$t->addIndexObject('COL4-INDEX')
-$t->addIndexObject('COL4-INDEX')->addIndexItem('COL5');
+              ->addIndexItem('COL4')
+              ->addAttribute('ASC');
+$t->addIndexObject('COL4-INDEX')
+              ->addIndexItem('COL5');
 $sql = $dict->createTableSql($tabledef);