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; |
de0485fd FB |
4 | alter table entreprises add column glat float(9,6) not null default 0; |
5 | alter table entreprises add column glng float(9,6) not null default 0; | |
37d44b3b FB |
6 | alter table entreprises add key cityid (cityid); |
7 | alter table entreprises add key country (country); | |
8 | alter table entreprises add key region (region); | |
9 | ||
10 | # vim:set syntax=mysql: |