CREATE TABLE [dbo].[meta_tag_category]( [tag_category_id] [int] IDENTITY NOT NULL, [tag_id] [int] NOT NULL, [category_id] [int] NOT NULL

CREATE TABLE [dbo].[meta_tag]( [tag_id] [int] IDENTITY NOT NULL, [tag_name] [varchar](250) NOT NULL, [tag_type] [varchar](250) NOT NULL, [exclude] [int] NOT NULL

CREATE TABLE [dbo].[meta_storage]( [storage_id] [int] IDENTITY NOT NULL, [root_path] [varchar](250) NOT NULL, [storage_information] [varchar](250)

CREATE TABLE [dbo].[meta_person_tag]( [person_tag_id] [int] IDENTITY NOT NULL, [picasa_id] [varchar](250) NOT NULL, [tag_id] [int] NOT NULL

CREATE TABLE [dbo].[meta_person]( [person_id] [int] IDENTITY NOT NULL, [picasa_id] [varchar](250) NOT NULL, [fullname] [varchar](250) NOT NULL

CREATE TABLE [dbo].[meta_mimetype]( [mimetype_id] [int] IDENTITY NOT NULL, [mimetype] [varchar](250) NOT NULL

CREATE TABLE [dbo].[meta_filesystem_tag]( [filesystem_tag_id] [int] IDENTITY NOT NULL, [file_id] [int] NOT NULL, [tag_id] [int] NOT NULL

CREATE TABLE [dbo].[meta_filecache]( [filecache_id] [int] IDENTITY NOT NULL, [storage_id] [int] NOT NULL, [path] [varchar](250) NOT NULL, [name] [varchar](250) NOT NULL, [mimetype_id] [int] NOT NULL

CREATE TABLE [dbo].[meta_face]( [face_id] [int] IDENTITY NOT NULL, [file_id] [int] NOT NULL, [person_id] [int] NOT NULL, [facelocation] [varchar](250) NOT NULL

CREATE TABLE [dbo].[meta_category]( [category_id] [int] IDENTITY NOT NULL, [name] [varchar](250) NOT NULL