1  # MySQL dump 7.1
2  #
3  # Host: localhost Database: membership
4  #--------------------------------------------------------
5  # Server version 3.22.32
6 
7  #
8  # Table structure for table 'CommitteeMembers'
9  #
10  DROP TABLE IF EXISTS CommitteeMembers;
11  CREATE TABLE CommitteeMembers (
12    CommitteeMemberID int(11) NOT NULL DEFAULT '0' auto_increment,
13    CommitteeID int(11),
14    MemberID int(11),
15    CommitteePosition varchar(30),
16    PRIMARY KEY(CommitteeMemberID)
17  );
18 
19  #
20  # Dumping data for table 'CommitteeMembers'
21  #
22 
23  LOCK TABLES CommitteeMembers WRITE;
24  INSERT INTO CommitteeMembers VALUES (1,1,1,'Member'),(2,1,4,'President'),(3,1,7,'Secretary'),(4,1,11,'Member'),(5,1,12,'Member'),(6,2,3,'President'),(7,2,9,'Member'),(8,2,6,'Secretary'),(9,2,4,'Member'),(10,2,2,'Treasurer');
25  UNLOCK TABLES;
26 
27  #
28  # Table structure for table 'Committees'
29  #
30  DROP TABLE IF EXISTS Committees;
31  CREATE TABLE Committees (
32    CommitteeID int(11) DEFAULT '0' NOT NULL auto_increment,
33    CommitteeName varchar(50),
34    CommitteeDescription mediumtext,
35    PRIMARY KEY(CommitteeID)
36  );
37 
38  #
39  # Dumping data for table 'Committees'
40  #
41 
42  LOCK TABLES Committees WRITE;
43  INSERT INTO Committees VALUES (1,'Meals','In charge of making sure food is available at meal time'),(2,'Transportation','In charge of making sure transportation is available in the event of a trip.');
44  UNLOCK TABLES;
45 
46  #
47  # Table structure for table 'MemberTypes'
48  #
49  DROP TABLE IF EXISTS MemberTypes;
50  CREATE TABLE MemberTypes (
51    MemberTypeID int(11) DEFAULT '0' NOT NULL auto_increment,
52    MemberType varchar(50),
53    MemberDues double(16,4),
54    PRIMARY KEY(MemberTypeID)
55  );
56 
57  #
58  # Dumping data for table 'MemberTypes'
59  #
60 
61  LOCK TABLES MemberTypes WRITE;
62  INSERT INTO MemberTypes VALUES (1,'Full Member',45.0000),(2,'Half Member',20.0000),(3,'Newsletter Only',7.0000);
63  UNLOCK TABLES;
64 
65  #
66  # Table structure for table 'Members'
67  #
68  DROP TABLE IF EXISTS Members;
69  CREATE TABLE Members (
70    MemberID int(11) DEFAULT '0' NOT NULL auto_increment,
71    FirstName varchar(50),
72    LastName varchar(50),
73    MemberTypeID int(11),
74    WorkCompany varchar(50),
75    Title varchar(50),
76    WorkAddress varchar(255),
77    WorkCity varchar(50),
78    WorkStateOrProvince varchar(20),
79    WorkPostalCode varchar(20),
80    WorkCountry varchar(50),
81    WorkPhone varchar(30),
82    Extension varchar(30),
83    HomeAddress varchar(255),
84    HomeCity varchar(50),
85    HomeStateOrProvince varchar(20),
86    HomePostalCode varchar(20),
87    HomeCountry varchar(50),
88    HomePhone varchar(30),
89    EmailName varchar(50),
90    DateJoined datetime,
91    FaxNumber varchar(30),
92    MobilePhone varchar(30),
93    InvoiceWorkAddress tinyint(4),
94    MemberDues double(16,4),
95    PRIMARY KEY(MemberID)
96  );
97 
98  #
99  # Dumping data for table 'Members'
100  #
101 
102  LOCK TABLES Members WRITE;
103  INSERT INTO Members VALUES (1,'Karl','Jablonski',1,'White Clover Markets','Owner','305 - 14th Ave. S.\r\nSuite 3B','Seattle','WA','98128','USA','',NULL,'722 DaVinci Blvd.','Kirkland','WA','98034','USA','','karlj',':00:00','',NULL,1,45.0000),(2,'Elizabeth','Lincoln',1,'Bottom-Dollar Markets','Accounting Manager','23 Tsawassen Blvd.','Tsawassen','B.C.','T2F 8M4','Canada','',NULL,'1900 Oak St.','Vancouver','B.C.','V3F 2K1','Canada','','elincoln',':00:00','',NULL,0,45.0000),(3,'Nancy','Davolio',1,'ABX Compute Corporation','Sales Representative','908 W. Capital Way','Tacoma','WA','98401','USA','',NULL,'507 - 20th Ave. E.\r\nApt. 2A','Seattle','WA','98122','USA','','nancyd',':00:00','',NULL,0,45.0000),(4,'Janet','Leverling',1,'Awesome Computers','Sales Representative','722 Moss Bay Blvd.','Kirkland','WA','98033','USA','',NULL,'4110 Old Redmond Rd.','Redmond','WA','98052','USA','','janetl',':00:00','',NULL,1,45.0000),(5,'Laura','Callahan',2,'ByteComp, Inc.','Inside Sales Coordinator',NULL,NULL,NULL,NULL,'USA',NULL,NULL,'4726 - 11th Ave. N.E.','Seattle','WA','98105','USA','','laurac',':00:00','',NULL,0,20.0000),(6,'Steven','Buchanan',1,'Flyteworks','Sales Manager','14 Garrett Hill','London',NULL,'SW1 8JR','UK','',NULL,'Coventry House\r\nMiner Rd.','London',NULL,'EC2 7JR','UK','','steveb',':00:00',NULL,NULL,1,45.0000),(7,'Hari','Kumar',1,'Seven Seas Imports','Sales Manager',NULL,NULL,NULL,NULL,'UK',NULL,NULL,'90 Wadhurst Rd.','London',NULL,'OX15 4NB','UK','','arik',':00:00','',NULL,0,45.0000),(8,'Patricio','Simpson',2,'Cactus Comidas para llevar','Sales Agent','Ing. Gustavo Moncada 8585\r\nPiso 20-A','Buenos Aires',NULL,'1010','Argentina','',NULL,'Cerrito 333','Buenos Aires',NULL,'1010','Argentina','','simpson',':00:00','',NULL,1,20.0000),(9,'Yoshi','Latimer',1,'Hungry Coyote Import Store','Sales Representative','City Center Plaza\r\n516 Main St.','Elgin','OR','97827','USA','',NULL,'2732 Baker Blvd.','Eugene','OR','97403','USA','','yoshil',':00:00','',NULL,0,45.0000),(10,'Lino','Rodriguez',3,'Ramona Publishing','Sales Manager','Jardim das rosas n. 32','Lisboa',NULL,'1675','Portugal','',NULL,'Estrada da saúde n. 58','Lisboa',NULL,'1756','Portugal','','linor',':00:00','',NULL,1,7.0000),(11,'Art','Braunschweiger',1,'Trail\'s Head Gourmet Provisioners','Sales Manager','P.O. Box 555','Lander','WY','82520','USA','',NULL,NULL,NULL,NULL,NULL,'USA',NULL,'artb',':00:00','',NULL,1,45.0000),(12,'Robert','King',1,'ProElectron, Inc.','Sales Representative','Edgeham Hollow\r\nWinchester Way','London',NULL,'RG1 9SP','UK','',NULL,'7 Houndstooth Rd.','London',NULL,'WG2 7LT','UK','','robertk',':00:00','',NULL,0,45.0000);
104  UNLOCK TABLES;
105 
106  #
107  # Table structure for table 'MyOrganizationInformation'
108  #
109  DROP TABLE IF EXISTS MyOrganizationInformation;
110  CREATE TABLE MyOrganizationInformation (
111    MyOrganizationInformationID int(11) DEFAULT '0' NOT NULL auto_increment,
112    CompanyName varchar(50),
113    Address varchar(255),
114    City varchar(50),
115    StateOrProvince varchar(20),
116    PostalCode varchar(20),
117    Country varchar(50),
118    DefaultPaymentTerms varchar(255),
119    DefaultInvoiceDescription mediumtext,
120    PhoneNumber varchar(30),
121    FaxNumber varchar(30),
122    PRIMARY KEY(MyOrganizationInformationID)
123  );
124 
125  #
126  # Dumping data for table 'MyOrganizationInformation'
127  #
128 
129  LOCK TABLES MyOrganizationInformation WRITE;
130  INSERT INTO MyOrganizationInformation VALUES (1,'The Social Organization','722 Moss Bay Blvd.','Kirkland','WA','98033','USA','Membership fee is due February 1st of each year.','You are the reason this is a great club.','','');
131  UNLOCK TABLES;
132 
133  #
134  # Table structure for table 'PaymentMethods'
135  #
136  DROP TABLE IF EXISTS PaymentMethods;
137  CREATE TABLE PaymentMethods (
138    PaymentMethodID int(11) DEFAULT '0' NOT NULL auto_increment,
139    PaymentMethod varchar(50),
140    CreditCard tinyint(4),
141    PRIMARY KEY(PaymentMethodID)
142  );
143 
144  #
145  # Dumping data for table 'PaymentMethods'
146  #
147 
148  LOCK TABLES PaymentMethods WRITE;
149  INSERT INTO PaymentMethods VALUES (1,'Check',0),(2,'Local Bank Credit Card',1),(3,'Fourth Bank Card',1),(4,'Teller Machine Card',1);
150  UNLOCK TABLES;
151 
152  #
153  # Table structure for table 'Payments'
154  #
155  DROP TABLE IF EXISTS Payments;
156  CREATE TABLE Payments (
157    PaymentID int(11) DEFAULT '0' NOT NULL auto_increment,
158    MemberID int(11),
159    PaymentAmount double(16,4),
160    PaymentDate datetime,
161    CreditCardNumber varchar(30),
162    CardholdersName varchar(50),
163    CreditCardExpDate datetime,
164    PaymentMethodID int(11),
165    PRIMARY KEY(PaymentID)
166  );
167 
168  #
169  # Dumping data for table 'Payments'
170  #
171 
172  LOCK TABLES Payments WRITE;
173  INSERT INTO Payments VALUES (1,1,45.0000,':00:00',NULL,NULL,NULL,1),(2,5,20.0000,':00:00',NULL,NULL,NULL,1),(3,6,45.0000,':00:00',NULL,NULL,NULL,1),(4,2,45.0000,':00:00',NULL,NULL,NULL,1),(5,3,30.0000,':00:00',NULL,NULL,NULL,1),(6,3,15.0000,':00:00',NULL,NULL,NULL,1),(7,4,45.0000,':00:00','','Janet Leverling',':00:00',4),(8,7,45.0000,':00:00',NULL,NULL,NULL,1),(9,8,10.0000,':00:00',NULL,NULL,NULL,1),(10,8,10.0000,':00:00',NULL,NULL,NULL,1),(11,9,45.0000,':00:00','','Yoshi Latimer',':00:00',2),(12,10,7.0000,':00:00',NULL,NULL,NULL,1),(13,12,30.0000,':00:00',NULL,NULL,NULL,1),(14,12,15.0000,':00:00',NULL,NULL,NULL,1);
174  UNLOCK TABLES;
175