{"action":"created","issue":{"url":"https://api.github.com/repos/directus/directus/issues/1643","repository_url":"https://api.github.com/repos/directus/directus","labels_url":"https://api.github.com/repos/directus/directus/issues/1643/labels{/name}","comments_url":"https://api.github.com/repos/directus/directus/issues/1643/comments","events_url":"https://api.github.com/repos/directus/directus/issues/1643/events","html_url":"https://github.com/directus/directus/issues/1643","id":239710200,"number":1643,"title":"403 Forbidden from the Server by adding field","user":{"login":"daddykom","id":741199,"avatar_url":"https://avatars2.githubusercontent.com/u/741199?v=3","gravatar_id":"","url":"https://api.github.com/users/daddykom","html_url":"https://github.com/daddykom","followers_url":"https://api.github.com/users/daddykom/followers","following_url":"https://api.github.com/users/daddykom/following{/other_user}","gists_url":"https://api.github.com/users/daddykom/gists{/gist_id}","starred_url":"https://api.github.com/users/daddykom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/daddykom/subscriptions","organizations_url":"https://api.github.com/users/daddykom/orgs","repos_url":"https://api.github.com/users/daddykom/repos","events_url":"https://api.github.com/users/daddykom/events{/privacy}","received_events_url":"https://api.github.com/users/daddykom/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":16,"created_at":"2017-06-30T08:25:32Z","updated_at":"2017-07-03T02:33:55Z","closed_at":null,"body":"I use Verion 6.3.9\r\n\r\nWhen I try to add a field to a table, i get a 403 Forbidden from the Server:\r\nPOST https://directus.collins.ch/cms/api/1/tables/Testtab/columns\r\n\r\nAdding the table works fine. adding a field to the table gives 403.\r\n\r\nIt sends the PHPSESSID Cookie, the same like in the create table call, which works.\r\n\r\nI do not understand, what can be the problem. GET on the same URL works fine, so it can not be a problem of the .htaccess, i think. I don't check, where this 403 is triggered.\r\n\r\nI remove everything and installed again with the newest build from Github. Same Problem.\r\n\r\nIt would be nice, i someone has an idea, where this problem came from..\r\n\r\n![screenshot at juni 30 10-20-30](https://user-images.githubusercontent.com/741199/27727280-1ae82a18-5d7e-11e7-9a2e-e2bc8c709302.png)\r\n\r\n![screenshot at juni 30 10-20-55](https://user-images.githubusercontent.com/741199/27727281-1ae86460-5d7e-11e7-835d-e2f0a7103924.png)\r\n\r\n![screenshot at juni 30 10-21-20](https://user-images.githubusercontent.com/741199/27727283-1aebbf48-5d7e-11e7-989b-439bc1f1a3bf.png)\r\n\r\n![screenshot at juni 30 10-21-50](https://user-images.githubusercontent.com/741199/27727282-1ae9cdbe-5d7e-11e7-986b-67f47288584b.png)\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/directus/directus/issues/comments/312536375","html_url":"https://github.com/directus/directus/issues/1643#issuecomment-312536375","issue_url":"https://api.github.com/repos/directus/directus/issues/1643","id":312536375,"user":{"login":"daddykom","id":741199,"avatar_url":"https://avatars2.githubusercontent.com/u/741199?v=3","gravatar_id":"","url":"https://api.github.com/users/daddykom","html_url":"https://github.com/daddykom","followers_url":"https://api.github.com/users/daddykom/followers","following_url":"https://api.github.com/users/daddykom/following{/other_user}","gists_url":"https://api.github.com/users/daddykom/gists{/gist_id}","starred_url":"https://api.github.com/users/daddykom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/daddykom/subscriptions","organizations_url":"https://api.github.com/users/daddykom/orgs","repos_url":"https://api.github.com/users/daddykom/repos","events_url":"https://api.github.com/users/daddykom/events{/privacy}","received_events_url":"https://api.github.com/users/daddykom/received_events","type":"User","site_admin":false},"created_at":"2017-07-03T02:33:55Z","updated_at":"2017-07-03T02:33:55Z","body":"SET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";\r\nSET time_zone = \"+00:00\";\r\n\r\nCREATE TABLE directus_activity (\r\n  id int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `type` varchar(100) DEFAULT NULL,\r\n  `action` varchar(100) NOT NULL,\r\n  identifier varchar(100) DEFAULT NULL,\r\n  `table_name` varchar(100) NOT NULL DEFAULT '',\r\n  row_id int(11) unsigned DEFAULT '0',\r\n  `user` int(11) unsigned NOT NULL DEFAULT '0',\r\n  `data` text,\r\n  delta text,\r\n  parent_id int(11) unsigned DEFAULT NULL,\r\n  parent_table varchar(100) DEFAULT NULL,\r\n  parent_changed tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Did the top-level record in the change set alter (scalar values/many-to-one relationships)? Or only the data within its related foreign collection records? (*toMany)',\r\n  `datetime` datetime DEFAULT NULL,\r\n  logged_ip varchar(20) DEFAULT NULL,\r\n  user_agent varchar(256) DEFAULT NULL,\r\n  PRIMARY KEY (id)\r\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO directus_activity (id, type, action, identifier, table_name, row_id, user, data, delta, parent_id, parent_table, parent_changed, datetime, logged_ip, user_agent) VALUES\r\n(1, 'LOGIN', 'LOGIN', NULL, 'directus_users', 0, 1, NULL, NULL, NULL, NULL, 0, '2017-06-29 15:30:57', '81.221.228.152', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:53.0) Gecko/20100101 Firefox/53.0'),\r\n(2, 'LOGIN', 'LOGIN', NULL, 'directus_users', 0, 1, NULL, NULL, NULL, NULL, 0, '2017-06-29 15:41:46', '81.221.228.152', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36'),\r\n(3, 'LOGIN', 'LOGIN', NULL, 'directus_users', 0, 1, NULL, NULL, NULL, NULL, 0, '2017-06-29 15:52:30', '81.221.228.152', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:53.0) Gecko/20100101 Firefox/53.0'),\r\n(4, 'LOGIN', 'LOGIN', NULL, 'directus_users', 0, 1, NULL, NULL, NULL, NULL, 0, '2017-06-29 18:30:16', '94.16.136.111', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:54.0) Gecko/20100101 Firefox/54.0'),\r\n(5, 'LOGIN', 'LOGIN', NULL, 'directus_users', 0, 1, NULL, NULL, NULL, NULL, 0, '2017-06-29 19:43:22', '94.16.136.111', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:54.0) Gecko/20100101 Firefox/54.0'),\r\n(6, 'LOGIN', 'LOGIN', NULL, 'directus_users', 0, 1, NULL, NULL, NULL, NULL, 0, '2017-06-30 08:16:27', '81.221.228.152', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:53.0) Gecko/20100101 Firefox/53.0'),\r\n(7, 'LOGIN', 'LOGIN', NULL, 'directus_users', 0, 1, NULL, NULL, NULL, NULL, 0, '2017-06-30 15:33:14', '81.221.228.152', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:53.0) Gecko/20100101 Firefox/53.0'),\r\n(8, 'LOGIN', 'LOGIN', NULL, 'directus_users', 0, 1, NULL, NULL, NULL, NULL, 0, '2017-06-30 15:35:47', '81.221.228.152', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:53.0) Gecko/20100101 Firefox/53.0'),\r\n(9, 'LOGIN', 'LOGIN', NULL, 'directus_users', 0, 1, NULL, NULL, NULL, NULL, 0, '2017-06-30 15:38:16', '81.221.228.152', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:53.0) Gecko/20100101 Firefox/53.0'),\r\n(10, 'LOGIN', 'LOGIN', NULL, 'directus_users', 0, 1, NULL, NULL, NULL, NULL, 0, '2017-06-30 18:06:49', '94.16.136.111', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/603.2.4 (KHTML, like Gecko) Version/10.1.1 Safari/603.2.4'),\r\n(11, 'ENTRY', 'ADD', '1', 'Testtab', 1, 1, '{\"id\":\"1\",\"active\":\"1\"}', '[]', NULL, NULL, 1, '2017-06-30 18:15:34', '94.16.136.111', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/603.2.4 (KHTML, like Gecko) Version/10.1.1 Safari/603.2.4'),\r\n(12, 'ENTRY', 'UPDATE', NULL, 'Testtab', 1, 1, '{\"id\":\"1\",\"active\":\"1\"}', '{\"active\":\"1\",\"id\":\"1\"}', NULL, NULL, 1, '2017-06-30 18:15:48', '94.16.136.111', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/603.2.4 (KHTML, like Gecko) Version/10.1.1 Safari/603.2.4'),\r\n(13, 'ENTRY', 'DELETE', NULL, 'Testtab', 1, 1, '{\"id\":\"1\",\"active\":\"0\"}', '{\"active\":\"0\",\"id\":\"1\"}', NULL, NULL, 1, '2017-06-30 18:15:55', '94.16.136.111', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/603.2.4 (KHTML, like Gecko) Version/10.1.1 Safari/603.2.4'),\r\n(14, 'ENTRY', 'ADD', '2', 'Testtab', 2, 1, '{\"id\":\"2\",\"active\":\"1\"}', '[]', NULL, NULL, 1, '2017-06-30 18:18:02', '94.16.136.111', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/603.2.4 (KHTML, like Gecko) Version/10.1.1 Safari/603.2.4'),\r\n(15, 'FILES', 'ADD', '00000000001.jpg', 'directus_files', 1, 1, '{\"id\":\"1\",\"active\":\"1\",\"name\":\"00000000001.jpg\",\"title\":\"Reuss 1\",\"location\":\"\",\"caption\":\"\",\"type\":\"image\\\\/jpeg\",\"charset\":\"binary\",\"tags\":\"\",\"width\":\"1280\",\"height\":\"692\",\"size\":\"451554\",\"embed_id\":null,\"user\":\"1\",\"date_uploaded\":\"2017-06-30 18:19:31\",\"storage_adapter\":\"local\"}', '[]', NULL, NULL, 1, '2017-06-30 18:19:32', '94.16.136.111', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/603.2.4 (KHTML, like Gecko) Version/10.1.1 Safari/603.2.4'),\r\n(16, 'LOGIN', 'LOGIN', NULL, 'directus_users', 0, 1, NULL, NULL, NULL, NULL, 0, '2017-07-02 10:50:20', '94.16.136.111', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/603.2.4 (KHTML, like Gecko) Version/10.1.1 Safari/603.2.4'),\r\n(17, 'LOGIN', 'LOGIN', NULL, 'directus_users', 0, 1, NULL, NULL, NULL, NULL, 0, '2017-07-03 01:22:15', '94.16.136.111', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:54.0) Gecko/20100101 Firefox/54.0');\r\n\r\nCREATE TABLE directus_bookmarks (\r\n  id int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `user` int(11) unsigned DEFAULT NULL,\r\n  title varchar(255) DEFAULT NULL,\r\n  url varchar(255) DEFAULT NULL,\r\n  icon_class varchar(255) DEFAULT NULL,\r\n  active tinyint(1) DEFAULT NULL,\r\n  section varchar(255) DEFAULT NULL,\r\n  PRIMARY KEY (id)\r\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO directus_bookmarks (id, user, title, url, icon_class, active, section) VALUES\r\n(1, 1, 'Activity', 'activity', 'icon-bell', NULL, 'other'),\r\n(2, 1, 'Files', 'files', 'icon-attach', NULL, 'other'),\r\n(3, 1, 'Messages', 'messages', 'icon-chat', NULL, 'other'),\r\n(4, 1, 'Users', 'users', 'icon-users', NULL, 'other'),\r\n(7, 1, 'testtab', 'tables/Testtab/pref/testtab', 'icon-search', NULL, 'search'),\r\n(8, 1, 'testpic', 'files/1/pref/testpic', 'icon-search', NULL, 'search');\r\n\r\nCREATE TABLE directus_columns (\r\n  id int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `table_name` varchar(64) NOT NULL DEFAULT '',\r\n  `column_name` varchar(64) NOT NULL DEFAULT '',\r\n  data_type varchar(64) DEFAULT NULL,\r\n  ui varchar(64) DEFAULT NULL,\r\n  relationship_type varchar(20) DEFAULT NULL,\r\n  related_table varchar(64) DEFAULT NULL,\r\n  junction_table varchar(64) DEFAULT NULL,\r\n  junction_key_left varchar(64) DEFAULT NULL,\r\n  junction_key_right varchar(64) DEFAULT NULL,\r\n  hidden_input tinyint(1) NOT NULL DEFAULT '0',\r\n  hidden_list tinyint(1) NOT NULL DEFAULT '0',\r\n  required tinyint(1) NOT NULL DEFAULT '0',\r\n  sort int(11) DEFAULT NULL,\r\n  `comment` varchar(1024) DEFAULT NULL,\r\n  PRIMARY KEY (id),\r\n  UNIQUE KEY `table-column` (`table_name`,`column_name`)\r\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO directus_columns (id, table_name, column_name, data_type, ui, relationship_type, related_table, junction_table, junction_key_left, junction_key_right, hidden_input, hidden_list, required, sort, comment) VALUES\r\n(1, 'directus_users', 'group', NULL, 'many_to_one', 'MANYTOONE', 'directus_groups', NULL, NULL, 'group_id', 0, 0, 0, NULL, ''),\r\n(2, 'directus_users', 'avatar_file_id', 'INT', 'single_file', 'MANYTOONE', 'directus_files', NULL, NULL, 'avatar_file_id', 0, 0, 0, NULL, '');\r\n\r\nCREATE TABLE directus_files (\r\n  id int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  active tinyint(1) DEFAULT '1',\r\n  `name` varchar(255) DEFAULT NULL,\r\n  title varchar(255) DEFAULT '',\r\n  location varchar(200) DEFAULT NULL,\r\n  caption text,\r\n  `type` varchar(50) DEFAULT '',\r\n  `charset` varchar(50) DEFAULT '',\r\n  tags varchar(255) DEFAULT '',\r\n  width int(11) unsigned DEFAULT '0',\r\n  height int(11) unsigned DEFAULT '0',\r\n  size int(11) unsigned DEFAULT '0',\r\n  embed_id varchar(200) DEFAULT NULL,\r\n  `user` int(11) unsigned NOT NULL,\r\n  date_uploaded datetime DEFAULT NULL,\r\n  storage_adapter varchar(50) DEFAULT NULL,\r\n  PRIMARY KEY (id)\r\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO directus_files (id, active, name, title, location, caption, type, charset, tags, width, height, size, embed_id, user, date_uploaded, storage_adapter) VALUES\r\n(1, 1, '00000000001.jpg', 'Reuss 1', '', '', 'image/jpeg', 'binary', '', 1280, 692, 451554, NULL, 1, '2017-06-30 18:19:31', 'local');\r\n\r\nCREATE TABLE directus_groups (\r\n  id int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `name` varchar(100) DEFAULT NULL,\r\n  description varchar(500) DEFAULT NULL,\r\n  restrict_to_ip_whitelist text,\r\n  nav_override text,\r\n  show_activity tinyint(1) NOT NULL DEFAULT '1',\r\n  show_messages tinyint(1) NOT NULL DEFAULT '1',\r\n  show_users tinyint(1) NOT NULL DEFAULT '1',\r\n  show_files tinyint(1) NOT NULL DEFAULT '1',\r\n  PRIMARY KEY (id)\r\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO directus_groups (id, name, description, restrict_to_ip_whitelist, nav_override, show_activity, show_messages, show_users, show_files) VALUES\r\n(1, 'Administrator', NULL, '0', NULL, 1, 1, 1, 1);\r\n\r\nCREATE TABLE directus_messages (\r\n  id int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `from` int(11) unsigned DEFAULT NULL,\r\n  `subject` varchar(255) NOT NULL DEFAULT '',\r\n  message text NOT NULL,\r\n  `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  attachment int(11) unsigned DEFAULT NULL,\r\n  response_to int(11) unsigned DEFAULT NULL,\r\n  comment_metadata varchar(255) DEFAULT NULL,\r\n  PRIMARY KEY (id)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE directus_messages_recipients (\r\n  id int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  message_id int(11) unsigned NOT NULL,\r\n  recipient int(11) unsigned NOT NULL,\r\n  `read` tinyint(1) NOT NULL,\r\n  `group` int(11) unsigned DEFAULT NULL,\r\n  PRIMARY KEY (id)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE directus_preferences (\r\n  id int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `user` int(11) unsigned DEFAULT NULL,\r\n  `table_name` varchar(64) DEFAULT NULL,\r\n  title varchar(255) DEFAULT NULL,\r\n  columns_visible varchar(300) DEFAULT NULL,\r\n  sort varchar(64) DEFAULT 'id',\r\n  sort_order varchar(5) DEFAULT 'ASC',\r\n  `status` varchar(5) DEFAULT '3',\r\n  search_string text,\r\n  PRIMARY KEY (id),\r\n  UNIQUE KEY `user` (`user`,`table_name`,title),\r\n  UNIQUE KEY pref_title_constraint (`user`,`table_name`,title)\r\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO directus_preferences (id, user, table_name, title, columns_visible, sort, sort_order, status, search_string) VALUES\r\n(1, 1, 'directus_bookmarks', NULL, 'user,title,url,icon_class', 'id', 'ASC', '1,2', NULL),\r\n(2, 1, 'directus_columns', NULL, 'table_name,column_name,data_type,ui,relationship_type', 'sort', 'ASC', '1,2', NULL),\r\n(3, 1, 'directus_files', NULL, 'name,title,location,caption', 'date_uploaded', 'DESC', '1,2', NULL),\r\n(4, 1, 'directus_groups', NULL, 'name,description,restrict_to_ip_whitelist,nav_override,show_activity', 'id', 'ASC', '1,2', NULL),\r\n(5, 1, 'directus_messages', NULL, 'from,subject,message,datetime,attachment', 'id', 'ASC', '1,2', NULL),\r\n(6, 1, 'directus_messages_recipients', NULL, 'message_id,recipient,read,group', 'id', 'ASC', '1,2', NULL),\r\n(7, 1, 'directus_preferences', NULL, 'user,table_name,title,columns_visible', 'sort', 'ASC', '1,2', NULL),\r\n(8, 1, 'directus_privileges', NULL, 'table_name,allow_view,allow_add,allow_edit,allow_delete', 'id', 'ASC', '1,2', NULL),\r\n(9, 1, 'directus_schema_migrations', NULL, 'version', 'id', 'ASC', '1,2', NULL),\r\n(10, 1, 'directus_settings', NULL, 'collection,name,value', 'id', 'ASC', '1,2', NULL),\r\n(11, 1, 'directus_tables', NULL, 'hidden,single,default_status,footer,list_view', 'table_name', 'ASC', '1,2', NULL),\r\n(12, 1, 'directus_ui', NULL, 'table_name,column_name,ui_name,name,value', 'id', 'ASC', '1,2', NULL),\r\n(13, 1, 'directus_users', NULL, 'group,avatar_file_id,first_name,last_name', 'id', 'ASC', '1,2', NULL),\r\n(14, 1, 'Testtab', NULL, '', 'id', 'ASC', '1,2', NULL),\r\n(15, 1, 'Testtab', 'testlink', '', 'id', 'ASC', '1,2', NULL),\r\n(16, 1, 'Testtab', 'testpic', '', 'id', 'ASC', '1,2', NULL),\r\n(17, 1, 'Testtab', 'testtab', '', 'id', 'ASC', '1,2', NULL);\r\n\r\nCREATE TABLE directus_privileges (\r\n  id int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `table_name` varchar(255) CHARACTER SET latin1 NOT NULL,\r\n  allow_view tinyint(1) NOT NULL DEFAULT '0',\r\n  allow_add tinyint(1) NOT NULL DEFAULT '0',\r\n  allow_edit tinyint(1) NOT NULL DEFAULT '0',\r\n  allow_delete tinyint(1) NOT NULL DEFAULT '0',\r\n  allow_alter tinyint(1) NOT NULL DEFAULT '0',\r\n  group_id int(11) unsigned NOT NULL,\r\n  read_field_blacklist varchar(1000) CHARACTER SET latin1 DEFAULT NULL,\r\n  write_field_blacklist varchar(1000) CHARACTER SET latin1 DEFAULT NULL,\r\n  nav_listed tinyint(1) NOT NULL DEFAULT '1',\r\n  status_id tinyint(1) NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (id)\r\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO directus_privileges (id, table_name, allow_view, allow_add, allow_edit, allow_delete, allow_alter, group_id, read_field_blacklist, write_field_blacklist, nav_listed, status_id) VALUES\r\n(1, 'directus_activity', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(2, 'directus_columns', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(3, 'directus_groups', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(4, 'directus_files', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(5, 'directus_messages', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(6, 'directus_preferences', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(7, 'directus_privileges', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(8, 'directus_settings', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(9, 'directus_tables', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(10, 'directus_ui', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(11, 'directus_users', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(12, 'directus_messages_recipients', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(13, 'directus_bookmarks', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0),\r\n(14, 'Testtab', 2, 1, 2, 2, 1, 1, NULL, NULL, 1, 0);\r\n\r\nCREATE TABLE directus_schema_migrations (\r\n  version varchar(255) DEFAULT NULL,\r\n  UNIQUE KEY idx_directus_schema_migrations_version (version)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO directus_schema_migrations (version) VALUES\r\n('20150203221946'),\r\n('20150203235646'),\r\n('20150204002341'),\r\n('20150204003426'),\r\n('20150204015251'),\r\n('20150204021255'),\r\n('20150204022237'),\r\n('20150204023325'),\r\n('20150204024327'),\r\n('20150204031412'),\r\n('20150204041007'),\r\n('20150204042025'),\r\n('20150204042725');\r\n\r\nCREATE TABLE directus_settings (\r\n  id int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  collection varchar(250) DEFAULT NULL,\r\n  `name` varchar(250) DEFAULT NULL,\r\n  `value` varchar(250) DEFAULT NULL,\r\n  PRIMARY KEY (id),\r\n  UNIQUE KEY `Unique Collection and Name` (collection,`name`)\r\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO directus_settings (id, collection, name, value) VALUES\r\n(1, 'global', 'cms_user_auto_sign_out', '60'),\r\n(2, 'global', 'project_name', 'Testprojekt'),\r\n(3, 'global', 'project_url', 'https://directus.mydomain.com/cms/'),\r\n(4, 'global', 'rows_per_page', '200'),\r\n(5, 'files', 'thumbnail_quality', '100'),\r\n(6, 'files', 'thumbnail_size', '200'),\r\n(7, 'global', 'cms_thumbnail_url', ''),\r\n(8, 'files', 'file_naming', 'file_id'),\r\n(9, 'files', 'thumbnail_crop_enabled', '1'),\r\n(10, 'files', 'youtube_api_key', '');\r\n\r\nCREATE TABLE directus_tables (\r\n  `table_name` varchar(64) NOT NULL DEFAULT '',\r\n  hidden tinyint(1) NOT NULL DEFAULT '0',\r\n  single tinyint(1) NOT NULL DEFAULT '0',\r\n  default_status tinyint(1) NOT NULL DEFAULT '1',\r\n  footer tinyint(1) DEFAULT '0',\r\n  list_view varchar(200) DEFAULT NULL,\r\n  column_groupings varchar(255) DEFAULT NULL,\r\n  primary_column varchar(255) DEFAULT NULL,\r\n  user_create_column varchar(64) DEFAULT NULL,\r\n  user_update_column varchar(64) DEFAULT NULL,\r\n  date_create_column varchar(64) DEFAULT NULL,\r\n  date_update_column varchar(64) DEFAULT NULL,\r\n  filter_column_blacklist text,\r\n  PRIMARY KEY (`table_name`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO directus_tables (table_name, hidden, single, default_status, footer, list_view, column_groupings, primary_column, user_create_column, user_update_column, date_create_column, date_update_column, filter_column_blacklist) VALUES\r\n('directus_bookmarks', 1, 0, 1, 0, NULL, NULL, NULL, 'user', NULL, NULL, NULL, NULL),\r\n('directus_files', 1, 0, 1, 0, NULL, NULL, NULL, 'user', NULL, NULL, NULL, NULL),\r\n('directus_messages_recipients', 1, 0, 1, 0, NULL, NULL, NULL, 'recipient', NULL, NULL, NULL, NULL),\r\n('directus_preferences', 1, 0, 1, 0, NULL, NULL, NULL, 'user', NULL, NULL, NULL, NULL),\r\n('directus_users', 1, 0, 1, 0, NULL, NULL, NULL, 'id', NULL, NULL, NULL, NULL);\r\n\r\nCREATE TABLE directus_ui (\r\n  id int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `table_name` varchar(64) DEFAULT NULL,\r\n  `column_name` varchar(64) DEFAULT NULL,\r\n  ui_name varchar(200) DEFAULT NULL,\r\n  `name` varchar(200) DEFAULT NULL,\r\n  `value` text,\r\n  PRIMARY KEY (id),\r\n  UNIQUE KEY `unique` (`table_name`,`column_name`,ui_name,`name`)\r\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO directus_ui (id, table_name, column_name, ui_name, name, value) VALUES\r\n(1, 'directus_users', 'avatar_file_id', 'single_file', 'allowed_filetypes', 'image/*');\r\n\r\nCREATE TABLE directus_users (\r\n  id int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  active tinyint(1) DEFAULT '1',\r\n  first_name varchar(50) DEFAULT '',\r\n  last_name varchar(50) DEFAULT '',\r\n  email varchar(255) DEFAULT '',\r\n  `password` varchar(255) DEFAULT '',\r\n  salt varchar(255) DEFAULT '',\r\n  token varchar(255) NOT NULL,\r\n  access_token varchar(255) DEFAULT '',\r\n  reset_token varchar(255) DEFAULT '',\r\n  reset_expiration datetime DEFAULT NULL,\r\n  position varchar(500) DEFAULT '',\r\n  email_messages tinyint(1) DEFAULT '1',\r\n  last_login datetime DEFAULT NULL,\r\n  last_access datetime DEFAULT NULL,\r\n  last_page varchar(255) DEFAULT '',\r\n  ip varchar(50) DEFAULT '',\r\n  `group` int(11) unsigned DEFAULT NULL,\r\n  avatar varchar(500) DEFAULT NULL,\r\n  avatar_file_id int(11) unsigned DEFAULT NULL,\r\n  location varchar(255) DEFAULT NULL,\r\n  phone varchar(255) DEFAULT NULL,\r\n  address varchar(255) DEFAULT NULL,\r\n  city varchar(255) DEFAULT NULL,\r\n  state varchar(2) DEFAULT NULL,\r\n  zip varchar(10) DEFAULT NULL,\r\n  `language` varchar(8) DEFAULT 'en',\r\n  timezone varchar(32) DEFAULT 'America/New_York',\r\n  PRIMARY KEY (id),\r\n  UNIQUE KEY directus_users_token_unique (token),\r\n  UNIQUE KEY directus_users_email_unique (email)\r\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO directus_users (id, active, first_name, last_name, email, password, salt, token, access_token, reset_token, reset_expiration, position, email_messages, last_login, last_access, last_page, ip, group, avatar, avatar_file_id, location, phone, address, city, state, zip, language, timezone) VALUES\r\n(1, 1, 'Admin', 'User', 'daddykom@mydomain.com', '', 'reLeJtqL2kAZv9aI', 'urORBAyZyS2h5aUDUsmLQX7mnQtIG31y', '84a1fd8b4316be65ee4f6caa351581eb02820fc0', '', NULL, '', 1, '2017-07-03 01:22:15', '2017-07-03 03:22:00', '{\"path\":\"settings/tables/Testtab\",\"route\":\"settingsTable\"}', '', 1, '//www.gravatar.com/avatar/729afba4acef0cd96dcb0d688b15ee7c?s=200&d=identicon&r=g', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'de', 'America/New_York');\r\n\r\nCREATE TABLE Testtab (\r\n  id int(11) NOT NULL AUTO_INCREMENT,\r\n  active int(11) NOT NULL DEFAULT '2',\r\n  PRIMARY KEY (id)\r\n) ENGINE=InnoDB  DEFAULT CHARSET=latin1;\r\n\r\nINSERT INTO Testtab (id, active) VALUES\r\n(1, 0),\r\n(2, 1);\r\n"}}
{"actor":{"display_login":"daddykom"}}