[Pypi-checkins] r880 - in trunk/pypi: . tools
martin.von.loewis
python-checkins at python.org
Fri Jan 28 09:56:42 CET 2011
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);
More information about the Pypi-checkins
mailing list