Differences

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

dev:sqlpolicies [2009/07/06 20:36]
127.0.0.1 external edit
dev:sqlpolicies [2010/04/18 15:12] (current)
david_pate Minor layout changes
Line 59: Line 59:
-==== Indexes ==== +=====Indexes===== 
-  * Primary Key +====Primary Key==== 
-    * Define inside the create table statement. +  * Define inside the create table statement. 
-    * Write in a new line rather than with the field definition.+  * Write in a new line rather than with the field definition.
<code sql> <code sql>
CREATE TABLE person_uuid (       -- the list of universally unique IDs for all people in the system CREATE TABLE person_uuid (       -- the list of universally unique IDs for all people in the system
Line 74: Line 74:
</code> </code>
-  * Foreign Keys +====Foreign Keys==== 
-    * Define inside the create table statement. +  * Define inside the create table statement. 
-    * Write in a new line rather than with the field definition.+  * Write in a new line rather than with the field definition.
<code sql> <code sql>
CREATE TABLE sys_config( CREATE TABLE sys_config(

Navigation
  • Navigate