Revision: 9726
http://xoops.svn.sourceforge.net/xoops/?rev=9726&view=rev
Author: txmodxoops
Date: 2012-06-26 14:18:44 +0000 (Tue, 26 Jun 2012)
Log Message:
-----------
fixed bug float
Modified Paths:
--------------
XoopsModules/addresses/branches/timgno/addresses/sql/mysql.sql
Modified: XoopsModules/addresses/branches/timgno/addresses/sql/mysql.sql
===================================================================
--- XoopsModules/addresses/branches/timgno/addresses/sql/mysql.sql 2012-06-26 14:11:03 UTC (rev 9725)
+++ XoopsModules/addresses/branches/timgno/addresses/sql/mysql.sql 2012-06-26 14:18:44 UTC (rev 9726)
@@ -1,13 +1,13 @@
-
+
#
# Table structure for table `addresses_broken` 4
#
CREATE TABLE `addresses_broken` (
-`broken_id` int (8) unsigned NOT NULL auto_increment,
+`broken_id` int (8) unsigned NOT NULL auto_increment,
`broken_aid` int (11) unsigned NOT NULL default '0',
`broken_sender` int (11) unsigned NOT NULL default '0',
-`broken_ip` varchar (20) NOT NULL default ' ',
+`broken_ip` varchar (20) NOT NULL default ' ',
PRIMARY KEY (`broken_id`),
KEY `broken_aid` (`broken_aid`),
KEY `broken_sender` (`broken_sender`),
@@ -18,11 +18,11 @@
#
CREATE TABLE `addresses_cat` (
-`cat_id` int (8) unsigned NOT NULL auto_increment,
+`cat_id` int (8) unsigned NOT NULL auto_increment,
`cat_pid` int (5) unsigned NOT NULL default '0',
-`cat_title` varchar (50) NOT NULL default ' ',
-`cat_description` text NOT NULL ,
-`cat_imgurl` varchar (150) NOT NULL default ' ',
+`cat_title` varchar (50) NOT NULL default ' ',
+`cat_description` text NOT NULL ,
+`cat_imgurl` varchar (150) NOT NULL default ' ',
`cat_show_map` tinyint (1) unsigned NOT NULL default '0',
PRIMARY KEY (`cat_id`),
KEY `cat_pid` (`cat_pid`)
@@ -32,29 +32,29 @@
#
CREATE TABLE `addresses_addr` (
-`addr_id` int (8) unsigned NOT NULL auto_increment,
+`addr_id` int (8) unsigned NOT NULL auto_increment,
`addr_cid` int (5) unsigned NOT NULL default '0',
-`addr_title` varchar (100) NOT NULL default ' ',
-`addr_description` text NOT NULL ,
-`addr_url` varchar (250) NOT NULL default ' ',
-`addr_address` varchar (100) NOT NULL default ' ',
-`addr_zip` varchar (20) NOT NULL default ' ',
-`addr_city` varchar (100) NOT NULL default ' ',
-`addr_country` varchar (100) NOT NULL default ' ',
-`addr_long` float ( ) NOT NULL default '0.0000',
-`addr_lat` float ( ) NOT NULL default '0.0000',
+`addr_title` varchar (100) NOT NULL default ' ',
+`addr_description` text NOT NULL ,
+`addr_url` varchar (250) NOT NULL default ' ',
+`addr_address` varchar (100) NOT NULL default ' ',
+`addr_zip` varchar (20) NOT NULL default ' ',
+`addr_city` varchar (100) NOT NULL default ' ',
+`addr_country` varchar (100) NOT NULL default ' ',
+`addr_long` float NOT NULL default '0.0000',
+`addr_lat` float NOT NULL default '0.0000',
`addr_zoom` tinyint (2) unsigned NOT NULL default '0',
-`addr_phone` varchar (40) NOT NULL default ' ',
-`addr_mobile` varchar (40) NOT NULL default ' ',
-`addr_fax` varchar (40) NOT NULL default ' ',
-`addr_contemail` varchar (100) NOT NULL default ' ',
-`addr_opentime` text NOT NULL ,
-`addr_logourl` varchar (150) NOT NULL default ' ',
+`addr_phone` varchar (40) NOT NULL default ' ',
+`addr_mobile` varchar (40) NOT NULL default ' ',
+`addr_fax` varchar (40) NOT NULL default ' ',
+`addr_contemail` varchar (100) NOT NULL default ' ',
+`addr_opentime` text NOT NULL ,
+`addr_logourl` varchar (150) NOT NULL default ' ',
`addr_submitter` int (11) unsigned NOT NULL default '0',
`addr_status` tinyint (2) unsigned NOT NULL default '0',
`addr_date` int (10) unsigned NOT NULL default '0',
`addr_hits` int (11) unsigned NOT NULL default '0',
-`addr_rating` double (6,4) NOT NULL default '0.0000',
+`addr_rating` double (6,4) NOT NULL default '0.0000',
`addr_votes` int (11) unsigned NOT NULL default '0',
`addr_comments` int (11) unsigned NOT NULL default '0',
PRIMARY KEY (`addr_id`),
@@ -66,11 +66,11 @@
#
CREATE TABLE `addresses_votedata` (
-`votedata_rid` int (8) unsigned NOT NULL auto_increment,
+`votedata_rid` int (8) unsigned NOT NULL auto_increment,
`votedata_aid` int (5) unsigned NOT NULL default '0',
`votedata_ruser` int (11) unsigned NOT NULL default '0',
`votedata_rating` tinyint (3) unsigned NOT NULL default '0',
-`votedata_rhostname` varchar (60) NOT NULL default ' ',
+`votedata_rhostname` varchar (60) NOT NULL default ' ',
`votedata_rtimestamp` int (10) unsigned NOT NULL default '0',
PRIMARY KEY (`votedata_rid`),
KEY `votedata_ruser` (`votedata_ruser`),
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
