Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
executable file 113 lines (100 sloc) 4.13 KB
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
CREATE TABLE IF NOT EXISTS `RE_APPS` (
`ID` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`CREATED` datetime NOT NULL,
`NAME` varchar(30) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `RE_USERS` (
`ID` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
`NAME` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`PASSWORD` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
`EMAIL` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`TYPE` int(2) NOT NULL,
`STATUS` int(1) NOT NULL,
`LANGUAGE` varchar(2) COLLATE utf8_spanish_ci DEFAULT 'en',
`LAST_LOGIN` datetime DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
CREATE TABLE IF NOT EXISTS `RE_USERS_REL_APPS` (
`ID` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`CREATED` datetime NOT NULL,
`TYPE` int(11) NOT NULL,
`FK_USER` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`FK_APP` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `TDR_ATTACHED_FILES` (
`ID` varchar(20) NOT NULL,
`CREATED` datetime NOT NULL,
`FILENAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`DOWNLOADS` bigint(20) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `TDR_CATEGORIES` (
`ID` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`CREATED` datetime NOT NULL,
`NAME` varchar(30) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `TDR_DATA` (
`ID` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`CREATED` datetime NOT NULL,
`TITLE` text CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`DATA` text CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`FK_CATEGORY` varchar(20) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `TDR_DATA_LOGS` (
`ID` varchar(20) NOT NULL,
`CREATED` datetime NOT NULL,
`FK_DATA` varchar(20) NOT NULL,
`MESSAGE` smallint(1) NOT NULL,
`FK_USER` varchar(20) NOT NULL,
`FK_ATTACHED_FILE` varchar(50) NOT NULL,
`FILENAME` varchar(100) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `TDR_DATA_REL_ATTACHED_FILES` (
`ID` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`FK_DATA` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`FK_ATTACHED_FILE` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `TDR_GROUPS` (
`ID` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`NAME` varchar(30) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`CREATED` datetime NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `TDR_GROUPS_REL_CATEGORIES` (
`ID` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`CREATED` datetime NOT NULL,
`FK_GROUP` varchar(20) NOT NULL,
`FK_CATEGORY` varchar(20) NOT NULL,
`ACCESS` int(1) NOT NULL,
`EDIT` int(1) NOT NULL,
`DEL` int(1) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `TDR_GROUPS_REL_USERS` (
`ID` varchar(20) NOT NULL,
`FK_USER` varchar(20) NOT NULL,
`FK_GROUP` varchar(20) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `TDR_USER_ACTIVATION` (
`ID` varchar(20) NOT NULL,
`FK_USER` varchar(20) NOT NULL,
`DATE` datetime NOT NULL,
`STATUS` int(1) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `TDR_PASSWORD_RECOVERY` (
`ID` varchar(20) NOT NULL,
`DATE` datetime NOT NULL,
`STATUS` int(1) NOT NULL,
`FK_USER` varchar(20) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1