david
28b02db2ea
git-svn-id: https://192.168.0.254/svn/Proyectos.Incam_SGD/tags/3.7.0.2_original@1 eb19766c-00d9-a042-a3a0-45cb8ec72764
19 lines
589 B
SQL
19 lines
589 B
SQL
CREATE TABLE notifications (
|
|
id int(11) NOT NULL default '0',
|
|
user_id int(11) NOT NULL default '0',
|
|
label varchar(255) NOT NULL default "",
|
|
type varchar(255) NOT NULL default "",
|
|
creation_date DATETIME NOT NULL,
|
|
data_int_1 int(11) NOT NULL default '0',
|
|
data_int_2 int(11) NOT NULL default '0',
|
|
data_str_1 VARCHAR(255) NOT NULL default "",
|
|
data_str_2 VARCHAR(255) NOT NULL default "",
|
|
UNIQUE KEY id (id),
|
|
INDEX (type),
|
|
INDEX (user_id)
|
|
) TYPE=InnoDB;
|
|
CREATE TABLE zseq_notifications (
|
|
id int(10) unsigned NOT NULL auto_increment,
|
|
PRIMARY KEY (id)
|
|
) TYPE=MyISAM;
|