[Pypi-checkins] r780 - trunk/pypi

[georg.brandl]

Author: georg.brandl
Date: Fri Jul 23 17:59:56 2010
New Revision: 780

Modified:
   trunk/pypi/pkgbase_schema.sql
Log:
Remove unused sequences; use SERIAL PRIMARY KEY consistently to make life easier for SQLite.

Modified: trunk/pypi/pkgbase_schema.sql
==============================================================================
--- trunk/pypi/pkgbase_schema.sql	(original)
+++ trunk/pypi/pkgbase_schema.sql	Fri Jul 23 17:59:56 2010
@@ -90,10 +90,9 @@
 );
 
 CREATE TABLE cheesecake_main_indices (
-    id SERIAL,
+    id SERIAL PRIMARY KEY,
     absolute INTEGER NOT NULL,
-    relative INTEGER NOT NULL,
-    PRIMARY KEY (id)
+    relative INTEGER NOT NULL
 );
 
 CREATE TABLE cheesecake_subindices (
@@ -146,15 +145,6 @@
 CREATE INDEX trove_class_id_idx ON trove_classifiers(id);
 
 
--- trove ids sequence
--- nosqlite
-CREATE TABLE dual (dummy INTEGER);
-INSERT INTO dual VALUES (1);
-CREATE SEQUENCE trove_ids;
-SELECT setval('trove_ids', 1000) FROM dual;
--- nosqlite-end
-
-
 -- Table structure for table: release_classifiers
 CREATE TABLE release_classifiers (
    name TEXT,
@@ -335,13 +325,12 @@
 
 -- ratings
 CREATE TABLE ratings(
-   id SERIAL UNIQUE,
+   id SERIAL PRIMARY KEY,
    name TEXT,
    version TEXT,
    user_name TEXT REFERENCES users ON DELETE CASCADE,
    date TIMESTAMP,
    rating INTEGER,
-   PRIMARY KEY (name, version, user_name),
    FOREIGN KEY (name, version) REFERENCES releases ON UPDATE CASCADE ON DELETE CASCADE
 );
 CREATE INDEX rating_name_version ON ratings(name, version);