rest/ext_tables.sql at develop · timrross/rest · GitHub

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
33
34
35
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
    tx_rest_apikey tinytext
);


#
# Table structure for table 'tx_rest_domain_model_document'
#
CREATE TABLE tx_rest_domain_model_document (

	uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,

	id varchar(255) DEFAULT '' NOT NULL,
	db varchar(255) DEFAULT '' NOT NULL,
	data_protected text NOT NULL,

  tstamp int(11) unsigned DEFAULT '0' NOT NULL,
	crdate int(11) unsigned DEFAULT '0' NOT NULL,
	cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
	deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
	hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
	starttime int(11) unsigned DEFAULT '0' NOT NULL,
	endtime int(11) unsigned DEFAULT '0' NOT NULL,


	PRIMARY KEY (uid),
	UNIQUE KEY guid (db,id),
	KEY parent (pid),
	KEY db (db),
	KEY id (id)
);