Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Structure of MySQL tables for Workshops CMP
CREATE TABLE IF NOT EXISTS `cx_workshop` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(250) NOT NULL,
`date` int(20) NOT NULL DEFAULT '0',
`time_start` time DEFAULT NULL,
`time_end` time DEFAULT NULL,
`capacity` int(11) NOT NULL,
`description` text NOT NULL,
`status` int(11) NOT NULL,
`annex` varchar(250) NOT NULL,
`annex_source` int(10) NOT NULL DEFAULT '0',
`createdby` int(10) NOT NULL DEFAULT '0',
`createdon` int(20) NOT NULL DEFAULT '0',
`deleted` tinyint(1) NOT NULL DEFAULT '0',
`deletedby` int(10) NOT NULL DEFAULT '0',
`deletedon` int(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `cx_workshop_participant` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`registration` int(11) NOT NULL,
`degree` varchar(50) NOT NULL,
`first_name` varchar(250) NOT NULL,
`last_name` varchar(250) NOT NULL,
`attendance` smallint(6) NOT NULL,
`deleted` tinyint(1) NOT NULL DEFAULT '0',
`deletedby` int(10) NOT NULL DEFAULT '0',
`deletedon` int(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `cx_workshop_registration` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`workshop` int(11) NOT NULL,
`type` int(11) NOT NULL,
`company` varchar(250) NOT NULL,
`address` text NOT NULL,
`email` varchar(250) NOT NULL,
`registration_nr` varchar(250) NOT NULL,
`vat_nr` varchar(250) NOT NULL,
`phone` varchar(250) NOT NULL,
`confirmed` smallint(6) NOT NULL,
`paid` int(20) DEFAULT '0',
`remark` text NOT NULL,
`createdon` int(20) NOT NULL DEFAULT '0',
`deleted` tinyint(1) NOT NULL DEFAULT '0',
`deletedby` int(10) NOT NULL DEFAULT '0',
`deletedon` int(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment