sqlall_form_designer.sql

BEGIN;
CREATE TABLE `form_designer_formdefinition` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `name` varchar(255) NOT NULL UNIQUE,
    `require_hash` bool NOT NULL,
    `private_hash` varchar(40) NOT NULL,
    `public_hash` varchar(40) NOT NULL,
    `title` varchar(255),
    `body` longtext,
    `action` varchar(255),
    `mail_to` varchar(255),
    `mail_from` varchar(255),
    `mail_subject` varchar(255),
    `mail_uploaded_files` bool NOT NULL,
    `method` varchar(10) NOT NULL,
    `success_message` varchar(255),
    `error_message` varchar(255),
    `submit_label` varchar(255),
    `log_data` bool NOT NULL,
    `save_uploaded_files` bool NOT NULL,
    `success_redirect` bool NOT NULL,
    `success_clear` bool NOT NULL,
    `allow_get_initial` bool NOT NULL,
    `message_template` longtext,
    `form_template_name` varchar(255),
    `display_logged` bool NOT NULL
)
;
CREATE TABLE `form_designer_formdefinitionfield` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `form_definition_id` integer NOT NULL,
    `field_class` varchar(32) NOT NULL,
    `position` integer,
    `name` varchar(255) NOT NULL,
    `label` varchar(255),
    `required` bool NOT NULL,
    `include_result` bool NOT NULL,
    `widget` varchar(255),
    `initial` longtext,
    `help_text` varchar(255),
    `choice_values` longtext,
    `choice_labels` longtext,
    `max_length` integer,
    `min_length` integer,
    `max_value` double precision,
    `min_value` double precision,
    `max_digits` integer,
    `decimal_places` integer,
    `regex` varchar(255),
    `choice_model` varchar(255),
    `choice_model_empty_label` varchar(255)
)
;
ALTER TABLE `form_designer_formdefinitionfield` ADD CONSTRAINT `form_definition_id_refs_id_227ad108` FOREIGN KEY (`form_definition_id`) REFERENCES `form_designer_formdefinition` (`id`);
CREATE TABLE `form_designer_formlog` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `form_definition_id` integer NOT NULL,
    `created` datetime NOT NULL,
    `created_by_id` integer
)
;
ALTER TABLE `form_designer_formlog` ADD CONSTRAINT `form_definition_id_refs_id_11b7c24d` FOREIGN KEY (`form_definition_id`) REFERENCES `form_designer_formdefinition` (`id`);
ALTER TABLE `form_designer_formlog` ADD CONSTRAINT `created_by_id_refs_id_2cdf0f95` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`);
CREATE TABLE `form_designer_formvalue` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `form_log_id` integer NOT NULL,
    `field_name` varchar(255) NOT NULL,
    `value` longtext
)
;
ALTER TABLE `form_designer_formvalue` ADD CONSTRAINT `form_log_id_refs_id_1a6b9686` FOREIGN KEY (`form_log_id`) REFERENCES `form_designer_formlog` (`id`);
CREATE INDEX `form_designer_formdefinitionfield_92c2d163` ON `form_designer_formdefinitionfield` (`form_definition_id`);
CREATE INDEX `form_designer_formdefinitionfield_4da47e07` ON `form_designer_formdefinitionfield` (`name`);
CREATE INDEX `form_designer_formlog_92c2d163` ON `form_designer_formlog` (`form_definition_id`);
CREATE INDEX `form_designer_formlog_0c98d849` ON `form_designer_formlog` (`created_by_id`);
CREATE INDEX `form_designer_formvalue_605fde98` ON `form_designer_formvalue` (`form_log_id`);
CREATE INDEX `form_designer_formvalue_d79d4265` ON `form_designer_formvalue` (`field_name`);

COMMIT;