Changeset 20468 for events/phpframework/codeigniter/trunk/sql/phwittr.sql

Timestamp:

10/02/08 11:53:02 (3 months ago)

Author:

kunitsuji

Message:

imp: add index

Files:

• events/phpframework/codeigniter/trunk/sql/phwittr.sql (modified) (2 diffs)

events/phpframework/codeigniter/trunk/sql/phwittr.sql

@@ -109 +109 @@
   `comment` varchar(255) collate utf8_unicode_ci NOT NULL,
   `created_at` datetime NOT NULL,
-  PRIMARY KEY  (`id`)
+  PRIMARY KEY  (`id`),
+  KEY `user_id_created_at` (`user_id`,`created_at`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
@@ -154 +155 @@
 
 
-INSERT INTO `countries` VALUES 
+INSERT INTO `countries` VALUES
   (1, 'United States'),
   (2, 'Canada'),