User contributions
(newest | oldest) View (newer 100 | older 100) (20 | 50 | 100 | 250 | 500)
- 17:27, 22 March 2009 (diff | hist) . . (+306) . . N Database Table: ml domains (Created page with 'ml_domains =Definition= <source lang="sql"> CREATE TABLE ml_domains ( dmid TINYINT UNSIGNED NOT NULL, PRIMARY KEY (dmid), type VARCHAR(30) NOT ...')
- 17:26, 22 March 2009 (diff | hist) . . (+581) . . N Database Table: memorable2 (Created page with 'memorable2 =Definition= <source lang="sql"> CREATE TABLE memorable2 ( userid INT(10) UNSIGNED NOT NULL DEFAULT '0', memid INT(10) ...')
- 17:25, 22 March 2009 (diff | hist) . . (+399) . . N Database Table: memkeyword2 (Created page with 'memkeyword2 =Definition= <source lang="sql"> CREATE TABLE memkeyword2 ( userid INT(10) UNSIGNED NOT NULL DEFAULT '0', memid INT(10...')
- 17:21, 22 March 2009 (diff | hist) . . (+337) . . N Database Table: logtext2 (Created page with 'logtext2 =Definition= <source lang="sql"> CREATE TABLE logtext2 ( journalid INT UNSIGNED NOT NULL, jitemid MEDIUMINT UNSIGNED NOT NULL, subject...')
- 17:21, 22 March 2009 (diff | hist) . . (+328) . . N Database Table: logtagsrecent (Created page with 'logtagsrecent =Definition= <source lang="sql"> CREATE TABLE logtagsrecent ( journalid INT UNSIGNED NOT NULL, jitemid MEDIUMINT UNSIGNED NOT...')
- 17:21, 22 March 2009 (diff | hist) . . (+340) . . N Database Table: logtags (Created page with 'logtags =Definition= <source lang="sql"> CREATE TABLE logtags ( journalid INT UNSIGNED NOT NULL, jitemid MEDIUMINT UNSIGNED NOT NULL, k...')
- 17:20, 22 March 2009 (diff | hist) . . (+302) . . N Database Table: logsec2 (Created page with 'logsec2 =Definition= <source lang="sql"> CREATE TABLE logsec2 ( journalid INT UNSIGNED NOT NULL, jitemid MEDIUMINT UNSIGNED NOT NULL, allowmask...')
- 17:20, 22 March 2009 (diff | hist) . . (+601) . . N Database Table: logproplist (Created page with 'logproplist =Definition= <source lang="sql"> CREATE TABLE logproplist ( propid tinyint(3) unsigned NOT NULL auto_increment, name varchar(50) defa...')
- 17:19, 22 March 2009 (diff | hist) . . (+345) . . N Database Table: logprop2 (Created page with 'logprop2 =Definition= <source lang="sql"> CREATE TABLE logprop2 ( journalid INT UNSIGNED NOT NULL, jitemid MEDIUMINT UNSIGNED NOT NULL, propid...')
- 17:19, 22 March 2009 (diff | hist) . . (+394) . . N Database Table: logkwsum (Created page with 'logkwsum =Definition= <source lang="sql"> CREATE TABLE logkwsum ( journalid INT UNSIGNED NOT NULL, kwid INT UNSIGNED NOT NULL, secur...')
- 17:19, 22 March 2009 (diff | hist) . . (+283) . . N Database Table: loginstall (Created page with 'loginstall =Definition= <source lang="sql"> CREATE TABLE loginstall ( userid INT UNSIGNED NOT NULL, ip INT UNSIGNED NOT NULL, time INT...')
- 17:18, 22 March 2009 (diff | hist) . . (+358) . . N Database Table: loginlog (Created page with 'loginlog =Definition= <source lang="sql"> CREATE TABLE loginlog ( userid INT UNSIGNED NOT NULL, logintime INT UNSIGNED NOT NULL, INDEX ...')
- 17:15, 22 March 2009 (diff | hist) . . (+404) . . N Database Table: log2 (Created page with 'links =Definition= <source lang="sql"> CREATE TABLE links ( journalid int(10) unsigned NOT NULL default '0', ordernum tinyint(4) unsigned NOT NUL...')
- 17:15, 22 March 2009 (diff | hist) . . (+227) . . N Database Table: links (Created page with 'knob =Definition= <source lang="sql"> CREATE TABLE knob ( knobname VARCHAR(255) NOT NULL PRIMARY KEY, val TINYINT UNSIGNED ) </source>...')
- 17:15, 22 March 2009 (diff | hist) . . (+306) . . N Database Table: knob (Created page with 'keywords =Definition= <source lang="sql"> CREATE TABLE keywords ( kwid int(10) unsigned NOT NULL auto_increment, keyword varchar(80) binary NOT N...')
- 17:14, 22 March 2009 (diff | hist) . . (+348) . . N Database Table: jobstatus (Created page with 'jobstatus =Definition= <source lang="sql"> CREATE TABLE jobstatus ( handle VARCHAR(100) PRIMARY KEY, result BLOB, start_time INT(10) UNSIGNED N...')
- 17:14, 22 March 2009 (diff | hist) . . (+414) . . N Database Table: jabroster (Created page with 'jabroster =Definition= <source lang="sql"> CREATE TABLE jabroster ( userid INT UNSIGNED NOT NULL, contactid INT UNSIGNED NOT NULL, PRIMARY...')
- 17:14, 22 March 2009 (diff | hist) . . (+539) . . N Database Table: jabpresence (Created page with 'jabpresence =Definition= <source lang="sql"> CREATE TABLE jabpresence ( userid INT UNSIGNED NOT NULL, reshash CHAR(22) BINARY, PRIMARY K...')
- 17:13, 22 March 2009 (diff | hist) . . (+293) . . N Database Table: jablastseen (Created page with 'jablastseen =Definition= <source lang="sql"> CREATE TABLE jablastseen ( userid INT UNSIGNED NOT NULL PRIMARY KEY, presence BLOB, time ...')
- 17:13, 22 March 2009 (diff | hist) . . (+257) . . N Database Table: jabcluster (Created page with 'jabcluster =Definition= <source lang="sql"> CREATE TABLE jabcluster ( clusterid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT, address VAR...')
- 17:13, 22 March 2009 (diff | hist) . . (+467) . . N Database Table: invitesent (Created page with 'invitesent =Definition= <source lang="sql"> CREATE TABLE invitesent ( commid INT(10) UNSIGNED NOT NULL, userid INT(10) UNSIGNED NOT...')
- 17:12, 22 March 2009 (diff | hist) . . (+397) . . N Database Table: inviterecv (Created page with 'inviterecv =Definition= <source lang="sql"> CREATE TABLE inviterecv ( userid INT(10) UNSIGNED NOT NULL, commid INT(10) UNSIGNED NOT...')
- 00:02, 22 March 2009 (diff | hist) . . (+464) . . N Database Table: infohistory (Created page with 'infohistory =Definition= <source lang="sql"> CREATE TABLE infohistory ( userid int(10) unsigned NOT NULL default '0', what varchar(15) NOT NULL d...')
- 23:59, 21 March 2009 (diff | hist) . . (+479) . . N Database Table: interests (Created page with 'This table stores information about interests. For associations to users, see userinterests interests =Definition=...')
- 23:55, 21 March 2009 (diff | hist) . . (+298) . . N Database Table: incoming email handle (Created page with 'incoming_email_handle =Definition= <source lang="sql"> CREATE TABLE incoming_email_handle ( ieid INT UNSIGNED NOT NULL AUTO_INCREMENT, timere...')
- 23:54, 21 March 2009 (diff | hist) . . (+282) . . N Database Table: includetext (Created page with 'includetext =Definition= <source lang="sql"> CREATE TABLE includetext ( incname VARCHAR(80) NOT NULL PRIMARY KEY, inctext TEXT, updatetime ...')
- 23:54, 21 March 2009 (diff | hist) . . (+59) . . Database Table: identitymap (→Relationships)
- 23:53, 21 March 2009 (diff | hist) . . (+334) . . N Database Table: identitymap (Created page with 'identitymap =Definition= <source lang="sql"> CREATE TABLE identitymap ( idtype CHAR(1) NOT NULL, identity VARCHAR(255) BINARY NOT NULL, use...')
- 20:29, 21 March 2009 (diff | hist) . . (+388) . . N Database Table: has subs (Created page with 'has_subs =Definition= <source lang="sql"> CREATE TABLE has_subs ( journalid INT UNSIGNED NOT NULL, etypeid INT UNSIGNED NOT NULL, arg1 ...')
- 20:28, 21 March 2009 (diff | hist) . . (+472) . . N Database Table: friends (Created page with 'friends =Definition= <source lang="sql"> CREATE TABLE friends ( userid int(10) unsigned NOT NULL default '0', friendid int(10) unsigned NOT NULL ...')
- 20:27, 21 March 2009 (diff | hist) . . (+31) . . Database Table: friendgroup2
- 20:27, 21 March 2009 (diff | hist) . . (+443) . . N Database Table: friendgroup2 (Created page with 'friendgroup =Definition= <source lang="sql"> CREATE TABLE friendgroup ( userid int(10) unsigned NOT NULL default '0', groupnum tinyint(3) unsigne...')
- 20:26, 21 March 2009 (diff | hist) . . (+315) . . N Database Table: faquses (Created page with 'faquses =Definition= <source lang="sql"> CREATE TABLE faquses ( faqid MEDIUMINT UNSIGNED NOT NULL, userid INT UNSIGNED NOT NULL, dateview DATET...')
- 20:26, 21 March 2009 (diff | hist) . . (+290) . . N Database Table: faqcat (Created page with 'faqcat =Definition= <source lang="sql"> CREATE TABLE faqcat ( faqcat varchar(20) NOT NULL default '', faqcatname varchar(100) default NULL, cat...')
- 20:25, 21 March 2009 (diff | hist) . . (+416) . . N Database Table: faq (Created page with 'faq =Definition= <source lang="sql"> CREATE TABLE faq ( faqid mediumint(8) unsigned NOT NULL auto_increment, question text, answer text, sort...')
- 20:24, 21 March 2009 (diff | hist) . . (+371) . . N Database Table: extuser (Created page with 'extuser =Definition= <source lang="sql"> CREATE TABLE extuser ( userid INT UNSIGNED NOT NULL PRIMARY KEY, siteid INT UNSIGNED NOT NULL, extus...')
- 20:24, 21 March 2009 (diff | hist) . . (+320) . . N Database Table: expunged users (Created page with 'expunged_users =Definition= <source lang="sql"> CREATE TABLE `expunged_users` ( user varchar(15) NOT NULL default '', expunge_time int(10) unsign...')
- 20:23, 21 March 2009 (diff | hist) . . (+273) . . N Database Table: eventtypelist (Created page with 'eventtypelist =Definition= <source lang="sql"> CREATE TABLE eventtypelist ( etypeid SMALLINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, class...')
- 20:23, 21 March 2009 (diff | hist) . . (+291) . . N Database Table: embedcontent (Created page with 'embedcontent =Definition= <source lang="sql"> CREATE TABLE embedcontent ( userid INT UNSIGNED NOT NULL, moduleid INT UNSIGNED NOT NULL, c...')
- 20:16, 21 March 2009 (diff | hist) . . (+244) . . N Database Table: email (Created page with 'email =Definition= <source lang="sql"> CREATE TABLE email ( userid INT UNSIGNED NOT NULL PRIMARY KEY, email VARCHAR(50), INDEX (e...')
- 20:14, 21 March 2009 (diff | hist) . . (+266) . . N Database Table: dw pp notify log (Created page with 'dw_pp_notify_log =Definition= <source lang="sql"> CREATE TABLE dw_pp_notify_log ( transdate int unsigned NOT NULL, pp_log varchar(3000) NOT N...')
- 20:14, 21 March 2009 (diff | hist) . . (+289) . . N Database Table: dw pp log (Created page with 'dw_pp_log =Definition= <source lang="sql"> CREATE TABLE dw_pp_log ( paymentid int unsigned NOT NULL, transdate int unsigned NOT NULL, pp_...')
- 20:13, 21 March 2009 (diff | hist) . . (+337) . . N Database Table: dw pp details (Created page with 'dw_pp_details =Definition= <source lang="sql"> CREATE TABLE dw_pp_details ( paymentid int unsigned NOT NULL, email varchar(255), firstna...')
- 20:12, 21 March 2009 (diff | hist) . . (+662) . . N Database Table: dw payments (Created page with 'dw_payments =Definition= <source lang="sql"> CREATE TABLE dw_payments ( paymentid int unsigned NOT NULL auto_increment, paydate int unsigned ...')
- 20:09, 21 March 2009 (diff | hist) . . (+386) . . N Database Table: dw paidstatus (Created page with 'dw_paidstatus =Definition= <source lang="sql"> CREATE TABLE dw_paidstatus ( userid int unsigned NOT NULL, typeid smallint unsigned NOT NULL, ...')
- 20:09, 21 March 2009 (diff | hist) . . (+486) . . N Database Table: duplock (Created page with 'duplock =Definition= <source lang="sql"> CREATE TABLE duplock ( realm enum('support','log','comment') NOT NULL default 'support', reid int(10) un...')
- 20:08, 21 March 2009 (diff | hist) . . (+328) . . N Database Table: dudata (Created page with 'dudata =Definition= <source lang="sql"> CREATE TABLE dudata ( userid INT UNSIGNED NOT NULL, area CHAR(1) NOT NULL, areaid INT UNSIGNED ...')
- 20:08, 21 March 2009 (diff | hist) . . (+263) . . N Database Table: domains (Created page with 'domains =Definition= <source lang="sql"> CREATE TABLE domains ( domain VARCHAR(80) NOT NULL, PRIMARY KEY (domain), userid INT UNSIGNED NOT...')
- 20:08, 21 March 2009 (diff | hist) . . (+325) . . N Database Table: dirsearchres2 (Created page with 'dirsearchres2 =Definition= <source lang="sql"> CREATE TABLE dirsearchres2 ( qdigest varchar(32) NOT NULL default '', dateins datetime NOT NULL de...')
- 20:07, 21 March 2009 (diff | hist) . . (+262) . . N Database Table: dirmogsethandles (Created page with 'dirmogsethandles =Definition= <source lang="sql"> CREATE TABLE dirmogsethandles ( conskey char(40) PRIMARY KEY, exptime INT UNSIGNED NOT NULL...')
- 20:06, 21 March 2009 (diff | hist) . . (+439) . . N Database Table: debug notifymethod (Created page with 'debug_notifymethod =Definition= <source lang="sql"> CREATE TABLE debug_notifymethod ( userid int unsigned not null, subid int unsi...')
- 20:06, 21 March 2009 (diff | hist) . . (+327) . . N Database Table: dbweights (Created page with 'dbweights =Definition= <source lang="sql"> CREATE TABLE dbweights ( dbid TINYINT UNSIGNED NOT NULL, role VARCHAR(25) NOT NULL, PRIMARY KE...')
- 20:04, 21 March 2009 (diff | hist) . . (+340) . . N Database Table: dbinfo (Created page with 'dbinfo =Definition= <source lang="sql"> CREATE TABLE dbinfo ( dbid TINYINT UNSIGNED NOT NULL, name VARCHAR(25), fdsn VARCHAR(255), ...')
- 07:09, 21 March 2009 (diff | hist) . . (+411) . . N Database Table: cprodlist (Created page with 'This table supports the prodding feature not currently supported in Dreamwidth. cprodlist =Definition= <source lang="sql"> CREATE TABLE cprodlist ( ...')
- 07:05, 21 March 2009 (diff | hist) . . (+619) . . N Database Table: cprod (Created page with 'This table supports the prodding feature not currently supported in Dreamwidth. cprod =Definition= <source lang="sql"> CREATE TABLE cprod ( userid...')
- 07:02, 21 March 2009 (diff | hist) . . (+335) . . Database Table: counter
- 06:53, 21 March 2009 (diff | hist) . . (-2) . . Database Table: content flag
- 06:53, 21 March 2009 (diff | hist) . . (+702) . . N Database Table: content flag (Created page with 'This table supports the content-flagging feature that is not currently enabled in DreamWidth. content_flag =Definition= <source lang="sql"> CREATE T...')
- 06:46, 21 March 2009 (diff | hist) . . (+494) . . N Database Table: comminterests (Created page with 'This table links community-type users to interests. comminterests =Definition= <source lang="sql"> CREATE TABLE comminterests ( userid int(10) uns...')
- 06:40, 21 March 2009 (diff | hist) . . (+485) . . N Database Table: commenturls (Created page with 'commenturls =Definition= <source lang="sql"> CREATE TABLE commenturls ( posterid int unsigned NOT NULL, journalid int unsigned NOT NULL, jta...')
- 06:32, 21 March 2009 (diff | hist) . . (+290) . . N Database Table: comm promo list (Created page with 'comm_promo_list =Definition= <source lang="sql"> CREATE TABLE comm_promo_list ( journalid INT UNSIGNED NOT NULL, r_start INT UNSIGNED NOT NULL,...')
- 06:30, 21 March 2009 (diff | hist) . . (+171) . . Database Table: codes
- 05:45, 21 March 2009 (diff | hist) . . (+346) . . N Database Table: codes (Created page with 'codes =Definition= <source lang="sql"> CREATE TABLE codes ( type varchar(10) NOT NULL default '', code varchar(7) NOT NULL default '', item var...')
- 05:42, 21 March 2009 (diff | hist) . . (+414) . . N Database Table: cmdbuffer (Created page with 'cmdbuffer =Definition= <source lang="sql"> CREATE TABLE cmdbuffer ( cbid INT UNSIGNED NOT NULL AUTO_INCREMENT, journalid INT UNSIGNED NOT NULL, ...')
- 05:41, 21 March 2009 (diff | hist) . . (+460) . . N Database Table: clustertrack2 (Created page with 'This table on each clustered database tracks users on that cluster. clustertrack2 =Definition= <source lang="sql"> CREATE TABLE clustertrack2 ( ...')
- 05:36, 21 March 2009 (diff | hist) . . (+748) . . N Database Table: clustermove inprogress (Created page with 'This table is used by the ljbackup and ljumover daemons to track the transitions of users between clusters. [[Category: Database Table|clustermov...')
- 05:30, 21 March 2009 (diff | hist) . . (+574) . . N Database Table: clustermove (Created page with 'This table tracks history when users are moved between clusters. clustermove =Definition= <source lang="sql"> CREATE TABLE clustermove ( cmid ...')
- 05:19, 21 March 2009 (diff | hist) . . (+1) . . Database Table: clientusage (→Relationships)
- 05:18, 21 March 2009 (diff | hist) . . (+559) . . N Database Table: clientusage (Created page with 'This table is populated at login. clientusage =Definition= <source lang="sql"> CREATE TABLE clientusage ( userid int(10) unsigned NOT NULL default...')
- 05:15, 21 March 2009 (diff | hist) . . (+393) . . N Database Table: clients (Created page with 'This table is populated at startup with all distinct values of logins.client. clients =Definition= <source lang="sql"> CR...')
- 05:12, 21 March 2009 (diff | hist) . . (+278) . . N Database Table: challenges (Created page with 'challenges =Definition= <source lang="sql"> CREATE TABLE challenges ( ctime int(10) unsigned NOT NULL DEFAULT 0, challenge char(80) NOT NULL ...')
- 05:12, 21 March 2009 (diff | hist) . . (0) . . Database Table: captchas (→Relationships)
- 05:09, 21 March 2009 (diff | hist) . . (+59) . . Database Table: captchas (→Relationships)
- 05:08, 21 March 2009 (diff | hist) . . (+2) . . Database Table: captcha session (→Relationships)
- 05:07, 21 March 2009 (diff | hist) . . (+67) . . Database Table: captcha session
- 05:06, 21 March 2009 (diff | hist) . . (+485) . . N Database Table: captchas (Created page with 'captchas =Definition= <source lang="sql"> CREATE TABLE captchas ( capid INT UNSIGNED NOT NULL auto_increment, type enum('image',...')
- 05:05, 21 March 2009 (diff | hist) . . (+392) . . N Database Table: captcha session (Created page with 'captcha_session =Definition= <source lang="sql"> CREATE TABLE captcha_session ( sess char(20) NOT NULL default '', sesstime int(10) unsigned ...')
- 05:04, 21 March 2009 (diff | hist) . . (+286) . . N Database Table: blockwatch events (Created page with 'blockwatch_events =Definition= <source lang="sql"> CREATE TABLE blockwatch_events ( id int unsigned NOT NULL auto_increment, name varchar(255) NO...')
- 05:03, 21 March 2009 (diff | hist) . . (+256) . . N Database Table: blobcache (Created page with 'blobcache =Definition= <source lang="sql"> CREATE TABLE blobcache ( bckey VARCHAR(40) NOT NULL, PRIMARY KEY (bckey), dateupdate DATETIME, va...')
- 04:55, 21 March 2009 (diff | hist) . . (+337) . . N Database Table: backupdirty (Created page with 'backupdirty =Definition= <source lang="sql"> CREATE TABLE backupdirty ( userid INT(10) unsigned NOT NULL default '0', marktime INT(10) unsign...')
- 04:50, 21 March 2009 (diff | hist) . . (+438) . . N Database Table: authactions (Created page with 'authactions =Definition= <source lang="sql"> CREATE TABLE authactions ( aaid int(10) unsigned NOT NULL auto_increment, userid int(10) unsigned NO...')
- 04:42, 21 March 2009 (diff | hist) . . (+474) . . N Database Table: active user summary (Created page with 'active_user_summary =Definition= <source lang="sql"> CREATE TABLE active_user_summary ( year SMALLINT NOT NULL, month TINYINT NOT NU...')
- 04:41, 21 March 2009 (diff | hist) . . (+279) . . N Database Table: active user (Created page with 'active_user =Definition= <source lang="sql"> CREATE TABLE active_user ( userid INT UNSIGNED NOT NULL, type CHAR(1) NOT NULL, time INT UN...')
- 04:41, 21 March 2009 (diff | hist) . . (+329) . . N Database Table: actionhistory (Created page with 'actionhistory =Definition= <source lang="sql"> CREATE TABLE actionhistory ( time INT UNSIGNED NOT NULL, clusterid TINYINT UNSIGNED NOT N...')
- 04:40, 21 March 2009 (diff | hist) . . (+344) . . N Database Table: acctcode (Created page with 'acctcode =Definition= <source lang="sql"> CREATE TABLE acctcode ( acid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, userid INT UNSIGNED ...')
- 02:04, 21 March 2009 (diff | hist) . . (+154) . . Database Table: community
- 02:00, 21 March 2009 (diff | hist) . . (+515) . . N Database Table: community (Created page with ' community =Definition= <source lang="sql"> CREATE TABLE community ( userid int(10) unsigned NOT NULL default '0', ownerid int(10) unsigned NOT N...')
- 00:45, 21 March 2009 (diff | hist) . . (+139) . . m Database Table: reluser2
- 00:41, 21 March 2009 (diff | hist) . . (+87) . . m Database Table: user
- 00:38, 21 March 2009 (diff | hist) . . (+100) . . Database Table: reluser
- 14:08, 20 March 2009 (diff | hist) . . (-25) . . Database Table: reluser2
- 14:07, 20 March 2009 (diff | hist) . . (-2) . . Database Table: reluser2
- 14:06, 20 March 2009 (diff | hist) . . (+116) . . Database Table: reluser
- 14:02, 20 March 2009 (diff | hist) . . (+734) . . N Database Table: reluser2 (Created page with 'Stores information about community memberships. This is in the clustered database; reluser stores related information in the global database. [[Cate...')
- 13:39, 20 March 2009 (diff | hist) . . (+723) . . Database Table: reluser
- 13:22, 20 March 2009 (diff | hist) . . (-93) . . Database Table: user
- 04:58, 20 March 2009 (diff | hist) . . (+59) . . Database Table: user (→Relationships)
- 04:36, 20 March 2009 (diff | hist) . . (-1) . . Database Table: user (→Definition)
- 04:24, 20 March 2009 (diff | hist) . . (+1,752) . . N Database Table: user (Created page with 'This table stores most of the permanent, user-specific data determined during account setup. Note that the ''name'' field is the setting from the 'basic info' screen, not the nam...')
- 02:41, 20 March 2009 (diff | hist) . . (+552) . . N Database Table: userproplite2 (Created page with 'This table is used to store multihomed userprops on the clustered database. It represents the same dataset as userprop, but blank values are saved as empty strings in userproplit...')
(newest | oldest) View (newer 100 | older 100) (20 | 50 | 100 | 250 | 500)