[TASK] Merge submodule dbal into core
[Packages/TYPO3.CMS.git] / typo3 / sysext / openid / ext_tables.sql
1 #
2 # Table structure for table 'be_users'
3 #
4 CREATE TABLE be_users (
5 tx_openid_openid varchar(255) DEFAULT '' NOT NULL
6 );
7
8 #
9 # Table structure for table 'fe_users'
10 #
11 CREATE TABLE fe_users (
12 tx_openid_openid varchar(255) DEFAULT '' NOT NULL
13 );
14
15 #
16 # Table structure for table 'tx_openid_assoc_store'.
17 #
18 CREATE TABLE tx_openid_assoc_store (
19 uid int(11) unsigned NOT NULL auto_increment,
20 pid int(11) unsigned DEFAULT '0' NOT NULL,
21 crdate int(11) unsigned DEFAULT '0' NOT NULL,
22 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
23 expires int(11) unsigned DEFAULT '0' NOT NULL,
24 server_url varchar(2047) DEFAULT '' NOT NULL,
25 assoc_handle varchar(255) DEFAULT '' NOT NULL,
26 content blob,
27
28 PRIMARY KEY (uid),
29 KEY assoc_handle (assoc_handle(8)),
30 KEY expires (expires)
31 ) ENGINE=InnoDB;
32
33 #
34 # Table structure for table 'tx_openid_nonce_store'.
35 #
36 CREATE TABLE tx_openid_nonce_store (
37 uid int(11) unsigned NOT NULL auto_increment,
38 pid int(11) unsigned DEFAULT '0' NOT NULL,
39 crdate int(11) unsigned DEFAULT '0' NOT NULL,
40 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
41 server_url varchar(2047) DEFAULT '' NOT NULL,
42 salt char(40) DEFAULT '' NOT NULL,
43
44 PRIMARY KEY (uid),
45 UNIQUE KEY nonce (server_url(255),tstamp,salt),
46 KEY crdate (crdate)
47 ) ENGINE=InnoDB;