summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlezvous.ca>2008-06-22 12:40:13 -0400
committerEvan Prodromou <evan@controlezvous.ca>2008-06-22 12:40:13 -0400
commit200124eca37a7e4ca108441f8806ccf9bfff58bd (patch)
tree8a1a078df96aa22de3f38db93476203723d3e172 /db
parent8a28d54f6acf93584076dbdc6e5db3f9bf033681 (diff)
auto-increment primary key for SMS carrier
darcs-hash:20080622164013-34904-4119be65edb5fc09dcbe11edf17c3401f1d19a33.gz
Diffstat (limited to 'db')
-rw-r--r--db/laconica.sql2
1 files changed, 1 insertions, 1 deletions
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',