Skip to content

Instantly share code, notes, and snippets.

@freretuc

freretuc/create-table.sql

Created August 29, 2015 16:02
Show Gist options
  • Save freretuc/16d1b885f27bea2b004d to your computer and use it in GitHub Desktop.
Save freretuc/16d1b885f27bea2b004d to your computer and use it in GitHub Desktop.
Download ZIP
vsftpd.mysql.sql
Raw
create-table.sql
CREATE TABLE IF NOT EXISTS `users` (
`uname` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`upwd` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`quota` int(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
ALTER TABLE `users`
ADD PRIMARY KEY (`uname`);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment