]> Tony Duckles's Git Repositories (git.nynim.org) - delicious-utils.git/blob - delicious-dump/php-delicious/examples/mysql-backup/db-schema.sql
delicious-dump: Handle changed XML output format
[delicious-utils.git] / 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 );