delicious-dump/php-delicious/examples/mysql-backup/db-schema.sql

   1 create database if not exists delicious
   2    default character set utf8
   3    default collate utf8_general_ci;
   4
   5 use delicious;
   6
   7 create table if not exists posts (
   8    url varchar(250),
   9    description varchar(250),
  10    notes text,
  11    hash varchar(50),
  12    updated datetime,
  13    primary key(hash)
  14 );
  15
  16 create table if not exists tags (
  17    hash varchar(50),
  18    tag varchar(50)
  19 );