-- MySQL dump 8.22
--
-- Host: localhost    Database: sync
---------------------------------------------------------
-- Server version	3.23.55-log

--
-- Table structure for table 'devices'
--

CREATE TABLE devices (
  device_id int(11) NOT NULL auto_increment,
  user_id int(11) default NULL,
  uri char(128) default NULL,
  PRIMARY KEY  (device_id)
) TYPE=MyISAM;

--
-- Table structure for table 'users'
--

CREATE TABLE users (
  user_id int(11) NOT NULL auto_increment,
  name char(16) default NULL,
  password char(16) default NULL,
  PRIMARY KEY  (user_id)
) TYPE=MyISAM;

--
-- Table structure for table 'vcalendars'
--

CREATE TABLE vcalendars (
  vcalendar_id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL default '0',
  vcalendar text,
  creation_ts int(11) NOT NULL default '0',
  update_ts int(11) default NULL,
  PRIMARY KEY  (vcalendar_id)
) TYPE=MyISAM;

--
-- Table structure for table 'vcalendars_maps'
--

CREATE TABLE vcalendars_maps (
  device_id int(11) default NULL,
  vcalendar_id int(11) default NULL,
  remote_id char(32) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'vcalendars_syncs'
--

CREATE TABLE vcalendars_syncs (
  device_id int(11) default NULL,
  local_last_anchor int(11) default NULL,
  remote_last_anchor char(32) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'vcards'
--

CREATE TABLE vcards (
  vcard_id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL default '0',
  vcard text,
  creation_ts int(11) NOT NULL default '0',
  update_ts int(11) default NULL,
  PRIMARY KEY  (vcard_id)
) TYPE=MyISAM;

--
-- Table structure for table 'vcards_maps'
--

CREATE TABLE vcards_maps (
  device_id int(11) default NULL,
  vcard_id int(11) default NULL,
  remote_id char(32) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'vcards_syncs'
--

CREATE TABLE vcards_syncs (
  device_id int(11) default NULL,
  local_last_anchor int(11) default NULL,
  remote_last_anchor char(32) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'vnotes'
--

CREATE TABLE vnotes (
  vnote_id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL default '0',
  vnote text,
  creation_ts int(11) NOT NULL default '0',
  update_ts int(11) default NULL,
  PRIMARY KEY  (vnote_id)
) TYPE=MyISAM;

--
-- Table structure for table 'vnotes_maps'
--

CREATE TABLE vnotes_maps (
  device_id int(11) default NULL,
  vnote_id int(11) default NULL,
  remote_id char(32) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'vnotes_syncs'
--

CREATE TABLE vnotes_syncs (
  device_id int(11) default NULL,
  local_last_anchor int(11) default NULL,
  remote_last_anchor char(32) default NULL
) TYPE=MyISAM;