projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
05578fc
)
sql/core_geoip_location.sql
author
Edward
<edward@roojs.com>
Tue, 13 May 2014 07:37:48 +0000
(15:37 +0800)
committer
Edward
<edward@roojs.com>
Tue, 13 May 2014 07:37:48 +0000
(15:37 +0800)
sql/core_geoip_location.sql
patch
|
blob
|
history
diff --git
a/sql/core_geoip_location.sql
b/sql/core_geoip_location.sql
index
09c3898
..
17c52aa
100644
(file)
--- a/
sql/core_geoip_location.sql
+++ b/
sql/core_geoip_location.sql
@@
-1,9
+1,8
@@
CREATE TABLE core_geoip_location (
id INT(11) NOT NULL AUTO_INCREMENT ,
- start_ip TEXT NOT NULL DEFAULT ''
- mask_length INT(11) NOT NULL DEFAULT 0,
- postal_code INT(11) NOT NULL DEFAULT 0,
-
+ city_id INT(11) NOT NULL DEFAULT 0
+ latitude INT(11) NOT NULL DEFAULT 0,
+ longitude INT(11) NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);