Lines 4790-4796
CREATE TABLE `stockrotationrotas` (
Link Here
|
4790 |
`description` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Description for this rota', |
4790 |
`description` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Description for this rota', |
4791 |
`cyclical` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Should items on this rota keep cycling?', |
4791 |
`cyclical` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Should items on this rota keep cycling?', |
4792 |
`active` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this rota currently active?', |
4792 |
`active` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this rota currently active?', |
4793 |
PRIMARY KEY (`rota_id`) |
4793 |
PRIMARY KEY (`rota_id`), |
|
|
4794 |
UNIQUE KEY `stockrotationrotas_title` (`title`) |
4794 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4795 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4795 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4796 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4796 |
|
4797 |
|
4797 |
- |
|
|