44AqE8uK

1<add name="stringname" connectionString="server=server;user id=userid;password=password;persistsecurityinfo=True;database=database" providerName="MySql.Data.MySqlClient" />
2	
3namespace WebApplication1.MySQLModels
4{
5    using System;
6    using System.Collections.Generic;
7    using System.ComponentModel.DataAnnotations;
8    using System.ComponentModel.DataAnnotations.Schema;
9    using System.Data.Entity.Spatial;
10
11    [Table("database.SomeTable")]
12    public partial class SomeTable
13    {
14        public int id { get; set; }
15
16        [StringLength(255)]
17        public string CM { get; set; }
18
19        [StringLength(255)]
20        public string Job { get; set; }
21
22        [StringLength(255)]
23        public string ClientJobNo { get; set; }
24
25        [StringLength(255)]
26        public string JobNo { get; set; }
27
28        [StringLength(255)]
29        public string Client { get; set; }
30
31        [Column(TypeName = "date")]
32        public DateTime? Start { get; set; }
33
34        [Column(TypeName = "date")]
35        public DateTime? Finish { get; set; }
36
37        [StringLength(255)]
38        public string Frequency { get; set; }
39
40        [StringLength(255)]
41        public string PONumber { get; set; }
42
43        [Column(TypeName = "date")]
44        public DateTime? AuditCompleted { get; set; }
45
46        [Column(TypeName = "date")]
47        public DateTime? Invoiced { get; set; }
48
49        public decimal? InvoiceAmount { get; set; }
50
51        [StringLength(255)]
52        public string Query { get; set; }
53
54        [StringLength(255)]
55        public string Status { get; set; }
56
57        [StringLength(255)]
58        public string Type { get; set; }
59
60        [StringLength(255)]
61        public string Area { get; set; }
62
63        [Column(TypeName = "date")]
64        public DateTime? PlannedAudit { get; set; }
65
66        [StringLength(255)]
67        public string YellowJacketRequired { get; set; }
68
69        [StringLength(255)]
70        public string YellowJacketCompleted { get; set; }
71
72        [StringLength(255)]
73        public string SuperName { get; set; }
74
75        [StringLength(255)]
76        public string SuperPhone { get; set; }
77
78        [StringLength(255)]
79        public string ReasonsDateChange { get; set; }
80
81        [Column(TypeName = "text")]
82        [StringLength(65535)]
83        public string Comments { get; set; }
84    }
85}
86	
87CREATE TABLE IF NOT EXISTS `SomeTable` (
88`id` int(11) NOT NULL,
89  `CM` varchar(255) DEFAULT NULL,
90  `Job` varchar(255) DEFAULT NULL,
91  `ClientJobNo` varchar(255) DEFAULT NULL,
92  `JobNo` varchar(255) DEFAULT NULL,
93  `Client` varchar(255) DEFAULT NULL,
94  `Start` date DEFAULT NULL,
95  `Finish` date DEFAULT NULL,
96  `Frequency` varchar(255) DEFAULT NULL,
97  `PONumber` varchar(255) DEFAULT NULL,
98  `AuditCompleted` date DEFAULT NULL,
99  `Invoiced` date DEFAULT NULL,
100  `InvoiceAmount` decimal(7,2) DEFAULT NULL,
101  `Query` varchar(255) DEFAULT NULL,
102  `Status` varchar(255) DEFAULT NULL,
103  `Type` varchar(255) DEFAULT NULL,
104  `Area` varchar(255) DEFAULT NULL,
105  `PlannedAudit` date DEFAULT NULL,
106  `YellowJacketRequired` varchar(255) DEFAULT NULL,
107  `YellowJacketCompleted` varchar(255) DEFAULT NULL,
108  `SuperName` varchar(255) DEFAULT NULL,
109  `SuperPhone` varchar(255) DEFAULT NULL,
110  `ReasonsDateChange` varchar(255) DEFAULT NULL,
111  `Comments` text
112) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
113
114ALTER TABLE `SomeTable`
115 ADD PRIMARY KEY (`id`);