[Pypi-checkins] r880 - in trunk/pypi: . tools

[martin.von.loewis]

Author: martin.von.loewis
Date: Fri Jan 28 09:56:42 2011
New Revision: 880

Added:
   trunk/pypi/tools/sql-migrate-20110129.sql   (contents, props changed)
Modified:
   trunk/pypi/pkgbase_schema.sql
Log:
Add uniqueness constraint for otks.


Modified: trunk/pypi/pkgbase_schema.sql
==============================================================================
--- trunk/pypi/pkgbase_schema.sql	(original)
+++ trunk/pypi/pkgbase_schema.sql	Fri Jan 28 09:56:42 2011
@@ -56,7 +56,7 @@
 -- Table structure for table: rego_otk
 CREATE TABLE rego_otk (
    name TEXT REFERENCES users,
-   otk TEXT,
+   otk TEXT UNIQUE,
    date TIMESTAMP );
 CREATE INDEX rego_otk_name_idx ON rego_otk(name);
 CREATE INDEX rego_otk_otk_idx ON rego_otk(otk);
@@ -277,4 +277,4 @@
   FOREIGN KEY (name, version) REFERENCES releases (name, version) ON DELETE CASCADE
 );
 
-commit;
\ No newline at end of file
+commit;

Added: trunk/pypi/tools/sql-migrate-20110129.sql
==============================================================================
--- (empty file)
+++ trunk/pypi/tools/sql-migrate-20110129.sql	Fri Jan 28 09:56:42 2011
@@ -0,0 +1 @@
+alter TABLE rego_otk add rego_otk_unique constraint unique(otk);