mirror of
https://github.com/quentin-g-dev/afup.git
synced 2026-03-24 17:22:06 +01:00
31 lines
1.1 KiB
SQL
31 lines
1.1 KiB
SQL
CREATE TABLE `afup_user_github` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`github_id` int(10) unsigned NOT NULL,
|
|
`login` varchar(255) NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`company` varchar(255) NOT NULL,
|
|
`profile_url` varchar(255) NOT NULL,
|
|
`avatar_url` varchar(255) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
CREATE TABLE `afup_sessions_vote_github` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`session_id` int(10) unsigned NOT NULL,
|
|
`user` int(10) unsigned NOT NULL,
|
|
`comment` text NOT NULL,
|
|
`vote` tinyint(3) unsigned NOT NULL,
|
|
`submitted_on` datetime NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
ALTER TABLE `afup_conferenciers` ADD `user_github` int unsigned NOT NULL;
|
|
ALTER TABLE `afup_sessions_vote_github`
|
|
CHANGE `comment` `comment` text COLLATE 'latin1_swedish_ci' NULL AFTER `user`;
|
|
ALTER TABLE `afup_conferenciers`
|
|
CHANGE `twitter` `twitter` varchar(255) COLLATE 'latin1_swedish_ci' NULL AFTER `biographie`;
|
|
ALTER TABLE `afup_sessions`
|
|
ADD `skill` tinyint(1) NOT NULL AFTER `genre`;
|
|
|
|
ALTER TABLE `afup_conferenciers`
|
|
ADD `photo` varchar(255) NULL; |