source: pro-violet-viettel/docs/db/viettel-violet.sql @ 296

Last change on this file since 296 was 296, checked in by dungnv, 11 years ago
File size: 5.2 KB
RevLine 
[296]1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5CREATE SCHEMA IF NOT EXISTS `violet-viettel` ;
6SHOW WARNINGS;
7USE `violet-viettel`;
8
9-- -----------------------------------------------------
10-- Table `violet-viettel`.`tbladmin`
11-- -----------------------------------------------------
12DROP TABLE IF EXISTS `violet-viettel`.`tbladmin` ;
13
14SHOW WARNINGS;
15CREATE  TABLE IF NOT EXISTS `violet-viettel`.`tbladmin` (
16  `admin_id` INT NOT NULL AUTO_INCREMENT ,
17  `login_name` VARCHAR(45) NOT NULL ,
18  `passwd` VARCHAR(65) NOT NULL ,
19  `full_name` VARCHAR(45) NOT NULL ,
20  `email` VARCHAR(45) NULL ,
21  `phone` VARCHAR(15) NULL ,
22  `created_time` DATETIME NULL ,
23  `updated_time` DATETIME NULL ,
24  `author` INT NULL ,
25  PRIMARY KEY (`admin_id`) )
26ENGINE = InnoDB;
27
28SHOW WARNINGS;
29
30-- -----------------------------------------------------
31-- Table `violet-viettel`.`tbladminrole`
32-- -----------------------------------------------------
33DROP TABLE IF EXISTS `violet-viettel`.`tbladminrole` ;
34
35SHOW WARNINGS;
36CREATE  TABLE IF NOT EXISTS `violet-viettel`.`tbladminrole` (
37  `role_id` INT NOT NULL AUTO_INCREMENT ,
38  `role_name` VARCHAR(45) NOT NULL ,
39  PRIMARY KEY (`role_id`) )
40ENGINE = InnoDB;
41
42SHOW WARNINGS;
43
44-- -----------------------------------------------------
45-- Table `violet-viettel`.`tblcollaborator`
46-- -----------------------------------------------------
47DROP TABLE IF EXISTS `violet-viettel`.`tblcollaborator` ;
48
49SHOW WARNINGS;
50CREATE  TABLE IF NOT EXISTS `violet-viettel`.`tblcollaborator` (
51  `id` INT NOT NULL AUTO_INCREMENT ,
52  `full_name` VARCHAR(45) NOT NULL ,
53  `login_name` VARCHAR(45) NOT NULL ,
54  `cellphone` VARCHAR(15) NOT NULL ,
55  `passwd` VARCHAR(65) NOT NULL ,
56  `activated` TINYINT NOT NULL DEFAULT 1 ,
57  `created_time` DATETIME NULL ,
58  `updated_time` DATETIME NULL ,
59  `author` INT NULL ,
60  PRIMARY KEY (`id`) )
61ENGINE = InnoDB;
62
63SHOW WARNINGS;
64
65-- -----------------------------------------------------
66-- Table `violet-viettel`.`tbluser`
67-- -----------------------------------------------------
68DROP TABLE IF EXISTS `violet-viettel`.`tbluser` ;
69
70SHOW WARNINGS;
71CREATE  TABLE IF NOT EXISTS `violet-viettel`.`tbluser` (
72  `us_id` INT NOT NULL ,
73  `cellphone` VARCHAR(15) NOT NULL ,
74  `collaborator` INT NULL ,
75  `acc_balanced` BIGINT NOT NULL DEFAULT 0 ,
76  `expire_date` DATE NOT NULL ,
77  `created_time` DATETIME NOT NULL ,
78  `updated_time` DATETIME NULL ,
79  PRIMARY KEY (`us_id`) )
80ENGINE = InnoDB;
81
82SHOW WARNINGS;
83
84-- -----------------------------------------------------
85-- Table `violet-viettel`.`tblsmstemplate`
86-- -----------------------------------------------------
87DROP TABLE IF EXISTS `violet-viettel`.`tblsmstemplate` ;
88
89SHOW WARNINGS;
90CREATE  TABLE IF NOT EXISTS `violet-viettel`.`tblsmstemplate` (
91  `sms_id` INT NOT NULL AUTO_INCREMENT ,
92  `sms_content` VARCHAR(255) NOT NULL ,
93  `sms_reply` VARCHAR(255) NULL ,
94  `reponse_url` VARCHAR(255) NULL ,
95  PRIMARY KEY (`sms_id`) )
96ENGINE = InnoDB;
97
98SHOW WARNINGS;
99
100-- -----------------------------------------------------
101-- Table `violet-viettel`.`tblwebservice`
102-- -----------------------------------------------------
103DROP TABLE IF EXISTS `violet-viettel`.`tblwebservice` ;
104
105SHOW WARNINGS;
106CREATE  TABLE IF NOT EXISTS `violet-viettel`.`tblwebservice` (
107  `service_id` INT NOT NULL AUTO_INCREMENT ,
108  `service_name` VARCHAR(45) NOT NULL ,
109  `address` VARCHAR(255) NULL ,
110  `uri` VARCHAR(255) NULL ,
111  PRIMARY KEY (`service_id`) )
112ENGINE = InnoDB;
113
114SHOW WARNINGS;
115
116-- -----------------------------------------------------
117-- Table `violet-viettel`.`tblsmslog`
118-- -----------------------------------------------------
119DROP TABLE IF EXISTS `violet-viettel`.`tblsmslog` ;
120
121SHOW WARNINGS;
122CREATE  TABLE IF NOT EXISTS `violet-viettel`.`tblsmslog` (
123  `id` INT NOT NULL AUTO_INCREMENT ,
124  `sender` VARCHAR(255) NOT NULL ,
125  `us_id` INT NULL ,
126  `mobody` VARCHAR(255) NULL ,
127  `mtbody` VARCHAR(255) NULL ,
128  `created_time` DATETIME NULL ,
129  PRIMARY KEY (`id`) )
130ENGINE = InnoDB;
131
132SHOW WARNINGS;
133
134-- -----------------------------------------------------
135-- Table `violet-viettel`.`tbluserpaylog`
136-- -----------------------------------------------------
137DROP TABLE IF EXISTS `violet-viettel`.`tbluserpaylog` ;
138
139SHOW WARNINGS;
140CREATE  TABLE IF NOT EXISTS `violet-viettel`.`tbluserpaylog` (
141  `id` BIGINT NOT NULL AUTO_INCREMENT ,
142  `us_id` INT NOT NULL ,
143  `pay_type` TINYINT NOT NULL DEFAULT 1 COMMENT '0:promotion;1:SMS;2:card' ,
144  `pay_time` DATETIME NOT NULL ,
145  `pay_value` INT NOT NULL DEFAULT 0 ,
146  PRIMARY KEY (`id`) )
147ENGINE = InnoDB;
148
149SHOW WARNINGS;
150
151-- -----------------------------------------------------
152-- Table `violet-viettel`.`tblcardlog`
153-- -----------------------------------------------------
154DROP TABLE IF EXISTS `violet-viettel`.`tblcardlog` ;
155
156SHOW WARNINGS;
157CREATE  TABLE IF NOT EXISTS `violet-viettel`.`tblcardlog` (
158  `id` INT NOT NULL ,
159  `sender` VARCHAR(255) NULL ,
160  `us_id` INT NULL ,
161  `pin_code` VARCHAR(45) NULL ,
162  `serial_num` VARCHAR(45) NULL ,
163  `card_value` INT NULL ,
164  `created_time` DATETIME NOT NULL ,
165  PRIMARY KEY (`id`) )
166ENGINE = InnoDB;
167
168SHOW WARNINGS;
169
170
171SET SQL_MODE=@OLD_SQL_MODE;
172SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
173SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Note: See TracBrowser for help on using the repository browser.