Skip to content

Instantly share code, notes, and snippets.

@tony-landis

tony-landis/gist:122663

Created June 2, 2009 23:16
Show Gist options
  • Save tony-landis/122663 to your computer and use it in GitHub Desktop.
Save tony-landis/122663 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
CREATE DATABASE `pylons_openid`;
USE pylons_openid;
CREATE TABLE `user` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(128) default NULL,
`password` varchar(128) default NULL,
`acl` varchar(16) NOT NULL,
`name` varchar(32) default NULL,
`dateLogin` datetime default NULL,
`sessionId` varchar(32) default NULL,
`ip` varchar(16) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM;
CREATE TABLE `user_openid` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`verifiedEmail` varchar(200) default NULL,
`displayName` varchar(200) default NULL,
`preferredUsername` varchar(200) default NULL,
`providerName` varchar(100) default NULL,
`identifier` varchar(200) default NULL,
`email` varchar(200) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
INSERT INTO `user` (username,password,acl,name) values ('tony', md5('password'), 'admin', 'Tony Landis');
INSERT INTO `user` (username,password,acl,name) values ('customer', md5('password'), 'customer', 'John Doe');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment