svn commit - mysqldoc@docsrva: r1659 - in trunk: refman-common sample-data/sakila

[mhillyer]

Author: mhillyer
Date: 2006-03-24 18:10:08 +0100 (Fri, 24 Mar 2006)
New Revision: 1659

Log:
Update connector/net changelog and add usage examples to the sakila doc.

Modified:
   trunk/refman-common/news-connector-net.xml
   trunk/sample-data/sakila/sakila.xml

Modified: trunk/refman-common/news-connector-net.xml
===================================================================
--- trunk/refman-common/news-connector-net.xml	2006-03-24 14:57:02 UTC (rev 1658)
+++ trunk/refman-common/news-connector-net.xml	2006-03-24 17:10:08 UTC (rev 1659)
@@ -54,6 +54,19 @@
 
       <listitem>
         <para>
+          The CommandBuilder ignored Unsigned flag at Parameter
+          creation. (Bug #17375)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          CHAR type added to MySqlDbType. (Bug #17749)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           Unsigned data types were not properly supported. (Bug #16788)
         </para>
       </listitem>

Modified: trunk/sample-data/sakila/sakila.xml
===================================================================
--- trunk/sample-data/sakila/sakila.xml	2006-03-24 14:57:02 UTC (rev 1658)
+++ trunk/sample-data/sakila/sakila.xml	2006-03-24 17:10:08 UTC (rev 1659)
@@ -1869,7 +1869,7 @@
 
       </section>
 
-      <section id="sakila-structure-triggers-customer_create_date">
+      <section id="sakila-structure-triggers-payment_date">
 
         <title>The payment_date Trigger</title>
 
@@ -1934,6 +1934,50 @@
 
     <title>Usage Examples</title>
 
+    <para>
+      These are a few usage examples of how to perform common operations
+      using the &sampdb; sample database.
+    </para>
+
+    <para>
+      The actual implementation of these steps is left to the reader.
+    </para>
+
+    <bridgehead>Rent a DVD</bridgehead>
+
+    <para>
+      To rent a DVD, first confirm that the given inventory item is in
+      stock, then insert a row into the rental table. After the rental
+      is created, insert a row into the payment table. Depending on
+      business rules, you may also need to check if the customer has an
+      outstanding balance before processing the rental.
+    </para>
+
+    <bridgehead>Return a DVD</bridgehead>
+
+    <para>
+      To return a DVD, we update the rental table and set the return
+      date. Depending on the situation we may then need to check the
+      customer balance and perhaps process a payment for overdue fees by
+      inserting a row into the payment table.
+    </para>
+
+    <bridgehead>Find Overdue DVDs</bridgehead>
+
+    <para>
+      Many DVD stores produce a daily list of overdue rentals so that
+      customers can be contacted and asked to return their overdue DVDs.
+    </para>
+
+    <para>
+      To create such a list, we search the rental table for films with a
+      return date that is NULL. In addition, we check whether the rental
+      date is further in the past than the rental duration specified in
+      the film table. If so, the film is overdue and we should return
+      the name of the film along with the customer name and phone
+      number.
+    </para>
+
   </section>
 
   <section id="sakila-acknowledgements">