tony-landis (owner)

Revisions

gist: 122663 Download_button fork
public
Public Clone URL: git://gist.github.com/122663.git
Embed All Files: show embed
Text only #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

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');