SqlSchema - Revision history

FunPika: syntax highlighting

2014-03-19T17:55:50Z

syntax highlighting

← Older revision		Revision as of 17:55, 19 March 2014
Line 2:		Line 2:
	[[CssWork]] (parent of this page)		[[CssWork]] (parent of this page)
	<br>[[SqlDefaults]]		<br>[[SqlDefaults]]
	~~<br>http://www.mediawiki.org/wiki/Help:Formatting~~

	~~<h2>~~Summary of tables~~</h2>~~		==Summary of tables==


Line 50:		Line 49:
	\|}		\|}

	~~<h2>~~Mysql Table Schema from /usr/local/slash/sql/mysql/schema.sql~~</h2>~~		==Mysql Table Schema from /usr/local/slash/sql/mysql/schema.sql==

	Needs to be condensed.		Needs to be condensed.


	<~~pre~~>		<syntaxhighlight lang="sql">

	# MySQL dump 8.10		# MySQL dump 8.10
Line 1,774:		Line 1,773:


	</~~pre~~>		</syntaxhighlight>

	[[Category:Development]]		[[Category:Development]]

FunPika: added Category:Development using HotCat

2014-03-15T15:39:00Z

added Category:Development using HotCat

← Older revision		Revision as of 15:39, 15 March 2014
Line 1,775:		Line 1,775:

	</pre>		</pre>

			[[Category:Development]]

50.45.173.35 at 09:52, 20 February 2014

2014-02-20T09:52:34Z

← Older revision		Revision as of 09:52, 20 February 2014
Line 47:		Line 47:
	\|\|users_logtokens\|\|users_openid\|\|users_openid_reskeys\|\|'''users_param'''\|\|'''users_prefs'''		\|\|users_logtokens\|\|users_openid\|\|users_openid_reskeys\|\|'''users_param'''\|\|'''users_prefs'''
	\|-		\|-
	\|vars\|\|xsite_auth_log\|\|-\|\|-\|\|-		\|'''vars'''\|\|xsite_auth_log\|\|-\|\|-\|\|-
	\|}		\|}

50.45.173.35 at 09:51, 20 February 2014

2014-02-20T09:51:38Z

← Older revision		Revision as of 09:51, 20 February 2014
Line 13:		Line 13:
	\|al2_log\|\|al2_log_comments\|\|al2_types\|\|authors_cache\|\|backup_blocks		\|al2_log\|\|al2_log_comments\|\|al2_types\|\|authors_cache\|\|backup_blocks
	\|-		\|-
	\|badpasswords\|\|blocks\|\|classes\|\|clout_types\|\|code_param		\|badpasswords\|\|'''blocks'''\|\|classes\|\|clout_types\|\|code_param
	\|-		\|-
	\|commentmodes\|\|comments\|\|comment_log\|\|comment_promote_log\|\|comment_text		\|'''commentmodes'''\|\|'''comments'''\|\|comment_log\|\|comment_promote_log\|\|'''comment_text'''
	\|-		\|-
	\|content_filters\|\|css_type\|\|css\|\|dateformats\|\|dbs		\|content_filters\|\|'''css_type'''\|\|'''css'''\|\|dateformats\|\|dbs
	\|-		\|-
	\|dbs_readerstatus\|\|dbs_readerstatus_queries\|\|discussions\|\|discussion_kinds\|\|dst		\|dbs_readerstatus\|\|dbs_readerstatus_queries\|\|discussions\|\|discussion_kinds\|\|dst
Line 23:		Line 23:
	\|file_queue\|\|formkeys\|\|globjs\|\|globj_adminnotes\|\|globj_types		\|file_queue\|\|formkeys\|\|globjs\|\|globj_adminnotes\|\|globj_types
	\|-		\|-
	\|globj_urls\|\|hooks\|\|menus\|\|misc_user_opts\|\|open_proxies		\|globj_urls\|\|hooks\|\|'''menus'''\|\|misc_user_opts\|\|open_proxies
	\|-		\|-
	\|pagemark\|\|pollanswers\|\|pollquestions\|\|pollvoters\|\|preview		\|pagemark\|\|pollanswers\|\|pollquestions\|\|pollvoters\|\|preview
Line 31:		Line 31:
	\|related_links\|\|remarks\|\|sessions\|\|shill_ids\|\|signoff		\|related_links\|\|remarks\|\|sessions\|\|shill_ids\|\|signoff
	\|-		\|-
	\|site_info\|\|skins\|\|skin_colors\|\|slashd_status\|\|slashd_errnotes		\|site_info\|\|skins\|\|'''skin_colors'''\|\|slashd_status\|\|slashd_errnotes
	\|-		\|-
	\|soap_methods\|\|spamarmors\|\|stories\|\|story_dirty\|\|story_render_dirty		\|soap_methods\|\|spamarmors\|\|'''stories'''\|\|story_dirty\|\|story_render_dirty
	\|-		\|-
	\|story_text\|\|story_param\|\|story_topics_chosen\|\|story_topics_rendered\|\|static_files		\|'''story_text'''\|\|'''story_param'''\|\|story_topics_chosen\|\|story_topics_rendered\|\|'''static_files'''
	\|-		\|-
	\|string_param\|\|submissions\|\|submission_param\|\|templates\|\|topics		\|string_param\|\|submissions\|\|submission_param\|\|'''templates'''\|\|'''topics'''
	\|-		\|-
	\|topic_nexus\|\|topic_nexus_dirty\|\|topic_nexus_extras\|\|topic_param\|\|topic_parents		\|'''topic_nexus'''\|\|topic_nexus_dirty\|\|topic_nexus_extras\|\|'''topic_param'''\|\|topic_parents
	\|-		\|-
	\|tzcodes\|\|urls\|\|users\|\|users_acl\|\|users_clout		\|tzcodes\|\|urls\|\|'''users'''\|\|users_acl\|\|users_clout
	\|-		\|-
	\|users_comments\|\|users_comments_read_log\|\|users_hits\|\|users_index\|\|users_info		\|'''users_comments'''\|\|users_comments_read_log\|\|users_hits\|\|users_index\|\|'''users_info'''
	\|-		\|-
	\|\|users_logtokens\|\|users_openid\|\|users_openid_reskeys\|\|users_param\|\|users_prefs		\|\|users_logtokens\|\|users_openid\|\|users_openid_reskeys\|\|'''users_param'''\|\|'''users_prefs'''
	\|-		\|-
	\|vars\|\|xsite_auth_log\|\|-\|\|-\|\|-		\|vars\|\|xsite_auth_log\|\|-\|\|-\|\|-

50.45.173.35 at 09:43, 20 February 2014

2014-02-20T09:43:03Z

@@ Line 47: / Line 47: @@
 ||users_logtokens||users_openid||users_openid_reskeys||users_param||users_prefs
 |-
-|vars||xsite_auth_log||x||x||X
+|vars||xsite_auth_log||-||-||-
 |}
 <h2>Mysql Table Schema from /usr/local/slash/sql/mysql/schema.sql</h2>

50.45.173.35 at 09:41, 20 February 2014

2014-02-20T09:41:24Z

