File indexing completed on 2024-04-14 05:53:07

0001 CREATE TABLE `collection_projects`
0002 (
0003     `collection_project_id` INT(11)         NOT NULL AUTO_INCREMENT,
0004     `collection_id`         INT(11)         NOT NULL,
0005     `project_id`            INT(11)         NOT NULL,
0006     `order`                 INT(11)         NULL DEFAULT NULL,
0007     `active`                INT(1) UNSIGNED NULL DEFAULT '1',
0008     `created_at`            DATETIME        NULL DEFAULT NULL,
0009     `changed_at`            DATETIME        NULL DEFAULT NULL,
0010     `deleted_at`            DATETIME        NULL DEFAULT NULL,
0011     PRIMARY KEY (`collection_project_id`)
0012 )
0013     COLLATE = 'latin1_swedish_ci'
0014     ENGINE = InnoDB
0015 ;