Commits

Miles Pickens committed d6a3689

Attempting to include the SQL files as TEXT files

  • Participants
  • Parent commits 466ae9b

Comments (0)

Files changed (5)

File sql/form_element_options_sql.txt

+/*
+ Navicat SQL Server Data Transfer
+
+ Source Server         : 172.16.0.41
+ Source Server Version : 9001399
+ Source Host           : 172.16.0.41
+ Source Database       : MHC
+ Source Schema         : dbo
+
+ Target Server Version : 9001399
+ File Encoding         : utf-8
+
+ Date: 02/28/2013 17:52:23 PM
+*/
+
+-- ----------------------------
+--  Table structure for [dbo].[form_element_options]
+-- ----------------------------
+IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID('[dbo].[form_element_options]') AND type IN ('U'))
+	DROP TABLE [dbo].[form_element_options]
+GO
+CREATE TABLE [dbo].[form_element_options] (
+	[id] int IDENTITY(1,1) NOT NULL,
+	[form_elementsid] int NULL,
+	[value] varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[name] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+)
+GO
+
+-- ----------------------------
+--  Records of [dbo].[form_element_options]
+-- ----------------------------
+BEGIN TRANSACTION
+GO
+SET IDENTITY_INSERT [dbo].[form_element_options] ON
+GO
+INSERT INTO [dbo].[form_element_options] ([id], [form_elementsid], [value], [name]) VALUES ('1', '4', 'Green', 'G');
+INSERT INTO [dbo].[form_element_options] ([id], [form_elementsid], [value], [name]) VALUES ('2', '4', 'Blue', 'B');
+INSERT INTO [dbo].[form_element_options] ([id], [form_elementsid], [value], [name]) VALUES ('3', '4', 'Yellow', 'Y');
+INSERT INTO [dbo].[form_element_options] ([id], [form_elementsid], [value], [name]) VALUES ('4', '4', 'Pink', 'P');
+INSERT INTO [dbo].[form_element_options] ([id], [form_elementsid], [value], [name]) VALUES ('5', '5', 'Soccer', 'S');
+INSERT INTO [dbo].[form_element_options] ([id], [form_elementsid], [value], [name]) VALUES ('6', '5', 'Football', 'F');
+INSERT INTO [dbo].[form_element_options] ([id], [form_elementsid], [value], [name]) VALUES ('7', '5', 'Basketball', 'B');
+GO
+SET IDENTITY_INSERT [dbo].[form_element_options] OFF
+GO
+COMMIT
+GO
+
+
+-- ----------------------------
+--  Options for table [dbo].[form_element_options]
+-- ----------------------------
+DBCC CHECKIDENT ('[dbo].[form_element_options]', RESEED, 7)
+GO
+

File sql/form_elements_sql.txt

+/*
+ Navicat SQL Server Data Transfer
+
+ Source Server         : 172.16.0.41
+ Source Server Version : 9001399
+ Source Host           : 172.16.0.41
+ Source Database       : MHC
+ Source Schema         : dbo
+
+ Target Server Version : 9001399
+ File Encoding         : utf-8
+
+ Date: 02/28/2013 17:52:18 PM
+*/
+
+-- ----------------------------
+--  Table structure for [dbo].[form_elements]
+-- ----------------------------
+IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID('[dbo].[form_elements]') AND type IN ('U'))
+	DROP TABLE [dbo].[form_elements]
+GO
+CREATE TABLE [dbo].[form_elements] (
+	[id] int IDENTITY(1,1) NOT NULL,
+	[formsid] int NOT NULL,
+	[label] varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[helptext] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[placeholder] varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[required] bit NOT NULL DEFAULT ((0)),
+	[validation] varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[elementtype] varchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+)
+GO
+
+-- ----------------------------
+--  Records of [dbo].[form_elements]
+-- ----------------------------
+BEGIN TRANSACTION
+GO
+SET IDENTITY_INSERT [dbo].[form_elements] ON
+GO
+INSERT INTO [dbo].[form_elements] ([id], [formsid], [label], [helptext], [placeholder], [required], [validation], [elementtype]) VALUES ('1', '1', 'Name', 'Here is where you put your name', 'Bob', '0', null, 'EditText');
+INSERT INTO [dbo].[form_elements] ([id], [formsid], [label], [helptext], [placeholder], [required], [validation], [elementtype]) VALUES ('2', '1', 'Age', 'Here is where you put your age', '16', '0', null, 'EditText');
+INSERT INTO [dbo].[form_elements] ([id], [formsid], [label], [helptext], [placeholder], [required], [validation], [elementtype]) VALUES ('3', '1', 'About Me', 'Here is where you talk about yourself.', 'Blah Blah Blah...I''m so cool.', '0', null, 'TextArea');
+INSERT INTO [dbo].[form_elements] ([id], [formsid], [label], [helptext], [placeholder], [required], [validation], [elementtype]) VALUES ('4', '2', 'Color', 'Pick a color', null, '0', null, 'Select');
+INSERT INTO [dbo].[form_elements] ([id], [formsid], [label], [helptext], [placeholder], [required], [validation], [elementtype]) VALUES ('5', '2', 'Sport', 'Pick 1 favorite', null, '0', null, 'Radio');
+GO
+SET IDENTITY_INSERT [dbo].[form_elements] OFF
+GO
+COMMIT
+GO
+
+
+-- ----------------------------
+--  Options for table [dbo].[form_elements]
+-- ----------------------------
+DBCC CHECKIDENT ('[dbo].[form_elements]', RESEED, 5)
+GO
+

