sql direct export-> phpDivingLog

[mosmutzel]

hello,
i'm new in the mac world
i've used divinglog before i switched to macdive.

i miss the function to export to a sql server.
I need this for my phpDivingLog

here the phpDivingLog Project http://sourceforge.net/projects/phpdivinglog/
her a demo http://www.borrett.id.au/divelog/index.php

i hope you integrate this funktion to the next update

best regards rene

[nick]

I will take a look at this. I am also considering a few other ideas, such as a custom HTML export option to generate webpages.

Are you attached to phpDivingLog, or do you just want some way to export your data to a webpage?

(Question goes for anybody reading)

[mosmutzel]

hy,
i don't want to change the system

i think its easyier to export in a sql database.

her is the strukture from the sql database:
Tabele:
Admin
Brevets
Buddy
City
Country
DBInfo
Divetype
Equipment
Logbook
Personal
Pictures
Place
Userdefined

Code: Select all

--
-- Datenbank: `divelog`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Admin`
--

CREATE TABLE IF NOT EXISTS `Admin` (
  `ID` int(15) NOT NULL AUTO_INCREMENT,
  `Username` varchar(15) DEFAULT NULL,
  `Password` varchar(100) DEFAULT NULL,
  `Email` varchar(50) DEFAULT NULL,
  `Admin` enum('True','False') DEFAULT 'False',
  `Allowpage` varchar(10) DEFAULT '0,0,0,0,0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Brevets`
--

CREATE TABLE IF NOT EXISTS `Brevets` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Brevet` varchar(255) DEFAULT '',
  `Org` varchar(255) DEFAULT '',
  `CertDate` date DEFAULT NULL,
  `Number` varchar(255) DEFAULT '',
  `Instructor` varchar(255) DEFAULT '',
  `InstructorNo` varchar(255) DEFAULT '',
  `Scan1Path` varchar(255) DEFAULT '',
  `Scan1` blob,
  `Scan2Path` varchar(255) DEFAULT '',
  `Scan2` blob,
  `UUID` char(36) DEFAULT '',
  `Updated` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Buddy`
--

CREATE TABLE IF NOT EXISTS `Buddy` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `FirstName` varchar(255) DEFAULT '',
  `LastName` varchar(255) DEFAULT '',
  `Street` varchar(255) DEFAULT '',
  `Address2` varchar(255) DEFAULT '',
  `Zip` varchar(50) DEFAULT '',
  `City` varchar(255) DEFAULT '',
  `State` varchar(255) DEFAULT '',
  `Country` varchar(255) DEFAULT '',
  `Phone` varchar(255) DEFAULT '',
  `Mobile` varchar(255) DEFAULT '',
  `Fax` varchar(255) DEFAULT '',
  `Email` varchar(255) DEFAULT '',
  `Birthdate` date DEFAULT NULL,
  `PhotoPath` varchar(255) DEFAULT '',
  `Photo` blob,
  `Comments` text,
  `UUID` char(36) DEFAULT '',
  `Updated` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `City`
--

CREATE TABLE IF NOT EXISTS `City` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `CountryID` int(11) DEFAULT NULL,
  `City` varchar(255) DEFAULT '',
  `Type` int(11) DEFAULT NULL,
  `Comments` text,
  `UUID` char(36) DEFAULT '',
  `Updated` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Country`
--

CREATE TABLE IF NOT EXISTS `Country` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `LogID` int(11) DEFAULT NULL,
  `Country` varchar(255) DEFAULT '',
  `Gmt` int(11) DEFAULT NULL,
  `Currency` varchar(255) DEFAULT '',
  `CurFactor` int(11) DEFAULT NULL,
  `FlagPath` varchar(255) DEFAULT '',
  `FlagPic` blob,
  `Comments` text,
  `UUID` char(36) DEFAULT '',
  `Updated` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `DBInfo`
--

CREATE TABLE IF NOT EXISTS `DBInfo` (
  `PrgName` varchar(50) DEFAULT '',
  `DBVersion` varchar(50) DEFAULT '',
  `LastBackup` date DEFAULT NULL,
  `LastChange` date DEFAULT NULL,
  `UUID` char(36) DEFAULT '',
  `Updated` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Divetype`
--

CREATE TABLE IF NOT EXISTS `Divetype` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Typename` varchar(100) DEFAULT '',
  `SortOrd` int(11) DEFAULT NULL,
  `UUID` char(36) DEFAULT '',
  `Updated` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Equipment`
--

CREATE TABLE IF NOT EXISTS `Equipment` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Object` varchar(255) DEFAULT '',
  `Manufacturer` varchar(255) DEFAULT '',
  `Serial` varchar(255) DEFAULT '',
  `DateP` date DEFAULT NULL,
  `DateR` date DEFAULT NULL,
  `Warranty` varchar(255) DEFAULT '',
  `Shop` varchar(255) DEFAULT '',
  `Price` double DEFAULT NULL,
  `PhotoPath` varchar(255) DEFAULT '',
  `Photo` blob,
  `Comments` text,
  `DateRN` date DEFAULT NULL,
  `UUID` char(36) DEFAULT '',
  `Updated` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Logbook`
--