← Older revision		Revision as of 09:41, 20 February 2014
Line 9:		Line 9:

	{\|		{\|
	\|abusers\|\|accesslog\|\|accesslog_admin\|\|accesslog_artcom\|al2		\|abusers\|\|accesslog\|\|accesslog_admin\|\|accesslog_artcom\|\|al2
	\|-		\|-
	\|al2_log\|\|al2_log_comments\|\|al2_types\|authors_cache\|\|backup_blocks		\|al2_log\|\|al2_log_comments\|\|al2_types\|\|authors_cache\|\|backup_blocks
	\|-		\|-
	\|badpasswords\|\|blocks\|\|classes\|\|clout_types\|\|code_param		\|badpasswords\|\|blocks\|\|classes\|\|clout_types\|\|code_param

50.45.173.35 at 09:39, 20 February 2014

2014-02-20T09:39:54Z

← Older revision		Revision as of 09:39, 20 February 2014
Line 6:		Line 6:
	<h2>Summary of tables</h2>		<h2>Summary of tables</h2>

	{\|
	~~\|Orange\|\|Apple\|\|more~~
	\|-
	~~\|Bread\|\|Pie\|\|more~~
	\|-
	~~\|Butter\|\|Ice<br/>cream\|\|and<br/>more~~
	\|}


	{\|		{\|
	\|abusers\|\|accesslog\|\|accesslog_admin\|\|accesslog_artcom		\|abusers\|\|accesslog\|\|accesslog_admin\|\|accesslog_artcom\|al2
	\|al2\|\|al2_log\|\|al2_log_comments\|\|al2_types\|authors_cache		\|-
			\|al2_log\|\|al2_log_comments\|\|al2_types\|authors_cache\|\|backup_blocks
	\|-		\|-
	~~\|backup_blocks\|~~\|badpasswords\|\|blocks\|\|classes\|\|clout_types\|\|code_param		\|badpasswords\|\|blocks\|\|classes\|\|clout_types\|\|code_param
	\|-		\|-
	\|commentmodes\|\|comments\|\|comment_log\|\|comment_promote_log\|\|comment_text		\|commentmodes\|\|comments\|\|comment_log\|\|comment_promote_log\|\|comment_text

50.45.173.35 at 09:37, 20 February 2014

2014-02-20T09:37:44Z

← Older revision		Revision as of 09:37, 20 February 2014
Line 16:		Line 16:

	{\|		{\|
	\|abusers\|\|accesslog\|\|accesslog_admin\|\|accesslog_artcom\|\|al2\|\|al2_log\|\|al2_log_comments\|\|al2_types		\|abusers\|\|accesslog\|\|accesslog_admin\|\|accesslog_artcom
			\|al2\|\|al2_log\|\|al2_log_comments\|\|al2_types\|authors_cache
	\|-		\|-
	~~\|authors_cache\|~~\|backup_blocks\|\|badpasswords\|\|blocks\|\|classes\|\|clout_types\|\|code_param		\|backup_blocks\|\|badpasswords\|\|blocks\|\|classes\|\|clout_types\|\|code_param
	\|-		\|-
	\|commentmodes\|\|comments\|\|comment_log\|\|comment_promote_log\|\|comment_text~~\|\|content_filters\|\|css_type~~		\|commentmodes\|\|comments\|\|comment_log\|\|comment_promote_log\|\|comment_text
	\|-		\|-
	\|~~css~~\|\|~~dateformats~~\|\|~~dbs~~\|\|~~dbs_readerstatus~~\|\|~~dbs_readerstatus_queries\|\|discussions\|\|discussion_kinds~~		\|content_filters\|\|css_type\|\|css\|\|dateformats\|\|dbs
	\|-		\|-
	\|~~dst~~\|\|~~file_queue~~\|\|~~formkeys~~\|\|~~globjs~~\|\|~~globj_adminnotes\|\|globj_types\|\|globj_urls\|\|hooks~~		\|dbs_readerstatus\|\|dbs_readerstatus_queries\|\|discussions\|\|discussion_kinds\|\|dst
	\|-		\|-
	\|~~menus~~\|\|~~misc_user_opts~~\|\|~~open_proxies~~\|\|~~pagemark~~\|\|~~pollanswers\|\|pollquestions\|\|pollvoters~~		\|file_queue\|\|formkeys\|\|globjs\|\|globj_adminnotes\|\|globj_types
	\|-		\|-
	\|~~preview~~\|\|~~preview_param~~\|\|~~projects~~\|\|~~querylog~~\|\|~~related_stories\|\|rss_raw\|\|related_links~~		\|globj_urls\|\|hooks\|\|menus\|\|misc_user_opts\|\|open_proxies
	\|-		\|-
	\|~~remarks~~\|\|~~sessions~~\|\|~~shill_ids~~\|\|~~signoff~~\|\|~~site_info\|\|skins\|\|skin_colors\|\|slashd_status~~		\|pagemark\|\|pollanswers\|\|pollquestions\|\|pollvoters\|\|preview
	\|-		\|-
	\|~~slashd_errnotes~~\|\|~~soap_methods~~\|\|~~spamarmors~~\|\|~~stories~~\|\|~~story_dirty\|\|story_render_dirty\|\|story_text~~		\|preview_param\|\|projects\|\|querylog\|\|related_stories\|\|rss_raw
	\|-		\|-
	\|~~story_param~~\|\|~~story_topics_chosen~~\|\|~~story_topics_rendered~~\|\|~~static_files(~~\|\|~~string_param\|\|submissions\|\|submission_param~~		\|related_links\|\|remarks\|\|sessions\|\|shill_ids\|\|signoff
	\|-		\|-
	\|~~templates~~\|\|~~topics~~\|\|~~topic_nexus~~\|\|~~topic_nexus_dirty~~\|\|~~topic_nexus_extras\|\|topic_param\|\|topic_parents~~		\|site_info\|\|skins\|\|skin_colors\|\|slashd_status\|\|slashd_errnotes
	\|-		\|-
	\|~~tzcodes~~\|\|~~urls~~\|\|~~users~~\|\|~~users_acl~~\|\|~~users_clout\|\|users_comments\|\|users_comments_read_log~~		\|soap_methods\|\|spamarmors\|\|stories\|\|story_dirty\|\|story_render_dirty
	\|-		\|-
	\|~~users_hits~~\|\|~~users_index~~\|\|~~users_info~~\|\|~~users_logtokens~~\|\|~~users_openid\|\|users_openid_reskeys~~		\|story_text\|\|story_param\|\|story_topics_chosen\|\|story_topics_rendered\|\|static_files
	\|-		\|-
	\|users_param\|\|users_prefs\|\|vars\|\|xsite_auth_log\|\|x\|\|x\|\|X		\|string_param\|\|submissions\|\|submission_param\|\|templates\|\|topics
			\|-
			\|topic_nexus\|\|topic_nexus_dirty\|\|topic_nexus_extras\|\|topic_param\|\|topic_parents
			\|-
			\|tzcodes\|\|urls\|\|users\|\|users_acl\|\|users_clout
			\|-
			\|users_comments\|\|users_comments_read_log\|\|users_hits\|\|users_index\|\|users_info
			\|-
			\|\|users_logtokens\|\|users_openid\|\|users_openid_reskeys\|\|users_param\|\|users_prefs
			\|-
			\|vars\|\|xsite_auth_log\|\|x\|\|x\|\|X
	\|}		\|}

50.45.173.35 at 09:26, 20 February 2014

2014-02-20T09:26:50Z

← Older revision		Revision as of 09:26, 20 February 2014
Line 13:		Line 13:
	\|Butter\|\|Ice<br/>cream\|\|and<br/>more		\|Butter\|\|Ice<br/>cream\|\|and<br/>more
	\|}		\|}


			{\|
			\|abusers\|\|accesslog\|\|accesslog_admin\|\|accesslog_artcom\|\|al2\|\|al2_log\|\|al2_log_comments\|\|al2_types
			\|-
			\|authors_cache\|\|backup_blocks\|\|badpasswords\|\|blocks\|\|classes\|\|clout_types\|\|code_param
			\|-
			\|commentmodes\|\|comments\|\|comment_log\|\|comment_promote_log\|\|comment_text\|\|content_filters\|\|css_type
			\|-
			\|css\|\|dateformats\|\|dbs\|\|dbs_readerstatus\|\|dbs_readerstatus_queries\|\|discussions\|\|discussion_kinds
			\|-
			\|dst\|\|file_queue\|\|formkeys\|\|globjs\|\|globj_adminnotes\|\|globj_types\|\|globj_urls\|\|hooks
			\|-
			\|menus\|\|misc_user_opts\|\|open_proxies\|\|pagemark\|\|pollanswers\|\|pollquestions\|\|pollvoters
			\|-
			\|preview\|\|preview_param\|\|projects\|\|querylog\|\|related_stories\|\|rss_raw\|\|related_links
			\|-
			\|remarks\|\|sessions\|\|shill_ids\|\|signoff\|\|site_info\|\|skins\|\|skin_colors\|\|slashd_status
			\|-
			\|slashd_errnotes\|\|soap_methods\|\|spamarmors\|\|stories\|\|story_dirty\|\|story_render_dirty\|\|story_text
			\|-
			\|story_param\|\|story_topics_chosen\|\|story_topics_rendered\|\|static_files(\|\|string_param\|\|submissions\|\|submission_param
			\|-
			\|templates\|\|topics\|\|topic_nexus\|\|topic_nexus_dirty\|\|topic_nexus_extras\|\|topic_param\|\|topic_parents
			\|-
			\|tzcodes\|\|urls\|\|users\|\|users_acl\|\|users_clout\|\|users_comments\|\|users_comments_read_log
			\|-
			\|users_hits\|\|users_index\|\|users_info\|\|users_logtokens\|\|users_openid\|\|users_openid_reskeys
			\|-
			\|users_param\|\|users_prefs\|\|vars\|\|xsite_auth_log\|\|x\|\|x\|\|X
			\|}

50.45.173.35 at 09:16, 20 February 2014

2014-02-20T09:16:40Z

← Older revision		Revision as of 09:16, 20 February 2014
Line 5:		Line 5:

	<h2>Summary of tables</h2>		<h2>Summary of tables</h2>

			{\|
			\|Orange\|\|Apple\|\|more
			\|-
			\|Bread\|\|Pie\|\|more
			\|-
			\|Butter\|\|Ice<br/>cream\|\|and<br/>more
			\|}


	<pre>		<pre>