nmM8rwqp

1
2-- -----------------------------------------------------
3-- Table `users`
4-- -----------------------------------------------------
5CREATE  TABLE IF NOT EXISTS `users` (
6  `UID` INT(25) NOT NULL ,
7  `username` VARCHAR(60) NOT NULL ,
8  `password` VARCHAR(100) NOT NULL ,
9  `ownerFN` VARCHAR(50) NOT NULL ,
10  `ownerLN` VARCHAR(100) NOT NULL ,
11  `userstatus` TINYINT(1) NOT NULL ,
12  `userregistertime` DATETIME NOT NULL ,
13  `userlastonline` DATETIME NOT NULL ,
14  PRIMARY KEY (`UID`) )
15ENGINE = InnoDB
16DEFAULT CHARACTER SET = utf8;
17
18
19-- -----------------------------------------------------
20-- Table `company`
21-- -----------------------------------------------------
22CREATE  TABLE IF NOT EXISTS `company` (
23  `CID` INT(25) NOT NULL AUTO_INCREMENT ,
24  `ownername` VARCHAR(60) NOT NULL ,
25  `companyname` VARCHAR(255) NOT NULL ,
26  `companyaddress` VARCHAR(255) NOT NULL ,
27  `companyemail` VARCHAR(255) NULL DEFAULT NULL ,
28  `companyphone` INT(20) NOT NULL ,
29  `companyimage` VARCHAR(255) NULL DEFAULT NULL ,
30  `partnership` TINYINT(1) NOT NULL DEFAULT '0' ,
31  `type` TINYINT(1) NOT NULL DEFAULT '0' ,
32  `introduction` TEXT NULL DEFAULT NULL ,
33  `announcement` TEXT NULL DEFAULT NULL ,
34  `template` TEXT NULL DEFAULT NULL ,
35  PRIMARY KEY (`CID`) ,
36  INDEX `username` (`ownername` ASC) ,
37  CONSTRAINT `username`
38    FOREIGN KEY (`ownername` )
39    REFERENCES `users` (`username` )
40    ON DELETE NO ACTION
41    ON UPDATE NO ACTION)
42ENGINE = InnoDB
43DEFAULT CHARACTER SET = utf8;
44
45
46-- -----------------------------------------------------
47-- Table `content`
48-- -----------------------------------------------------
49CREATE  TABLE IF NOT EXISTS `content` (
50  `PID` INT(25) NOT NULL AUTO_INCREMENT ,
51  `username` VARCHAR(60) NOT NULL ,
52  `introduction` TEXT NULL DEFAULT NULL ,
53  `announcement` TEXT NULL DEFAULT NULL ,
54  `template` TEXT NULL DEFAULT NULL ,
55  PRIMARY KEY (`PID`) ,
56  INDEX `username` (`username` ASC) ,
57  CONSTRAINT `username`
58    FOREIGN KEY (`username` )
59    REFERENCES `company` (`ownername` )
60    ON DELETE CASCADE
61    ON UPDATE CASCADE)
62ENGINE = MyISAM
63DEFAULT CHARACTER SET = utf8;
64
65
66-- -----------------------------------------------------
67-- Table `product`
68-- -----------------------------------------------------
69CREATE  TABLE IF NOT EXISTS `product` (
70  `RID` INT(25) NOT NULL AUTO_INCREMENT ,
71  `companyname` VARCHAR(60) NOT NULL ,
72  `productname` VARCHAR(60) NOT NULL ,
73  `what` TEXT NOT NULL ,
74  `image` VARCHAR(255) NOT NULL ,
75  `price` DECIMAL(9,2) NOT NULL ,
76  `tag` VARCHAR(60) NOT NULL ,
77  PRIMARY KEY (`RID`) )
78ENGINE = InnoDB
79DEFAULT CHARACTER SET = utf8;
80
81
82-- -----------------------------------------------------
83-- Table `comments`
84-- -----------------------------------------------------
85CREATE  TABLE IF NOT EXISTS `comments` (
86  `OID` INT(25) NOT NULL AUTO_INCREMENT ,
87  `companyname` VARCHAR(60) NOT NULL ,
88  `guestemail` VARCHAR(255) NOT NULL ,
89  `comment` TEXT NOT NULL ,
90  PRIMARY KEY (`OID`) )
91ENGINE = InnoDB
92DEFAULT CHARACTER SET = utf8;