CREATE TABLE IF NOT EXISTS `Logbook` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Number` int(11) DEFAULT NULL,
  `Divedate` date DEFAULT NULL,
  `Entrytime` time DEFAULT NULL,
  `Surfint` varchar(50) DEFAULT '',
  `Country` varchar(255) DEFAULT '',
  `CountryID` int(11) DEFAULT NULL,
  `City` varchar(255) DEFAULT '',
  `CityID` int(11) DEFAULT NULL,
  `Place` varchar(255) DEFAULT '',
  `PlaceID` int(11) DEFAULT NULL,
  `Divetime` double DEFAULT NULL,
  `Depth` double DEFAULT NULL,
  `Buddy` varchar(255) DEFAULT '',
  `BuddyIDs` varchar(100) DEFAULT '',
  `Signature` text,
  `Comments` text,
  `Water` int(11) DEFAULT NULL,
  `Entry` int(11) DEFAULT NULL,
  `Divetype` varchar(100) DEFAULT '',
  `Tanktype` int(11) DEFAULT NULL,
  `Tanksize` double DEFAULT NULL,
  `PresS` double DEFAULT NULL,
  `PresE` double DEFAULT NULL,
  `Gas` varchar(255) DEFAULT '',
  `Weather` varchar(255) DEFAULT '',
  `UWCurrent` varchar(255) DEFAULT '',
  `Surface` varchar(255) DEFAULT '',
  `Visibility` int(11) DEFAULT NULL,
  `Airtemp` double DEFAULT NULL,
  `Watertemp` double DEFAULT NULL,
  `Weight` double DEFAULT NULL,
  `Deco` enum('True','False') DEFAULT 'False',
  `Decostops` varchar(255) DEFAULT '',
  `Rep` enum('True','False') DEFAULT 'False',
  `Altitude` varchar(255) DEFAULT '',
  `Divesuit` varchar(255) DEFAULT '',
  `Computer` varchar(255) DEFAULT '',
  `ProfileInt` int(11) DEFAULT NULL,
  `Profile` text,
  `UsedEquip` varchar(100) DEFAULT '',
  `PresW` double DEFAULT NULL,
  `Profile2` text,
  `Profile3` text,
  `DepthAvg` double DEFAULT NULL,
  `UUID` char(36) DEFAULT '',
  `Updated` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Personal`
--

CREATE TABLE IF NOT EXISTS `Personal` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `FirstName` varchar(255) DEFAULT '',
  `LastName` varchar(255) DEFAULT '',
  `Street` varchar(255) DEFAULT '',
  `Zip` varchar(50) DEFAULT '',
  `City` varchar(255) DEFAULT '',
  `State` varchar(255) DEFAULT '',
  `Country` varchar(255) DEFAULT '',
  `Phone` varchar(255) DEFAULT '',
  `Mobile` varchar(255) DEFAULT '',
  `Fax` varchar(255) DEFAULT '',
  `Email` varchar(255) DEFAULT '',
  `Birthdate` date DEFAULT NULL,
  `LastMediCheck` date DEFAULT NULL,
  `PhotoPath` varchar(255) DEFAULT '',
  `Photo` blob,
  `Bloodgroup` varchar(50) DEFAULT '',
  `EmergContact` text,
  `Comments` text,
  `UUID` char(36) DEFAULT '',
  `Updated` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Pictures`
--

CREATE TABLE IF NOT EXISTS `Pictures` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `LogID` int(11) DEFAULT NULL,
  `Path` varchar(255) DEFAULT '',
  `Description` varchar(255) DEFAULT '',
  `Graphic` blob,
  `UUID` char(36) DEFAULT '',
  `Updated` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1089 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Place`
--

CREATE TABLE IF NOT EXISTS `Place` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `CountryID` int(11) DEFAULT NULL,
  `Place` varchar(255) DEFAULT '',
  `Rating` int(11) DEFAULT NULL,
  `MaxDepth` double DEFAULT NULL,
  `Lat` double DEFAULT NULL,
  `Lon` double DEFAULT NULL,
  `MapPath` varchar(255) DEFAULT '',
  `Map` blob,
  `Comments` text,
  `UUID` char(36) DEFAULT '',
  `Updated` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Userdefined`
--

CREATE TABLE IF NOT EXISTS `Userdefined` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `LogID` int(11) DEFAULT NULL,
  `Field1` varchar(255) DEFAULT '',
  `Field2` varchar(255) DEFAULT '',
  `Field3` varchar(255) DEFAULT '',
  `Field4` varchar(255) DEFAULT '',
  `Field5` varchar(255) DEFAULT '',
  `Field6` varchar(255) DEFAULT '',
  `Field7` varchar(255) DEFAULT '',
  `Field8` varchar(255) DEFAULT '',
  `Field9` varchar(255) DEFAULT '',
  `Field10` varchar(255) DEFAULT '',
  `UUID` char(36) DEFAULT '',
  `Updated` date DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[nick]

Sure, that's easier for you of course But it's also very specific.

One option (for now at least) is to write a script/tool to convert one of the other exportable formats into this.

Have you looked at http://en.divelogs.de/ ? This will import MacDive files for an online divelog.