commit from the sky

1 files changed, 101 insertions, 0 deletions

diff --git a/sample_database/pagila-0.10.1/README b/sample_database/pagila-0.10.1/README
new file mode 100644
index 0000000..515331b
--- /dev/null
+++ b/sample_database/pagila-0.10.1/README
@@ -0,0 +1,101 @@
+Pagila
+======
+
+Pagila is a port of the Sakila example database available for MySQL, which was  
+originally developed by Mike Hillyer of the MySQL AB documentation team. It  
+is intended to provide a standard schema that can be used for examples in 
+books, tutorials, articles, samples, etc.
+
+All the tables, data, views, and functions have been ported; some of the changes made were:
+
+* Changed char(1) true/false fields to true boolean fields
+* The last_update columns were set with triggers to update them
+* Added foreign keys
+* Removed 'DEFAULT 0' on foreign keys since it's pointless with real FK's
+* Used PostgreSQL built-in fulltext searching for fulltext index.  Removed the need for the
+  film_text table.
+* The rewards_report function was ported to a simple SRF
+
+The schema and data for the Sakila database were made available under the BSD license 
+which can be found at http://www.opensource.org/licenses/bsd-license.php. The pagila 
+database is made available under this license as well.  
+
+
+FULLTEXT SEARCH
+---------------
+
+In older versions of pagila, the fulltext search capabilities were split into a 
+seperate file, so they could be loaded into only databases that support fulltext.
+Starting in PostgreSQL 8.3, fulltext functionality is built in, so now these
+parts of the schema exist in the main schema file. 
+
+Example usage:
+
+SELECT * FROM film WHERE fulltext @@ to_tsquery('fate&india');
+
+
+PARTITIONED TABLES
+------------------
+
+The payment table is designed as a partitioned table with a 6 month timespan for the date ranges. 
+If you want to take full advantage of table partitioning, you need to make sure constraint_exclusion 
+is turned on in your database. You can do this by setting "constraint_exclusion = on" in your 
+postgresql.conf, or by issuing the command "ALTER DATABASE pagila SET constraint_exclusion = on" 
+(substitute pagila for your database name if installing into a database with a different name)
+
+
+INSTALL NOTE
+------------
+
+The pagila-data.sql file and the pagila-insert-data.sql both contain the same
+data, the former using COPY commands, the latter using INSERT commands, so you 
+only need to install one of them. Both formats are provided for those who have
+trouble using one version or another.
+
+
+ARTICLES
+--------------
+
+The following articles make use of pagila to showcase various PostgreSQL features:
+
+* Showcasing REST in PostgreSQL - The PreQuel
+http://www.postgresonline.com/journal/index.php?/archives/32-Showcasing-REST-in-PostgreSQL-The-PreQuel.html#extended
+
+* PostgreSQL 8.3 Features: Enum Datatype
+http://people.planetpostgresql.org/xzilla/index.php?/archives/320-PostgreSQL-8.3-Features-Enum-Datatype.html
+
+* Email Validation with pl/PHP
+http://people.planetpostgresql.org/xzilla/index.php?/archives/261-Re-inventing-Gregs-method-to-prevent-re-inventing.html
+
+* Getting Started with PostgreSQL for Windows
+http://www.charltonlopez.com/index.php?option=com_content&task=view&id=56&Itemid=38
+
+* RATIO_TO_REPORT in PostgreSQL
+http://people.planetpostgresql.org/xzilla/index.php?/search/pagila/P3.html
+
+* The postmaster and postgres Processes
+http://www.charltonlopez.com/index.php?option=com_content&task=view&id=57&Itemid=38
+
+* Building Rails to Legacy Applications :: Take Control of Active Record
+http://people.planetpostgresql.org/xzilla/index.php?/archives/220-Building-Rails-to-Legacy-Applications-Take-Control-of-Active-Record.html
+
+* Building Rails to Legacy Applications :: Masking the Database
+http://people.planetpostgresql.org/xzilla/index.php?/archives/213-Building-Rails-to-Legacy-Applications-Masking-the-Database.html
+
+
+VERSION HISTORY
+---------------
+
+Version 0.10.1
+* Add pagila-data-insert.sql file, added articles section
+
+Version 0.10
+* Support for built-in fulltext. Add enum example 
+
+Version 0.9
+* Add table partitioning example 
+
+Version 0.8 
+* First release of pagila
+
+