added docs for the db using schemaspy

1 files changed, 85 insertions, 0 deletions

diff --git a/dbdocs/tables/table.js b/dbdocs/tables/table.js
new file mode 100644
index 0000000..a07a96e
--- /dev/null
+++ b/dbdocs/tables/table.js
@@ -0,0 +1,85 @@
+$(document).ready(function() {
+    anchors.options.visible = 'always';
+    anchors.add('h3');
+
+    var table = $('#standard_table').DataTable( {
+        lengthChange: false,
+        ordering: false,
+        paging: config.pagination,
+		autoWidth: true,
+		buttons: [
+					{
+						text: 'Related columns',
+						action: function ( e, dt, node, config ) {
+							$(".relatedKey").toggle();
+							this.active( !this.active() );
+							table.columns.adjust().draw();
+						}
+					},
+					{
+						text: 'Constraint',
+						action: function ( e, dt, node, config ) {
+							$(".constraint").toggle();
+							this.active( !this.active() );
+							table.columns.adjust().draw();
+						}
+					},
+					{
+						extend: 'columnsToggle',
+						columns: '.toggle'
+					}
+				]
+
+    } );
+    dataTableExportButtons(table);
+
+    if ($('#indexes_table').length) {
+        var indexes = $('#indexes_table').DataTable({
+            lengthChange: false,
+            paging: config.pagination,
+            ordering: false
+        });
+        dataTableExportButtons(indexes);
+    }
+
+    if ($('#check_table').length) {
+        var check = $('#check_table').DataTable( {
+            lengthChange: false,
+            paging: config.pagination,
+            ordering: false
+        } );
+        dataTableExportButtons(check);
+    }
+} );
+
+
+$(function() {
+	var $imgs = $('img.diagram, object.diagram');
+	$imgs.css("cursor", "move")
+	$imgs.draggable();
+});
+
+$.fn.digits = function(){
+	return this.each(function(){
+		$(this).text( $(this).text().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "1 ") );
+	})
+}
+
+$(function() {
+	$("#recordNumber").digits();
+});
+
+var codeElement = document.getElementById("sql-script-codemirror");
+var editor = null;
+if (null != codeElement) {
+	editor = CodeMirror.fromTextArea(codeElement, {
+		lineNumbers: true,
+		mode: 'text/x-sql',
+		indentWithTabs: true,
+		smartIndent: true,
+		lineNumbers: true,
+		matchBrackets: true,
+		autofocus: true,
+        readOnly: true
+	});
+}