Commit | Line | Data |
---|---|---|
37d44b3b FB |
1 | alter table entreprises add column cityid int(11) default null after city; |
2 | alter table entreprises add column regiontxt varchar(80) not null after region; | |
f93fb300 | 3 | alter table entreprises add column flags set('geoloc') not null; |
37d44b3b FB |
4 | alter table entreprises add key cityid (cityid); |
5 | alter table entreprises add key country (country); | |
6 | alter table entreprises add key region (region); | |
7 | ||
8 | # vim:set syntax=mysql: |