diff options
| author | redmatrix <git@macgirvin.com> | 2016-05-31 17:50:47 -0700 |
|---|---|---|
| committer | redmatrix <git@macgirvin.com> | 2016-05-31 17:50:47 -0700 |
| commit | dfb6255f59980835d364402b372dd39f2b41ee7c (patch) | |
| tree | f8d97437d713311a9cd3cf13e0e8faa5b617fa8f /install/schema_mysql.sql | |
| parent | 00b4843425371e4ff55c82be577a279e248c29fc (diff) | |
| download | volse-hubzilla-dfb6255f59980835d364402b372dd39f2b41ee7c.tar.gz volse-hubzilla-dfb6255f59980835d364402b372dd39f2b41ee7c.tar.bz2 volse-hubzilla-dfb6255f59980835d364402b372dd39f2b41ee7c.zip | |
more removal of reserved words from DB schemas
Diffstat (limited to 'install/schema_mysql.sql')
| -rw-r--r-- | install/schema_mysql.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 63be37f80..2b48afe98 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -188,7 +188,7 @@ CREATE TABLE IF NOT EXISTS `auth_codes` ( `client_id` varchar(20) NOT NULL DEFAULT '', `redirect_uri` varchar(200) NOT NULL DEFAULT '', `expires` int(11) NOT NULL DEFAULT '0', - `scope` varchar(250) NOT NULL DEFAULT '', + `auth_scope` varchar(512) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -342,7 +342,7 @@ CREATE TABLE IF NOT EXISTS `clients` ( `client_id` varchar(20) NOT NULL DEFAULT '', `pw` varchar(20) NOT NULL DEFAULT '', `redirect_uri` varchar(200) NOT NULL DEFAULT '', - `name` text, + `clname` text, `icon` text, `uid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`client_id`) @@ -1054,7 +1054,7 @@ CREATE TABLE IF NOT EXISTS `register` ( `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `uid` int(10) unsigned NOT NULL DEFAULT '0', `password` char(255) NOT NULL DEFAULT '', - `language` char(16) NOT NULL DEFAULT '', + `lang` char(16) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `hash` (`hash`), KEY `created` (`created`), @@ -1064,7 +1064,7 @@ CREATE TABLE IF NOT EXISTS `register` ( CREATE TABLE IF NOT EXISTS `session` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `sid` char(255) NOT NULL DEFAULT '', - `data` text NOT NULL, + `sess_data` text NOT NULL, `expire` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `sid` (`sid`), @@ -1176,7 +1176,7 @@ CREATE TABLE IF NOT EXISTS `tokens` ( `secret` text NOT NULL, `client_id` varchar(20) NOT NULL DEFAULT '', `expires` bigint(20) unsigned NOT NULL DEFAULT '0', - `scope` varchar(200) NOT NULL DEFAULT '', + `auth_scope` varchar(512) NOT NULL DEFAULT '', `uid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `client_id` (`client_id`), @@ -1204,13 +1204,13 @@ CREATE TABLE IF NOT EXISTS `updates` ( CREATE TABLE IF NOT EXISTS `verify` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `channel` int(10) unsigned NOT NULL DEFAULT '0', - `type` char(32) NOT NULL DEFAULT '', + `vtype` char(32) NOT NULL DEFAULT '', `token` char(255) NOT NULL DEFAULT '', `meta` char(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `channel` (`channel`), - KEY `type` (`type`), + KEY `vtype` (`vtype`), KEY `token` (`token`), KEY `meta` (`meta`), KEY `created` (`created`) |