File sql/form_submissions_sql.txt

+/*
+ Navicat SQL Server Data Transfer
+
+ Source Server         : 172.16.0.41
+ Source Server Version : 9001399
+ Source Host           : 172.16.0.41
+ Source Database       : MHC
+ Source Schema         : dbo
+
+ Target Server Version : 9001399
+ File Encoding         : utf-8
+
+ Date: 02/28/2013 17:52:13 PM
+*/
+
+-- ----------------------------
+--  Table structure for [dbo].[form_submissions]
+-- ----------------------------
+IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID('[dbo].[form_submissions]') AND type IN ('U'))
+	DROP TABLE [dbo].[form_submissions]
+GO
+CREATE TABLE [dbo].[form_submissions] (
+	[id] int IDENTITY(1,1) NOT NULL,
+	[submitdata] text COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[timestamp] datetime NULL,
+	[workstation] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[username] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[createdate] datetime NULL
+)
+GO
+
+
+-- ----------------------------
+--  Options for table [dbo].[form_submissions]
+-- ----------------------------
+DBCC CHECKIDENT ('[dbo].[form_submissions]', RESEED, 1)
+GO
+

File sql/forms.sql.file

-/*
- Navicat SQL Server Data Transfer
-
- Source Server         : 172.16.0.41
- Source Server Version : 9001399
- Source Host           : 172.16.0.41
- Source Database       : MHC
- Source Schema         : dbo
-
- Target Server Version : 9001399
- File Encoding         : utf-8
-
- Date: 02/28/2013 17:52:07 PM
-*/
-
--- ----------------------------
---  Table structure for [dbo].[forms]
--- ----------------------------
-IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID('[dbo].[forms]') AND type IN ('U'))
-	DROP TABLE [dbo].[forms]
-GO
-CREATE TABLE [dbo].[forms] (
-	[id] int IDENTITY(1,1) NOT NULL,
-	[title] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
-	[category] varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
-	[posturl] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
-	[active] bit NOT NULL DEFAULT ((1))
-)
-GO
-
--- ----------------------------
---  Records of [dbo].[forms]
--- ----------------------------
-BEGIN TRANSACTION
-GO
-SET IDENTITY_INSERT [dbo].[forms] ON
-GO
-INSERT INTO [dbo].[forms] ([id], [title], [category], [posturl], [active]) VALUES ('1', 'Who Are You?', 'People', 'https://www.myhospicecenter.com/v1/put_form', '1');
-INSERT INTO [dbo].[forms] ([id], [title], [category], [posturl], [active]) VALUES ('2', 'Which is your favorite?', 'People', 'https://www.myhospicecenter.com/v1/put_form', '1');
-GO
-SET IDENTITY_INSERT [dbo].[forms] OFF
-GO
-COMMIT
-GO
-
-
--- ----------------------------
---  Options for table [dbo].[forms]
--- ----------------------------
-DBCC CHECKIDENT ('[dbo].[forms]', RESEED, 2)
-GO
-

File sql/forms_sql.txt

+/*
+ Navicat SQL Server Data Transfer
+
+ Source Server         : 172.16.0.41
+ Source Server Version : 9001399
+ Source Host           : 172.16.0.41
+ Source Database       : MHC
+ Source Schema         : dbo
+
+ Target Server Version : 9001399
+ File Encoding         : utf-8
+
+ Date: 02/28/2013 17:52:07 PM
+*/
+
+-- ----------------------------
+--  Table structure for [dbo].[forms]
+-- ----------------------------
+IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID('[dbo].[forms]') AND type IN ('U'))
+	DROP TABLE [dbo].[forms]
+GO
+CREATE TABLE [dbo].[forms] (
+	[id] int IDENTITY(1,1) NOT NULL,
+	[title] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[category] varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[posturl] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
+	[active] bit NOT NULL DEFAULT ((1))
+)
+GO
+
+-- ----------------------------
+--  Records of [dbo].[forms]
+-- ----------------------------
+BEGIN TRANSACTION
+GO
+SET IDENTITY_INSERT [dbo].[forms] ON
+GO
+INSERT INTO [dbo].[forms] ([id], [title], [category], [posturl], [active]) VALUES ('1', 'Who Are You?', 'People', 'https://www.myhospicecenter.com/v1/put_form', '1');
+INSERT INTO [dbo].[forms] ([id], [title], [category], [posturl], [active]) VALUES ('2', 'Which is your favorite?', 'People', 'https://www.myhospicecenter.com/v1/put_form', '1');
+GO
+SET IDENTITY_INSERT [dbo].[forms] OFF
+GO
+COMMIT
+GO
+
+
+-- ----------------------------
+--  Options for table [dbo].[forms]
+-- ----------------------------
+DBCC CHECKIDENT ('[dbo].[forms]', RESEED, 2)
+GO
+