-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathdb_changes.txt
More file actions
22 lines (17 loc) · 774 Bytes
/
db_changes.txt
File metadata and controls
22 lines (17 loc) · 774 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
# 2017-02-26, mmx
ALTER TABLE `cms_users` ADD `username` VARCHAR( 255 ) NOT NULL AFTER `id`;
ALTER TABLE `cms_users` ADD `is_superadmin` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `email` ;
# 2017-04-02, mmx
--
-- Table structure for table `cms_template_data_relations`
--
CREATE TABLE IF NOT EXISTS `cms_template_data_relations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`template_id` int(11) NOT NULL,
`var_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`data_model_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`props` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`),
KEY `template_id` (`template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;