[SQL-CVS] SQLObject/docs SQLObject.txt,1.9,1.10

[<ian...@us...>]

Update of /cvsroot/sqlobject/SQLObject/docs
In directory sc8-pr-cvs1:/tmp/cvs-serv32081

Modified Files:
	SQLObject.txt 
Log Message:
Note SERIAL PRIMARY KEY for pg


Index: SQLObject.txt
===================================================================
RCS file: /cvsroot/sqlobject/SQLObject/docs/SQLObject.txt,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** SQLObject.txt	9 Apr 2003 04:34:45 -0000	1.9
--- SQLObject.txt	17 Apr 2003 03:39:08 -0000	1.10
***************
*** 130,134 ****
  
      CREATE TABLE person (
!         id SERIAL,
          first_name VARCHAR(100) NOT NULL,
  	middle_initial CHAR(1),
--- 130,134 ----
  
      CREATE TABLE person (
!         id SERIAL PRIMARY KEY,
          first_name VARCHAR(100) NOT NULL,
  	middle_initial CHAR(1),
***************
*** 195,200 ****
  You'll note that the ``id`` column is not given in the class
  definition, it is implied.  For MySQL databases it should be defined
! as ``INT PRIMARY KEY AUTO_INCREMENT``, in Postgres ``SERIAL``, and in
! SQLite as ``INTEGER PRIMARY KEY``.
  
  Using the Class
--- 195,200 ----
  You'll note that the ``id`` column is not given in the class
  definition, it is implied.  For MySQL databases it should be defined
! as ``INT PRIMARY KEY AUTO_INCREMENT``, in Postgres ``SERIAL PRIMARY KEY``, 
! and in SQLite as ``INTEGER PRIMARY KEY``.
  
  Using the Class
***************
*** 382,387 ****
      The name of the primary key column (default ``id``).
  
! Relations Between Classes/Tables
! --------------------------------
  
  You can use the `foreignKey` argument to `Col` to handle simple
--- 382,387 ----
      The name of the primary key column (default ``id``).
  
! Relationships Between Classes/Tables
! ------------------------------------
  
  You can use the `foreignKey` argument to `Col` to handle simple
***************
*** 389,397 ****
  many-to-many references you'll use joins.
  
! Relations: One-to-Many
! ~~~~~~~~~~~~~~~~~~~~~~
  
! Now we'll deal with having a relation to another table, a phone number
! table that refers to a person::
  
      CREATE TABLE phone_number (
--- 389,397 ----
  many-to-many references you'll use joins.
  
! Relationships: One-to-Many
! ~~~~~~~~~~~~~~~~~~~~~~~~~~
  
! Now we'll deal with having a relationship to another table, a phone
! number table that refers to a person::
  
      CREATE TABLE phone_number (
***************
*** 437,442 ****
  .. _Many-to-Many:
  
! Relations: Many-to-Many
! ~~~~~~~~~~~~~~~~~~~~~~~
  
  We'll add roles to the system, where a person can have more than one
--- 437,442 ----
  .. _Many-to-Many:
  
! Relationships: Many-to-Many
! ~~~~~~~~~~~~~~~~~~~~~~~~~~~
  
  We'll add roles to the system, where a person can have more than one
***************
*** 836,840 ****
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  
! To create a database call `createTable`.  It takes two arguments:
  
  `ifNotExists`: 
--- 836,840 ----
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  
! To create a table call `createTable`.  It takes two arguments:
  
  `ifNotExists`: 
***************
*** 842,846 ****
      False.
  `createJoinTables`: 
!     If you used Many-to-Many_ relations, then the intermediate tables
      will be created (but only for one of the two involved classes).
      Default True.
--- 842,846 ----
      False.
  `createJoinTables`: 
!     If you used Many-to-Many_ relationships, then the intermediate tables
      will be created (but only for one of the two involved classes).
      Default True.