diff options
| author | Evan Prodromou <evan@controlezvous.ca> | 2008-06-22 12:40:13 -0400 |
|---|---|---|
| committer | Evan Prodromou <evan@controlezvous.ca> | 2008-06-22 12:40:13 -0400 |
| commit | 200124eca37a7e4ca108441f8806ccf9bfff58bd (patch) | |
| tree | 8a1a078df96aa22de3f38db93476203723d3e172 | |
| parent | 8a28d54f6acf93584076dbdc6e5db3f9bf033681 (diff) | |
auto-increment primary key for SMS carrier
darcs-hash:20080622164013-34904-4119be65edb5fc09dcbe11edf17c3401f1d19a33.gz
| -rw-r--r-- | classes/stoica.ini | 3 | ||||
| -rw-r--r-- | db/laconica.sql | 2 |
2 files changed, 2 insertions, 3 deletions
diff --git a/classes/stoica.ini b/classes/stoica.ini index 3245b39b7..96f3d06bc 100644 --- a/classes/stoica.ini +++ b/classes/stoica.ini @@ -95,8 +95,7 @@ created = 142 modified = 384 [sms_carrier__keys] -id = K -name = U +id = N [subscription] subscriber = 129 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', |