~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/create_table.rst

  • Committer: Lee Bieber
  • Date: 2011-01-08 01:57:02 UTC
  • mfrom: (1994.4.21 drizzle)
  • mto: This revision was merged to the branch mainline in revision 2063.
  • Revision ID: kalebral@gmail.com-20110108015702-d9mc4jwppb9vej94
Merge Marisa - latest doc updates, fix sphinx warnings

Show diffs side-by-side

added added

removed removed

Lines of Context:
21
21
    [engine_options]
22
22
 
23
23
create_definition:
 
24
 
24
25
    column_name column_definition
25
26
  | [CONSTRAINT [symbol] ] PRIMARY KEY [index_type]
26
27
    (index_column_name, ...)
33
34
  | CHECK (expr)
34
35
 
35
36
column_definition:
 
37
 
36
38
  data_type [NOT NULL | NULL] [DEFAULT default_value]
37
39
    [AUTO_INCREMENT] [UNIQUE [KEY] | [PRIMARY] KEY]
38
40
    [COMMENT 'string']
39
41
    [reference_definition]
40
42
 
41
43
data_type:
 
44
 
42
45
  | INTEGER
43
46
  | BIGINT
44
47
  | DOUBLE[(length, decimals)]