Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `#__gruposlocales` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) NOT NULL,
- `latitude` float(10,6) NOT NULL DEFAULT '255.000000',
- `longitude` float(10,6) NOT NULL DEFAULT '255.000000',
- PRIMARY KEY (`id`)
- ) ENGINE=INNODB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
- INSERT INTO `#__gruposlocales` (`id`, `latitude`, `longitude`) SELECT userid, latitude, longitude FROM `#__community_users`;
- INSERT INTO `#__gruposlocales` (`name`) SELECT name FROM `#__community_groups` WHERE id=ownerid;
Add Comment
Please, Sign In to add comment