-- MySQL dump 8.23
--
-- Host: localhost    Database: ddns
---------------------------------------------------------
-- Server version	3.23.58

--
-- Table structure for table `domains`
--

CREATE TABLE domains (
  fqdn varchar(255) NOT NULL default '',
  userid int(10) unsigned NOT NULL default '0',
  active tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (fqdn)
) TYPE=MyISAM;

--
-- Table structure for table `hosts`
--

CREATE TABLE hosts (
  fqdn varchar(255) NOT NULL default '',
  userid int(10) unsigned NOT NULL default '0',
  active tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (fqdn)
) TYPE=MyISAM;

--
-- Table structure for table `log`
--

CREATE TABLE log (
  id int(10) unsigned NOT NULL auto_increment,
  userid int(10) unsigned NOT NULL default '0',
  fqdn varchar(255) NOT NULL default '',
  ip varchar(16) NOT NULL default '',
  datetime datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `users`
--

CREATE TABLE users (
  userid int(10) unsigned NOT NULL auto_increment,
  username varchar(45) NOT NULL default '',
  password varchar(45) NOT NULL default '',
  active tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (userid)
) TYPE=MyISAM;