...
You will see a list of Locations. You can view a Location by clicking on the blue view icon. You can also edit or delete your locations.
.
Database Schema
Code Block | ||||
---|---|---|---|---|
| ||||
Create Table: CREATE TABLE `locations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(200) NOT NULL DEFAULT '', `org_id` int(10) unsigned NOT NULL DEFAULT '1', `type` enum('Airforce','Airport','Ambulance Station','Army','Cloud','Conference Center','Court House','Data Center','Depot','District','Doctors Office','Embassy','Factory','Fire Station','Guard','Head Office','High School','Hospital','Hotel','House','Library','Light House','Marina','Mobile Phone Tower','Motel','Navy','Newsagent','Nursing Home','Observatory','Office','Oil Rig','Police','Power Plant','Power Substation','Prison','Radio Station','Regional','Resort','Retail','School','Security','Stadium','Train Station','Travel Agency','TV Station','University','Warehouse','Workshop') NOT NULL DEFAULT 'Office', `room` varchar(100) NOT NULL DEFAULT '', `suite` varchar(100) NOT NULL DEFAULT '', `level` varchar(100) NOT NULL DEFAULT '', `address` varchar(100) NOT NULL DEFAULT '', `suburb` varchar(100) NOT NULL DEFAULT '', `city` varchar(100) NOT NULL DEFAULT '', `district` varchar(100) NOT NULL DEFAULT '', `region` varchar(100) NOT NULL DEFAULT '', `area` varchar(100) NOT NULL DEFAULT '', `state` varchar(100) NOT NULL DEFAULT '', `postcode` varchar(10) NOT NULL DEFAULT '', `country` varchar(100) NOT NULL DEFAULT '', `tags` varchar(250) NOT NULL DEFAULT '', `phone` varchar(20) NOT NULL DEFAULT '', `picture` varchar(100) NOT NULL DEFAULT '', `latitude` float(10,6) NOT NULL, `longitude` float(10,6) NOT NULL, `geo` varchar(200) NOT NULL DEFAULT '', `edited_by` varchar(200) NOT NULL DEFAULT '', `edited_date` datetime NOT NULL DEFAULT '2000-01-01 00:00:00', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; |
...