This may be of use to someone that has MS SQL and not My SQL and wants to play with the Punch List demo App
Enjoy, Bruce
Enjoy, Bruce
Code:
/* Source Server : AlphaProjects Source Server Version : Source Host : localhost:1433 Source Database : projectdb Target Server Type : MS-SQL Target Server Version : 2008 Date: 2017-11-21 23:04:00 */ /* SET FOREIGN_KEY_CHECKS=0; */ -- ---------------------------- -- Table structure for categories -- ---------------------------- IF OBJECT_ID('dbo.categories', 'U') IS NOT NULL DROP TABLE dbo.categories; CREATE TABLE categories ( [id] int NOT NULL IDENTITY, [category] varchar(45) DEFAULT NULL, PRIMARY KEY ([id]) ) ; -- ---------------------------- -- Records of categories -- ---------------------------- -- SET IDENTITY_INSERT to ON. SET IDENTITY_INSERT dbo.categories ON INSERT INTO categories ([id],[category] ) VALUES ('1', 'Plumbing'); INSERT INTO categories ([id],[category] ) VALUES ('2', 'Electrical'); INSERT INTO categories ([id],[category] ) VALUES ('3', 'Doors'); INSERT INTO categories ([id],[category] ) VALUES ('4', 'Windows'); INSERT INTO categories ([id],[category] ) VALUES ('5', 'Flooring'); INSERT INTO categories ([id],[category] ) VALUES ('6', 'Roofing'); INSERT INTO categories ([id],[category] ) VALUES ('7', 'Flashing'); INSERT INTO categories ([id],[category] ) VALUES ('8', 'Site Work'); INSERT INTO categories ([id],[category] ) VALUES ('9', 'Interior Trim'); INSERT INTO categories ([id],[category] ) VALUES ('10', 'Exterior Trim'); INSERT INTO categories ([id],[category] ) VALUES ('11', 'Siding'); INSERT INTO categories ([id],[category] ) VALUES ('12', 'Walkways'); INSERT INTO categories ([id],[category] ) VALUES ('13', 'Fixtures'); INSERT INTO categories ([id],[category] ) VALUES ('14', 'Door Hardware'); INSERT INTO categories ([id],[category] ) VALUES ('15', 'Cabinetry'); INSERT INTO categories ([id],[category] ) VALUES ('16', 'Built Ins'); INSERT INTO categories ([id],[category] ) VALUES ('17', 'Pool'); INSERT INTO categories ([id],[category] ) VALUES ('18', 'Interior Paint'); INSERT INTO categories ([id],[category] ) VALUES ('19', 'Exterior Paint'); INSERT INTO categories ([id],[category] ) VALUES ('20', 'HVAC'); INSERT INTO categories ([id],[category] ) VALUES ('21', 'Tile'); INSERT INTO categories ([id],[category] ) VALUES ('22', 'Countertops'); INSERT INTO categories ([id],[category] ) VALUES ('23', 'Garage Doors'); INSERT INTO categories ([id],[category] ) VALUES ('24', 'Sheetrock'); INSERT INTO categories ([id],[category] ) VALUES ('25', 'Fireplaces'); INSERT INTO categories ([id],[category] ) VALUES ('26', 'Timber Frame'); -- SET IDENTITY_INSERT to OFF. SET IDENTITY_INSERT dbo.categories OFF -- ---------------------------- -- Table structure for projects -- ---------------------------- IF OBJECT_ID('dbo.projects', 'U') IS NOT NULL DROP TABLE dbo.projects; CREATE TABLE projects ( [project_id] int NOT NULL IDENTITY, [project_name] varchar(45) DEFAULT NULL, [project_address] varchar(80) DEFAULT NULL, [project_city] varchar(45) DEFAULT NULL, [project_state] varchar(2) DEFAULT NULL, [project_zip] varchar(12) DEFAULT NULL, [project_lat] varchar(25) DEFAULT NULL, [project_lon] varchar(25) DEFAULT NULL, [project_phone] varchar(45) DEFAULT NULL, [project_photo] varchar(255) DEFAULT NULL, [owner_name] varchar(45) DEFAULT NULL, [owner_address] varchar(80) DEFAULT NULL, [owner_city] varchar(45) DEFAULT NULL, [owner_state] varchar(2) DEFAULT NULL, [owner_zip] varchar(12) DEFAULT NULL, [owner_email] varchar(45) DEFAULT NULL, [owner_work_phone] varchar(45) DEFAULT NULL, [owner_cell_phone] varchar(45) DEFAULT NULL, [owner_home_phone] varchar(45) DEFAULT NULL, PRIMARY KEY ([project_id]), CONSTRAINT [idProjects_UNIQUE] UNIQUE ([project_id]) ) ; -- ---------------------------- -- Records of projects -- ---------------------------- -- SET IDENTITY_INSERT to ON. SET IDENTITY_INSERT dbo.projects ON INSERT INTO projects ([project_id], [project_name], [project_address], [project_city], [project_state], [project_zip], [project_lat], [project_lon], [project_phone], [project_photo], [owner_name], [owner_address], [owner_city], [owner_state], [owner_zip], [owner_email], [owner_work_phone], [owner_cell_phone], [owner_home_phone]) VALUES ('1', 'Haynes Project', 'East Beach Road', 'Darien', 'CT', '06454', '41.0772', '-73.4687', '203-333-4343', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_project_photo_j4k9z8ij_A3C1BCE2-2E2C-4C43-AFC7-318751842DFB.jpg', 'Douglas Haynes', '18 Bronson Road', 'Fairfield', 'CT', '06432', '[email protected]', '212-333-4232', '203-433-2334', '203-237-2323'); INSERT INTO projects ([project_id], [project_name], [project_address], [project_city], [project_state], [project_zip], [project_lat], [project_lon], [project_phone], [project_photo], [owner_name], [owner_address], [owner_city], [owner_state], [owner_zip], [owner_email], [owner_work_phone], [owner_cell_phone], [owner_home_phone]) VALUES ('2', 'Homestead Project', '26 Kent Falls Road', 'Kent ', 'CT', '06880', '41.7248', '-73.4770', '203-237-9080', 'http://alphaanywheredemo.s3.amazonaws.com/p2/p2_img3.jpg', 'John and May Homestead', '515 Park Avenue', 'New York', 'NY', '10065', '[email protected]', '212-322-4343', '203-227-3434', '203-566-3434'); INSERT INTO projects ([project_id], [project_name], [project_address], [project_city], [project_state], [project_zip], [project_lat], [project_lon], [project_phone], [project_photo], [owner_name], [owner_address], [owner_city], [owner_state], [owner_zip], [owner_email], [owner_work_phone], [owner_cell_phone], [owner_home_phone]) VALUES ('3', 'Harrison Project', '12 Blue View Drive', 'Lincoln', 'VT', '05340', '44.1059', '-72.9971', '802-444-5454', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_project_photo_j4ka08ie_703AD86C-4ED8-432B-9017-91FA2127680E.jpg', 'John and Lisa Harrison', '102 Redding Rd.', 'Fairlfield', 'CT', '06430', '[email protected]', '212-355-6767', '203-235-2323', '203-255-6565'); INSERT INTO projects ([project_id], [project_name], [project_address], [project_city], [project_state], [project_zip], [project_lat], [project_lon], [project_phone], [project_photo], [owner_name], [owner_address], [owner_city], [owner_state], [owner_zip], [owner_email], [owner_work_phone], [owner_cell_phone], [owner_home_phone]) VALUES ('4', 'Clapp Project', '674 Washington Street', 'Duxbury', 'MA', '02332', '42.0418', '-70.6723', '781-234-5689', 'http://alphaanywheredemo.s3.amazonaws.com/p4/p4_img1.jpg', 'Michael and Martha Clapp', '228 Commonwealth Ave.', 'Boston', 'MA', '02116', '[email protected]', '617-234-5332', '617-222-8964', '617-546-2317'); INSERT INTO projects ([project_id], [project_name], [project_address], [project_city], [project_state], [project_zip], [project_lat], [project_lon], [project_phone], [project_photo], [owner_name], [owner_address], [owner_city], [owner_state], [owner_zip], [owner_email], [owner_work_phone], [owner_cell_phone], [owner_home_phone]) VALUES ('7', 'Morrison Project', '7 East Street', 'Duxbury', 'MA', '02332', '42.0418', '-70.6723', '203-259-0021', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_project_photo_j4jzb40f_76F7607B-4F66-4734-9046-1F7648DF2E81.jpg', 'Robert Morrison', '80 Bronson Road', 'Fairfield', 'CT', '06430', '[email protected]', '772-234-3232', null, null); -- SET IDENTITY_INSERT to OFF. SET IDENTITY_INSERT dbo.projects OFF -- ---------------------------- -- Table structure for punchlist_details -- ---------------------------- IF OBJECT_ID('dbo.punchlist_details', 'U') IS NOT NULL DROP TABLE dbo.punchlist_details; CREATE TABLE punchlist_details ( [punchlist_detail_id] int NOT NULL IDENTITY, [punchlist_item_id] int DEFAULT NULL, [date] date DEFAULT NULL, [notes] varchar(max), [audio_notes] varchar(1024) DEFAULT NULL, PRIMARY KEY ([punchlist_detail_id]) ) ; -- ---------------------------- -- Records of punchlist_details -- ---------------------------- -- SET IDENTITY_INSERT to ON. SET IDENTITY_INSERT dbo.punchlist_details ON INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('2', '2', '2017-02-21', 'These fixtures are missing. They need to be ordered and should have been supplied.', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_notes_j2qgi9mr_rec-2017_5_15-14_21_54-6_581.m4a'); INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('3', '3', '2017-02-21', 'Replace paint grade hinges with ORB hinges ASAP!', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_notes_j2qgldqb_rec-2017_5_15-14_23_53-13_579.m4a'); INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('4', '4', '2017-07-26', 'Check weatherstrip, garagedoor.', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_notes_rec-2017_7_26-15_25_41-8_041.m4a'); INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('5', '2', '2017-02-21', 'Lights should have been supplied: Bob spoke with the Dave Lawlor about these lights. The material and cost is in the electrical contract. Dave will order.', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_notes_j2w1b40d_rec-2017_5_19-12_2_51-11_05.m4a'); INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('6', '22', '2017-04-13', 'Painter notified.', null); INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('7', '23', '2017-04-13', 'This door looks like it needs to be replaced. Did this come from the supplier in this condition?', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_notes_j4k8314d_rec-2017_6_30-14_56_49-10_567.m4a'); INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('9', '8', '2017-06-25', 'Confirmed warped door. New door on order.', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_notes_j4k15anq_rec-2017_6_30-11_44_37-10_567.m4a'); INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('12', '5', '2017-04-25', 'Inspected and verified that this.', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_notes_j4kabj7n_rec-2017_6_30-16_1_17-9_306.m4a'); INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('13', '20', '2017-05-15', 'Fix gaps in mortar', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_notes_j2qgr5tl_rec-2017_5_15-14_28_48-6_705.m4a'); INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('15', '15', '2017-05-22', 'Fixed it.', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_notes_j4k0rusm_rec-2017_6_30-11_34_12-8_551.m4a'); INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('16', '13', '2017-06-09', 'Confirmed low water pressure. Informed plumber.', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_notes_j4k0nvuj_rec-2017_6_30-11_31_5-9_055.m4a'); INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('17', '23', '2017-06-30', 'Door supplier will replace door.', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_notes_j4k8314d_rec-2017_6_30-14_58_10-15_081.m4a'); INSERT INTO punchlist_details ([punchlist_detail_id], [punchlist_item_id], [date], [notes], [audio_notes]) VALUES ('18', '6', '2017-06-30', 'I spoke to the plumber. These fixtures will be installed next week.', ''); -- SET IDENTITY_INSERT to OFF. SET IDENTITY_INSERT dbo.punchlist_details OFF -- ---------------------------- -- Table structure for punchlist_items -- ---------------------------- IF OBJECT_ID('dbo.punchlist_items', 'U') IS NOT NULL DROP TABLE dbo.punchlist_items; CREATE TABLE punchlist_items ( [punchlist_id] int NOT NULL IDENTITY, [project_id] int DEFAULT NULL , [category] varchar(45) DEFAULT NULL , [description] varchar(1024) DEFAULT NULL, [start_date] date DEFAULT NULL, [completion_date] date DEFAULT NULL, [status] varchar(45) DEFAULT 'Not Started' , [photo_filename] varchar(1024) DEFAULT NULL, [audio_filename] varchar(1024) DEFAULT NULL, PRIMARY KEY ([punchlist_id]) ) ; -- ---------------------------- -- Records of punchlist_items -- ---------------------------- -- SET IDENTITY_INSERT to ON. SET IDENTITY_INSERT dbo.punchlist_items ON INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('2', '1', 'Electrical', 'Under cabinet lights missing', '2017-02-20', null, 'In Process', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_photo_filename_j4k0in2x_4C3CDCE4-CFBD-417B-82B7-F5470AAB0E2C.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k7z8ee_rec-2017_6_30-14_52_47-10_557.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('4', '2', 'Garage Doors', 'Weatherstrip seals missing', '2017-02-21', '2017-03-16', 'Completed', 'http://alphaanywheredemo.s3.amazonaws.com/p2/p2_img5.jpg', null); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('5', '2', 'Exterior Paint', 'Touch up paint, South Elevation', '2017-04-27', null, 'In Process', 'http://alphaanywheredemo.s3.amazonaws.com/p2/p2_img7.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j31tc298_rec-2017_5_23-13_6_27-5_049.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('6', '2', 'Plumbing', 'Bath #2, missing fixtures', '2017-02-23', '2017-04-27', 'Completed', 'http://alphaanywheredemo.s3.amazonaws.com/p2/p2_img1.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k8a6ae_rec-2017_6_30-15_3_0-8_046.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('8', '3', 'Cabinetry', 'Warped cabinet door, upstairs bath.', '2017-02-21', null, 'In Process', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_photo_filename_j4k8ewtb_1BF28818-7755-4C34-B6BC-9D8F3884F775.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k14544_rec-2017_6_30-11_43_44-11_567.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('9', '3', 'Tile', 'Seal grout, bathrom #5', '2017-05-22', '2017-06-25', 'Completed', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_photo_filename_j4k11p16_7B346DFE-A31D-4AA4-8966-1191CC760C1A.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k12x7b_rec-2017_6_30-11_42_52-7_54.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('11', '2', 'Windows', 'Check cupula windows for leak', null, null, 'Not Started', 'http://alphaanywheredemo.s3.amazonaws.com/p2/p2_img4.jpg', 'http://alphaanywheredemo.s3.amazonaws.com/p2/p2_cupula.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('12', '1', 'Doors', 'Leak, back porch door, check weatherstripping.', '2017-04-25', null, 'In Process', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_photo_filename_j4k0jkqq_78D0128B-66CB-4ABF-9A9A-612E11E72DE8.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k7z8ee_rec-2017_6_30-14_54_38-13_075.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('13', '4', 'Fixtures', 'Check pot filler over stove for proper water flow.', '2017-05-23', null, 'In Process', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_photo_filename_j4k0in2x_0AE5BDAF-DD1A-4BBE-B8BE-64829764A060.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k0nvui_rec-2017_6_30-11_29_50-10_809.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('14', '4', 'Plumbing', 'Check installation of washer hot and cold water feeds.', null, null, 'Not Started', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_photo_filename_j4k0in2x_8CD5C081-EDD7-4ABB-90FF-DA0E5977797B.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k0pc0q_rec-2017_6_30-11_32_5-17_591.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('15', '4', 'HVAC', 'Noisy air handler, 2nd floor east bedroom', null, null, 'Completed', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_photo_filename_j4k0in2x_762F9D9F-6A0A-49FD-9FF8-E4DC314CFF44.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k0rusl_rec-2017_6_30-11_33_19-14_329.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('18', '1', 'Interior Paint', 'Repair gaps, crown, West Bedroom', null, null, 'Not Started', 'http://alphaanywheredemo.s3.amazonaws.com/p1/p1_img3.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_rec-2017_7_26-15_27_7-14_096.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('19', '1', 'Sheetrock', 'Repair and replace, audio panel, bedroom #3', null, null, 'Not Started', 'http://alphaanywheredemo.s3.amazonaws.com/p1/p1_img4.jpg', 'http://alphaanywheredemo.s3.amazonaws.com/p1/p1_audio_panel.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('21', '1', 'Fireplaces', 'Gas fixture, missing, FP #1', null, null, 'Not Started', 'http://alphaanywheredemo.s3.amazonaws.com/p1/p1_img6.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k7shhj_rec-2017_6_30-14_50_37-12_565.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('22', '1', 'Interior Paint', 'Main stairs, touchup', '2017-04-12', null, 'In Process', 'http://alphaanywheredemo.s3.amazonaws.com/p1/p1_img7.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k7z8ee_rec-2017_6_30-14_55_51-12_066.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('23', '1', 'Doors', 'Front door damaged', '2017-04-13', null, 'In Process', 'http://alphaanywheredemo.s3.amazonaws.com/p1/p1_img8.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k0l9x1_rec-2017_6_30-11_29_6-7_788.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('24', '1', 'HVAC', 'Filter fit, improper', null, null, 'Not Started', 'http://alphaanywheredemo.s3.amazonaws.com/p1/p1_img9.jpg', 'http://alphaanywheredemo.s3.amazonaws.com/p1/p1_air_filter.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('25', '1', 'Doors', 'Closet doors, East bedroom, check fit', null, null, 'Not Started', 'http://alphaanywheredemo.s3.amazonaws.com/p1/p1_img10.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k7u221_rec-2017_6_30-14_51_48-12_073.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('26', '2', 'Timber Frame', 'East sun room, trim pegs', null, null, 'Not Started', 'http://alphaanywheredemo.s3.amazonaws.com/p2/p2_img2.jpg', 'http://alphaanywheredemo.s3.amazonaws.com/p2/p2_timber_pegs.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('27', '2', 'Interior Trim', 'Check fireplace veneer', '2017-04-11', '2017-04-12', 'Not Started', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_photo_filename_j4k0in2y_C86CD182-A962-410F-AA42-7967486262E2.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_rec-2017_7_26-15_23_51-12_797.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('29', '7', 'Doors', 'Check fit on this entrance door, 2nd floor kid bedroom.', '2017-04-25', '2017-04-30', 'In Process', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_photo_filename_j4k9y58d_3C262871-4D1D-4AE5-9BF4-EDB82652B970.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4ka94if_rec-2017_6_30-15_59_16-18_855.m4a'); INSERT INTO punchlist_items ([punchlist_id], [project_id], [category], [description], [start_date], [completion_date], [status], [photo_filename], [audio_filename]) VALUES ('43', '1', 'HVAC', 'Check all labels on boiler for accuracy.', '2017-06-30', null, 'In Process', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_photo_filename_j4k87396_43A9E175-6E22-446B-AE8B-1DCFEA668731.jpg', 'https://alphaanywheredemo.s3.amazonaws.com/B38BB4A2-3914-4806-9424-B6EF8C58C0D8_audio_filename_j4k87397_rec-2017_6_30-15_1_56-13_332.m4a'); -- SET IDENTITY_INSERT to OFF. SET IDENTITY_INSERT dbo.punchlist_items OFF -- ---------------------------- -- Table structure for status -- ---------------------------- IF OBJECT_ID('dbo.status', 'U') IS NOT NULL DROP TABLE dbo.status; CREATE TABLE status ( [id] int NOT NULL IDENTITY, [status] varchar(45) DEFAULT NULL, PRIMARY KEY ([id]) ) ; -- ---------------------------- -- Records of status -- ---------------------------- -- SET IDENTITY_INSERT to ON. SET IDENTITY_INSERT dbo.status ON INSERT INTO status ([id], [status]) VALUES ('1', 'On hold'); INSERT INTO status ([id], [status]) VALUES ('2', 'In Process'); INSERT INTO status ([id], [status]) VALUES ('3', 'Not Started'); INSERT INTO status ([id], [status]) VALUES ('4', 'Completed'); -- SET IDENTITY_INSERT to OFF. SET IDENTITY_INSERT dbo.status OFF /* SET FOREIGN_KEY_CHECKS=1; */