Please Log in to join the conversation.
Please Log in to join the conversation.
---- Datenbank: `j39`---- ------------------------------------------------------------ Table structure for table `abcde_comprofiler`--
CREATE TABLE `abcde_comprofiler` ( `id` int(11) NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`alias` varchar(150) DEFAULT NULL,
`firstname` varchar(100) DEFAULT NULL,
`middlename` varchar(100) DEFAULT NULL,
`lastname` varchar(100) DEFAULT NULL,
`hits` int(11) NOT NULL DEFAULT '0',
`message_last_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`message_number_sent` int(11) NOT NULL DEFAULT '0',
`avatar` varchar(255) DEFAULT NULL,
`avatarapproved` tinyint(4) NOT NULL DEFAULT '1',
`canvasposition` tinyint(4) NOT NULL DEFAULT '50',
`canvasapproved` tinyint(4) NOT NULL DEFAULT '1',
`canvas` varchar(255) DEFAULT NULL,
`approved` tinyint(4) NOT NULL DEFAULT '1',
`confirmed` tinyint(4) NOT NULL DEFAULT '1',
`lastupdatedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`registeripaddr` varchar(50) NOT NULL DEFAULT '',
`cbactivation` varchar(50) NOT NULL DEFAULT '',
`banned` tinyint(4) NOT NULL DEFAULT '0',
`banneddate` datetime DEFAULT NULL,
`unbanneddate` datetime DEFAULT NULL,
`bannedby` int(11) DEFAULT NULL,
`unbannedby` int(11) DEFAULT NULL,
`bannedreason` mediumtext,
`acceptedterms` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`acceptedtermsconsent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`address` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`zipcode` varchar(255) DEFAULT NULL,
`cb_geschlecht` varchar(255) DEFAULT NULL,
`cb_lieblingstag` mediumtext NOT NULL,
`cb_persdaten` varchar(255) DEFAULT NULL,
`cb_clubcardname` varchar(255) DEFAULT NULL,
`cb_gebdat` date DEFAULT NULL,
`cb_field` varchar(255) DEFAULT NULL,
`cb_gocnamen` mediumtext,
`cb_pgenable` varchar(255) DEFAULT NULL,
`cb_pgautopublish` varchar(255) DEFAULT NULL,
`cb_pgautoapprove` varchar(255) DEFAULT NULL,
`cb_pgshortgreeting` varchar(255) DEFAULT NULL,
`cb_pgtotalquotasize` varchar(255) DEFAULT NULL,
`cb_pgtotalquotaitems` varchar(255) DEFAULT NULL,
`cb_pguploadsize` varchar(255) DEFAULT NULL,
`cb_pgtotalitems` varchar(255) DEFAULT NULL,
`cb_pgtotalsize` varchar(255) DEFAULT NULL,
`cb_pglastupdate` date DEFAULT NULL,
`cb_pgaccessmode` varchar(255) DEFAULT NULL,
`cb_pgdisplayformat` varchar(255) DEFAULT NULL,
`cb_uebermich` mediumtext,
`cb_nextlevel` varchar(255) DEFAULT NULL,
`cb_suchen` mediumtext,
`cb_motto` mediumtext,
`cb_name` mediumtext,
`cb_esknnensichnurgstedeslifestyleclubabcdefghiregistrieren` varchar(255) DEFAULT NULL,
`cb_email` varchar(255) DEFAULT NULL,
`cb_namepartner` mediumtext,
`cb_pb_enable` varchar(255) DEFAULT NULL,
`cb_pb_autopublish` varchar(255) DEFAULT NULL,
`cb_pb_notifyme` varchar(255) DEFAULT NULL,
`cb_ubermichuns` mediumtext,
`cb_suche` mediumtext,
`cb_geburtsdatum` date DEFAULT NULL,
`cb_meinname` varchar(255) DEFAULT NULL,
`cb_meinname2` varchar(255) DEFAULT NULL,
`cb_meinbudy` varchar(255) DEFAULT NULL,
`cb_geburtsdatum2` date DEFAULT NULL,
`cb_nurfrmembers` varchar(255) DEFAULT NULL,
`cb_stats` varchar(255) DEFAULT NULL,
`cb_statsbuddy` varchar(255) DEFAULT NULL,
`cb_interessean` mediumtext NOT NULL,
`cb_status3` mediumtext,
`cb_forumorder` text,
`cb_forumview` text,
`cb_forumsignature` mediumtext) ENGINE=InnoDB DEFAULT CHARSET=latin1
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.