--user
use jboss;
show tables;
CREATE TABLE user (id VARCHAR(10), passwd VARCHAR(10), name VARCHAR(40));

ALTER TABLE user
ADD CONSTRAINT PK_user PRIMARY KEY NONCLUSTERED (id);

describe user;

INSERT INTO user
 VALUES ('test', 1111, 'test');

  
--cardinfo
use jboss;
show tables;
CREATE TABLE cardinfo (name VARCHAR(40), SSN VARCHAR(13), CardNo VARCHAR(12), validdate VARCHAR(10));

ALTER TABLE cardinfo
ADD CONSTRAINT PK_cardinfo PRIMARY KEY NONCLUSTERED (CardNo);

describe cardinfo;

INSERT INTO cardinfo
 VALUES ('test', '1111112222222', '111122223333', '1111');
 

--movie
use jboss;
show tables;
CREATE TABLE movie (movieid VARCHAR(10), title VARCHAR(100), content VARCHAR(200), price int(10));

ALTER TABLE movie
ADD CONSTRAINT PK_movie PRIMARY KEY NONCLUSTERED (movieid);

describe movie;

INSERT INTO movie
 VALUES ('010', 'Harry Potter', 'Fantasitic story about Magic school and wizards', '10'),
('012', 'CATS', 'Musical', '5'), 
('013', 'MIB', 'Men In Black fighting agaist aliens, Science Fiction', '10'), 
('014', 'Kill Bill', 'Action and Violence', '10');   


--reserve
use jboss;
show tables;

CREATE TABLE reserv (
             reservid MEDIUMINT NOT NULL AUTO_INCREMENT,
	     opid int(10),
             date VARCHAR(10),
             paydate VARCHAR(10),
             time VARCHAR(10),
             amount int(10),
             Movieid VARCHAR(10),
             userid VARCHAR(10),
             ticketnum int(10),
             PRIMARY KEY (reservid)
             );

--login
use jboss;
show tables;

CREATE TABLE login (
             userid VARCHAR(10),
	     opid int(10),
             PRIMARY KEY (userid)
             );