sqlall_filer.sql

BEGIN;
CREATE TABLE `filer_folder` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `parent_id` integer,
    `name` varchar(255) NOT NULL,
    `owner_id` integer,
    `uploaded_at` datetime NOT NULL,
    `created_at` datetime NOT NULL,
    `modified_at` datetime NOT NULL,
    `lft` integer UNSIGNED NOT NULL,
    `rght` integer UNSIGNED NOT NULL,
    `tree_id` integer UNSIGNED NOT NULL,
    `level` integer UNSIGNED NOT NULL,
    UNIQUE (`parent_id`, `name`)
)
;
ALTER TABLE `filer_folder` ADD CONSTRAINT `owner_id_refs_id_a9e7dcbc` FOREIGN KEY (`owner_id`) REFERENCES `auth_user` (`id`);
ALTER TABLE `filer_folder` ADD CONSTRAINT `parent_id_refs_id_42b2c54f` FOREIGN KEY (`parent_id`) REFERENCES `filer_folder` (`id`);
CREATE TABLE `filer_folderpermission` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `folder_id` integer,
    `type` smallint NOT NULL,
    `user_id` integer,
    `group_id` integer,
    `everybody` bool NOT NULL,
    `can_edit` smallint,
    `can_read` smallint,
    `can_add_children` smallint
)
;
ALTER TABLE `filer_folderpermission` ADD CONSTRAINT `folder_id_refs_id_b2c18baf` FOREIGN KEY (`folder_id`) REFERENCES `filer_folder` (`id`);
ALTER TABLE `filer_folderpermission` ADD CONSTRAINT `user_id_refs_id_2bc29acf` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
ALTER TABLE `filer_folderpermission` ADD CONSTRAINT `group_id_refs_id_f86eccc7` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`);
CREATE TABLE `filer_file` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `polymorphic_ctype_id` integer,
    `folder_id` integer,
    `file` varchar(255),
    `_file_size` integer,
    `sha1` varchar(40) NOT NULL,
    `has_all_mandatory_data` bool NOT NULL,
    `original_filename` varchar(255),
    `name` varchar(255) NOT NULL,
    `description` longtext,
    `owner_id` integer,
    `uploaded_at` datetime NOT NULL,
    `modified_at` datetime NOT NULL,
    `is_public` bool NOT NULL
)
;
ALTER TABLE `filer_file` ADD CONSTRAINT `polymorphic_ctype_id_refs_id_a03609f3` FOREIGN KEY (`polymorphic_ctype_id`) REFERENCES `django_content_type` (`id`);
ALTER TABLE `filer_file` ADD CONSTRAINT `owner_id_refs_id_a6490af8` FOREIGN KEY (`owner_id`) REFERENCES `auth_user` (`id`);
ALTER TABLE `filer_file` ADD CONSTRAINT `folder_id_refs_id_41348f39` FOREIGN KEY (`folder_id`) REFERENCES `filer_folder` (`id`);
CREATE TABLE `filer_clipboard` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `user_id` integer NOT NULL
)
;
ALTER TABLE `filer_clipboard` ADD CONSTRAINT `user_id_refs_id_5b2d2788` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
CREATE TABLE `filer_clipboarditem` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `file_id` integer NOT NULL,
    `clipboard_id` integer NOT NULL
)
;
ALTER TABLE `filer_clipboarditem` ADD CONSTRAINT `file_id_refs_id_a869c276` FOREIGN KEY (`file_id`) REFERENCES `filer_file` (`id`);
ALTER TABLE `filer_clipboarditem` ADD CONSTRAINT `clipboard_id_refs_id_fd11d4a0` FOREIGN KEY (`clipboard_id`) REFERENCES `filer_clipboard` (`id`);
CREATE TABLE `filer_image` (
    `file_ptr_id` integer NOT NULL PRIMARY KEY,
    `_height` integer,
    `_width` integer,
    `date_taken` datetime,
    `default_alt_text` varchar(255),
    `default_caption` varchar(255),
    `author` varchar(255),
    `must_always_publish_author_credit` bool NOT NULL,
    `must_always_publish_copyright` bool NOT NULL,
    `subject_location` varchar(64)
)
;
ALTER TABLE `filer_image` ADD CONSTRAINT `file_ptr_id_refs_id_7375d00c` FOREIGN KEY (`file_ptr_id`) REFERENCES `filer_file` (`id`);
CREATE INDEX `filer_folder_410d0aac` ON `filer_folder` (`parent_id`);
CREATE INDEX `filer_folder_cb902d83` ON `filer_folder` (`owner_id`);
CREATE INDEX `filer_folder_f777e2bb` ON `filer_folder` (`lft`);
CREATE INDEX `filer_folder_76886718` ON `filer_folder` (`rght`);
CREATE INDEX `filer_folder_f391089a` ON `filer_folder` (`tree_id`);
CREATE INDEX `filer_folder_b8f3f94a` ON `filer_folder` (`level`);
CREATE INDEX `filer_folderpermission_3aef490b` ON `filer_folderpermission` (`folder_id`);
CREATE INDEX `filer_folderpermission_6340c63c` ON `filer_folderpermission` (`user_id`);
CREATE INDEX `filer_folderpermission_5f412f9a` ON `filer_folderpermission` (`group_id`);
CREATE INDEX `filer_file_0022f76a` ON `filer_file` (`polymorphic_ctype_id`);
CREATE INDEX `filer_file_3aef490b` ON `filer_file` (`folder_id`);
CREATE INDEX `filer_file_cb902d83` ON `filer_file` (`owner_id`);
CREATE INDEX `filer_clipboard_6340c63c` ON `filer_clipboard` (`user_id`);
CREATE INDEX `filer_clipboarditem_4e9667b7` ON `filer_clipboarditem` (`file_id`);
CREATE INDEX `filer_clipboarditem_8d9ffea2` ON `filer_clipboarditem` (`clipboard_id`);

COMMIT;