Sakila

Sakila Sample Database
Table of Contents
1. Preface and Legal Notice .................................................................................................................1 2. Introduction .................................................................................................................................2 3. History.......................................................................................................................................2 4. Installation ..................................................................................................................................3 5. Structure .....................................................................................................................................4 5.1. Tables..............................................................................................................................4 5.2. Views ............................................................................................................................ 10 5.3. Stored Procedures .............................................................................................................. 10 5.4.Stored Functions ............................................................................................................... 12 5.5. Triggers ......................................................................................................................... 14 6. Usage Examples.......................................................................................................................... 14 7. Acknowledgments ....................................................................................................................... 15 8. License for the Sakila Sample Database .............................................................................................. 15 9. Note for Authors......................................................................................................................... 16 10. Sakila Change History ................................................................................................................. 16 10.1. Version 0.8 .................................................................................................................... 16 10.2. Version 0.7.................................................................................................................... 16 10.3. Version 0.6 .................................................................................................................... 16 10.4. Version 0.5 .................................................................................................................... 16 10.5. Version 0.4.................................................................................................................... 17 10.6. Version 0.3 .................................................................................................................... 17 10.7. Version 0.2 .................................................................................................................... 17 This document describes the Sakila sampledatabase—its history, installation, structure and usage. Document generated on: 2012-05-17 (revision: 30323) For legal information, see the Legal Notice.

1. Preface and Legal Notice
This document describes the Sakila sample database—its history, installation, structure and usage.

Legal Notices
Copyright © 2007, 2011, Oracle and/or its affiliates. All rights reserved. This software and relateddocumentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means....