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