From 200124eca37a7e4ca108441f8806ccf9bfff58bd Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Sun, 22 Jun 2008 12:40:13 -0400 Subject: auto-increment primary key for SMS carrier darcs-hash:20080622164013-34904-4119be65edb5fc09dcbe11edf17c3401f1d19a33.gz --- db/laconica.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'db') diff --git a/db/laconica.sql b/db/laconica.sql index 1fd7dc025..cc475e4cf 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -30,7 +30,7 @@ create table avatar ( ) ENGINE=InnoDB; create table sms_carrier ( - id integer primary key comment 'primary key for SMS carrier', + id integer auto_increment primary key comment 'primary key for SMS carrier', name varchar(64) unique key comment 'name of the carrier', email_pattern varchar(255) not null comment 'sprintf pattern for making an email address from a phone number', created datetime not null comment 'date this record was created', -- cgit v1.2.3-54-g00ecf