448wX2Mq

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Server version:               5.6.15-log - MySQL Community Server (GPL)
4-- Server OS:                    Win32
5-- HeidiSQL Version:             9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Dumping database structure for cms
14CREATE DATABASE IF NOT EXISTS `cms` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;
15USE `cms`;
16
17
18-- Dumping structure for table cms.event
19CREATE TABLE IF NOT EXISTS `event` (
20  `iEventID` bigint(20) NOT NULL AUTO_INCREMENT,
21  `vcTitle` varchar(255) NOT NULL COMMENT 'Titel',
22  `iVenueID` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Venue',
23  `daStart` bigint(20) DEFAULT '0' COMMENT 'Startdato',
24  `daStop` bigint(20) DEFAULT '0' COMMENT 'Slutdato',
25  `daCreated` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Oprettet',
26  `txShortDesc` text NOT NULL COMMENT 'Kort beskrivelse',
27  `txLongDesc` text NOT NULL COMMENT 'Lang beskrivelse',
28  `vcTicketUrl` varchar(255) DEFAULT '' COMMENT 'Link til billetkøb',
29  `iIsActive` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Aktiv',
30  `iDeleted` tinyint(4) NOT NULL DEFAULT '0',
31  PRIMARY KEY (`iEventID`)
32) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33
34-- Data exporting was unselected.
35
36
37-- Dumping structure for table cms.user
38CREATE TABLE IF NOT EXISTS `user` (
39  `iUserID` bigint(20) NOT NULL AUTO_INCREMENT,
40  `vcUserName` varchar(255) NOT NULL DEFAULT '',
41  `vcPassword` varchar(50) NOT NULL DEFAULT '',
42  `iUserRole` mediumint(9) NOT NULL DEFAULT '0',
43  `vcFirstName` varchar(255) DEFAULT '',
44  `vcLastName` varchar(255) DEFAULT '',
45  `vcAddress` varchar(255) DEFAULT '',
46  `iZip` mediumint(10) DEFAULT NULL,
47  `vcCity` varchar(255) DEFAULT '',
48  `vcEmail` varchar(255) DEFAULT '',
49  `vcPhone1` varchar(255) DEFAULT NULL,
50  `vcPhone2` varchar(255) DEFAULT NULL,
51  `vcPhone3` varchar(255) DEFAULT NULL,
52  `daCreated` bigint(20) DEFAULT NULL,
53  `iSuspended` tinyint(4) NOT NULL DEFAULT '0',
54  `iDeleted` tinyint(4) NOT NULL DEFAULT '0',
55  PRIMARY KEY (`iUserID`)
56) ENGINE=InnoDB DEFAULT CHARSET=utf8;
57
58-- Data exporting was unselected.
59
60
61-- Dumping structure for table cms.usergroup
62CREATE TABLE IF NOT EXISTS `usergroup` (
63  `iUserGroupID` bigint(20) NOT NULL AUTO_INCREMENT,
64  `vcUserGroupName` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
65  `txDescription` text COLLATE utf8_bin NOT NULL,
66  PRIMARY KEY (`iUserGroupID`)
67) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
68
69-- Data exporting was unselected.
70
71
72-- Dumping structure for table cms.usergrouprel
73CREATE TABLE IF NOT EXISTS `usergrouprel` (
74  `iUserGroupRelID` bigint(20) NOT NULL AUTO_INCREMENT,
75  `iUserID` bigint(20) NOT NULL DEFAULT '2',
76  `iUserGroupID` bigint(20) NOT NULL DEFAULT '2',
77  PRIMARY KEY (`iUserGroupRelID`)
78) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
79
80-- Data exporting was unselected.
81/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
82/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
83/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;