------------------------------------------------------------ revno: 886 committer: Roger Martin <[email protected]> branch nick: aikiframework timestamp: Thu 2011-07-14 23:06:10 +0200 message: create unique index for aiki_redirects.url modified: src/sql/CreateTables.sql
-- lp:aikiframework https://code.launchpad.net/~aikiframework-devel/aikiframework/trunk Your team Aiki Framework Developers is subscribed to branch lp:aikiframework. To unsubscribe from this branch go to https://code.launchpad.net/~aikiframework-devel/aikiframework/trunk/+edit-subscription
=== modified file 'src/sql/CreateTables.sql' --- src/sql/CreateTables.sql 2011-06-27 20:23:02 +0000 +++ src/sql/CreateTables.sql 2011-07-14 21:06:10 +0000 @@ -120,7 +120,8 @@ url varchar(255) NOT NULL, redirect varchar(255) NOT NULL, hits int(11) NOT NULL, - PRIMARY KEY (id) + PRIMARY KEY (id), + UNIQUE KEY url (url) ) ENGINE=MyISAM CHARSET=utf8; -- ------------------------------------------------------
_______________________________________________ Mailing list: https://launchpad.net/~aikiframework-devel Post to : [email protected] Unsubscribe : https://launchpad.net/~aikiframework-devel More help : https://help.launchpad.net/ListHelp
