174 lines
6.7 KiB
SQL
174 lines
6.7 KiB
SQL
#
|
|
# Table structure for table 'tx_bookmarkslikesratings_domain_model_ratingobject'
|
|
#
|
|
CREATE TABLE tx_bookmarkslikesratings_domain_model_ratingobject
|
|
(
|
|
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
ratetable varchar(64) DEFAULT '' NOT NULL,
|
|
ratefield varchar(64) DEFAULT '' NOT NULL,
|
|
stepconfs int(11) DEFAULT '0' NOT NULL,
|
|
ratings int(11) DEFAULT '0' NOT NULL,
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid),
|
|
KEY phpunit_dummy (is_dummy_record),
|
|
INDEX tx_bookmarkslikesratings_domain_model_ratingobject_i1 (ratetable, ratefield)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'tx_bookmarkslikesratings_domain_model_stepconf'
|
|
#
|
|
CREATE TABLE tx_bookmarkslikesratings_domain_model_stepconf
|
|
(
|
|
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
ratingobject int(11) DEFAULT '0' NOT NULL,
|
|
steporder int(11) DEFAULT '1' NOT NULL,
|
|
stepweight int(11) DEFAULT '1' NOT NULL,
|
|
stepname int(11) DEFAULT '0' NOT NULL,
|
|
votes int(11) DEFAULT '0' NOT NULL,
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) DEFAULT '0' NOT NULL,
|
|
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid),
|
|
KEY phpunit_dummy (is_dummy_record),
|
|
INDEX tx_bookmarkslikesratings_domain_model_stepconf_i1 (ratingobject, steporder)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'tx_bookmarkslikesratings_domain_model_stepname'
|
|
#
|
|
CREATE TABLE tx_bookmarkslikesratings_domain_model_stepname
|
|
(
|
|
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
stepconf int(11) DEFAULT '0' NOT NULL,
|
|
stepname varchar(64) DEFAULT '' NOT NULL,
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) DEFAULT '0' NOT NULL,
|
|
t3_origuid int(11) DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
sys_language_uid int(11) DEFAULT '0' NOT NULL,
|
|
l18n_parent int(11) DEFAULT '0' NOT NULL,
|
|
l18n_diffsource mediumblob NOT NULL,
|
|
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid),
|
|
KEY phpunit_dummy (is_dummy_record),
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'tx_bookmarkslikesratings_domain_model_rating'
|
|
#
|
|
CREATE TABLE tx_bookmarkslikesratings_domain_model_rating
|
|
(
|
|
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
ratingobject int(11) DEFAULT '0' NOT NULL,
|
|
ratedobjectuid int(11) DEFAULT '0' NOT NULL,
|
|
votes int(11) DEFAULT '0' NOT NULL,
|
|
currentrates varchar(255) DEFAULT '0' NOT NULL,
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid),
|
|
KEY phpunit_dummy (is_dummy_record),
|
|
INDEX tx_bookmarkslikesratings_domain_model_rating_i1 (ratingobject, ratedobjectuid)
|
|
);
|
|
|
|
#
|
|
# Table structure for table 'tx_bookmarkslikesratings_domain_model_vote'
|
|
#
|
|
CREATE TABLE tx_bookmarkslikesratings_domain_model_vote
|
|
(
|
|
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
rating int(11) DEFAULT '0' NOT NULL,
|
|
voter int(11) DEFAULT '0' NOT NULL,
|
|
vote int(11) DEFAULT '0' NOT NULL,
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid),
|
|
KEY phpunit_dummy (is_dummy_record),
|
|
INDEX tx_bookmarkslikesratings_domain_model_vote_i1 (rating, voter)
|
|
);
|
|
|
|
|
|
CREATE TABLE tx_bookmarkslikesratings_domain_model_bookmark
|
|
(
|
|
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
tablename varchar(250) NOT NULL,
|
|
object_uid int(11) NOT NULL,
|
|
user int(11) NOT NULL,
|
|
seen_on_page int(11) DEFAULT NULL,
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid),
|
|
INDEX tx_bookmarkslikesratings_domain_model_bookmark_i1 (tablename, object_uid, user)
|
|
);
|
|
|
|
CREATE TABLE tx_bookmarkslikesratings_domain_model_like
|
|
(
|
|
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
tablename varchar(250) NOT NULL,
|
|
object_uid int(11) NOT NULL,
|
|
user int(11) NOT NULL,
|
|
seen_on_page int(11) DEFAULT NULL,
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid),
|
|
INDEX tx_bookmarkslikesratings_domain_model_like_i1 (tablename, object_uid, user)
|
|
);
|