You are here: start » dev » sqlpolicies
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( |
Trace: